What Is a Content Audit? Step-by-Step Guide (With Template)

What a content audit is, why it matters for SEO, and how to run one step by step: build an inventory, gather data, then decide to keep, update, merge or remove.

By Published 8 min read

A content audit is a systematic review of every piece of content on a website — each page, post and landing page — to decide what to keep, what to improve, what to combine and what to remove. It turns a pile of URLs that grew over years into a deliberate set of pages that each have a job.

Most sites never do one.

Pages get published, links point at them, and nobody looks again until traffic drops. An audit is how you find the pages quietly dragging the site down, the ones one update away from ranking, and the duplicates competing with each other.

This guide walks through a complete audit you can run with free tools and a spreadsheet.

Why a content audit is worth the effort

Search engines look at whole sites. Google's helpful content guidance, folded into its core ranking systems in 2024, says its systems use site-wide signals as well as page-level ones. A large amount of unhelpful content can therefore weigh on how the rest of a site performs.

Old pages decay. Statistics go stale, products change, screenshots show interfaces that no longer exist, and competitors publish better answers. A page that ranked well two years ago may be slipping for reasons that are easy to fix.

Pages compete with each other. Three thin posts on the same topic usually perform worse than one strong page. An audit finds these overlaps (often called keyword cannibalisation) so you can merge them.

It shows what to write next. Once you can see which topics earn traffic and which have gaps, you know where the next articles should go.

AI search reads your content too. Assistants like ChatGPT, Claude and Perplexity quote pages that answer questions clearly, state who wrote them and when, and are readable without JavaScript.

Content audit vs SEO audit

The two overlap but answer different questions:

  • A technical SEO audit asks whether search engines can crawl, render and index the site: status codes, redirects, robots.txt, sitemaps, speed, structured data.
  • A content audit asks whether each page deserves to exist and does its job: is it useful, accurate, unique, and does it earn traffic or conversions?

Run the technical check first, then the content audit. There's no point rewriting pages Google can't reach, and our robots.txt guide covers the most common crawl blocker.

Before you start: pick a goal

An audit without a goal produces a spreadsheet nobody acts on.

Choose one primary aim, because it decides which numbers matter:

  • More organic traffic: focus on clicks, impressions, rankings and search intent.
  • More leads or sales: focus on conversions and the pages that sit on the path to them.
  • Better user experience: focus on engagement, outdated information and broken journeys.
  • A smaller, cleaner site before a redesign or migration: focus on what can be removed or merged.

For a small site, audit everything. For a large one, start with a section (the blog, or one product category) and expand once the process works.

Step 1: Build a content inventory

List every indexable URL on the site in one spreadsheet. Three good sources, ideally combined:

  1. Your XML sitemap. It should already list the pages you want indexed. Paste your sitemap URL into the XML Sitemap Checker: it validates the file and exports every URL to CSV, which you can open straight in a spreadsheet.
  2. Google Search Console. Under Indexing → Pages, export the indexed pages. This catches URLs Google knows about that your sitemap doesn't, often old pages you forgot existed.
  3. A crawler, if the site is large or the sitemap is unreliable. A crawl finds what's actually linked from the site.

Merge the lists and remove duplicates. Pages that appear in Search Console but not in your sitemap deserve a closer look: they're either missing from the sitemap or shouldn't exist.

Step 2: Gather data for every URL

Add columns to the inventory. Keep it to what you'll actually use for decisions:

Basics

  • URL
  • Page type (blog post, product, category, landing page…)
  • Title
  • Topic or target keyword
  • Date published and last updated

Search performance (from Search Console, last 12 months to smooth out seasonality)

  • Clicks
  • Impressions
  • Average position

Behaviour and business (from your analytics tool, such as GA4)

  • Sessions or views
  • Engagement rate
  • Conversions or key events

Quality signals

  • Word count
  • Number of internal links pointing to the page
  • Backlinks, if you have a tool that shows them (our comparison of Ahrefs, Semrush and Moz explains what the paid options include)
  • Obvious problems: missing meta description, multiple or missing H1, slow loading, broken links

You don't need to check the quality signals page by page by hand. Running each important URL through the Website Auditor flags thin content, missing or overlong titles and descriptions, heading problems, broken links and slow pages in one report, and the PDF export makes it easy to share findings with whoever will do the fixes.

Step 3: Assess each page

Now read the pages.

Data tells you what is happening; reading tells you why. For each URL, ask:

  • Is it accurate and current? Dates, prices, statistics, screenshots, product names.
  • Does it match search intent? Look at what currently ranks for its main keyword. If the top results are step-by-step guides and yours is a sales page, the format itself needs to change.
  • Is it the best answer available? Compare it honestly with the top three results.
  • Is it unique? Does another page on your own site cover the same topic?
  • Does it show who wrote it and why they're credible? Author, date, sources, first-hand experience.
  • Does it lead somewhere? A clear next step: a related guide, a tool, a contact form.

Score pages simply: good, needs work, poor.

Step 4: Decide what to do with each page

Every page gets exactly one of five actions. This decision table covers most cases:

Action When What to do
Keep Performs well, accurate, matches intent Leave it. Add internal links to it from newer pages.
Update Has impressions or past traffic but is slipping, outdated or thin Refresh facts, expand where competitors are better, improve the title and description, update dateModified.
Consolidate Several pages cover the same topic and split the traffic Merge the best material into the strongest URL and 301-redirect the others to it.
Remove and redirect No value, but has backlinks or traffic Delete it and 301-redirect to the most relevant page.
Remove No traffic, no links, no purpose, nothing relevant to redirect to Delete it and let the URL return 404 or 410.

A few rules that prevent expensive mistakes:

  • Low traffic alone is no reason to delete. Some pages serve customers, legal requirements or conversions. Check conversions and backlinks first.
  • Redirect to something genuinely relevant. Redirecting every removed page to the homepage is treated by Google much like a 404 and frustrates visitors.
  • Update before you delete. A page with impressions but few clicks often just needs a better title: it's already ranking somewhere.
  • Keep the URL when you update. Changing it throws away the history the page has built.

Step 5: Act, starting with the biggest wins

Work in this order, because it front-loads the results:

  1. Quick wins: pages ranking roughly in positions 5–20 with plenty of impressions. A better title, a refreshed introduction, a few added sections and stronger internal links can move them onto page one.
  2. Consolidations: merging competing pages usually produces one page that outranks all of the originals.
  3. Major updates to important pages that have decayed.
  4. Removals and redirects, done in a batch so you can test the redirects together.

After removing or redirecting pages, update your XML sitemap so it lists only live, indexable URLs, and check it again with the sitemap checker.

Step 6: Measure and repeat

Note the date you made each change in the spreadsheet, then compare clicks and impressions in Search Console four to eight weeks later, because changes take time to be recrawled and re-evaluated. Expect updates to lift some pages and not others. Then put the next audit in the calendar:

  • Small sites: once a year.
  • Sites publishing weekly or more: every six months, or a rolling audit of one section per quarter.
  • Before any redesign or migration: always.

A content audit template

Download the template in whichever format you use. Both files have the same 14 columns and two filled-in example rows, marked so you can delete them. The Excel version adds a dropdown for the Action column and a second sheet holding the decision table from step 4.

Download the template (.xlsx) Download as CSV

The columns, if you'd rather build your own:

URL Type Topic Published Updated Clicks (12 mo) Impressions Avg position Conversions Words Issues Action Notes Done
/blog/example-post/ Blog example topic 2024-03-01 2024-03-01 120 8,400 14.2 2 650 Thin; outdated stats Update Expand pricing section ☐

Two habits make the template work: use a fixed list of values in the Action column (Keep, Update, Consolidate, Remove and redirect, Remove), and fill in Notes with the specific change, so whoever picks up the row knows exactly what to do.

Checking AI search readiness during the audit

Because you're already reviewing every important page, check how AI assistants see them too:

  • Is the main content in the HTML? Many AI crawlers don't run JavaScript, so content drawn in the browser is invisible to them.
  • Can AI search crawlers reach the page? A robots.txt rule meant for training bots sometimes blocks AI search bots as well.
  • Does the page answer questions directly? Question-style headings with short, clear answers are what assistants quote.
  • Is it dated and attributed? A visible author and an accurate last-updated date help both readers and machines judge freshness.

The AI Visibility Checker tests a page for each of these in a few seconds.

Frequently asked questions

How long does a content audit take?

For a site with under 100 pages, a day or two. For several thousand pages, plan for weeks, or audit one section at a time.

Will deleting pages hurt my SEO?

Removing genuinely unhelpful pages usually helps, but removing pages that have backlinks, traffic or conversions without redirecting them can hurt. Check each page's data before deleting, and redirect when a relevant page exists.

What's the difference between a content audit and a content inventory?

The inventory is the list of URLs with their data (steps one and two). The audit is the judgement and the decisions you make from it.

What tools do I need?

A spreadsheet, Google Search Console, your analytics tool, and something to list your URLs and check pages for problems. All of that can be done with free tools.

Tools in this guide

All guides
Action successful