Content Audit & Refresh Template

Free editable Content Audit & Refresh Template. Copy, personalize, or download the Word .docx template from UNmiss.

Most sites don't have a content problem so much as a content sprawl problem: hundreds of old posts, thin pages, and near-duplicates quietly dragging down crawl efficiency and topical authority. A content audit fixes that. Instead of endlessly publishing new pages, you take stock of what you already have, measure how each page actually performs, and make a deliberate keep / update / consolidate / prune decision for every URL. This template walks you through the full process: building a content inventory, scoring performance, applying a decision matrix, briefing refreshes, planning consolidations with 301 redirects, and pruning low-value pages safely. Pull the numbers from your own analytics, never guess, and you'll end up with a leaner, stronger, better-ranking site.

6 ready-to-use variants

Content Inventory & Data Capture

Build the master list of every URL on your site with the raw data you'll score against.

Content Inventory & Data Capture

Pull every indexable URL into one sheet before you judge anything. Combine a crawler export with GA4, Google Search Console, and your CMS so each row carries its own evidence.

  • Site & scope: [Domain / section being audited]
  • Audit date & owner: [Date] / [Name]
  • URL: [Full page URL]
  • Title & primary topic: [Page title / target keyword]
  • Content type: [Blog / product / landing / pillar]
  • Publish & last-updated date: [Dates]
  • Word count & author: [Count] / [Author]
  • Indexable? [Yes / noindex / blocked]
  • Internal links in / out: [Counts]

Capture every page first, score second. A complete inventory is what makes the rest of the audit defensible.

Performance Scoring

Score each page on traffic, rankings, conversions, and engagement using real data.

Performance Scoring

Score each URL on four pulled-from-source dimensions over a consistent window (for example, the last 12 months). Use GA4 for traffic, engagement, and conversions, and Search Console for impressions, clicks, and position. Avoid estimates.

  • Scoring window: [e.g. last 12 months]
  • Organic traffic (GA4 sessions and engaged sessions): [Number]
  • Clicks & impressions (GSC): [Clicks / impressions]
  • Average position & top query: [Position / query]
  • Conversions / assisted conversions: [Number / goal]
  • Engagement (GA4 engaged sessions, average engagement time): [Metric]
  • Backlinks / referring domains: [Count]
  • Trend (rising / flat / declining): [Direction]
  • Performance tier: [High / Medium / Low / Zero]

Use GA4's own metric names, engaged sessions and average engagement time, rather than the old Universal Analytics bounce rate, which GA4 no longer reports the same way and shouldn't be relied on. A page on page two with strong impressions but few clicks is a refresh candidate, not a prune candidate. Let the numbers, not gut feel, set the tier.

Keep / Update / Consolidate / Prune Decision Matrix

Turn each page's scores into one clear action using a repeatable rule set.

Keep / Update / Consolidate / Prune Decision Matrix

Translate every page's performance tier and strategic value into a single decision. Apply the same rules to every URL so the audit stays consistent and two auditors reach the same call.

  • URL & current tier: [URL / High-Medium-Low-Zero]
  • Still aligned with business goals? [Yes / No]
  • Has backlinks or conversions? [Yes / No]
  • Overlaps another page? [URL it competes with]
  • Decision: [Keep / Update / Consolidate / Prune]
  • Reasoning: [One-line rationale]
  • Priority: [High / Medium / Low]
  • Owner & due date: [Name / Date]

Set concrete, reproducible thresholds up front so the matrix is objective. Use these as examples and adjust the cutoffs to your own site:

  • Zero tier (prune candidate): 0 organic clicks AND 0 conversions AND 0 referring domains over the scoring window.
  • Refresh candidate (Update): average position 11–20 with meaningful impressions but a low click-through rate. The page is seen but not chosen.
  • Keep: top-of-page-one position, stable or rising clicks, and current content.
  • Consolidate: a thin page that overlaps a stronger URL on the same query and splits its clicks or links.

Rough rules of thumb: strong, current pages get Keep; pages with high impressions or backlinks but slipping results get Update; thin pages that overlap a stronger one get Consolidate; and genuine dead weight with no traffic, links, or conversions gets Prune. Never delete a page with backlinks or conversions without redirecting it.

Refresh Brief

Spell out exactly what to change on a page worth updating before a writer touches it.

Refresh Brief

For every Update decision, write a brief so the refresh targets the gap, not a full rewrite. Updating a page that already ranks usually beats publishing a new one, because it keeps the URL's existing equity.

  • URL & target keyword: [URL / primary keyword]
  • Current vs target position: [Now / goal]
  • Why it's slipping: [Outdated stats / thin / intent shift]
  • Search intent to match: [Informational / commercial]
  • Content gaps vs top results: [Missing sections / questions]
  • Updates needed: [New data, examples, visuals, FAQs]
  • On-page fixes: [Title, H1, meta, internal links]
  • Keep the URL unchanged? [Yes / 301 if slug changes]
  • Change date to annotate in GA4 & GSC: [Re-publish date]

Refresh real gaps and re-publish, then annotate the change date in GA4 and Search Console so you can compare before and after. Remember the page must be re-crawled and re-indexed before any lift shows up. That lag is often several weeks, so don't read the results until the new version is actually indexed, then track position and clicks for several weeks to confirm the lift.

Consolidation & Redirect Plan

Merge thin, overlapping pages into one strong URL and redirect the rest.

Consolidation & Redirect Plan

When several pages chase the same topic, they split clicks and links and can cannibalize each other. Merge them into the single strongest URL and 301 the others to it so the surviving page inherits their authority.

  • Topic cluster: [Theme being consolidated]
  • Pages to merge: [List of URLs]
  • Winner (canonical URL): [Strongest URL: most links/traffic]
  • Content to migrate: [Sections worth keeping from losers]
  • Redirect type: [301 permanent to winner]
  • Internal links to repoint: [Links pointing at merged URLs]
  • Canonical & sitemap updates: [Actions]
  • Owner & launch date: [Name / Date]

Pick the winner on real link and traffic data, fold in the best unique content from the others, 301 every merged URL, update internal links to point straight at the winner, and resubmit your sitemap.

Warning: every 301 must point to the closest relevant page, never a mass redirect to the homepage. Google treats an irrelevant redirect as a soft 404 and drops the link equity you were trying to preserve, so match each merged URL to the most topically relevant destination.

After launch, expect a re-crawl and re-index lag (often several weeks) before the consolidation's effect is visible. Annotate the launch date in GA4 and Search Console so the before/after comparison is meaningful.

Prune & De-Index Plan

Remove or de-index genuine dead weight without losing equity or breaking links.

Prune & De-Index Plan

Pruning low-value pages can lift site-wide quality, but never bulk-delete. Decide deliberately for each page whether to redirect, remove, or simply de-index, and confirm there's no equity to protect first.

  • URL to prune: [URL]
  • Why prune: [Zero traffic / outdated / duplicate]
  • Backlinks or conversions? [Yes / No: if yes, redirect]
  • Action: [301 redirect / 410 gone / noindex]
  • Redirect target (if any): [Closest relevant URL]
  • Internal links to remove or repoint: [Links to fix]
  • Remove from sitemap: [Yes]
  • Post-prune check date: [Date to verify no traffic loss]

Blocking gate: a 410 or hard delete is safe ONLY when the page has zero backlinks AND zero conversions AND no organic value. If any one of those is present, do not delete. 301-redirect the URL to the closest relevant page instead. And if a page must stay live for users (it still serves a purpose on the site) but you simply don't want it in search, the correct action is noindex, not a 410.

So: redirect pages with links or conversions to the closest relevant URL; use a 410 only for truly dead, irrelevant pages that clear the gate above; or noindex pages you want live for users but out of the index. Track results so you can confirm the prune helped, allowing for the re-crawl and re-index lag, often several weeks, before changes settle.

How to use this template

  1. Crawl your site and export every indexable URL into one master sheet, then enrich each row with data from GA4, Google Search Console, and your CMS.
  2. Define a consistent scoring window (such as the last 12 months) and pull real traffic, clicks, impressions, average position, conversions, and GA4 engagement metrics (engaged sessions, average engagement time) for every page.
  3. Assign each page a performance tier (High, Medium, Low, or Zero) using concrete thresholds, not gut feel: for example, Zero = 0 organic clicks AND 0 conversions AND 0 referring domains over the window.
  4. Run every URL through the decision matrix to label it Keep, Update, Consolidate, or Prune, recording a one-line rationale for each so two auditors reach the same call.
  5. For Update pages, write a refresh brief that names the specific gaps to fix, then refresh and re-publish without changing the URL where possible, and annotate the change date in GA4 and Search Console.
  6. For Consolidate groups, choose the strongest URL as the winner, migrate the best content from the others, and 301-redirect every merged page to the closest relevant URL (never the homepage), since Google treats irrelevant redirects as soft 404s and drops the equity.
  7. For Prune pages, redirect any URL with backlinks or conversions to the closest relevant page, and 410 or noindex genuine dead weight; only 410 or delete when the page has zero backlinks AND zero conversions AND no organic value, and use noindex when a page must stay live for users.
  8. Update internal links and your XML sitemap, then allow for the re-crawl and re-index lag (often several weeks) before tracking rankings, clicks, and traffic for several weeks to confirm the audit lifted performance.

Pro tips

  • Always pull decisions from real GA4 and Search Console data over a consistent window; use GA4's engaged sessions and average engagement time rather than UA-style bounce rate, and never score pages on memory or assumptions.
  • Before deleting anything, apply the blocking gate: only 410 or delete when a page has zero backlinks AND zero conversions AND no organic value. If it has any of those, 301-redirect it to the closest relevant URL instead, never a mass redirect to the homepage.
  • Refreshing a page that already ranks on page two usually beats writing a brand-new article, because it keeps the URL's existing links and history; just remember a refreshed or consolidated page needs to be re-crawled and re-indexed (often several weeks) before any lift is real, so annotate the change date in GA4 and GSC.
  • Re-run the audit on a regular cadence (for example, twice a year) so content sprawl and decay never build back up.

Frequently asked questions

What is a content audit and why does it matter for SEO?

A content audit is a systematic review of every page on your site, scored against real performance data, so you can decide what to keep, update, consolidate, or prune. It matters because sites accumulate thin, outdated, and duplicate pages over time, which dilutes topical authority and wastes crawl budget. Clearing dead weight and strengthening your best pages lifts overall site quality, which helps the content you keep rank better.

How often should I run a content audit?

For most sites, a full audit once or twice a year is a sensible cadence, with lighter check-ins on key pages each quarter. Larger sites or those publishing frequently benefit from more regular reviews because content decay and sprawl accumulate faster. The goal is to catch slipping pages and overlaps before they drag down the rest of the site, so set a recurring date rather than treating the audit as a one-off project.

Should I update an existing page or write a new one?

If a page already ranks, has backlinks, or earns impressions for your target topic, updating it almost always beats writing something new. A refresh keeps the URL's existing link equity and history while you fix the gaps that are holding it back. Write a new page only when no existing URL targets the topic, or when the existing page is so off-target that a refresh can't realistically close the gap. After you re-publish, allow for the re-crawl and re-index lag, often several weeks, before judging the result.

When should I consolidate pages instead of keeping them separate?

Consolidate when several pages target the same topic or keyword and end up splitting clicks, links, and authority between them. Pick the strongest URL as the winner based on real link and traffic data, migrate the best unique content from the others into it, and 301-redirect the merged pages to the winner. Always point each 301 at the closest relevant page rather than mass-redirecting to the homepage, because Google treats irrelevant redirects as soft 404s and drops the equity. This concentrates your authority on one page that can rank, instead of several weaker pages competing with each other.

Is it safe to delete or prune old pages?

Pruning genuine low-value pages can improve site-wide quality, but it has to be deliberate, not a bulk delete. Treat deletion as gated: a 410 or hard delete is safe only when the page has zero backlinks AND zero conversions AND no organic value. If a page has any of those, 301-redirect it to the closest relevant URL instead of removing it. Use a noindex tag for pages you want to keep live for users but out of the search index. Then track results to confirm no traffic was lost, allowing for the re-crawl and re-index lag of often several weeks.

Which tools and data do I need for a content audit?

At minimum you need a crawler to list every URL, Google Search Console for impressions, clicks, and average position, and GA4 for sessions, engaged sessions, average engagement time, and conversions. Note that GA4 has no Universal-Analytics-style bounce rate to rely on, so judge engagement with its native metrics. Your CMS supplies publish and update dates and authorship, and a backlink tool helps you spot pages worth preserving. Pull everything into one sheet so each page carries its own evidence, and base every keep, update, consolidate, or prune decision on that real data rather than assumptions.