Reoptimize
Solutions
Content Audit Template: Inventory Spreadsheet and SEO Checklist
A content audit template is a spreadsheet that inventories every page you have published, records how each one performs, and forces a single decision per page: keep, refresh, consolidate, or prune. The columns below are the ones that actually change what you do. Copy them, fill one row per URL, and the audit stops being a vague project and becomes a prioritized list of fixes.
Read-only. No CMS access. Plans from $49/mo.
Analyze a page you already published
Read-only. No CMS access needed.
…
fixes, prioritized
-
- ^
Last updated July 2026
The content audit template: columns to copy
Start a sheet with one row per URL and these columns. The first block is inventory, the second is performance, the third is the decision. You can pull most of the performance data from Google Search Console and your analytics in an afternoon.
| Column | What goes in it | Where to get it |
|---|---|---|
| URL | The full page address | Sitemap or CMS export |
| Title | Current page title | CMS or a crawl |
| Target keyword | The one query this page should own | Search Console, top query by clicks |
| Current position | Average rank for that keyword | Search Console (last 3 months) |
| Monthly clicks | Organic clicks now | Search Console |
| Impressions | How often it shows in results | Search Console |
| Traffic trend | Up, flat, or declining vs last year | Search Console, compare periods |
| Word count | Length of the main content | Crawl or CMS |
| Last updated | Date of the last real edit | CMS |
| Intent match | Does the page answer what the query wants? Yes / partly / no | Your judgment vs the live SERP |
| Decision | Keep / refresh / consolidate / prune | The rule set below |
| Priority | High / medium / low by traffic at stake | Impressions times position gap |
The two columns people skip are the two that matter most: traffic trend and intent match. A page can have decent traffic today and still be sliding, and a page can rank while answering the wrong version of the query. Both are invisible unless you write them down.
The SEO content audit checklist for each page
For every row marked refresh, run this checklist. It is the same diff a search engine makes when it decides which page to rank, turned into a work order.
- Intent: open the live results for the target keyword. Does your page answer the same question in the same format the ranking pages use? If they are all step-by-step guides and yours is an opinion essay, that is the problem.
- Title and H1: does the title lead with the keyword and match what searchers actually type? Is there exactly one H1?
- Subtopics: list the H2s across the top three ranking pages. Which subtopics do they all cover that you skip? Those gaps are why you lose.
- Freshness: any dated statistics, years, prices, or screenshots that make the page look old? Update them and the visible last-updated date together.
- Internal links: how many internal links point to this page, and do they use descriptive anchor text? Thin internal linking is the most common fixable weakness.
- Structure: does the answer appear in the first paragraph, or is it buried? Lead with it.
- Schema: does the page qualify for Article, Product, or other structured data it is missing?
Running that checklist by hand takes 20 to 30 minutes a page. The on page SEO analysis at the top of this page does the same diff automatically and returns it as a plan, so you spend the time editing instead of comparing tabs.
The keep, refresh, consolidate, or prune decision
Every row lands in exactly one of four buckets. Most audits over-prune, so read the consolidate row before you delete anything.
| Decision | When | Action |
|---|---|---|
| Keep | Ranks well, matches intent, traffic stable or rising | Leave it. Re-check next quarter. |
| Refresh | Has history and links but traffic is sliding, or it ranks on page 2 with a fixable gap | Run the checklist and rewrite in priority order. This is where the recoverable traffic is. |
| Consolidate | Two or more thin pages compete for the same intent | Merge into the strongest URL and 301 the others to it. Combined authority beats scattered. |
| Prune | No traffic, no links, no conversions, and no strategic reason to exist | Redirect to a relevant page if any equity remains, otherwise remove. Prune sparingly. |
The instinct after an audit is to delete aggressively because pruning feels like progress. Resist it. A page with a handful of backlinks and a little ranking history is almost always worth a refresh or a merge before it is worth a delete, because that history is expensive to rebuild. When in doubt, refresh or consolidate before you prune.
How often to run the audit
A full library audit once a year, plus a lightweight decay check every quarter, keeps a mid-size site healthy. The full audit is the deep pass described above. The quarterly check is narrower: pull the pages whose traffic dropped most versus the prior quarter and refresh those, rather than re-auditing everything. On a large site, running the audit continuously beats running it annually, because decay is gradual and constant. That is the case for automating it: the content decay checker re-scores the whole library on a schedule so the refresh list is always current, and the content audit tool writes the per-page fixes. Copy the template, run it manually once to learn the moves, then automate the parts you do not want to repeat by hand.
Frequently asked questions
What is a content audit template?
A content audit template is a spreadsheet that lists every published page in one row each, with columns for the URL, target keyword, current position, traffic, trend, word count, last-updated date, intent match, and a decision. It turns a vague "review our content" project into a prioritized list of keep, refresh, consolidate, or prune actions.
What should a content audit include?
A content audit should include an inventory of every URL, performance data per page (position, clicks, impressions, and the traffic trend versus last year), an intent check against the live search results, an on-page review of title, headings, subtopics, freshness, internal links, and schema, and a single decision per page: keep, refresh, consolidate, or prune, ranked by traffic at stake.
How do you do a content audit in Google Search Console?
Export your pages from the Search Console Performance report, then for each page record its top query, average position, clicks, and impressions. Compare the last three months with the same period a year earlier to spot declining pages. Those with falling clicks but existing rankings are your refresh priorities, since the traffic is recoverable rather than net-new.
How often should you do a content audit?
Run a full content audit of the whole library once a year, with a lighter decay check each quarter that only looks at the pages losing the most traffic. Large sites benefit from continuous auditing rather than an annual event, because content decay is gradual and steady, so automating the re-scoring keeps the refresh list current without repeating the manual pass.
Put it to work
Check one of your own pages
Paste a URL and a target keyword into the analyzer and watch the markup pass land: score, gaps, and the fixes that matter first.