Content Audit Template: A Practical Step-by-Step Guide

A content audit template is a structured spreadsheet that tracks every page on your website alongside key performance data: organic traffic, keyword rankings, backlinks, on-page SEO health, and technical issues. It helps you decide whether each page should be kept, updated, consolidated, or deleted. Most teams see ranking improvements within 60 to 90 days of implementing audit decisions.

What a Content Audit Template Does

A content audit is the process of evaluating every piece of existing content on your website to measure how it performs and whether it supports your goals.

The template itself is the working document where that evaluation happens. Think of it as a decision board: you pull performance data for each URL, score each page against criteria that matter to your business, and assign one of four actions.

Without the template, you’re making judgment calls from memory. With it, you’re making decisions from data.

A content audit helps you:

Step 1: Define Your Goal Before You Open the Spreadsheet

Before you collect a single URL, decide what success looks like. This determines which metrics you track and how you interpret the data.

Three common audit goals:

Improve SEO performance. Focus on organic traffic, keyword rankings, and backlinks. Any page not contributing to search visibility is a candidate for review.

Increase conversions. Focus on landing pages and service pages. Measure form submissions, calls, and purchases tied to organic traffic. A page ranking well but converting at under 1% has a different problem than a page with no traffic at all.

Improve content quality. Focus on outdated information, thin content, and pages that fail Google’s Helpful Content Update standards. Post-2024, pages with low E-E-A-T signals can suppress the rankings of your entire domain, not just the individual page.

Step 2: Collect Your URLs

You cannot audit what you haven’t found. Start by building your URL list.

For smaller sites under 100 pages, export your sitemap directly from your CMS. For larger sites, use Screaming Frog SEO Spider (free up to 500 URLs) or Google Search Console’s indexed pages report under Coverage. Tools like Semrush Site Audit or Ahrefs Webmaster Tools crawl your site and export a complete URL list with status codes already attached.

One practical rule: exclude pages published in the last six months from the audit. New pages have not had enough time to establish organic signals, and auditing them now leads to premature decisions.

Apply the 80/20 rule for large sites. Auditing a site with 1,000 blog posts is not realistic in one session. Instead, pull the top 20% of pages by organic traffic. Improving those pages delivers roughly 80% of your possible results. Audit the rest in rolling quarterly batches.

The Content Audit Template: Column-by-Column

Once you have your URL list in a spreadsheet, add these columns. Each one maps to a specific decision.

Column	What to Track	Data Source
URL	Full page address	Crawl export
Page Type	Blog post, landing page, service page	Manual
Focus Keyword	Primary target term	Keyword research
Organic Traffic (90 days)	Clicks from search	Google Search Console
Keyword Ranking	Current position	Semrush or Ahrefs
Referring Domains	Number of sites linking in	Ahrefs or Semrush Backlinks
On-Page SEO	Title tag, meta, headers, alt text	Screaming Frog or On-Page tool
Technical Issues	Crawl errors, speed, indexability	Google Search Console
Internal Links	Does this page receive internal links?	Site audit tool
Last Updated	Date of last content edit	CMS
Action	Keep / Update / Consolidate / Delete	Your decision

This structure works without any paid tool. Google Search Console handles organic traffic and technical issues.

Step 3: Score Each Page Before You Decide

The four decisions (keep, update, consolidate, delete) become much clearer when you score each page first. Here is a practical scoring system:

Factor	Score 1	Score 2	Score 3
Organic traffic	Under 10 clicks / 90 days	10 to 100 clicks	Over 100 clicks
Keyword ranking	Position 50 or below	Position 11 to 49	Position 1 to 10
Referring domains	Zero	1 to 5	6 or more
Business relevance	Not tied to any offer	Loosely related	Directly tied to revenue
Content age	Over 3 years, not updated	1 to 3 years	Under 1 year

Total each page’s score:

This scoring system removes the guesswork. A page sitting at position 14 with 40 clicks in the last 90 days and three referring domains scores an 8. It needs an update, not deletion.

Step 4: The Four Decisions Explained

Keep as-is. The page is ranking well, traffic is healthy, and the content is current. The only action is a quarterly check to confirm the information has not aged out.

Update. Use this when a page ranks on page two or three, when the content is outdated, or when competing pages cover subtopics yours does not. Updating means rewriting sections to match current search intent, adding missing subtopics found in competing pages, fixing on-page SEO issues like missing title tags or thin meta descriptions, and strengthening the internal linking structure.

Consolidate and redirect. This applies when two or more pages target the same keyword and none of them ranks strongly. Pick the stronger page as the primary URL, fold the best content from the other pages into it, and 301 redirect the others to the primary URL. This concentrates link equity into a single page instead of splitting it across duplicates.

Delete. A page with zero organic traffic, zero backlinks, and no connection to your business goals does not improve with time. It sits there consuming crawl budget and potentially pulling down your site’s overall quality assessment. Delete it and either return a 404 or set up a redirect to the most relevant category page.

One important distinction the Helpful Content Update made relevant: thin content and low-traffic content are different problems. A well-written, substantive page that gets no traffic may just need better internal links or a topic update.  

How to Audit Content for AI Overview Eligibility

Google AI Overviews and tools like ChatGPT pull from content that:

During your content audit, flag pages that rank in positions 3 to 10 for informational queries. These are your highest-potential candidates for AI visibility. Add FAQ sections with schema markup, improve the opening paragraph to answer the query directly in the first two sentences, and ensure the author or organization is clearly identified with relevant credentials.

For pages that contain AI-generated content published before your quality controls were in place, evaluate them individually. If the content is accurate, helpful, and demonstrates genuine expertise, update the author attribution and strengthen the E-E-A-T signals. If it is thin or inaccurate, rewrite it or delete it.

How Often Should You Run a Content Audit?

This depends on your site size. Here is a practical schedule:

Do not wait until rankings drop to audit. Run audits on a schedule and treat them like site maintenance, not emergency response.

Content Audit Tools: What You Need

You do not need every tool to run a useful audit. These are some right options to perform content audit:

Free tools that cover the essentials:

Paid tools that save time at scale:

For most content teams running audits quarterly, Google Search Console plus Screaming Frog’s free tier covers the majority of what you need.

The Next Step

The content audit template is not a one-time exercise. Sites grow, search intent shifts, and Google’s quality standards evolve. A team that runs structured audits every quarter has a concrete advantage over one that publishes continuously without ever looking back.

Start with what you have: pull your top 20 pages by organic traffic from Google Search Console, build the template columns above in Google Sheets, score each page using the criteria in this article, and assign your first round of actions.