A social media content audit takes one hour: pull your last 90 days of posts, rank them by shares plus saves, group the winners into three clusters, cut the lane that never performs, and plan your next batch from the top cluster. You need your analytics export and a spreadsheet, and that is the whole toolkit. The output is a data-backed answer to what you should post next month.
What is a social media content audit?
An audit is a structured look back at what you published and how people responded, so your next month runs on evidence instead of vibes. Most creators skip it because it sounds like homework, then keep guessing at content ideas while the answers sit in their own analytics. You have already run the experiments. The audit just reads the results.
The reason to rank by shares plus saves, rather than views or likes, is that those two signals predict reach and revenue better than anything else you can see. A save says the viewer plans to use it. A share says the viewer knew someone who needed it. Views tell you what the algorithm tested; shares and saves tell you what humans endorsed.
A good audit turns "what should I post?" into "which winner should I make more of?"
The one-hour audit
Set a timer. The deadline is part of the method, because a perfect audit next month loses to a rough one today.
- Minutes 0 to 10: get your data. Export your analytics, noting that TikTok's native export covers roughly the last 60 days, so grab it now and again in a month to build your 90-day picture. The walkthrough is in how to export TikTok analytics. Drop every post into a spreadsheet with columns for topic, format, shares, and saves.
- Minutes 10 to 25: score and sort. Add shares plus saves for each post and sort the sheet by that number, highest first. Ignore views and likes for this pass entirely.
- Minutes 25 to 40: name the clusters. Read your top third and describe each post's topic in three or four words. Patterns appear fast. "Pricing mistakes," "client red flags," and "behind the scenes" might each claim several spots. Those recurring themes are your pillars, the concept I unpacked in content pillars explained.
- Minutes 40 to 50: kill the bottom lane. Find the topic that appears repeatedly in your bottom third and never in your top. Retire it for the next 90 days. This step stings and matters most, because every post in a dead lane spends a slot a winner could have used.
- Minutes 50 to 60: plan the next batch. Write ten new video ideas that live inside your top cluster. Variations, follow-ups, and deeper cuts of proven winners count as new ideas.
This is, almost line for line, the manual version of what Batchly automates: it reads your export, scores every video with shares and saves weighted up top, clusters your winners into pillars, and writes the next batch of scripts.
What if your export is missing saves or watch time?
Sometimes it will be. Saves and watch time are missing from some platform exports depending on the platform and account type, which frustrates everyone the first time they see it. Work with what travels: shares are the strongest single signal, so shares alone can carry the ranking. If you need saves, they display in the app on each post even when the export omits them, and for your top and bottom ten posts a quick manual check is worth the minutes. On Instagram, most of what you need lives in the in-app insights, and I covered where to find it in how to read Instagram insights.
Do not let a missing column cancel the audit. A ranking built on shares by themselves still beats the ranking most creators use, which is whichever post felt good.
Ivy's audit: 34 posts, one obvious answer
A composite that shows how fast this goes. Ivy is a nutrition coach who posted 34 times in 90 days without a plan. She runs the hour. Sorting by shares plus saves, her top eight posts include six grocery store breakdowns, the ones where she walks an aisle and explains what she would buy for a specific goal. Her bottom third is dominated by day-in-the-life vlogs, which averaged under one share each and made up a third of her output.
Her next batch writes itself: ten grocery breakdowns, each for a different goal or budget, and zero vlogs. The following month, her average shares per post roughly double, less because the content got better and more because she stopped spending slots on a lane her audience had already voted against. One hour, one spreadsheet, and her next quarter has a spine.
The uncomfortable lesson from Ivy's sheet is that she half-knew the vlogs were not working, and posted them anyway because they were easy to make. The audit's job is to make that knowledge impossible to ignore.
What about the middle third?
The middle of your ranking is the judgment zone. Some of those posts are good ideas with weak hooks, and they deserve a second take with a sharper opening line. Others are winners in disguise that went up at a strange time or got buried behind a stronger week. Pick two or three middle posts whose topics match your top cluster and remake them before you write anything new. Remakes are the cheapest content you will ever produce, because the idea is validated and the script already half exists.
How often should you run the audit?
Quarterly is the rhythm that fits how much data a few posts a week produces. Run it more often and you are reading noise. Run it once and never again, and your pillars drift out of date as your audience changes. Put a recurring hour on your calendar every 90 days, treat it like a client meeting, and let each audit set the next quarter's batch plan.
Do this next
Block one hour this week, export your data, and run the five steps with the timer on. By minute 60 you will know your top cluster, your dead lane, and your next ten videos. If you would rather skip the spreadsheet, Batchly runs the whole audit from your analytics upload and hands back pillars, scripts, and a Batch Day filming plan for $9.99 a month.