seo/EDITORIAL_STRATEGY_GUIDE.md

Editorial Strategy & Migration Guide

Overview

The SEO automation tool can now analyze your editorial strategy and provide data-driven recommendations for:

1. Editorial lines - What each site should focus on
2. Post migrations - Which posts to move between sites
3. Category structure - Optimal number and types of categories per site

Commands

Analyze Editorial Strategy

# Analyze latest export
./seo editorial_strategy

# Analyze specific CSV
./seo editorial_strategy output/all_posts_2026-02-16.csv

Output: output/editorial_strategy_YYYYMMDD_HHMMSS.md - Comprehensive markdown report

Answering Your Questions

1. How to Determine Editorial Line for Each Site?

The tool analyzes your actual content to determine editorial focus:

./seo editorial_strategy

Analysis includes:

• Topic distribution - What topics each site covers (VPN, Software, Gaming, Torrenting, etc.)
• Category distribution - Current category usage
• Traffic patterns - Which content performs best
• Content gaps - Missing topics
• Overlapping content - Duplicate coverage across sites

Example Output:

mistergeek.net:
  Editorial Focus: Focus on VPN, Software, Gaming content
  Top Categories: VPN (45 posts), Software (32 posts), Gaming (28 posts)
  Traffic: 60% of posts have 100+ monthly visits

webscroll.fr:
  Editorial Focus: Focus on Torrenting, File-Sharing content
  Top Categories: Torrenting (78 posts), Tracker Guides (45 posts)
  Traffic: 40% of posts have 100+ monthly visits

hellogeek.net:
  Editorial Focus: Mixed content - needs consolidation
  Top Categories: Other (50 posts), Various (30 posts)
  Traffic: 80% of posts have <50 monthly visits

2. How to Migrate Articles Between Sites?

The tool provides AI-powered migration recommendations:

Step 1: Get Migration Recommendations

./seo editorial_strategy

This generates a report with specific migration recommendations:

• Which posts to move
• From which site to which site
• Priority level (High/Medium)
• Reason for migration

Step 2: Review Recommendations

Open the generated report:

open output/editorial_strategy_*.md

Review the "Migration Recommendations" section:

## Migration Recommendations

**Total posts to migrate:** 45

### To mistergeek.net: 25 posts
| Post ID | Title | Current Site | Priority |
|---------|-------|--------------|----------|
| 1234 | Best VPN for... | hellogeek.net | High |
| 5678 | Software Review... | webscroll.fr | Medium |

### To webscroll.fr: 15 posts
...

### To hellogeek.net: 5 posts
...

Step 3: Execute Migrations

Currently, migrations need to be done manually in WordPress admin, or you can:

1. Export migration list from the report
2. Use WordPress import/export tools
3. Or use the category_apply command after updating site assignments

3. How Many Categories Per Site?

Best Practice: 5-10 categories per site for optimal SEO

The tool provides specific recommendations:

./seo editorial_strategy

Recommended Category Structure:

mistergeek.net (High-value tech content)

• Ideal: 8-12 categories
• Focus: VPN, Software, Gaming, SEO
• Recommended:
  1. VPN (High priority)
  2. Software/Tools (High)
  3. Gaming (High)
  4. SEO (Medium)
  5. Content Marketing (Medium)
  6. Tech Reviews (Medium)
  7. Tutorials (Low)
  8. News (Low)

webscroll.fr (Torrenting niche)

• Ideal: 5-8 categories
• Focus: Torrenting, File-Sharing
• Recommended:
  1. Torrenting (High)
  2. File-Sharing (High)
  3. Tracker Guides (High)
  4. VPN for Torrenting (Medium)
  5. Seedbox (Medium)
  6. Legal (Low)

hellogeek.net (Catch-all for low-traffic)

• Ideal: 3-5 categories (minimal)
• Focus: Experimental, low-traffic content
• Recommended:
  1. Experimental (High)
  2. Low-Traffic (High)
  3. Off-Brand (Medium)
  4. Testing (Low)

Why These Numbers?

Too few (<3 categories):

• ❌ Poor content organization
• ❌ Hard for users to navigate
• ❌ Weak internal linking

Optimal (5-10 categories):

• ✅ Clear content hierarchy
• ✅ Strong category authority
• ✅ Good user experience
• ✅ SEO benefits

Too many (>15 categories):

• ❌ Diluted category authority
• ❌ Thin content per category
• ✅ Confusing for users
• ❌ SEO penalty (keyword cannibalization)

Complete Workflow

Phase 1: Analysis

# 1. Export all posts
./seo export

# 2. Analyze editorial strategy
./seo editorial_strategy

# 3. Review report
open output/editorial_strategy_*.md

Phase 2: Category Optimization

# 4. Get AI category proposals
./seo category_propose

# 5. Review proposals
open output/category_proposals_*.csv

# 6. Create missing categories
./seo category_create -s mistergeek.net "VPN Reviews"
./seo category_create -s webscroll.fr "Seedbox Guides"

# 7. Apply category recommendations
./seo category_apply -s mistergeek.net -c High

Phase 3: Content Migration

# 8. Review migration recommendations from report
# 9. Manually migrate high-priority posts (or automate)
# 10. Monitor traffic changes

Migration Decision Matrix

The tool uses this logic to recommend migrations:

Content Type	Current Site	Recommended Site	Reason
VPN/Software	hellogeek	mistergeek	Core topic
VPN/Software	webscroll	mistergeek	Wrong niche
Torrenting	mistergeek	webscroll	Niche focus
Torrenting	hellogeek	webscroll	Niche focus
Low-traffic	mistergeek	hellogeek	Clean up main site
Low-traffic	webscroll	hellogeek	Clean up niche site
High-traffic	hellogeek	mistergeek	Move to main site

Migration Implementation

Option 1: Manual (Recommended for first time)

1. Review migration report
2. Export posts from source site (WordPress Tools → Export)
3. Import to target site (WordPress Tools → Import)
4. Set up 301 redirects (important for SEO!)

Option 2: Semi-Automated

1. Use the migration CSV from report
2. Write custom script using WordPress REST API
3. Batch process migrations
4. Verify redirects

Option 3: Full Automation (Future feature)

# Coming soon
./seo migrate_posts --from hellogeek.net --to mistergeek.net

Monitoring Results

After migrations:

1. Wait 2-4 weeks for Google to re-index
2. Monitor traffic in Google Analytics
3. Check rankings in Search Console
4. Verify 301 redirects are working

Expected results:

• ✅ Improved category authority
• ✅ Better user engagement
• ✅ Higher rankings for core topics
• ✅ Cleaner site structure

Best Practices

DO:

• ✅ Start with high-traffic migrations first
• ✅ Set up 301 redirects for all moved posts
• ✅ Migrate in batches (10-20 posts at a time)
• ✅ Monitor traffic after each batch
• ✅ Keep categories focused (5-10 per site)

DON'T:

• ❌ Migrate all posts at once
• ❌ Forget 301 redirects (SEO disaster!)
• ❌ Create too many categories (>15)
• ❌ Ignore traffic data in decisions
• ❌ Migrate without backup

Example Session

# Complete editorial strategy session

# 1. Export
./seo export
# → output/all_posts_2026-02-16.csv

# 2. Analyze strategy
./seo editorial_strategy
# → output/editorial_strategy_20260216_143022.md

# 3. Review report
open output/editorial_strategy_20260216_143022.md

# 4. Create missing categories
./seo category_create -s mistergeek.net "VPN Reviews"
./seo category_create -s mistergeek.net "Software Tutorials"

# 5. Get category proposals
./seo category_propose

# 6. Apply categories
./seo category_apply -s mistergeek.net -c High

# 7. Manually migrate top 10 recommended posts
# (following migration report)

---

Version: 1.0.0
Last Updated: 2026-02-16
Related: See CATEGORY_MANAGEMENT_GUIDE.md for category operations