Social Media Content Audit: A Step-by-Step Guide

Most social media accounts have a graveyard problem. Buried in their post history are carousel formats that killed it six months ago and haven't been repeated, topic categories that nobody engages with but keep appearing out of habit, and video hooks that worked once and were never extracted into a template.

A social media audit of the account itself — checking bios, links, and profile completeness — is something most people do occasionally. A content audit is different, and far less common. Instead of asking "is our profile set up correctly," it asks: "of everything we've published, what's actually working, what isn't, and what should we do about it?"

This is the guide for the second kind. It walks through how to conduct a content-level audit from scratch: gathering the data, categorizing your posts, reading the signals, and turning the findings into a concrete content decision — more of this, less of that, repurpose this, retire that.

Why Content Audits Belong on Your Quarterly Calendar

Most teams review their content performance in two ways: they look at the most recent posts (recency bias) or they look at the most viral ones (outlier bias). Neither gives you a reliable read on what's systematically working.

A content audit looks at the whole corpus. It lets you answer questions like:

• Does our educational content outperform our promotional content, or the reverse?
• Do Reels drive more saves and profile visits than carousels?
• Are posts in our "behind-the-scenes" pillar consistently underperforming, or did we just post that content at the wrong time?
• Which content types generate followers who stay versus followers who churn after a week?

Without that full-picture view, you're optimizing the last post instead of the strategy. Running a content audit every quarter — or at minimum twice a year — puts you in a fundamentally different decision-making position than teams that never do it.

Step 1 — Define Your Audit Window and Scope

Before pulling any numbers, decide exactly what you're auditing.

Time window: three to six months is usually the right range. Too short and you don't have enough signal to distinguish patterns from noise. Too long and platform algorithm changes from 18 months ago may be distorting the data. If you've made a significant content pivot (new format, new posting frequency, new platform), audit only the period after the pivot — mixing pre- and post-pivot data muddies the read.

Platforms: audit one platform at a time. Metrics don't translate across platforms. An engagement rate that would be strong on LinkedIn is mediocre on TikTok. Run separate analyses for each platform you're active on and resist the urge to combine them into a single "social media performance" view.

Scope of posts: include everything that was published in the window, not just the ones you remember. The posts you've mentally written off might surprise you. The posts you thought were strong might look different in context.

Step 2 — Export Your Post Data

Every major platform offers some form of analytics export, at the time of writing — though the format and depth vary significantly.

For Instagram, Facebook, and LinkedIn, native analytics typically let you export a spreadsheet of post performance. For TikTok and X, you may need to pull data manually or use a third-party analytics tool depending on account type and tier.

What you want to capture for each post:

• Publish date and time
• Format (photo, video, carousel, Reel, text, story, etc.)
• Content category / content pillar (you'll add this manually)
• Reach or impressions
• Engagement (likes + comments + shares + saves where available)
• Engagement rate — if not calculated by default, use our engagement rate calculator to standardize it
• Link clicks (if applicable)
• Saves (Instagram, Pinterest — saves are high-signal)
• Any conversion or traffic attribution you have

Don't let the absence of perfect data stop you. Work with what you have. A 70% complete dataset that you actually analyze is more valuable than waiting for the perfect export.

Step 3 — Tag Every Post by Content Category

This is the most time-consuming step and the one most people skip. It's also where all the real insight comes from.

Go through your export and manually tag each post with:

Content pillar or topic: educational, promotional, entertainment, behind-the-scenes, community/UGC, news/trending. Use your actual defined pillars if you have them — or create categories retroactively based on what you see.

Format: the platform format (Reel, carousel, static image, video, text-only, Story).

Hook type (optional but valuable): a question, a bold claim, a how-to, a story opener, a list.

This tagging work takes an hour or two for a 90-day dataset, and it turns your spreadsheet from a list of numbers into a categorized inventory you can actually slice.

Step 4 — Run the Analysis

With tagged data, you can now ask the questions that matter.

Performance by Content Pillar

Average the engagement rate for each pillar. You're looking for which topic categories consistently outperform and which consistently underperform.

Fill this in with your real data. The pattern that emerges is your strategic signal.

Performance by Format

Which formats earn the highest engagement rate? Which reach the most people? Which drive the most saves or clicks? These questions often have different answers, which tells you something useful about matching format to goal.

Timing Patterns

Look at whether posts published at certain days or times show meaningfully different performance. Cross-reference with our best time to post data for your specific platforms — that gives you a benchmark to compare against.

Top and Bottom Performers

Pull the top 10% and bottom 10% of posts by engagement rate. Read them. Not to reverse-engineer every viral post, but to notice patterns: are your top performers clustered in a particular pillar or format? Are your bottom performers sharing a hook type or topic that consistently falls flat?

Step 5 — Categorize Every Post into a Decision Bucket

This is the output step — translating analysis into action. For each content category or format, assign it to one of four buckets:

Double down: high engagement, high reach, good fit with where you want to take the brand. Make more of this. If possible, build it into a repeating series.

Repurpose: the topic or concept performs well, but the format might not be optimal. A blog-style caption that earned strong saves might work better as a carousel. A long video that drops off early might work better as three short clips. Flag for repurposing rather than creating net-new content.

Test and optimize: moderate performance that might be improvable with a different hook, a different posting time, or a format tweak. Don't kill it yet — give it a deliberate test with one variable changed.

Retire: consistently low performance across multiple posts, no clear path to optimization, poor brand fit in retrospect. Stop producing this type of content. Redirect the time to the "double down" bucket.

The goal is to come out of the audit with a concrete allocation: what percentage of your content calendar going forward should be each pillar and each format? That's the deliverable — not a report, but a changed publishing mix.

Step 6 — Audit for Repurposing Opportunities

Before closing the spreadsheet, do one more pass specifically looking for repurposing candidates. Ask:

• Which posts have strong engagement but were only published once, to one platform?
• Which topics generated high saves (a signal of "I want to come back to this") but haven't been explored further?
• Which Reels or videos have strong early retention but weren't promoted or cross-posted?

Content repurposing is often the highest-leverage output of a content audit — not creating new content, but redistributing what already proved itself. A post that performed well on Instagram may not have been adapted for LinkedIn or Pinterest. A thread that earned strong engagement might become a carousel.

Common Mistakes in Content Audits

Only auditing your "best" content. If you only look at posts you remember performing well, you're auditing your memory, not your content. Include everything.

Comparing raw numbers across platforms. 200 likes on LinkedIn and 200 likes on Instagram represent very different performance levels. Always normalize to engagement rate or platform-relative benchmarks.

Not separating organic from boosted posts. If some of your posts had paid amplification, flag them. A boosted post with high reach tells you nothing about organic performance; mixing it with organic data distorts the pillar-level averages.

Acting on one post instead of patterns. A single viral post in a category that otherwise consistently underperforms isn't a signal to invest in that category — it's an outlier. You need 8–10 data points per category to trust a pattern.

Auditing without changing the content mix. The audit is useless if it doesn't change what you publish next. Block a working session after the analysis specifically to update your content calendar and posting mix. Otherwise the findings just sit in a spreadsheet.

What to Do with the Findings

A completed content audit gives you three concrete outputs:

1. A revised content mix: the percentage breakdown of pillars and formats you'll use going forward, based on what the data showed
2. A repurposing list: specific posts or topics flagged for adaptation and redistribution
3. A "stop doing" list: content types or topics you're explicitly retiring to redirect the time

Implement the revised mix in your next content calendar cycle. Track performance for the following 60–90 days, then run a shorter "mini-audit" to see if the adjustments are showing up in the numbers.

This is how content strategy compounds over time — not through one-off inspiration, but through iterative cycles of publish, measure, audit, adjust.

Staying Consistent Through the Audit Cycle

One practical note: the teams that audit most consistently aren't the ones with the most time. They're the ones with the most organized publishing history. When your posts are tagged by pillar and format at publication — rather than retroactively — the audit goes from a half-day project to a 45-minute analysis.

A scheduling tool that lets you categorize and label posts at creation time, rather than hunting through native platform analytics export files, makes the quarterly audit dramatically faster. That's not a small thing — the friction in pulling the data is often the reason audits don't happen.

Build the habit of tagging content as you schedule it. Future-you running the Q1 audit will be grateful.