Content Audit Template: Decide What to Keep, Fix, Repurpose or Retire
A four-label review that turns old posts into next month's calendar
Quick download
Get the free content audit template
Download the worksheet, jump to the template section, or preview its fields first.
Step 1: Build the inventory
List every post in the window with its URL, format, topic, and the audience question it answered. Copy the numbers each platform's own analytics shows for that post, and note the date you read them. If a platform does not show a metric, leave the cell empty. An empty cell is more honest than an estimate.
- One row per post, not per campaign.
- Record the intended outcome (saves, replies, clicks, sign-ups) before you look at results.
- Note the destination each post sent people to, if any.
Step 2: Label every post
Give each post exactly one label. Forcing a single choice is what makes the audit useful, because it stops you from keeping everything.
- Keep: it did its intended job and the topic is still current. Plan a similar post.
- Fix: the idea was right but the hook, format, or call to action was weak. Rewrite it and publish it again.
- Repurpose: the idea works but suits another format, such as a long post that should become a carousel or a short video.
- Retire: no clear audience question, outdated advice, or a format you no longer want to make. Stop producing it.
Step 3: Turn labels into calendar changes
Convert each label into a dated task. A keep becomes a follow-up post. A fix becomes a rewritten draft with an owner and a date. A repurpose becomes a new draft in the target format. A retire becomes a line in your do-not-make list, so you do not drift back to it.
Limit the first round to a handful of changes. If you schedule fifteen experiments you will not be able to tell which one moved anything.
A worked example (illustration only)
Imagine a creator who teaches watercolor and reviews twelve posts. A step-by-step tutorial is saved often, so it is a keep: plan a second tutorial on the same technique. A supplies list has a good idea but an unclear opening line, so it is a fix. A long caption explaining color mixing would read better as a carousel, so it is a repurpose. A weekly motivational quote has no tie to any audience question, so it is a retire.
This example is invented to show the process. It is not a customer result, and the labels you choose depend on your own data and goals.
Common mistakes
- Auditing without a goal, so every metric looks equally important.
- Comparing posts across platforms as if the numbers meant the same thing.
- Judging by one number. Read the metric against the outcome you wanted.
- Skipping the retire label, which leaves the calendar full of low-value work.
How often should you audit?
Quarterly works for most creators with a steady posting rhythm. If you post daily, a lighter monthly pass on the last four weeks is easier to keep up. Move the findings straight into your content calendar so the audit changes what you publish next.
Reference tables
Content audit fields that create action
Planning fields, not research data. Fill one row per post.
| Field | What to record | Decision it should create |
|---|---|---|
| Post URL and date | Link, platform, format, publish date | Locate the post later |
| Intended outcome | Saves, replies, clicks or sign-ups you wanted | Judge the post against its own goal |
| Result | Numbers from the platform's analytics, with read date | Separate observation from guess |
| Label | Keep, fix, repurpose or retire (pick one) | Decide the next action |
| Next action | Task, owner, due date | Put it on the calendar |
Source: Original Repping.AI worksheet; fill it with your own data
Interactive tool
Content audit checklist
Tick each item before you call the work finished. Use your own evidence, not assumptions.
Downloadable template
Download the content audit template
A Markdown worksheet with the fields and checklist from this guide. Fill it in with your own data.
Download templateFrequently asked questions
How many posts should I audit?
Audit the posts from one platform and one date window, such as the last three months. A smaller sample you finish is better than a large one you abandon.
What should I do with posts that have no clear result?
Mark the metric as missing and judge the post on the audience question it answered. Do not fill gaps with estimates.
Do I need a paid tool for a content audit?
No. A spreadsheet or the downloadable worksheet is enough. Repping.AI's free content calendar template can hold the calendar changes that come out of the audit.
Related reading
Free social media content audit template: review each post against its goal, log signals and audience language, and plan next month's calendar.
Free weekly social media analytics report template: group posts by goal, log audience language, and end with calendar changes for next week.
Choose three to five content pillars built from audience problems, turn each into repeatable formats, and review them monthly with real signals.
Related product pages
Turn your audit into scheduled posts
Use Repping.AI Creator for AI-assisted drafts, platform-specific posts, and scheduling. Free includes your creator page and free tools. Pro approval workflows are coming soon. Repping.AI collects post performance metrics on 13 platforms and channel analytics for YouTube.
See how it works