Content Audit Template for Refresh Decisions
A practical content audit template for deciding which pages to keep, update, consolidate, remove, or review with GA4, Search Console, AI-readability checks, and 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.
If you do not have a reliable URL list yet, start with the content inventory template. The inventory records what exists; this audit template turns the selected URLs into decisions.
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.
Copy-ready content audit template columns
Use this as the first row in your spreadsheet. It keeps the template focused on evidence, page quality, AI-readability, and the next action.
URL | Page type | Business role | Primary intent | GA4 sessions | GA4 engaged sessions | GSC clicks | GSC impressions | CTR | Average position | Top query | Last meaningful update | Freshness risk | Intent fit | Missing answers | AI-readability gaps | Internal-link gaps | Recommended action | Priority | Owner | Due date | Next review date
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
- Key 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
AI readability
- Direct answer block
- Clear entity names
- Source-backed claims
- Extractable list or table
- Boundary statement
- FAQ 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. If you need the metric definitions first, use the content audit metrics guide.
- 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.
Priority formula for the next refresh batch
A simple priority score helps you choose the next few URLs without pretending the spreadsheet can predict search outcomes. Add the first four factors, then subtract effort.
Search demand
Score: 0-3
Use Search Console impressions, clicks, and query relevance. Score 3 when the page still has meaningful demand.
Business role
Score: 0-3
Score 3 when the page supports signup, pricing, product education, sample-report review, or a known conversion path.
Refresh urgency
Score: 0-3
Score 3 when outdated claims, old screenshots, changed product details, or stale examples weaken trust.
Edit clarity
Score: 0-3
Score 3 when the next edit is obvious: missing answer, weak intro, outdated example, broken link, or unclear CTA.
Effort
Score: 0-3
Score 3 for high effort. Subtract this from the positive factors when choosing the next refresh batch.
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 clear business 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.
AI-readability checks to add to the template
GEO does not require a separate AI-only file or magic schema. For this template, treat AI-readability as a visible content quality check: can the page be understood, summarized, and cited without hidden context?
Direct answer block
Does the page answer the main query in a short, visible section near the top?
Entity clarity
Are product names, page types, metrics, tools, and audiences named directly instead of implied?
Source context
Are important claims tied to visible examples, dates, data sources, or authoritative references?
Extractable structure
Could a reader or AI answer system lift a list, table, definition, or decision rule without guessing from hidden context?
Boundary statement
Does the page say when the advice or tool is not enough, such as technical SEO, analytics setup, or sitewide crawl issues?
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.
Review cadence after the first audit
A template only helps if it gets reviewed. Keep the cadence tied to page decisions instead of adding more columns every week.
Weekly
Review pages edited recently, high-priority declines, and URLs with impressions but weak CTR.
Monthly
Refresh the audit queue, compare GSC and GA4 windows, and assign the next batch of single-URL reviews.
Quarterly
Recheck old decisions, consolidate overlaps, retire pages with no role, and update templates that no longer match the site.
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.
For AI-search readiness, use Google's AI features guidance and generative AI search guide as boundaries. Keep the page crawlable, useful, and source-backed; do not add hidden AI-only text that readers cannot see.
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, AI-readability gaps, 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 →