A social media audit template is a structured document, usually a spreadsheet, that you use to review every social profile you own: which accounts exist, how each one performs, and what to change next. Below is a free template you can copy straight into a spreadsheet or doc, plus a six-step process for filling it in, a checklist, and answers to the questions people ask most.
You do not need special software to run an audit. You need a repeatable structure, 90 days of data, and about two hours.
What is a social media audit?
A social media audit is a periodic review of all your social accounts to measure what is working, catch what is not, and decide where to spend your time next. A good audit answers four questions:
- Inventory: Which accounts do we actually have, and are they all on brand?
- Performance: Which platforms and posts drive real engagement and results?
- Content: Which formats and topics earn attention, and which fall flat?
- Direction: What should we start, stop, and continue next quarter?
Audits matter because social strategies drift. A platform that worked last year quietly declines, an abandoned account keeps showing up in search results, and posting schedules shrink without anyone deciding to post less. An audit puts numbers on that drift so you can correct it deliberately.
What to include in a social media audit template
Every solid template covers the same four sections: a profile inventory, a performance snapshot, a content audit, and an action plan. The template below is deliberately lean. Large agency templates with 20 tabs look impressive but rarely get filled in twice. Four tables you actually complete each quarter beat a masterpiece you complete once.
The free social media audit template (copy and paste)
Copy these four tables into Google Sheets, Excel, Notion, or a doc. One row per platform or finding.
1. Profile inventory
Platform | Handle | Profile URL | Followers | Bio and links current? | Branding consistent? | Verdict (keep / fix / archive) |
|---|---|---|---|---|---|---|
@yourbrand | ... | ... | Yes / No | Yes / No | Keep | |
TikTok | @yourbrand | ... | ... | Yes / No | Yes / No | Fix |
List every account, including old ones nobody posts to anymore. Abandoned profiles with outdated logos and dead links are the most common audit finding, and the cheapest to fix.
2. Performance snapshot (last 90 days)
Platform | Posts published | Avg engagement rate | Reach or impressions | Follower change | Best post (link) |
|---|---|---|---|---|---|
... | ... | ... | +/- ... | ... | |
... | ... | ... | +/- ... | ... |
Pull these numbers from each platform's native analytics or from your management tool's dashboard. If you are unsure which metrics deserve a column, our guide to building a social media analytics dashboard breaks down the ones worth tracking.
3. Content audit
Content type | Example posts | Avg engagement vs account average | Verdict (double down / adjust / drop) |
|---|---|---|---|
Reels / short video | ... | Above / below | ... |
Carousels | ... | Above / below | ... |
Text or link posts | ... | Above / below | ... |
4. Action plan
Finding | Action | Owner | Deadline |
|---|---|---|---|
e.g. LinkedIn bio outdated | Rewrite bio, update link | Sam | Oct 15 |
e.g. Reels outperform 3x | Shift calendar to 50% video | Ana | Nov 1 |
An audit without this fourth table is just a report. The action plan is what makes the next quarter different from the last one.
How to do a social media audit in 6 steps
Step 1: List every account you own
Search each platform for your brand name and collect every profile, official or forgotten. Record handles, URLs, and who has login access. Decide per account: keep, fix, or archive.
Step 2: Check branding and profile completeness
Same logo, same handle style, same bio voice, working links on every profile. Inconsistent branding quietly costs trust, and it takes an afternoon to repair.
Step 3: Pull 90 days of performance data
Ninety days smooths out one-off spikes without hiding trends. Native analytics (Instagram Insights, TikTok Analytics, YouTube Studio) give you the deepest per-platform data and they are free. The tradeoff is that you collect numbers platform by platform. A tool with cross-channel social media analytics puts engagement and growth for your channels in one view, which is where the audit time savings come from. One honest note if you evaluate Nimply for this: analytics for Instagram, Facebook, TikTok, YouTube, and Pinterest are live today, while LinkedIn and X analytics are still coming soon, so for those two you would use native analytics for now.
Step 4: Identify your top and bottom content
Sort posts by engagement. Look at your top five and bottom five and ask why: format, topic, hook, timing. Patterns here fill in the content audit table and tell you what next quarter's calendar should look like.
Step 5: Benchmark two or three competitors
You cannot see competitors' private analytics, but you can record what is public: posting frequency, formats, follower counts, and which of their posts earn outsized engagement. The goal is not copying. It is spotting gaps, like a format your audience clearly enjoys that nobody in your niche does well yet.
Step 6: Turn findings into an action plan
Write three to five specific actions with owners and deadlines, then push them into your actual workflow. If the audit says "post more consistently," the fix is usually operational: plan content ahead on a content calendar with an approval workflow and schedule posts in advance so consistency stops depending on daily willpower.
How often should you run a social media audit?
A full audit once per quarter works for most creators, small businesses, and agencies. Monthly is worth it if you post daily or manage client accounts, since clients expect the numbers anyway. At minimum, audit twice a year; less than that and you are steering by memory.
A useful pairing: run the audit right before you report results, since the same data feeds both. If you tie audits to business outcomes, our walkthrough on how to measure social media ROI covers the formula side.
Do you need a paid tool for this?
No. A spreadsheet plus native analytics covers a full audit, and the downloadable templates from HubSpot or Hootsuite are perfectly good starting points if you prefer a pre-built file. Paid tools earn their keep on repetition: if you audit monthly, manage several brands, or report to clients, pulling cross-channel numbers from one dashboard instead of five native apps is the difference between a two-hour audit and a two-day one. Start with the free version of the template above, and add tooling only when the manual version starts costing you real hours.
FAQ
How to make a social media audit?
List every social account you own, check each profile's branding and links, pull the last 90 days of performance data, identify your best and worst content, benchmark two or three competitors, and finish with an action plan that has owners and deadlines. The four-table template above gives you the structure; the six steps fill it in.
Can ChatGPT do a social media audit?
Partially. ChatGPT and other AI assistants cannot access your analytics directly, so they cannot pull your numbers. What they do well is analyze data you paste in, summarize patterns, and draft the action plan. You still gather the data first, either from native analytics or from a social media management tool that centralizes it.
What is the 5-3-2 rule for social media posts?
The 5-3-2 rule says that for every 10 posts, five should be curated content from others, three should be your own created content, and two should be personal or human posts. Treat it as a starting ratio, not a law. Your own content audit data beats any generic rule.
What are the 5 C's of auditing?
The 5 C's come from general audit practice: criteria (what should be happening), condition (what is actually happening), cause (why there is a gap), consequence (what the gap costs), and corrective action (how to fix it). Applied to social media, that maps to your goals, your 90-day data, the reasons behind underperformance, the business impact, and your action plan.



