How to Audit Your Entire Content Library in an Afternoon
By Emily Redmond, Data Analyst at Emilytics · April 2026
TL;DR: Export GA4 (traffic by page) and Search Console (keywords by page). Join them in Google Sheets. Create a 2x2 grid: high traffic + high ranking = good. Low traffic + high ranking = optimize. Quick audit: 2 hours.
You have 300 blog posts. Some are winners. Some are broken. Some should have been deleted years ago.
Where do you start auditing?
Most teams don't audit at all—they just keep publishing. Their content library becomes a graveyard of old posts nobody reads.
Here's a systematic way to audit your entire library in one afternoon.
The 4-Step Audit Framework
Step 1: Export GA4 traffic by page (30 minutes)
In GA4, create a report:
Explore > Report:
| Dimension | Metric |
|---|---|
| Page path, Page title | Users |
| Filter: Page path contains "/blog/" | |
| Date range: Last 6 months |
Export to Google Sheets. Now you have: every blog post + traffic.
Step 2: Export Search Console keywords (30 minutes)
In Search Console > Performance:
| Dimension | Metric |
|---|---|
| Page | Clicks, Impressions, Position |
| Date range: Last 6 months |
Export to Google Sheets. Now you have: every page + rankings + keywords.
Step 3: Join the data (30 minutes)
In Google Sheets, create a pivot:
| Page Title | GA4 Users | SC Impressions | SC Position | SC Clicks |
|---|---|---|---|---|
| Post A | 450 | 1,200 | 5 | 120 |
| Post B | 50 | 200 | 28 | 3 |
| Post C | 0 | 0 | — | 0 |
Use VLOOKUP to join GA4 data with Search Console data.
Step 4: Categorize and decide (30 minutes)
Create a decision column:
| Page | Users | SC Clicks | Decision | Reason |
|---|---|---|---|---|
| Post A | 450 | 120 | Keep & promote | High traffic, high ranking |
| Post B | 50 | 3 | Optimize | Ranking but low traffic |
| Post C | 0 | 0 | Delete | No traffic, no ranking |
Use these rules:
Keep & Promote:
- 100+ monthly users
- Ranking in top 10
- High engagement
Optimize:
- 20–100 monthly users
- Ranking 11–20
- Update and rewrite for ranking
Archive (301-redirect):
- 0–20 monthly users
- Not ranking
- Redirect to similar post
Delete:
- 0 users for 12+ months
- 0 ranking
- No value
💡 Emily's take: A client had 150 old posts—many published 2+ years ago. I ran this audit. Found: 30 posts with zero traffic in 6 months. They 301-redirected those to newer similar posts. Redirects passed authority to new posts. New posts' rankings improved 3–5 positions. 30 hours of cleanup work generated more SEO value than writing 10 new posts.
Using the Audit Results
After you categorize, here's what to do:
-
Promote your "Keep & Promote" posts
- Add internal links from 5–10 other posts
- Mention in your newsletter
- Share on social media monthly
- Update if facts are outdated
-
Optimize your "Optimize" posts
- Update examples and data
- Improve title and meta description
- Add subheadings and structure
- Republish with new date
- Resubmit to Google Search Console
-
Archive your "Archive" posts
- Set up 301-redirects to similar content
- Don't delete (you lose backlinks)
- Update internal links to point to new posts
- Remove from navigation
-
Delete your "Delete" posts
- If no backlinks pointing to them
- If not linked internally
- After 301-redirects are live
Advanced Audit: Add Conversion Data
If you're tracking conversions by page in GA4:
Add a column: Conversion Rate = Conversions ÷ Users
Now your decision matrix includes:
| Page | Users | Conversion Rate | Decision |
|---|---|---|---|
| Post A | 450 | 6% | Keep & promote (high traffic, high conversion) |
| Post B | 50 | 0% | Delete or rewrite (low traffic, no conversion) |
| Post C | 100 | 2% | Optimize (high traffic, low conversion - rewrite) |
This shows which posts are actually driving business value vs. just traffic.
Audit Cadence
First audit: Full audit of all posts (2 hours)
Quarterly audits: Review posts that dropped 20%+ traffic (30 mins)
Annual audit: Full re-audit to find new decay (2 hours)
Set a calendar reminder. Most teams do this once per year and regret not doing it sooner.
Frequently Asked Questions
Q: What if I have 1,000+ posts? A: Filter for blog posts only (exclude landing pages, resource pages). Then filter for posts with at least 1 user in last 6 months. That narrows to maybe 300–400 active posts. Audit those. Dead content (0 users) isn't worth your time.
Q: Should I delete old posts or keep them for SEO? A: Delete if: 0 users, 0 ranking, 0 backlinks. Keep if: any ranking (even position 50+), any users, any backlinks. Old content has value—refresh before deleting.
Q: How do I know if a post is decaying or just seasonal? A: Compare year-over-year traffic. If traffic was 100/month in March 2024 and 50/month in March 2025, it's decaying. If traffic dropped from 100 in January to 30 in February (and usually recovers), it's seasonal.
Q: What if my audit shows most posts have zero traffic? A: That's normal for new blogs (under 6 months). For blogs 2+ years old, you either have weak content, weak SEO, weak internal linking, or all three. Audit for patterns: do how-to posts do well? Do comparison posts underperform? Use patterns to guide future content.
Q: Should I include non-blog content in audit? A: Yes, if you want total content picture. But audit blog and non-blog separately. Different types (landing pages, resource pages, pillar pages) have different success metrics.
The Bottom Line
Audit your content twice per year. 2-hour investment identifies 30+ hours of optimization work. That's a 15x return on time.
You don't need new content—you need better content. Audit forces you to choose.
Emily Redmond is a data analyst at Emilytics — AI analytics agent watching your GA4, Search Console, and Bing data. 8 years experience. Say hi →