A content audit is a systematic review of every indexed page on your site to determine which pages are contributing to rankings and which are quietly working against them. The goal is not just to find what is broken but to make deliberate decisions: update, consolidate, redirect, or remove. Most sites I audit have a significant share of pages that are neither ranking nor converting — they just exist, consuming crawl budget and diluting topical authority.

How to Pull the Data You Need

Start with a full crawl of your site using Screaming Frog or a comparable tool to get a complete URL list. Then match each URL against data from two sources:

  • Google Search Console: Export the Performance report at the page level. You want clicks, impressions, and average position for the trailing 12 months. Pages with high impressions but near-zero clicks are usually suffering from title/meta issues or ranking too low to get traffic. Pages with zero impressions are either not indexed or not relevant to any query.
  • Google Analytics (or equivalent): Pull sessions, bounce rate, and conversions by landing page. A page driving traffic but no conversions is a different problem than a page not driving traffic at all.

Once you have those two data sets merged by URL, you can segment pages into clear categories: strong performers, fixable underperformers, cannibalization candidates, and removal candidates.

Merging Screaming Frog and GSC Data in Practice

The merge step is where most people get stuck. Screaming Frog exports a spreadsheet with every URL it crawls — status codes, word counts, title tags, canonical URLs. GSC exports clicks and impressions per URL. The problem is the URL formats rarely match exactly. Screaming Frog will crawl https://example.com/page/ with a trailing slash; GSC may report https://example.com/page without one, or vice versa. Before you can VLOOKUP or merge in a tool like Google Sheets, you need to normalize both lists: strip trailing slashes, lowercase everything, and remove UTM parameters from the GSC export.

Once normalized, the merge gives you a row per URL with crawl data (indexability, word count, canonical, redirect status) alongside performance data (clicks, impressions, average position). Sort by impressions descending. The pages Googlebot is showing in search results but that get almost no clicks are your first priority — a title rewrite or meta description fix can move those without touching the content at all. Pages with zero impressions and low word counts under 300 words are your consolidation and removal candidates.

On a recent audit of a 400-page B2B site, that merge identified 112 pages with zero clicks and zero impressions over 12 months. Of those, 34 had no inbound internal links — orphaned pages that were indexed but Googlebot was finding only through the sitemap. Another 41 were thin location variants with under 200 words of unique text. That single data pass shaped the entire audit strategy.

The Four Actions a Content Audit Produces

  • Update: Pages that rank on page two or three for valuable terms, or that rank but have a declining trend, often need freshened data, expanded coverage, or better internal links pointing to them. These are the highest-ROI fixes in most audits.
  • Consolidate: Two or three thin pages targeting similar queries dilute each other. Merging them into one authoritative page with a 301 redirect from the old URLs concentrates link equity and signals topical depth.
  • Redirect or remove: Pages with no traffic, no backlinks, and no realistic path to ranking should be removed or redirected to a relevant live page. Keeping them indexed signals low quality at the site level.
  • Leave alone: Pages that are ranking and converting need no intervention. A content audit should identify these explicitly so you do not accidentally optimize them into problems.

What Underperforming Content Actually Looks Like

The patterns I find most often are not dramatic. They tend to be:

  • Blog posts from 2018 to 2021 that ranked briefly, then dropped as fresher content entered the space, and were never updated.
  • Service pages that exist for every city in a state, generated by swapping a location name into a template, with no unique content differentiating them.
  • FAQ pages that duplicate what service pages already cover, creating cannibalization that neither page wins.
  • Case study or portfolio pages with no descriptive text — just an image and a headline — that are indexed but contribute nothing to topical authority.

Crawl Budget and What a Bloated Page Count Actually Costs You

Crawl budget is not a concern for every site. If your site has under 500 pages and loads quickly, Googlebot will crawl the whole thing regardless of how many thin pages exist. But once you get into the thousands of pages — and especially if you have a large number of low-quality, duplicate, or parameter-generated URLs — crawl budget becomes a real constraint. Googlebot has a finite number of requests it will spend on your domain in a given period. If a significant portion of those requests go to pages that will never rank, your high-value pages get crawled and reindexed more slowly.

The practical effect: a content change on an important page may take weeks to be picked up if Googlebot is busy recrawling thin location pages or session-ID duplicates. I have seen sites where reducing indexed page count by 30% measurably shortened the recrawl interval on core service pages — not because Googlebot suddenly liked the site more, but because it stopped wasting requests on pages that should have been deindexed.

If you are managing crawl budget, your robots.txt and XML sitemap become tools for steering Googlebot. Only include indexable, canonical URLs in your sitemap. Use robots.txt to block parameter-generated duplicates from being crawled at all, rather than relying solely on noindex tags after they have already been crawled.

Frequency and Scope

A content audit is most useful on sites with 50 or more indexed pages. For smaller sites, a page-by-page review during a technical audit covers the same ground. For larger sites — e-commerce catalogs, publisher sites, or local businesses with extensive location pages — a content audit may be the highest-leverage SEO work available, ahead of any link building or new content creation.

For most sites publishing regularly, a content audit once a year is a reasonable cadence. For sites that publish aggressively — multiple posts per week — a lighter quarterly review of the trailing 90 days of content performance catches problems before they compound. The goal is to keep the ratio of indexable, contributing pages high. Every thin or duplicate page you allow to accumulate is a small but real drag on the overall quality signals the site sends.

Content audits are part of the scope I cover in my website audit service, alongside technical infrastructure and structured data. If your site has been publishing for several years, you may also want to look at how reading an SEO audit report translates findings into a workable action plan.