# 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

```bash
# 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:

```bash
./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
```bash
./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:
```bash
open output/editorial_strategy_*.md
```

Review the "Migration Recommendations" section:
```markdown
## 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:

```bash
./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
```bash
# 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
```bash
# 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
```bash
# 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)
```bash
# 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

```bash
# 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