How to Do a Content Audit in 2 Hours (Step-by-Step)
How to Do a Content Audit in 2 Hours (Step-by-Step)
A content audit is a systematic review of every piece of content on your site — scored against performance data — to decide what to refresh, consolidate, or cut. Done right, it takes about 2 hours and gives you a prioritized action list worth months of SEO gains.
You don't need expensive tools. You need Google Search Console, a spreadsheet, and a clear framework for making decisions quickly.
Here's the step-by-step process, including a template you can copy and work through today.
What You Need Before You Start
Two tools: Google Search Console (free) and a spreadsheet.
Optional: Google Analytics for bounce rate and time-on-page data, which adds useful context but isn't required for the core audit.
Set up your spreadsheet with these columns:
| Column | Purpose |
|---|---|
| URL | Full page path |
| Title | H1 or page title |
| Publish Date | When first published |
| Last Updated | Most recent substantial edit |
| 90-Day Sessions | From Google Analytics |
| Avg. Position | From GSC Performance → Pages |
| Impressions | From GSC |
| CTR | From GSC |
| Decision | Refresh / Keep / Kill / Consolidate |
| Priority | High / Medium / Low |
| Notes | Primary problem, one sentence |
You'll fill this in as you work through each step below.
Step 1: Export Your Content Inventory (15 Minutes)
Go to Google Search Console → Performance → Pages. Set the date range to the last 90 days. Export the full report as a CSV.
This gives you every URL that received at least one impression in the last 90 days. Import the CSV into your spreadsheet, then add the Publish Date and a Content Type column (Blog Post / Landing Page / Product Page / Other).
Scope tip: For most content marketers auditing a blog, limit this pass to blog posts only. Don't audit everything at once — scope creep turns a 2-hour audit into a 2-week project.
Step 2: Flag the Dead Pages (10 Minutes)
Dead pages are posts that received fewer than 10 organic sessions in the last 90 days and are older than 6 months.
Filter your spreadsheet for this combination. Mark each one in the Decision column as either:
- Kill — off-topic, obsolete, or has no realistic path to traffic. Delete the page or 301-redirect to a related post.
- Consolidate — similar topic to another post you could merge it into. Flag now, deal with separately.
Don't agonize here. A 4-year-old post about a discontinued tool is a kill. A duplicate how-to with 3 sessions per month is a consolidation candidate. Move fast.
Step 3: Score Your Active Content (40 Minutes)
For every page with 10+ sessions in the last 90 days, assign a priority score using this four-signal framework.
The 4-Signal Scoring System
Signal 1 — Average Position (0–30 points)
- Positions 1–3: 10 points (already winning — needs maintenance, not overhaul)
- Positions 4–10: 30 points (high potential — the most valuable refresh candidates)
- Positions 11–20: 20 points (page 2, worth refreshing)
- Positions 21+: 5 points (too far back to prioritize now)
Signal 2 — Traffic Trend (0–20 points) Compare last 90 days vs. prior 90 days in GSC. Declining traffic = 20 points (content decay in progress, most urgent). Flat traffic = 10 points. Growing traffic = 5 points.
Signal 3 — Impressions vs. CTR (0–20 points) High impressions with a low CTR means Google is surfacing you but users aren't clicking. If impressions > 1,000 and CTR < 3%, score 20 points. A weak title or meta description is usually the fix.
Signal 4 — Content Age (0–30 points)
- 18 months to 3 years old: 30 points (prime refresh window)
- 3–5 years old: 20 points
- Under 18 months: 5 points
- Over 5 years: 15 points (high-authority page — assess carefully before touching)
Total score range: 0–100
Posts scoring 70+ are Priority 1 — your first refresh sprint. Scores of 40–69 are Priority 2. Under 40 are hold or low priority.
Step 4: Diagnose Each Priority 1 Post (30 Minutes)
For each Priority 1 post, do a quick 3-minute spot check. Open the post and look for:
- Statistics older than 18 months
- Broken or outdated external links (tools discontinued, pages 404'd)
- Intent mismatch — search your keyword in incognito and compare what's ranking to what your post covers
- Missing FAQ section
- Thin structure: no headings, walls of text, no scannable elements
- Outdated or auto-generated meta description
Note the primary problem in your spreadsheet's Notes column. One sentence is enough: "Stats from 2022, no FAQ, intent has shifted to comparisons." That single note will focus your refresh work later and prevent scope creep when you sit down to actually edit the post.
For a deeper look at the most common content problems, 5 warning signs your content is quietly killing your SEO covers each diagnostic pattern in detail.
Step 5: Build Your Refresh Queue (15 Minutes)
Sort by Priority, then by score within each tier. Your top 5 Priority 1 posts are your first refresh sprint.
A realistic pace for a solo content marketer: 2 posts per week, working in score order. At that cadence, you'll move through your entire Priority 1 list in 3–4 weeks — and you'll see ranking improvements from the first refresh within 2–3 weeks of republishing.
This is where the audit pays off. Refreshing existing content delivers 3–5x better ROI than creating new posts — but only when the refresh is targeted. The audit is what makes it targeted instead of random.
Content Audit Template
Copy this structure into your working spreadsheet:
| Column | What to Fill In |
|---|---|
| URL | Full page URL |
| Title | H1 or page title |
| Publish Date | Date first published |
| Last Updated | Most recent substantial update |
| 90-Day Sessions | From Google Analytics |
| Avg. Position | From GSC |
| Impressions | From GSC |
| CTR | From GSC |
| Position Score | 0–30 (per framework above) |
| Trend Score | 0–20 (per framework above) |
| CTR Score | 0–20 (per framework above) |
| Age Score | 0–30 (per framework above) |
| Total Score | Sum of all four signals |
| Priority | High (70+) / Med (40–69) / Low (<40) |
| Decision | Refresh / Keep / Kill / Consolidate |
| Primary Problem | One sentence |
| Notes | Anything else relevant |
Common Mistakes That Waste Your Audit Time
Auditing everything at once. Start with blog posts only, or even just your top 30 pages by impression volume. A scoped audit completed in 2 hours beats an exhaustive audit abandoned halfway through.
Using sessions as the only signal. A post with 50 sessions at position #5 with declining traffic is more urgent than a post with 300 sessions at position #2 with stable traffic. Trend and position context change the calculus entirely.
Skipping the diagnose step. Knowing a post needs refreshing isn't the same as knowing what to fix. The 3-minute spot check prevents wasted effort on the wrong edits.
Treating the audit as a one-time event. A content audit is a quarterly habit, not a one-off project. The first one takes 2 hours. Subsequent ones take 45 minutes because you're maintaining a live spreadsheet rather than starting from scratch.
FAQ
How often should I do a content audit?
Quarterly for most blogs. If you publish frequently (5+ posts per week) or operate in a fast-moving industry, monthly is better. At minimum, run a full audit before any major content push or after a Google algorithm update.
Do I need to audit every page on my site?
No. Start with blog posts — they're the highest-leverage, most auditable content type. Landing pages and product pages have different performance signals and typically warrant a separate audit pass with different scoring criteria.
What's the difference between a content audit and a content refresh?
The audit identifies what needs refreshing and puts it in priority order. The refresh is the actual work — updating statistics, restructuring for scannability, rewriting weak sections, adding FAQ content. The audit without the refresh is just a spreadsheet. The refresh without the audit is guesswork.
Should I delete underperforming content?
Only if it has zero realistic traffic potential and adds no topical value. Most underperforming content is better consolidated into a related post via 301 redirect, which preserves any backlinks and authority the original URL accumulated.
How does a content audit connect to AI search optimization?
AI search engines like Perplexity, ChatGPT search, and Google AI Overviews favor fresh, structured, and factually dense content. Your audit surfaces the posts with the most AI citation potential — the ones that are already getting impressions but haven't been optimized for how AI engines extract answers. The refresh is what converts that potential into citations.
Most content libraries contain dozens of posts that were once driving real traffic — and now quietly decay while their owners keep writing new ones. A 2-hour audit tells you exactly where the leverage is.
If your content library has more than 20 posts and you're not auditing quarterly, you're leaving real ranking potential untouched.
Start your free content audit with SEORefresher → — connect your GSC data, get automatic scoring of your entire blog, and skip building the spreadsheet from scratch.