Content Audit Spreadsheet for Small Sites
Build a content audit spreadsheet for one small site with URL fields, GA4 and GSC metrics, quality checks, GEO readiness, action rules, priority scoring, and next review dates.
Short answer
A content audit spreadsheet should help you decide what to do with each URL. Use one row per canonical page, attach GA4 and Google Search Console evidence, score quality and GEO readiness, assign one action, and send only the best refresh candidates into a one-URL page audit.
Use five tabs instead of one giant sheet
A single sheet can work for a tiny site, but five tabs make the audit easier to maintain: inventory, performance, quality checks, GEO readiness, and actions. The split keeps raw data separate from editorial decisions.
| Tab | Purpose | Core columns |
|---|---|---|
| Inventory | List canonical public URLs, page types, titles, owners, publish dates, and business roles. | URL, canonical, title, page type, owner, publish date, last update, business role. |
| Performance | Attach page-level GA4 and Google Search Console evidence before making action decisions. | GA4 sessions, engaged sessions, key events, GSC clicks, impressions, CTR, average position, top query. |
| Quality checks | Review intent fit, freshness, content depth, missing answers, source support, and internal-link gaps. | Intent fit, freshness risk, thin section, missing question, weak paragraph, stale source, link gap. |
| GEO readiness | Check whether the page is easy for readers and AI answer systems to parse from visible text. | Direct answer, entity clarity, extractable table/list, source-backed claims, FAQ coverage, limitations. |
| Actions | Turn the review into one decision per URL with owner, priority, due date, and next review date. | Recommended action, priority score, effort score, owner, due date, next review, notes. |
Copy-ready spreadsheet columns
Start with these columns. Remove fields you cannot maintain weekly, but do not remove the final action fields. A spreadsheet without a decision is only an inventory.
URL | Canonical URL | Page title | Page type | Business role | Primary reader job | Publish date | Last meaningful update | GA4 sessions | GA4 engaged sessions | GA4 key events | GSC clicks | GSC impressions | GSC CTR | GSC average position | Top query | Freshness risk | Intent fit | Missing answers | Weak sections | Source gaps | AI-readable answer gap | Internal-link gap | Recommended action | Priority score | Effort score | Owner | Due date | Next review date | Notes
Where each data source belongs
Pull data from source systems instead of guessing. Use Google Search Console Performance reports for query and page visibility, GA4 reports for sessions and engagement, and a manual review for page quality and source gaps.
| Source | Use in the spreadsheet |
|---|---|
| Sitemap | Start from canonical public URLs that should be crawlable and indexable. |
| Google Search Console | Add page clicks, impressions, CTR, average position, and top query context. |
| GA4 | Add sessions, engaged sessions, key events, and next-page behavior. |
| Manual page review | Add freshness risk, source gaps, weak sections, missing answers, and internal-link notes. |
| Page Refresh AI report | Add one-URL findings after a page is selected for deeper refresh review. |
Action rules for each URL
Every URL should leave the spreadsheet with one next action. Use clear rules so the sheet creates work, not more vague notes.
| Action | Rule |
|---|---|
| Keep | The URL is accurate, useful, internally linked, and still has a clear reader or business role. |
| Update | The topic still matters, but examples, sources, structure, missing answers, or internal links need a targeted refresh. |
| Audit one URL | The spreadsheet shows the page is worth improving, but you need a page-level report before assigning edits. |
| Consolidate | The URL overlaps another page and would be stronger as part of a clearer canonical resource. |
| Remove or redirect | The URL has no clear search job, business role, internal-link value, or useful content to preserve. |
| Manual review | The data is mixed, the page affects pricing or product trust, or the action needs founder/editor judgment. |
Priority scoring formula
The score should surface the pages where a targeted refresh can matter. Do not treat the number as a final decision; use it to sort the queue before editorial review.
| Factor | Scoring rule |
|---|---|
| Search demand | 0-3 from GSC impressions, clicks, and relevant top queries. |
| Business role | 0-3 from product discovery, signup path, pricing support, or customer education value. |
| Freshness risk | 0-3 from stale examples, outdated platform details, old screenshots, or unsupported claims. |
| GEO readability | 0-3 from visible direct answers, clear entities, source context, and extractable sections. |
| Edit clarity | 0-3 from how obvious the next edit is: intro, source, FAQ, internal link, or weak section. |
| Effort | 0-3 where 3 means heavy rewrite or technical dependency. Subtract this from the priority total. |
Priority score
=SearchDemand + BusinessRole + FreshnessRisk + GeoReadability + EditClarity - Effort
Refresh candidate
=IF(AND(SearchDemand>=2, EditClarity>=2), "Audit one URL", "Review later")
Measurement window
=IF(RecommendedAction="Update", "Review after recrawl", "No refresh window")
How to use Page Refresh AI with the sheet
- Filter the spreadsheet to URLs with a high priority score and clear edit reason.
- Open the current page and confirm that it is public, canonical, and still serves a useful reader job.
- Paste one selected URL into the free content audit tool.
- Record the report findings in the sheet: missing questions, weak sections, paragraph issues, source gaps, and internal-link opportunities.
- Assign one owner and one next review date before editing starts.
Frequently asked questions
What columns should a content audit spreadsheet include?
Start with URL, page title, page type, business role, publish date, last meaningful update, GA4 sessions, engaged sessions, GSC clicks, impressions, CTR, average position, top query, freshness risk, intent fit, AI-readability gaps, internal-link gaps, recommended action, owner, and next review date.
Is a content audit spreadsheet different from a content inventory?
Yes. A content inventory lists what exists. A content audit spreadsheet combines inventory fields with performance data, quality checks, action decisions, owners, and follow-up dates.
Where does Page Refresh AI fit into the spreadsheet?
Use Page Refresh AI after the spreadsheet identifies one public URL worth reviewing. Paste that URL into the audit tool, then record page-level findings such as missing questions, weak sections, answer clarity, and internal-link opportunities.
How should I prioritize pages in the spreadsheet?
Score each URL by search demand, business role, freshness risk, content quality, GEO readability, edit clarity, and effort. Prioritize pages with meaningful demand, clear value, and specific refresh actions.
Can a spreadsheet replace GA4 or Google Search Console?
No. The spreadsheet organizes decisions. GA4 and Google Search Console still provide the traffic, engagement, query, and indexing evidence used in the audit.
Related resources
Audit the page before you edit
Use the spreadsheet to choose a page, then paste one public URL into Page Refresh AI for a focused page-level refresh audit.
Audit one URL from the spreadsheet →