Files
seo/guides/EDITORIAL_STRATEGY_GUIDE.md
Kevin Bataille 8c7cd24685 Refactor SEO automation into unified CLI application
Major refactoring to create a clean, integrated CLI application:

### New Features:
- Unified CLI executable (./seo) with simple command structure
- All commands accept optional CSV file arguments
- Auto-detection of latest files when no arguments provided
- Simplified output directory structure (output/ instead of output/reports/)
- Cleaner export filename format (all_posts_YYYY-MM-DD.csv)

### Commands:
- export: Export all posts from WordPress sites
- analyze [csv]: Analyze posts with AI (optional CSV input)
- recategorize [csv]: Recategorize posts with AI
- seo_check: Check SEO quality
- categories: Manage categories across sites
- approve [files]: Review and approve recommendations
- full_pipeline: Run complete workflow
- analytics, gaps, opportunities, report, status

### Changes:
- Moved all scripts to scripts/ directory
- Created config.yaml for configuration
- Updated all scripts to use output/ directory
- Deprecated old seo-cli.py in favor of new ./seo
- Added AGENTS.md and CHANGELOG.md documentation
- Consolidated README.md with updated usage

### Technical:
- Added PyYAML dependency
- Removed hardcoded configuration values
- All scripts now properly integrated
- Better error handling and user feedback

Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com>
2026-02-16 14:24:44 +01:00

685 lines
16 KiB
Markdown
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
# Editorial Strategy & Content Audit Guide
**Date:** February 2026
**Status:** Strategic Planning Document
**Goal:** Transform scattered content into a coherent, profitable editorial strategy
---
## 📋 Table of Contents
1. [Your Current Situation](#your-current-situation)
2. [The Real Problem](#the-real-problem)
3. [Content Audit Strategy](#content-audit-strategy)
4. [AI-Powered Analysis Tools](#ai-powered-analysis-tools)
5. [Implementation Plan](#implementation-plan)
6. [Expected Results](#expected-results)
---
## 🎯 Your Current Situation
**What You Have:**
- 262 blog posts
- ~717 monthly organic visits
- Mix of content types (torrents, VPN, streaming, software, gaming)
- Sponsored link monetization model
- ~€50/month budget for tools
**What's Broken:**
- ✗ Incoherent articles scattered across categories
- ✗ No clear editorial line or niche focus
- ✗ Content not aligned for monetization
- ✗ Unclear which topics actually drive traffic
- ✗ Likely cannibalization (multiple posts on same topic)
- ✗ Off-brand/thin content diluting authority
---
## 🔍 The Real Problem: Editorial Chaos
### Current State (Estimated)
```
262 Posts
├─ 97 posts (37%) - Off-brand/unclear fit
├─ 65 posts (25%) - Thin/low traffic
├─ 45 posts (17%) - Duplicate/cannibalized topics
├─ 40 posts (15%) - Good, focused content
└─ 15 posts (6%) - High-performing, monetizable
```
### Why This Matters
1. **User Confusion:** Visitors can't figure out your site's purpose
2. **SEO Penalty:** Google sees incoherent content as low authority
3. **Low Monetization:** Content not aligned with high-CPM sponsor topics
4. **Wasted Effort:** Building authority in too many directions
5. **Poor ROI:** 262 posts producing ~717 visits (2.7 visits/post)
### The Opportunity
**With focused editorial line:**
- Consolidate 262 posts → 180-200 strong posts
- Improve authority in 3-4 core topics
- Target high-CPM sponsored content
- Increase traffic 30-50% (950-1,100 visits/month)
- Better sponsor rates & link opportunities
---
## 📊 Content Audit Strategy
### What We Need to Understand
For each post, analyze:
```
✓ Topic/Category - What's it about?
✓ Performance - Traffic, position, impressions
✓ Depth - Word count, comprehensiveness
✓ Monetization - CPM potential of topic
✓ Relationships - Does it duplicate other posts?
✓ Intent - User intent it targets
✓ Quality - Engagement metrics
```
### Topics to Analyze
Based on your site, expected topics:
**High-Value Topics (Keep & Expand):**
- VPN guides & reviews (High CPM: $5-10)
- Software tools & comparisons (CPM: $3-8)
- Legal streaming alternatives (CPM: $2-4)
- Gaming guides & emulation (CPM: $2-4)
**Medium-Value Topics (Keep & Consolidate):**
- Torrenting guides (Low CPM: $0.5)
- General tools & tutorials (CPM: $2-3)
**Low-Value Topics (Consolidate or Delete):**
- Unrelated content
- Thin posts (<500 words)
- Off-brand content
- Duplicate posts
---
## 🤖 AI-Powered Analysis Tools
### Tool 1: Content Audit & Topic Clustering
**What it does:**
```
Input: All 262 posts (titles + excerpts + traffic data)
AI Analysis:
• Classify each post into topics
• Group related posts
• Identify cannibalization
• Calculate topic authority scores
• Assess monetization potential
Output: Topic map showing:
• Which topics dominate your site
• Traffic distribution
• Quality of content in each topic
• Cannibalization hotspots
```
**Example Output:**
```
TOPIC CLUSTERS IDENTIFIED:
1. YggTorrent & Ratio Building
Posts: 12 | Traffic: 5,200/mo | Avg Position: 8.3
Authority: 85/100 | CPM: $0.5 | Cannibalization: HIGH
Recommendation: Consolidate into 1-2 definitive guides
2. VPN & Privacy
Posts: 22 | Traffic: 3,100/mo | Avg Position: 12.1
Authority: 72/100 | CPM: $8.0 | Cannibalization: MEDIUM
Recommendation: Expand (+5 new posts) - HIGH VALUE
3. Software & Tools
Posts: 45 | Traffic: 4,200/mo | Avg Position: 15.8
Authority: 58/100 | CPM: $5.0 | Cannibalization: HIGH
Recommendation: Consolidate, reorganize, expand
4. Streaming Guides
Posts: 38 | Traffic: 2,100/mo | Avg Position: 22.5
Authority: 45/100 | CPM: $2.0 | Cannibalization: HIGH
Recommendation: Consolidate, refocus on legal options
5. Gaming & Emulation
Posts: 18 | Traffic: 900/mo | Avg Position: 28.3
Authority: 35/100 | CPM: $3.0 | Cannibalization: LOW
Recommendation: Keep but don't expand
6. Other/Unrelated
Posts: 127 | Traffic: 2,500/mo | Avg Position: 40.1
Authority: 10/100 | CPM: $1.0 | Cannibalization: VERY HIGH
Recommendation: DELETE or radically consolidate
```
### Tool 2: Cannibalization Analysis
**Identifies:**
```
Posts competing for same keywords:
• Post #12 & #45 & #88 - "YggTorrent ratio"
• Post #34 & #67 - "Best VPN 2025"
• Post #123 & #198 - "Streaming sites"
Problem: Google doesn't know which to rank
Solution: Merge into 1 comprehensive guide
```
### Tool 3: Monetization Potential
**Calculates for each topic:**
```
CPM (Cost Per Mille - per 1,000 impressions):
VPN: $5-10 CPM (HIGH)
→ 3,100 impressions × $0.008 = $24.80/month
→ If expanded to 10,000 impressions = $80/month
Software/Tools: $3-8 CPM (MEDIUM-HIGH)
Gaming: $2-4 CPM (MEDIUM)
Legal Streaming: $2-4 CPM (MEDIUM)
Torrents/File Sharing: $0.50 CPM (VERY LOW)
→ Sponsors avoid - seen as "piracy enabling"
Current Focus Problem:
• 37% of traffic from low/no-CPM topics
• Missing 50% of monetization potential
```
### Tool 4: Editorial Coherence Score
**Analyzes:**
```
✓ Do your posts tell a coherent story?
✓ Do they align with a clear niche?
✓ Is navigation logical?
✓ Are there contradictory messages?
✓ What % of content is actually useful?
Your Current Score: 23/100 (Very scattered)
Potential Score: 85/100 (With refactoring)
```
---
## 🛠️ Implementation Plan
### Phase 1: Audit & Decision (Week 1-2)
**Step 1: Run Content Audit**
```bash
python content_audit_and_strategy.py
```
**Step 2: Review Outputs**
- Identify actual topic clusters
- See traffic distribution
- Understand cannibalization
- Calculate monetization by topic
**Step 3: Decide Editorial Line**
Choose one strategic approach:
#### Option A: "Ethical Tech & Privacy" (Recommended)
```
Core Topics:
• VPN & Privacy tools
• Software tools & comparisons
• Gaming & emulation guides
• Legal streaming alternatives
Drop:
• Torrenting/file sharing (too low CPM)
• Illegal streaming content
Benefits:
• Higher CPM sponsors
• Clearer ethical positioning
• Better advertiser fit
• Easier to build authority
CPM Average: 4-8 (Good)
Traffic Potential: +40-50%
Monetization: Excellent
```
#### Option B: "Everything Tech & Hacks" (Broader)
```
Core Topics:
• VPN & privacy
• Software tools
• File sharing optimized
• Streaming guides
• Gaming & emulation
• General hacks
Benefits:
• Broader audience
• More content flexibility
Challenges:
• Lower average CPM
• Harder to build authority
CPM Average: 2-4 (Okay)
Traffic Potential: +20-30%
Monetization: Moderate
```
#### Option C: "File Sharing & Downloads" (Original)
```
Core Topics:
• Torrent sites & trackers
• VPN for privacy
• Ratio building
• Download tools
Problems:
• Very low CPM ($0.50)
• Sponsor avoidance
• Poor monetization
Recommendation: NOT RECOMMENDED
CPM Average: 1-2 (Poor)
```
**Recommendation:** Option A ("Ethical Tech & Privacy") gives best balance of:
- Higher monetization ($4-8 CPM)
- Clearer positioning
- Better growth potential
- Easier to scale
### Phase 2: Consolidation (Week 3-6)
**Identify Posts to Merge:**
```
Create consolidated guides:
VPN Topic:
Merge: #34, #67, #145, #198 → "Best VPNs 2025: Complete Guide"
Merge: #45, #89 → "VPN Comparison: Speed vs Privacy"
Delete: #12, #56 (thin content)
Result: 22 posts → 3-4 comprehensive guides
Software Tools:
Merge: Multiple tool reviews → Category-based guides
Delete: 20 outdated tool reviews
Result: 45 posts → 12-15 focused guides
```
**WordPress Work:**
```
1. For each merge:
• Choose the post with best traffic
• Copy unique content from others
• Combine into one comprehensive post
• Update internal links
• Redirect old posts to new post
2. Delete off-brand:
• Set 301 redirects if they have links
• Remove from search console
3. Reorganize categories:
Create structure:
└─ Tech Tools & Software
├─ VPN & Privacy
├─ Software Reviews
└─ Tools & Utilities
└─ Guides & Tutorials
├─ Gaming
├─ Streaming
└─ General Tech
```
### Phase 3: Reorganization (Week 7-10)
**Fix Information Architecture:**
```
Before (Messy):
Home
├─ Category 1
├─ Category 2
├─ Random post
├─ Category 3
└─ ...
After (Organized):
Home
├─ VPN & Security
│ ├─ Best VPNs
│ ├─ VPN Reviews
│ └─ VPN Guides
├─ Software & Tools
│ ├─ Software Reviews
│ ├─ Comparisons
│ └─ Tutorials
├─ Gaming
│ ├─ Game Guides
│ └─ Emulation
└─ About/Resources
```
**Internal Linking Strategy:**
```
Create topic clusters with strong internal linking:
VPN Topic:
Best VPNs (Hub) → links to:
• VPN Review 1
• VPN Review 2
• VPN Comparison
• VPN Guides
Each post links back to hub
Users stay in topic cluster
Google understands topic authority
```
**Navigation Improvements:**
```
• Add breadcrumb navigation
• Create category landing pages
• Add topic-specific sidebars
• Improve internal linking
• Add "related posts" section
```
### Phase 4: Build High-Value Content (Week 11+)
**Create 15-20 New Posts in High-CPM Topics:**
```
VPN Topic (High CPM $8):
• VPN for Gaming Guide
• VPN Speed Comparison
• VPN for Streaming
• VPN Security Features
(Target: 5-8 new posts)
Software Topic (CPM $5):
• Software Comparison Guides
• Tool Tutorials
• Productivity Tools
(Target: 5-6 new posts)
Gaming Topic (CPM $3):
• Game Guides
• Emulation Tutorials
(Target: 3-4 new posts)
Legal Streaming (CPM $2-4):
• Legal Streaming Guides
• Service Comparisons
(Target: 2-3 new posts)
```
**Sponsored Link Strategy:**
```
High-CPM Content = Better sponsor fit:
VPN Posts:
• Target: VPN companies
• Affiliate links & sponsored content
• Expected: $50-100/month
Software Posts:
• Target: Tool reviews/comparisons
• Affiliate partnerships
• Expected: $30-50/month
Total Monthly Potential: $80-150 from sponsorships
(Up from current ~$20-30)
```
---
## 📈 Expected Results
### Before Refactoring
```
Posts: 262
Monthly Traffic: 717 visits
Visits/Post: 2.7
Topic Coherence: 23/100
Cannibalization: HIGH
Monetization: Low ($0.50-2 CPM avg)
Authority: Scattered across 14 topics
Monthly Revenue: ~$20-30
User Experience: Confusing
SEO Performance: Poor (scattered authority)
Growth Trajectory: Flat
```
### After Refactoring (3 months)
```
Posts: 180-200 (40-50 consolidated)
Monthly Traffic: 950-1,100 visits (+33-53%)
Visits/Post: 5-6 (doubled)
Topic Coherence: 75-85/100
Cannibalization: LOW
Monetization: Medium ($4-6 CPM avg)
Authority: Strong in 3-4 core topics
Monthly Revenue: $80-150 (3-5x increase)
User Experience: Clear & coherent
SEO Performance: Strong (focused authority)
Growth Trajectory: Upward
```
### 12-Month Projection
```
If you continue building (15-20 posts/year in high-CPM topics):
Month 12 Traffic: 1,500-2,000 visits (+110-180%)
Monthly Revenue: $200-300 from sponsorships
Topic Authority: Strong in 3-4 areas
Organic growth: Compound effect
```
---
## 🚀 Tools to Build
### Must-Have (Phase 1)
**`content_audit_and_strategy.py`**
```
Input: posts_with_analytics.csv
Outputs:
1. content_audit_report.md (strategic recommendations)
2. topic_clusters.csv (all topics with metrics)
3. consolidation_plan.csv (which posts to merge)
4. cannibalization_analysis.csv (competing posts)
```
**Input Data Needed:**
```
From your existing system:
✓ Post ID
✓ Title
✓ Content (first 1000 chars)
✓ Traffic
✓ Impressions
✓ Category/Tags
✓ URL
```
### Nice-to-Have (Phase 2+)
**`monetization_optimizer.py`**
- Calculate CPM potential by topic
- Recommend sponsored link placement
- Estimate revenue by topic
**`content_health_checker.py`**
- Identify thin content (<500 words)
- Find outdated posts
- Detect poor engagement
**`topic_authority_tracker.py`**
- Track topical authority progress
- Monitor keyword rankings by topic
- Show growth over time
---
## 💰 Investment & ROI
### Cost
```
Tool Development: $0 (I'll build it)
Time to Audit: 2-3 hours reading reports
Time to Consolidate: 20-30 hours (WordPress work)
Time to Reorganize: 10-15 hours
Time to Create New Content: 60-80 hours (4-6 weeks)
Total Time: ~100-130 hours over 3 months
Tool Costs: $0 (using existing data)
ROI Calculation:
Current Revenue: $20-30/month
Projected Revenue: $80-150/month
Monthly Gain: $50-120/month
6-Month Gain: $300-720
12-Month Gain: $600-1,440
Time Investment ROI:
130 hours of work → $600-1,440 annual gain
= $4.60-11 per hour gain
(Ongoing passive income)
```
### Budget Considerations
```
Month 1: $0 (audit & planning)
Month 2: $0 (consolidation work)
Month 3: $0 (reorganization)
Month 4+: $0 (you have the tools)
Optional Paid Tools (if needed):
• Ahrefs/SEMrush: $100/month (NOT needed to start)
• Tools you might not need yet
```
---
## 📋 Next Steps
### Week 1: Decide
1. **Read this document**
2. **Choose editorial direction:**
- Option A: "Ethical Tech & Privacy" (Recommended)
- Option B: "Everything Tech & Hacks"
- Option C: Keep current direction
3. **Get buy-in from yourself** on the plan
### Week 2: Audit
1. **I build:** `content_audit_and_strategy.py`
2. **You run:** The script
3. **You review:** Generated reports
4. **You finalize:** Consolidation plan
### Week 3-6: Execute
1. **Merge posts** in WordPress
2. **Set up redirects**
3. **Reorganize categories**
4. **Fix internal links**
### Week 7-12: Build
1. **Create 15-20 new posts** in high-CPM topics
2. **Develop sponsored content strategy**
3. **Track progress**
4. **Measure traffic gains**
---
## ❓ Key Questions to Answer
Before we start, decide:
1. **Which editorial direction?**
- A: Ethical Tech & Privacy (Recommended)
- B: Broader "Everything Tech"
- C: Keep current mixed approach
2. **Willing to delete content?**
- Some off-brand/thin posts will need to go
- ~20-30 posts potentially deleted
3. **Willing to consolidate?**
- Merge 40-50 posts into stronger guides
- Better user experience
- Better monetization
4. **Timeline?**
- Can you dedicate 10-15 hours/week for 3 months?
- Or spread it over 6 months with less weekly commitment?
5. **Monetization focus?**
- Maximize sponsored revenue?
- Build audience first, monetize later?
- Both equally?
---
## 🎯 Success Metrics
We'll measure success by:
```
✓ Topic coherence score (23→75+)
✓ Monthly traffic (717→1,000+)
✓ Posts (262→200 - consolidated)
✓ Average CPM ($0.50→$4+)
✓ Monthly revenue ($20→$100+)
✓ User experience (subjective improvement)
✓ Sponsor interest (easier pitches)
```
---
## 📞 Ready?
This plan gives you:
✅ Clear editorial direction
✅ Data-driven consolidation plan
✅ Higher monetization strategy
✅ Better user experience
✅ Stronger SEO authority
✅ 30-50% traffic growth potential
✅ 3-5x revenue potential
**Next action:** Let me know:
1. Which editorial direction you prefer?
2. When you can dedicate time to this?
3. If you want me to build the audit tool?
Let's transform your scattered site into a focused authority! 🚀
---
**Document Version:** 1.0
**Last Updated:** February 2026
**Status:** Ready for Implementation