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: [Site] · [Year]
01Inventory
One row per URL, one value per cell. Start from a complete URL list: sitemap, crawl and Search Console together.
| URL | Section | Page type | Clicks (12 months) | Impressions (12 months) | Clicks, last 3 months | Clicks, same 3 months last year | Top query | Avg. position | Organic key events | External links | Internal links | Overlaps with | Decision | Owner | Done date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
02Where each column comes from
| Column | Source | Why it matters |
|---|---|---|
| URL, section, page type | Master URL list, URL folder | Lets you decide by section instead of page by page |
| Clicks and impressions, last 12 months | Search Console, Pages | Is the page used at all? |
| Clicks, last 3 months vs the same 3 months a year earlier | Search Console, Compare | Trend without seasonality |
| Top query and average position | Search Console, page filter | What the page is actually found for |
| Organic key events | GA4, Landing page report | Business value beyond traffic |
| Internal and external links | Search Console, Links report | What you'd lose by deleting it |
| Overlaps with | Your notes, query × page data | Merge candidates |
| Decision, owner, done date | You | Turns 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.
| Role | Strong 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 intent | Keep: routine upkeep only | Update: refresh facts, cover the queries, fix the title | Update: check it's indexed; keep as is if it converts |
| Same intent as another page | Keep: make it the merge target for the others | Merge: into the page with most clicks, links, conversions | Merge: 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 offer | Redirect: to the closest equivalent page | Remove: 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
| Action | Typical page | What you do |
|---|---|---|
| Keep | Steady clicks, unique intent, nothing out of date | Nothing beyond normal upkeep; note the date you checked it |
| Update | Ranks 5 to 20, or slipping from its peak | Refresh facts and examples, cover what the query list asks, fix the title |
| Merge | Two pages answer the same searches | Move the useful parts into the stronger URL, then redirect the weaker one |
| Redirect | Obsolete, but a close replacement exists or other sites link to it | 301 to the closest equivalent page, not the home page |
| Remove / noindex | No traffic, no links, no conversions, no purpose | Return 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.
How to use it.
4 steps, start to finish.
- 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.
- 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.
- 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.
- 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.
At least 12 months, so a seasonal dip doesn't look like a decline. Search Console keeps 16 months, so use all of it if you can.
Check the query data, not the titles. Export the top 20 queries of each page; if most are the same, the pages serve one intent. Merge into the URL with the most clicks, links and conversions combined.
Only if they also have no links, no conversions and no purpose. A page other sites link to gets redirected, a converting page gets kept or updated, and removing pages just to look fresh doesn't help rankings.
More free templates.
All templates- Report
Monthly SEO report template
Nine sections that answer what happened, why, and what you do next, in under five minutes of reading.
Open the template - Brief
Content brief template
Turn a cluster of Search Console queries into a brief a writer can act on, with a success check set before you publish.
Open the template - Checklist
SEO audit checklist
Nine Search Console checks, in order, with where to click and what counts as a finding. One hour a month.
Open the template