The Only Content Audit Template You'll Ever Need

A content audit without a good template is like a road trip without a map. You might eventually get somewhere useful, but you will waste enormous amounts of time along the way. This guide provides a comprehensive, battle-tested template that works for any website, from a 50-page startup site to a 10,000-page enterprise portal.

What Your Template Needs to Capture

Every content audit template must balance comprehensiveness with practicality. Capture too little data and your audit will miss critical insights. Capture too much and your team will drown in spreadsheet columns they never use.

Essential Columns

These columns form the foundation of any content audit:

• URL: The full URL of the page
• Page Title: The title tag content
• H1: The primary heading on the page
• Content Type: Blog post, product page, landing page, support article, etc.
• Word Count: Total word count of the main content
• Last Modified Date: When the page was last updated
• Meta Description: Present or missing, and the actual text
• Internal Links In: Number of internal pages linking to this URL
• Internal Links Out: Number of internal links on this page

Performance Columns

Layer in analytics data to understand how each page is actually performing:

• Organic Sessions (90 days): Traffic from search engines via GA4
• Total Pageviews (90 days): All traffic sources combined
• Bounce Rate / Engagement Rate: User behavior signals
• Search Impressions (90 days): Visibility in Google search results via GSC
• Search Clicks (90 days): Actual clicks from search results
• Average Position: Where the page ranks for its primary keywords

Quality Assessment Columns

These columns require human judgment and are filled during the qualitative phase:

• Relevance Score (1-5): Does this content align with current business goals?
• Quality Score (1-5): Is the writing clear, accurate, and comprehensive?
• SEO Score (1-5): Does the page follow technical SEO best practices?
• Overall Score: Weighted average of the above dimensions
• Action: Keep, Improve, Consolidate, or Remove
• Priority: High, Medium, or Low
• Notes: Specific observations and recommendations

The Scoring Framework

Raw data is not actionable until you apply a consistent scoring methodology. Use this four-dimension framework to assess every page objectively.

Dimension 1: Relevance

Does this content still serve your business and audience? Content about discontinued products, past events, or outdated industry practices scores low on relevance regardless of its quality.

Dimension 2: Quality

Evaluate the writing, formatting, and completeness. Is the content well-structured with headings and lists? Are claims supported with evidence? Is the tone consistent with your brand? Would you be proud to share this page with a prospect?

Dimension 3: Performance

Let the data speak. Pages with strong organic traffic, good engagement metrics, and meaningful conversion rates earn high performance scores. Pages with zero traffic over 90 days have a clear performance problem.

Dimension 4: SEO Health

Check the technical fundamentals. Does the page have a unique, descriptive title tag? A compelling meta description? A single H1? Proper internal linking? No broken images or slow load times?

Deciding What to Do With Each Page

After scoring, every page falls into one of four action categories.

Keep: High scores across all dimensions. These pages are working. Monitor them and update periodically to maintain quality.

Improve: Good content with fixable problems. Maybe the page ranks on page two and needs better optimization, or the content is solid but the formatting is dated. These are your highest-leverage opportunities.

Consolidate: Multiple pages covering the same topic, each too thin to rank well on its own. Merge them into a single comprehensive resource that outperforms any individual piece.

Remove: Low relevance, low quality, low performance, and no realistic path to improvement. Removing these pages reduces crawl waste and concentrates your site's authority on content that matters.

Making It Repeatable

The real value of a content audit comes from repetition. Your first audit establishes a baseline. Subsequent audits, ideally quarterly, track improvement and catch new problems early.

Save your template with all formulas and scoring criteria intact. Document your methodology so any team member can run the audit consistently. Automate the data collection wherever possible — manual URL-by-URL analysis does not scale.

The goal is not a one-time cleanup but an ongoing practice of content governance that keeps your site healthy as it grows.