How to Do an SEO Content Audit

TL;DR

A content audit evaluates every page on your site to decide: keep, improve, consolidate, or remove. Most sites accumulate content debt over years, including outdated posts, thin pages, duplicate topics, and content that never ranked. This dead weight can hurt site-wide quality signals. A proper audit involves exporting all URLs with performance data, categorizing each by action needed, then systematically improving winners, consolidating overlapping content, and removing or noindexing content that can’t be saved. Done right, many sites see ranking improvements from removing weak content alone.

Do This Today (3 Quick Checks)

Find your zero-traffic pages: Export GSC data, filter for pages with zero clicks in last 12 months. These are audit priorities because they’re consuming crawl budget without contributing value.

Check for topic cannibalization: Search “site:yourdomain.com [topic]” for your main topics. Multiple pages targeting the same keyword? That’s consolidation opportunity.

Identify outdated content: Sort blog posts by publish date. Content from 3+ years ago without updates likely needs refreshing, consolidating, or removing.

Content Quality Scoring Rubric

Score each page 1-5 on these criteria, then total for prioritization:

Criteria	1 (Poor)	3 (Average)	5 (Excellent)
<strong>Traffic</strong>	0 sessions/month	10-100 sessions	500+ sessions
<strong>Backlinks</strong>	0 referring domains	1-5 RDs	10+ RDs
<strong>Rankings</strong>	Not ranking	Page 2-3	Page 1
<strong>Content depth</strong>	<500 words, thin	1000-1500 words	2000+ comprehensive
<strong>Accuracy</strong>	Outdated/wrong	Partially current	Fully accurate
<strong>Uniqueness</strong>	Duplicate/generic	Some unique value	Highly differentiated

Score interpretation:

25-30: Keep, possibly improve
18-24: Improve or consolidate
12-17: Consolidate or redirect
6-11: Remove or noindex

Weighting option: Double-weight traffic and rankings if SEO is primary goal.

Update vs Rewrite Decision Matrix

Current State	Traffic Trend	Action
Good content, ranking declining	Was higher, now dropping	<strong>Update:</strong> Refresh stats, add sections, update date
Good content, never ranked	Flat at zero	<strong>Rewrite:</strong> Different angle, better optimization
Thin content, some rankings	Stable low traffic	<strong>Expand:</strong> Add depth, keep URL
Thin content, no rankings	Never performed	<strong>Remove or consolidate:</strong> Not worth saving
Outdated content, had traffic	Declining from peak	<strong>Rewrite:</strong> Modernize completely, keep URL
Good content, stable rankings	Consistent traffic	<strong>Keep:</strong> Minor updates only

Update (keep structure, refresh content):

Update statistics and examples
Add new sections for recent developments
Refresh images and screenshots
Update internal/external links
Change dateModified

Rewrite (new approach, same URL):

Research current SERP and intent
Create new outline matching winners
Write fresh content from scratch
Maintain URL to preserve any existing equity

Redirect Mapping Template

When consolidating content, map redirects carefully:

Old URL	Redirect To	Reason	Backlinks	Traffic
/blog/email-tips-2019/	/blog/email-marketing-guide/	Outdated, consolidated	3	0
/blog/email-basics/	/blog/email-marketing-guide/	Thin, same topic	0	5
/blog/newsletter-guide/	/blog/email-marketing-guide/	Overlapping topic	12	45

Redirect rules:

Always use 301 (permanent) for content consolidation
Point to most relevant existing content
If no relevant target, redirect to category or hub page
Update internal links to point directly to new URL (don’t rely on redirects)
Track redirects in spreadsheet for future reference

Audit Frequency by Site Size

Site Size	Full Audit	Quarterly Review	Monthly Check
<100 pages	Annually	Top 20 performers	New content only
100-500 pages	Every 6 months	Top 50 performers	Declining pages
500-2000 pages	Quarterly	Top 100 performers	Declining + zero traffic
2000+ pages	Continuous rolling	Section by section	Automated alerts

What to check at each level:

Monthly: New content performance (is it getting indexed, ranking?)
Quarterly: Performance changes (what’s declining, what’s growing?)
Annual: Full inventory audit (every page evaluated)

Set up automated alerts:

GSC: Coverage errors increasing
Analytics: Traffic drops >20% on key pages
Rankings: Position drops >5 for priority keywords

Content Audit Decision Framework

For each page, assign one action:

Action	When to Use	Implementation
<strong>Keep</strong>	Ranking well, driving traffic/conversions, still accurate	No changes needed
<strong>Improve</strong>	Good topic, some traffic, but underperforming potential	Update, expand, optimize
<strong>Consolidate</strong>	Multiple pages on same topic, none dominant	Merge into one strong page, redirect others
<strong>Redirect</strong>	Topic covered better elsewhere, page has backlinks	301 redirect to best alternative
<strong>Noindex</strong>	Needed for users but not search (thin legal pages, etc.)	Add noindex, keep page live
<strong>Remove</strong>	No traffic, no backlinks, no value, outdated	Delete with 410 status code

Decision tree:

Does it get traffic? 
├── Yes → Keep or Improve
└── No → Does it have backlinks?
    ├── Yes → Redirect to relevant page
    └── No → Is content still valuable/accurate?
        ├── Yes → Improve and republish
        └── No → Remove or Noindex

The Conversation

Mia, content director at a marketing agency blog, 400+ articles over 6 years, traffic declining despite continuous publishing, noticed rankings dropping across many pages, needs to justify content investment to leadership, advanced content knowledge but limited technical SEO: We’ve published over 400 articles in six years. We used to rank for a lot of keywords, but traffic has been declining for 18 months despite publishing 10+ new articles monthly. Leadership is questioning whether content is working. I think we have a quality problem, not a quantity problem, but I don’t know how to prove it or fix it.

SDC SEO Brain: Your intuition is likely correct. Six years of publishing creates content debt: outdated articles, overlapping topics, thin posts from earlier eras, and content that never performed. Google’s recent updates specifically target sites with significant portions of unhelpful content. Even if your new content is great, a backlog of weak content can drag down overall site quality perception. Let’s audit. How many of your 400 articles get meaningful traffic?

Mia: I haven’t checked systematically. I know our top 20 posts drive most traffic.

SDC SEO Brain: That distribution is common. Let’s get actual data. Export your last 12 months of GSC data for all pages. How many pages show zero clicks over that period?

Mia: Give me a minute… Okay, 147 articles had zero clicks in the past year. Another 89 had fewer than 10 clicks.

SDC SEO Brain: So roughly 236 out of 400 articles, 59% of your content, drive nearly zero search traffic. That’s substantial dead weight. These pages are being crawled and indexed but contributing nothing. Worse, if Google perceives them as low-quality, they’re actively hurting your site’s overall quality signals.

Mia: That’s alarming. Should we just delete them all?

SDC SEO Brain: Not automatically. Some might have backlinks worth preserving via redirect. Some might be valuable topics that just need updating. Some should genuinely be deleted. Let’s categorize. For those 147 zero-click articles, pull backlink data. How many have external links pointing to them?

Mia: I can check Ahrefs… 31 of them have at least one referring domain. The other 116 have zero backlinks.

SDC SEO Brain: The 31 with backlinks should be redirected to relevant existing content, not deleted. You’d lose those backlinks if you delete. The 116 with no traffic and no backlinks are candidates for removal, but first check if any cover topics you still care about.

Mia: Some do. We have 5 articles about “marketing automation” from different years, all with zero traffic.

SDC SEO Brain: That’s a consolidation opportunity, not deletion. You have 5 competing articles on one topic, none ranking. They’re cannibalizing each other. Combine the best elements into one comprehensive, updated “marketing automation” guide. Redirect the 4 weaker URLs to the consolidated page. One strong page beats five weak ones.

Mia: How do I identify all our cannibalization issues?

SDC SEO Brain: Search “site:yourblog.com [topic]” for your main topics. If multiple pages appear, you have potential cannibalization. Also export your GSC data grouped by query, then look for queries where multiple URLs get impressions. That’s Google testing different pages because it’s not clear which is canonical for that topic.

Mia: What about our 89 articles with under 10 clicks? What do we do with those?

SDC SEO Brain: Evaluate individually. Some might be good content on competitive topics that just need more authority or updates. Some might be thin content that was never going to rank. Pull up a few and assess: Is this content still accurate? Is it comprehensive compared to what ranks now? Is the topic worth pursuing?

Mia: I looked at a few. Some are embarrassingly thin. 300-word posts from 2019 that we’d never publish today.

SDC SEO Brain: Those are removal candidates. But also check if those thin pages ever ranked. If a 300-word post ranked in 2019 and lost rankings, the topic might still be valuable, just needing a comprehensive rewrite rather than deletion.

Mia: How do I check historical rankings?

SDC SEO Brain: Ahrefs or Semrush historical data can show past rankings. Or compare GSC data year-over-year if you have history. But honestly, for pages with no current traffic and no backlinks, historical rankings matter less. The question is: would you create this content today? If no, remove it. If yes but better, improve it.

Mia: What’s the process for actually doing the audit?

SDC SEO Brain: Here’s a systematic approach:

Step 1: Export all URLs

GSC: All pages with impressions/clicks data (last 16 months)
Crawl: All indexable pages from Screaming Frog/Sitebulb
Backlinks: Referring domains per page from Ahrefs/Semrush

Step 2: Create master spreadsheet
Columns: URL, Title, Publish Date, Last Updated, Clicks (12mo), Impressions (12mo), Avg Position, Referring Domains, Word Count, Primary Keyword, Current Ranking

Step 3: Categorize by performance

Winners: Top 20% by traffic
Potential: Ranking page 2 or positions 5-10
Underperformers: Few clicks despite impressions
Zero performers: No traffic, no impressions
Unknown: Not in GSC (maybe not indexed)

Step 4: Assign actions

Winners: Keep, maybe update
Potential: Improve, optimize
Underperformers: Evaluate for improvement or consolidation
Zero performers: Consolidate, redirect, or remove
Unknown: Check indexing, decide if worth keeping

Step 5: Execute systematically

Week 1-2: Process removals and redirects
Week 3-4: Consolidate overlapping content
Ongoing: Improve and update valuable content

Mia: How quickly will we see results?

SDC SEO Brain: Removal results can show within weeks as Google recrawls and sees improved site quality signals. Improvement results take longer as updated content earns rankings. Some sites report ranking improvements simply from removing weak content, before any improvements. The timeline depends on crawl frequency and competition.

Mia: How do I present this to leadership?

SDC SEO Brain: Frame it as ROI optimization. “59% of our content drives zero traffic. We’re spending resources maintaining and crawling content that provides no return. This audit will identify content to remove, consolidate, or improve, focusing resources on what works.” Then track: traffic change, rankings change, and content efficiency (traffic per article).

Mia: Should we pause new content while doing this audit?

SDC SEO Brain: Not necessarily, but consider reducing volume temporarily to focus resources on the audit. Publishing new content while ignoring 236 underperforming articles is like filling a leaky bucket. Fix the leaks first, then resume filling. Or allocate some resources to new content and some to audit, but don’t ignore the backlog.

Mia: Any tools that help with content audits?

SDC SEO Brain: Several: Screaming Frog for crawl data, Ahrefs/Semrush for rankings and backlinks, GSC for search performance, Google Analytics for on-site behavior. Some dedicated tools like ContentKing, Sitebulb, or SEMrush’s Content Audit feature combine these. But honestly, a spreadsheet combining exported data works fine for most sites.

FAQ

Q: How often should I do a content audit?
A: Full audits annually for large sites. Quarterly reviews of performance data to catch declining content early. Continuous monitoring of your top pages. The larger and older your content library, the more frequently you need to audit.

Q: Should I delete old content or just noindex it?
A: Delete if the content has no value to anyone (users or SEO). Noindex if users might still find it valuable (through direct links, internal search) but you don’t want it competing in search. When in doubt, noindex first; delete later if needed.

Q: Will deleting content hurt my SEO?
A: Deleting low-quality, zero-traffic content usually helps. It improves site-wide quality signals and focuses crawl budget on valuable pages. Deleting content with traffic, backlinks, or strategic value can hurt. The audit process distinguishes between the two.

Q: What do I do with content that has backlinks but no traffic?
A: Redirect it to the most relevant existing page. The backlinks transfer value to the redirect target. Don’t delete pages with backlinks unless the links are spam or the page is harmful to keep live.

Q: How do I handle content consolidation?
A: Identify the “keeper” URL (most traffic, best content, or best URL). Improve that page by incorporating the best elements from pages being consolidated. Set up 301 redirects from the consolidated pages to the keeper. Update internal links to point to the keeper.

Summary

Content debt accumulates over time. Years of publishing creates outdated, thin, duplicate, and underperforming content that drags down site quality. Regular audits prevent accumulation and improve overall SEO performance.

Most sites follow the 80/20 rule: A small percentage of content drives most traffic. Auditing identifies the dead weight that consumes resources without contributing value.

Every page gets one of six actions:

Keep: Performing well, accurate, no changes needed
Improve: Good topic, needs updating or optimization
Consolidate: Merge multiple weak pages on same topic
Redirect: Has backlinks, but content not worth keeping
Noindex: Needed by users, not for search
Remove: No traffic, no backlinks, no value

The audit process:

Export all URLs with performance and backlink data
Create master spreadsheet with key metrics
Categorize by performance level
Assign action to each page
Execute systematically: removals, redirects, consolidations, improvements

Removing weak content can improve rankings. Google’s systems evaluate site-wide quality. Eliminating a significant portion of low-quality pages can improve how Google perceives remaining content.

Consolidation beats competition. Five weak articles on one topic lose to one comprehensive article. Merge the best elements, redirect the others.

Track and present as ROI improvement. Measure traffic per article, not just total traffic. Removing zero-value content improves content efficiency even if total traffic stays flat initially.

Sources

Google Search Central: Consolidating duplicate URLs – https://developers.google.com/search/docs/crawling-indexing/consolidate-duplicate-urls
Google Search Central: Remove outdated content – https://developers.google.com/search/docs/crawling-indexing/remove-information
Google: Creating helpful content – https://developers.google.com/search/docs/fundamentals/creating-helpful-content

SDC SEO