Content Audit Template: How to Evaluate Every Post on Your Blog

A content audit template is the foundation of any serious content program. Without one, content decisions are made on gut instinct: the post that looks old gets updated, the post someone remembers writing gets refreshed, and the dozens of underperforming pages that are quietly dragging down your site's quality signals go untouched.

A systematic audit changes that. You pull data, score every post against consistent criteria, and assign a clear action: update, consolidate, prune, or leave. You end up with a prioritized queue that tells your team exactly where to focus.

This guide walks through the entire process: what data to pull, which columns to include in your spreadsheet, how to score each post, and how to decide which action category each page belongs in.

Why a Structured Audit Beats Ad Hoc Content Reviews

Most content teams do some version of an audit, but without a template, the process is inconsistent. One person focuses on traffic. Another focuses on how old the publish date is. A third focuses on personal preference.

The result is a list of posts to update that does not reflect actual business impact.

A structured audit enforces consistency. Every post gets evaluated by the same criteria. The scores make prioritization transparent. And when you revisit the audit in six months, you can compare scores to measure progress.

The other benefit is documentation. A well-maintained content audit spreadsheet becomes a living map of your entire content program: what exists, what it covers, what it ranks for, and what shape it is in. For teams managing hundreds of posts, this institutional knowledge is irreplaceable.

The Content Audit Spreadsheet: Columns to Include

Build your spreadsheet with these columns. You do not need all of them immediately, but these are the data points that drive the best decisions.

Identification Columns

These columns establish what the post is and give you basic signals about whether it is stale.

Performance Columns

Performance data is the most important input. A post with 50 monthly organic sessions is a fundamentally different situation from a post with 5,000 sessions, regardless of how the content looks on the surface.

Quality Columns

Quality columns require a human review. Block time to read a representative sample of your posts and score each one. You do not need to read every word; a 30-second scan is enough to judge depth and accuracy for most posts.

Classification Columns

How to Score Each Post

A numeric scoring system removes subjectivity from prioritization. Use this formula to generate a priority score for each post:

Priority Score = (Business Potential x 3) + (Current Performance x 2) + (Content Quality x 1)

Score each component on a scale of 1 to 5:

Business Potential (weight 3x):

• 5: Target keyword has high volume, the topic is central to your product, the post is in a high-converting category
• 3: Moderate keyword volume, relevant topic, average conversion category
• 1: Low-volume keyword, tangentially related topic, low-converting category

Next, assess how the post is currently performing in search.

Current Performance (weight 2x):

• 5: Post is ranking in positions 4-10 with high impressions (near the top, has momentum)
• 3: Post is ranking 11-20 or has moderate traffic
• 1: Post has minimal traffic and impressions (below position 30 or not indexed)

Finally, evaluate the quality of the content itself.

Content Quality (weight 1x):

• 5: Comprehensive, accurate, well-structured, strong CTA
• 3: Adequate depth, some gaps, CTA present but weak
• 1: Thin, outdated, or missing a clear CTA

A post with Business Potential 4, Performance 3, Quality 2 would score: (4x3) + (3x2) + (2x1) = 12 + 6 + 2 = 20. Posts with higher scores should be addressed first.

This weighting reflects a key insight: business potential matters more than current traffic. A post ranking position 15 for a high-value keyword is a better investment than a post ranking position 3 for a keyword your buyers do not care about.

The Four Action Categories

Every post in your audit belongs in one of four categories.

Update

A post you update is one with real ranking potential where outdated content, thin coverage, or weak optimization is limiting its performance.

Signs a post needs an update:

• Ranking positions 4-20 for a valuable keyword (within striking distance of top 3)
• Traffic dropped compared to the previous period with no ranking explanation
• Published more than 12 months ago with time-sensitive information
• Content depth score of 2 or below relative to competing pages
• Missing structured data, internal links, or a strong CTA

When you update a post, treat it as a substantial rewrite, not a light edit. Add new data, improve the structure, deepen the coverage, and optimize the meta tags. The content refresh strategy guide covers the full process.

Consolidate

Two or more posts covering the same topic dilute each other's ranking potential. Pick the stronger post (higher traffic, more backlinks, better URL), redirect the weaker posts to it, and merge the best content from the weaker posts into the primary URL.

Signs a post needs consolidation:

• Two or more posts targeting the same primary keyword
• Thin coverage that would be better served by combining into one comprehensive piece
• Multiple posts with fewer than 300 words each on related subtopics

Consolidation is one of the most impactful actions in a content audit. Consolidating duplicate or near-duplicate pages concentrates ranking signals. The effect on positions can be significant and fast.

Prune

A post you prune is removed from the site entirely, typically with a 301 redirect to a more relevant page or to the category index.

Prune a post when:

• It has zero or near-zero organic traffic for 6+ months
• The topic is no longer relevant to your business
• The content is irredeemably thin and not worth rewriting
• It creates confusion or cannibalization with a stronger post on the same topic

Do not prune posts with backlinks. Before removing any post, check the backlink profile in Ahrefs or Semrush. A post with external backlinks has link equity that needs to be redirected appropriately, not discarded. The content pruning guide covers how to handle these cases safely.

Leave

A post you leave is one that is performing well, is accurate, and does not need intervention. Leaving posts alone is an underrated action. Not every post needs to be touched.

Leave a post when:

• It is ranking in positions 1-5 for its target keyword
• Traffic is stable or growing
• Content is accurate and comprehensive
• No cannibalization issues exist

Documenting "Leave" decisions is important for accountability. When someone asks why you are not updating a high-traffic post, the audit record shows it was reviewed and intentionally left.

Prioritizing Your Audit Action List

Once every post has a priority score and an action category, sort by action category first, then by priority score within each category.

Work the Update and Consolidate lists first. These have the highest impact on organic performance. Updates to near-ranking posts produce faster results than any other content investment. Consolidations often produce quick ranking gains by eliminating cannibalization.

Prune actions can be batched and executed in bulk once you have confirmed redirects. Do not rush pruning; a redirect audit takes time to get right.

Set a realistic timeline. A team of two content editors can realistically work through 20 to 30 update actions per quarter at high quality. Overloading the queue leads to rushed updates that do not move the needle.

Track completion in the same spreadsheet. Add a "Status" column with values like "In Progress," "Published," and "Redirect Live." Reviewing completion rate at the end of each quarter tells you whether your audit process is working or if it is a planning exercise that does not translate to execution.

How to Pull the Data

Here is a practical workflow for populating the audit spreadsheet:

1. Export all post URLs from your CMS, sitemap, or Screaming Frog crawl.
2. Pull Google Search Console data for clicks, impressions, and average position over 90 days. Export from the Performance report filtered to your blog URLs.
3. Pull Google Analytics 4 data for organic sessions by page. Use the Pages and Screens report filtered to the organic traffic segment.
4. Pull backlink counts from Ahrefs Site Explorer or Semrush Backlink Analytics. Export domain-level referring domains per URL.
5. Add word count using a bulk URL word count tool or a Screaming Frog crawl with a custom extraction.
6. Fill in quality scores manually after reviewing each post.

The entire data collection process for a 200-post blog takes about four hours. The scoring and action assignment take another four to six hours, depending on how many posts require careful review. Schedule this as a dedicated work block, not a task you pick at between other things.

Connecting Your Audit to Content Planning

A content audit is not a one-time exercise. Run it on a quarterly or semi-annual cadence. Update the priority scores based on fresh performance data. Reprioritize the action list as rankings and business priorities shift.

Connect your audit findings to your content plan. If the audit reveals 30 posts that need updates, your content calendar should reflect that. New post production and existing content optimization should share your team's bandwidth intentionally, not compete for it ad hoc.

For teams that want to go further, the content performance analysis guide covers how to set up ongoing monitoring dashboards that surface which posts need attention between formal audit cycles.

A well-executed content audit is the fastest way to improve organic performance without publishing a single new post. The gains from updating near-ranking posts, consolidating duplicates, and pruning dead weight compound over time because every action improves the overall quality of the site that Google is evaluating.