Tutorial: Complete Content Audit Process for SEO Optimization

This step-by-step tutorial walks you through conducting a thorough content audit to identify quality issues, optimization opportunities, and strategic gaps in your content library.

Prerequisites

• Google Search Console access with at least 3 months of data
• Google Analytics 4 access
• Screaming Frog SEO Spider (free version works for sites under 500 pages)
• Ahrefs or Semrush account (for backlink data)
• Spreadsheet for data organization

Phase 1: Data Collection (Days 1-2)

Step 1: Export All URLs

Start with a comprehensive URL inventory:

1. Run Screaming Frog crawl of your entire site
2. Export all crawled URLs (filter: HTML only)
3. Export sitemap URLs and compare for discrepancies
4. Export GSC coverage report to identify indexed URLs

Step 2: Pull Traffic Data

From Google Analytics 4:

1. Navigate to Reports > Engagement > Pages and screens
2. Set date range to last 12 months
3. Export with columns: Page path, Sessions, Average engagement time, Bounce rate
4. Cross-reference with GSC Clicks data

Step 3: Pull Ranking Data

From Google Search Console:

1. Navigate to Search results performance
2. Click Pages tab
3. Export: URL, Clicks, Impressions, CTR, Average position
4. Also export Queries tab for keyword-level data

Step 4: Gather Backlink Data

From Ahrefs or Semrush:

1. Export all URLs with referring domains count
2. Note: Focus on URLs with 5+ referring domains as high-value assets

Phase 2: Content Categorization (Day 3)

Step 5: Merge All Data

Create a master spreadsheet with columns:

• URL, Title, Word Count, Publish Date, Last Modified
• Organic Sessions (12 months), Clicks (GSC), Impressions, CTR, Avg Position
• Referring Domains, Backlinks
• Content Type (Article/Tutorial/Landing/Product)

Step 6: Classify Each URL

Apply these classifications to each URL:

• Keep & Optimize: Good content with ranking potential but not fully optimized
• Update & Expand: Valuable content that's outdated or thin
• Consolidate: Cannibalizing or thin pages that should merge
• Noindex: Pages with no value that shouldn't use crawl budget
• Delete & 301: Pages with no value, no backlinks, that should be removed

Phase 3: Prioritization and Planning (Day 4)

Step 7: Score Each Page

Create a composite priority score:

• Organic sessions score (0-25 points based on traffic tier)
• Impressions score (0-25 points based on GSC impressions)
• Backlink score (0-25 points based on referring domains)
• Improvement potential score (0-25 points based on position vs. potential)

Step 8: Build an Action Plan

Sort by priority score and create quarterly action plans:

• Q1: Top 20 "Update & Expand" pages by priority score
• Q2: Top 20 "Keep & Optimize" pages
• Q3: Consolidation projects identified
• Q4: New content to fill gaps identified in audit

Phase 4: Execution (Ongoing)

Step 9: Execute Updates

For each page in your action plan:

1. Review current competitor rankings for target keywords
2. Update outdated statistics and add recent examples
3. Add sections addressing People Also Ask questions
4. Optimize title tag and meta description based on CTR data
5. Update lastmod date in sitemap
6. Submit URL for re-crawling in GSC

Step 10: Monitor and Iterate

Track results 30, 60, 90 days post-update:

• Compare CTR, average position, and clicks vs. pre-update
• Identify which update types drive the best results
• Refine your update approach based on data

Content Audit Template

Download a free content audit spreadsheet template with all the columns, scoring formulas, and classification dropdowns pre-built. This template automates the scoring process and generates visualization charts for stakeholder reporting.

Conclusion

A systematic content audit transforms vague concerns about content quality into a prioritized action plan with measurable outcomes. Run this process quarterly to maintain optimal content health across your site. The first audit typically takes 2-4 days; subsequent quarterly audits can be completed in a day once your processes are established.