A content audit gives you a practical way to decide which blog posts to keep, improve, combine, redirect, or retire. This reusable content audit template helps you catalogue pages, compare performance, identify outdated or overlapping content, assign refresh priorities, and review the results on a monthly or quarterly schedule.
Overview
A blog content audit is a structured review of the pages on your site. It is more useful than checking traffic alone because it combines performance data with editorial judgement. A post may attract visitors but contain outdated advice, or it may receive little traffic while targeting a valuable topic that needs better optimisation.
The aim is not to change every article. The aim is to make a defensible decision about each important URL and focus limited publishing time where it can have the greatest effect. A simple audit spreadsheet can become the central record for these decisions and a useful part of your publishing workflow.
Before starting, choose a clear scope. You might audit every blog post, only pages older than 12 months, or one topic cluster at a time. If the site is large, begin with your most important categories, pages that previously performed well, and posts that are close to ranking for relevant searches.
For a wider planning system, pair this audit with a content planning template for bloggers and creators. The audit shows what already exists; the planning process helps decide what should be created next.
What to track
Use one row per URL and keep the spreadsheet easy to filter. The following fields provide enough detail for most independent bloggers and publisher teams.
Identification and ownership
- URL: The exact page address.
- Title: The current page title or headline.
- Content type: For example, guide, tutorial, review, comparison, case study, or glossary page.
- Topic cluster: The wider subject the page supports.
- Primary query: The main search intent the page is intended to satisfy.
- Editor or owner: The person responsible for the next action.
- Last updated: The date of the most recent meaningful revision, not merely a date change.
Performance indicators
- Organic clicks and impressions: Record the same date range for every page so comparisons are fair.
- Average search position: Use it as directional evidence rather than a complete measure of success.
- Click-through rate: A useful prompt to review the page title and description when impressions are present but clicks are weak.
- Sessions or page views: Add analytics data if it is available and consistently measured.
- Conversions or assisted actions: Track newsletter sign-ups, downloads, enquiries, affiliate clicks, or other outcomes relevant to the page.
- Internal links: Note important links pointing to the page and links leading from it.
Quality and risk checks
- Search intent match: Mark whether the page answers the likely reason behind the query.
- Freshness: Record whether examples, screenshots, tools, recommendations, or instructions need checking.
- Content depth: Note missing steps, unanswered questions, weak evidence, or sections that no longer add value.
- Overlap: Identify pages targeting substantially similar topics or search intents.
- Technical status: Check indexability, broken links, redirects, canonical settings, and obvious rendering problems where relevant.
- Recommended action: Choose one clear outcome: keep, refresh, expand, consolidate, redirect, or remove from active promotion.
A practical spreadsheet can also include a short notes field. Write specific observations such as “old product examples in section three” or “two posts answer the same beginner question”. Specific notes make the next task easier to assign than general comments such as “needs SEO”.
A simple priority formula
To prevent the loudest problem from always receiving attention, score each page against a small set of criteria. For example, give each factor a value from 0 to 3:
- Business or audience value: How useful is the page for your goals?
- Opportunity: Is there evidence of relevant impressions, engagement, or demand that the page is not fully capturing?
- Decay or risk: Is the information outdated, inaccurate, inaccessible, or likely to disappoint readers?
- Effort: How practical is a meaningful improvement?
One straightforward formula is Priority score = value + opportunity + decay + (3 - effort). This gives a maximum score of 12. Label pages with higher scores as “now”, middle scores as “next”, and lower scores as “monitor”. The formula is a decision aid, not a prediction of traffic. Adjust the weighting if accuracy or legal sensitivity makes certain updates more urgent than their search performance suggests.
When revising a selected page, use an on-page SEO checklist for blog posts to review headings, internal links, metadata, media, accessibility, and page intent in a consistent order.
Cadence and checkpoints
Run a full audit quarterly if your site has a manageable number of pages. A monthly light review is useful for monitoring recently updated posts and catching obvious changes. Larger sites can use a rolling process: review one category or topic cluster each month and complete a full catalogue over the course of a quarter.
Monthly checkpoint
- Filter for pages updated during the previous month.
- Check whether the intended change was published correctly.
- Look for sudden drops, new ranking opportunities, broken links, or comments showing reader confusion.
- Record the next action and owner rather than reopening every decision.
Quarterly checkpoint
- Export or record comparable performance data for the chosen period.
- Review pages with falling clicks, high impressions and low click-through, or no meaningful engagement.
- Compare pages within the same topic cluster to find overlap and gaps.
- Check whether refreshed pages have been recrawled and whether their results are stabilising.
- Update the priority queue and move completed work into a change log.
Do not judge a revision immediately after publication. Allow enough time for the page to be discovered and for a comparable reporting period to develop. The appropriate interval varies by site, topic, and publishing volume, so record the review date and use the same comparison window wherever possible.
How to interpret changes
Performance changes need context. A fall in clicks is a signal to investigate, not proof that the article has failed. First check whether impressions also changed. If impressions are stable but clicks have fallen, review the title, description, search intent, and competing page types. If both impressions and clicks have fallen, inspect topical relevance, freshness, internal linking, technical accessibility, and whether the query itself has changed.
Pages with impressions but limited clicks may need a clearer promise in the title, a more direct opening, or better alignment with the searcher’s question. Pages with clicks but weak reader actions may need improved structure, stronger internal links, clearer next steps, or a better match between the article and the reader’s stage.
When two pages overlap, compare their purpose rather than simply comparing keywords. If both pages serve the same intent, consolidation may produce a clearer resource. If they serve different audiences or stages, keep both and strengthen their distinctions with precise titles, introductions, headings, and internal links.
A refresh should improve the reader’s experience, not just add words. Replace obsolete examples, remove repetition, answer missing questions, check every important link, update the introduction, and make the recommended action clear. Avoid changing a URL without a reason; if consolidation or removal is appropriate, document the decision and check the resulting redirect or internal-link path.
For practical tooling, you can combine analytics, search performance data, a site crawler, a spreadsheet, and writing aids. A guide to free SEO tools for bloggers can help you assemble a lightweight process without making the audit dependent on one platform.
When to revisit
Revisit this content audit template at least quarterly, with additional checks after a substantial site change. Return to the spreadsheet when you publish a new topic cluster, redesign navigation, change a major conversion path, merge articles, or notice a sustained shift in search performance. Also review individual pages whenever their subject depends on changing tools, features, examples, regulations, or recommendations.
End every audit with three short lists:
- Refresh now: Pages with clear value, a realistic improvement path, and meaningful decay or opportunity.
- Investigate: Pages where the data or overlap is unclear and needs a closer editorial decision.
- Monitor: Pages that are currently acceptable but should be checked at the next review.
Schedule the next review before closing the current one. Add each approved refresh to your editorial calendar, assign an owner, define the intended change, and record the date when results will be checked. After publication, add a short entry to the change log describing what changed. Over time, this creates a reliable record of which updates improved usefulness, visibility, or reader action.
The most effective audit is repeatable. Keep the fields stable, use comparable reporting periods, make one clear decision per URL, and prioritise work that improves both search relevance and the reader’s experience.
