Skip to content

Cookie settings

Necessary · always on

Sign-in, security and remembering this choice. The site doesn't work without them.

Analytics

Counts visits and how pages are used, so we know what to improve. Google Analytics, Microsoft Clarity.

Marketing

Measures which ads bring visitors and lets us show ads to people who visited. Meta, Google Ads.

Content audit template: keep, update, merge, redirect or remove

An inventory with one decision per URL, the columns to fill from Search Console and GA4, and the matrix that picks the default action.

Free, no sign-up · works in Excel, Google Sheets, Numbers, Notion or any Markdown editor

At a glance

Sections
4
Type
Sheet · spreadsheet
Formats
xlsx · csv · md
Cost
Free, no sign-up

The whole template, on one page.

The downloads hold exactly this. Jump to a section from the list.

content-audit-templateSpreadsheet preview

Content audit: [Site] · [Year]

Search data: Search Console, last 12 months (up to 16) · Conversions: GA4 Landing page report

01Inventory

One row per URL, one value per cell. Start from a complete URL list: sitemap, crawl and Search Console together.

URLSectionPage typeClicks (12 months)Impressions (12 months)Clicks, last 3 monthsClicks, same 3 months last yearTop queryAvg. positionOrganic key eventsExternal linksInternal linksOverlaps withDecisionOwnerDone date

02Where each column comes from

ColumnSourceWhy it matters
URL, section, page typeMaster URL list, URL folderLets you decide by section instead of page by page
Clicks and impressions, last 12 monthsSearch Console, PagesIs the page used at all?
Clicks, last 3 months vs the same 3 months a year earlierSearch Console, CompareTrend without seasonality
Top query and average positionSearch Console, page filterWhat the page is actually found for
Organic key eventsGA4, Landing page reportBusiness value beyond traffic
Internal and external linksSearch Console, Links reportWhat you'd lose by deleting it
Overlaps withYour notes, query × page dataMerge candidates
Decision, owner, done dateYouTurns the sheet into work

03Decision matrix

Label each page twice: how it performs in search, and what role it plays. The cell is the default action.

RoleStrong and steady (clicks flat or growing year over year)Declining or close (below its peak, or position 5–20)Little or none (few clicks or impressions in 12 months)
Unique intentKeep: routine upkeep onlyUpdate: refresh facts, cover the queries, fix the titleUpdate: check it's indexed; keep as is if it converts
Same intent as another pageKeep: make it the merge target for the othersMerge: into the page with most clicks, links, conversionsMerge: or redirect to the page that owns the intent
Obsolete (product, offer or version is gone)Redirect: to the replacement, or rewrite it for the current offerRedirect: to the closest equivalent pageRemove: 404 or 410; noindex if people still need it

Overrides: other sites link to it → redirect, never remove. It has key events → keep or update, whatever the traffic.

04What each action means

ActionTypical pageWhat you do
KeepSteady clicks, unique intent, nothing out of dateNothing beyond normal upkeep; note the date you checked it
UpdateRanks 5 to 20, or slipping from its peakRefresh facts and examples, cover what the query list asks, fix the title
MergeTwo pages answer the same searchesMove the useful parts into the stronger URL, then redirect the weaker one
RedirectObsolete, but a close replacement exists or other sites link to it301 to the closest equivalent page, not the home page
Remove / noindexNo traffic, no links, no conversions, no purposeReturn 404 or 410; use noindex when people still need the page but search doesn't

The .xlsx, .csv and .md downloads contain the same content.

Preview of the Content audit decision sheet; the downloads hold the same content.

How to use it.

4 steps, start to finish.

  1. 01

    Build the inventory

    Combine the sitemap, a crawl and Search Console's Pages export into one URL list. Keep pages with no impressions: they're the clearest remove-or-redirect candidates.

  2. 02

    Pull 12 to 16 months

    Export the Pages tab for the last 12 months, then Compare the last 3 months with the same 3 months a year earlier for the trend column.

  3. 03

    Add conversions and links

    Key events per landing page from GA4, and linked pages from Search Console's Links report. They override traffic in the matrix.

  4. 04

    Decide by section, ship in waves

    Set a default per section, flag the exceptions, then do one section's redirects and removals at a time and let the data settle.

With Serplyze

Fill the search columns from your Search Console with Serplyze

Serplyze's Traffic screen rolls clicks and impressions up by URL folder or by page groups you define with URL rules, and the content decay heatmap ranks pages by clicks lost against their own best month over up to 16 months. On paid plans, log each change as an Action and Serplyze compares 28 days before with 28 days after, next to the whole site's change.

Questions.

An inventory of every indexable page with the numbers that show whether it earns its place and one decision per URL: keep, update, merge, redirect or remove. It's separate from a technical audit, which asks whether Google can crawl and index the site.