📋 Content Audit Framework
Systematically analyze and improve your website content
🔄 Audit Process
📥
Collect
Crawl site, export all URLs
📊
Analyze
Gather metrics and data
📏
Score
Rate each page quality
🏷️
Categorize
Keep, update, merge, delete
🚀
Execute
Implement improvements
📈 Key Metrics to Collect
📊
Organic Traffic
Monthly sessions from search engines
>500 Good🔗
Backlinks
External links pointing to page
>10 Good📝
Word Count
Total words on page
>1000 OK⏱️
Time on Page
Average engagement time
>2min Good↩️
Bounce Rate
Single-page session rate
>70% Bad🎯
Conversions
Goal completions from page
Any = Good📅
Last Updated
Content freshness
<1yr OK🔍
Rankings
Keyword positions
Top 20 Good📑 Audit Spreadsheet Template
| URL | Title | Traffic | Words | Backlinks | Last Updated | Score | Action |
|---|---|---|---|---|---|---|---|
| /microdosing/fadiman-protocol | Fadiman Protocol Guide | 2,450 | 2,800 | 45 | 2025-12 | 92 | Keep |
| /safety/harm-reduction | Harm Reduction Guide | 1,200 | 1,500 | 22 | 2024-06 | 75 | Update |
| /species/cubensis-1 | Cubensis Overview | 150 | 600 | 3 | 2023-11 | 42 | Merge |
| /old/test-page | Test Page | 5 | 200 | 0 | 2022-03 | 12 | Delete |
🎯 Action Decision Matrix
✅ KEEP
- High traffic (>500/mo)
- Good backlinks (>10)
- High engagement
- Converting content
- Recently updated
🔄 UPDATE
- Declining traffic
- Outdated information
- Has backlinks worth keeping
- Still relevant topic
- Needs more depth
🔗 MERGE
- Similar/duplicate topics
- Thin content (< 500 words)
- Low individual traffic
- Combined would be stronger
- Cannibalized keywords
❌ DELETE
- Zero traffic (12+ months)
- No backlinks
- Irrelevant/outdated topic
- Duplicate with better page
- Cannot be improved
📏 Content Scoring System (0-100)
Traffic Performance 25 pts
- 0-50 visits = 5 pts
- 51-200 visits = 10 pts
- 201-500 visits = 15 pts
- 501-1000 visits = 20 pts
- 1000+ visits = 25 pts
Content Quality 25 pts
- <300 words = 5 pts
- 300-700 words = 10 pts
- 700-1500 words = 15 pts
- 1500-2500 words = 20 pts
- 2500+ words = 25 pts
Backlink Authority 25 pts
- 0 backlinks = 0 pts
- 1-5 backlinks = 10 pts
- 6-15 backlinks = 15 pts
- 16-30 backlinks = 20 pts
- 30+ backlinks = 25 pts
Freshness & Engagement 25 pts
- Updated <6 months = 10 pts
- Updated <1 year = 5 pts
- Bounce rate <50% = 5 pts
- Time on page >2min = 5 pts
- Has conversions = 5 pts
✅ Content Audit Checklist
📥 Data Collection
- Crawl entire website
- Export Google Analytics data
- Export Search Console data
- Get backlink data
- Check word counts
- Note last modified dates
📊 Analysis
- Calculate content scores
- Identify thin content
- Find duplicate content
- Check for cannibalization
- Assess E-A-T signals
- Review user engagement
🚀 Action Plan
- Categorize all pages
- Prioritize updates
- Plan merges (301 redirects)
- Schedule deletions
- Create content calendar
- Set review schedule