Social media audit template
A social media audit template in Excel with a channel tab that calculates cost per enquiry per channel and returns a keep-or-close verdict, a four-week content calendar with a mix counter, and 22 audit checks you can tick off on this page. It starts with the question most social audits avoid: is this channel earning the hours it costs?
- TEMPLATE
- CHECKLIST
- XLSX
- FREE
- Best for
- Anyone running several social channels who cannot say what any of them produced
- Includes
- Excel audit + content calendar + 22 tickable checks + PDF
- Time to use
- 2 hours across all channels
Free to download and use in your own client work. No email address required.
Problems this solves
Recurring complaints about this task, and what this resource does about each one. If it does not solve your version of the problem, that is worth knowing before you download anything.
- You stopped posting for a month and nothing measurable changed
- That is a finding, and the workbook is built to produce it: cost per enquiry per channel, and a verdict of Keep, "Reach only — justify it", or Close or pause. An unstated reason for a channel is indistinguishable from a habit.
- Posting consistently and generating no leads
- The audit checks whether every post links to something you own and whether links are tagged, because an untagged channel is invisible in analytics — and an invisible channel gets cut regardless of what it produced.
- You do not know what to post, so you post offers
- A content mix with rough shares, and a calendar that counts your actual mix against it. Promotional content works because the other 85% exists; on its own it is scrolled past.
The question most social audits avoid: is this channel earning the hours it costs?
Five channels each receiving a fifth of the necessary attention is the most common social setup I see, and the honest answer is usually fewer channels rather than more posts.
The audit checklist
Is this channel earning its place? 4
Profile basics, per channel 5
Content 5
Cadence and process 4
Measurement 4
The keep-or-close calculation
The workbook’s first tab takes followers, net growth, posts, hours, sessions and enquiries per channel, and returns cost per enquiry and a verdict:
- Hours spent, no enquiries, almost no sessions → Close or pause
- Hours spent, no enquiries, real referred traffic → Reach only — justify it
- Any enquiries → Keep
“Reach only” is a legitimate verdict, not a failure. Some channels exist for recruitment, for proof during a sales process, or for customer service. But it has to be stated, because an unstated reason is indistinguishable from a habit.
Cost per hour means your cost, not your rate
Enter what an hour of your or your team’s time actually costs. The point of the total at the bottom is the comparison: if eight channels consume twenty hours a month between them and produce two enquiries, the answer is not a better posting schedule.
What to post
| Type | What it is | Rough share | Note |
|---|---|---|---|
| Proof | Work you have done, results, client words, things you have built | Around 30% | The type that converts, and the type most accounts post least. |
| Useful | Something a viewer can act on without contacting you | Around 50% | Earns the right to be followed. This is where a template or a checklist does well. |
| Promotional | An explicit offer, launch or availability post | Around 15% | Works because the other 85% exists. On its own it is ignored. |
| Human | The team, the process, the mistakes | Around 5% | Cheap to make and disproportionately good at starting conversations. |
The mix matters more than the frequency. Promotional content works because the other 85% exists — on its own it is scrolled past, which is why accounts that post only offers conclude social does not work.
The proof category is the one most accounts underuse. Work you have actually done converts better than anything else you can post, and it is the hardest thing for a competitor to copy.
The calendar
Four weeks, with channel and type as dropdowns and a counter at the bottom that tallies your actual mix against the target. That counter is the point — the mix is easy to agree and hard to hold, and it drifts towards promotional whenever there is something to sell.
Common mistakes
- Running five channels at a fifth of the attention each needs.
- Reporting impressions and follower count instead of referred sessions and enquiries.
- Cross-posting the same content identically everywhere.
- Neglecting a channel rather than closing it — an abandoned profile still costs you credibility.
- Untagged links, so the channel cannot be defended when budgets are reviewed.
- Counting follower growth gross, so unfollows are invisible.