Content Audit Template for Refresh Decisions
A practical content audit template for deciding which pages to keep, update, consolidate, remove, or review with a single-URL refresh audit.
A content audit template is a spreadsheet structure for turning page data into editorial decisions. It should help you answer one practical question for each URL: should this page stay as-is, be updated, be consolidated, be removed, or get a deeper page-level review?
This template is built for solo bloggers and small content teams refreshing existing content. It does not replace GA4, Google Search Console, a crawler, or editorial judgment. Use those tools to choose URLs, then use Page Refresh AI when one public page needs a focused refresh audit.
Short answer: copy these columns first
Start with these core columns: URL, page type, business role, GA4 sessions, GSC clicks, GSC impressions, CTR, average position, last meaningful update, freshness issue, intent fit, internal-link gap, recommended action, owner, due date, and next review date.
Keep the template narrow enough to finish. A complete 20-column audit that gets used is better than a 70-column spreadsheet nobody maintains.
Content audit template fields
Use four field groups: inventory, performance, quality review, and decision. This keeps the audit grounded in evidence while still ending with a concrete action.
Inventory
- URL
- Page title
- Page type
- Publish date
- Last meaningful update
- Owner
Performance
- GA4 sessions
- Conversions or goal events
- GSC clicks
- GSC impressions
- CTR
- Average position
Quality review
- Search intent fit
- Freshness issues
- Thin sections
- Missing follow-up questions
- Weak paragraphs
- Internal-link gaps
Decision
- Recommended action
- Priority
- Next edit owner
- Due date
- Next review date
- Notes
Recommended scoring rules
Use scores to support the decision, not to pretend a spreadsheet can judge content alone. A simple 1 to 3 score is enough for most small sites.
- Business role: 3 if the page supports signup, pricing, product education, or a known conversion path.
- Search demand: 3 if the page still gets impressions or relevant queries in Google Search Console.
- Freshness risk: 3 if screenshots, prices, tools, examples, or claims are visibly outdated.
- Intent fit: 3 if the current page format still matches what searchers need.
- Edit effort: 1 for small edits, 2 for section-level changes, 3 for a rewrite or consolidation.
Turn each row into one action
The template should force a decision. If every row says "review later," the audit has not done its job.
Keep
The page is accurate, useful, internally linked, and still serves a clear reader or business role.
Update
The topic still matters, but the page needs fresher examples, clearer structure, stronger answers, or better internal links.
Consolidate
Two or more URLs overlap on the same intent and would be stronger as one clearer page.
Remove or redirect
The URL has no useful role, no meaningful demand, and no internal-link reason to stay public.
Single-URL audit
The page is worth editing, but you need a page-level refresh report before assigning specific changes.
Example template rows
These examples show the level of detail that makes a template useful. Keep notes short and decision-oriented.
/blog/old-guide
Signal: Clicks down 31%, impressions stable, screenshots outdated
Action: Update
Next step: Run a single-URL audit, update stale sections, add missing FAQs
/blog/tool-list-2023
Signal: Year-specific post, old products, still earns impressions
Action: Update or rewrite
Next step: Recheck intent and replace outdated examples before changing date
/blog/short-tip
Signal: No impressions, overlaps stronger guide, no conversion role
Action: Consolidate
Next step: Merge useful paragraph into stronger URL and retire weak page
When to use Page Refresh AI with the template
Use Page Refresh AI after the template identifies a URL worth editing. Paste one public URL and review the page-level report for structure issues, stale or thin sections, missing follow-up questions, weak paragraphs, and internal-link opportunities.
Do not use a single-URL audit to replace the whole inventory step. The spreadsheet tells you which pages deserve attention. The audit report helps you decide what to change on one page before editing.
Quality checks before publishing updates
- The page still has one clear search intent and one clear reader job.
- The first screen gives a direct answer or clear next step.
- Outdated claims, old screenshots, changed pricing, and dead links are removed or replaced.
- Internal links point to related guides, tool pages, or the sample report where useful.
- Visible dates are changed only when the page was materially reviewed and updated.
- The post-update baseline is recorded so GA4 and Search Console data can be compared later.
Sources to use with the template
Use GA4 reports for sessions and conversion context. Use the Search Console Performance report for clicks, impressions, CTR, average position, and query context.
For the quality review, compare the page against Google's helpful content guidance: useful, original, accurate, clearly sourced, and satisfying for the intended reader.
Frequently asked questions
What should a content audit template include?
A useful template should include URL, page type, business role, GA4 data, Search Console data, freshness checks, quality notes, internal-link gaps, recommended action, owner, and next review date.
Can Page Refresh AI complete the whole template for me?
No. Page Refresh AI audits one public URL at a time. Use analytics, Search Console, and your own business context for inventory and prioritization, then use Page Refresh AI for the page-level refresh review.
How do I score pages in a content audit?
Score pages by business role, search demand, performance trend, freshness, intent fit, content quality, and internal-link context. The score should support a decision, not replace editorial judgment.
What action should each audited page get?
Assign one action: keep, update, consolidate, remove, redirect, or review manually. Pages should not leave the audit with vague notes and no decision.
Related resources
Audit the page before you edit
Use the template to choose the page, then paste one public URL into Page Refresh AI for the page-level refresh review.
Audit one URL →