SEO Content Pipeline Documentation
Data-driven SEO content production: SpyFu → NeuronWriter → opencode (DeepSeek) → WordPress
info
This documentation covers the complete SEO content operations system, including keyword discovery, content optimization, AI-assisted generation, WordPress publishing, pipeline management, and business monetization.
Quick Start
The pipeline connects four phases into a single data-driven system:
Documentation Structure
| Section | Description |
|---|---|
| 01. Overview | System architecture, problem statement, data flow |
| 02. Keyword Discovery | SpyFu workflow, scoring formula, data fields |
| 03. Content Optimization | NeuronWriter workflow, prompt engineering, NW brief creation |
| 04. Content Generation | Model selection, generation modes, quality control |
| 05. Publishing | wp-cli automated publishing, final editing in WordPress, plugin reference |
| 06. Pipeline CSV | 42-column reference, formulas, status tracking |
| 07. Tools Reference | SpyFu API, NeuronWriter API, Website Auditor |
| 08. Multi-Site Strategy | Managing multiple WordPress sites in one pipeline |
| 09. Business & Monetization | Service packages, pricing, target markets |
| 10. Workflow & Operations | Weekly cycles, cost management, quality checks |
| 11. E-E-A-T & Quality | Trust signals, expert review, content standards |
| 12. Performance Tracking | GSC integration, reporting, refresh cycles |
Core Principles
- Data-driven decisions — Every keyword is scored, every term is researched, every result is tracked
- Reference not rules — NeuronWriter terms guide writing but never override originality
- Human in the loop — AI drafts speed up production but human editing ensures quality
- Track everything — The CSV pipeline is the single source of truth for status
- Measure outcomes — GSC data closes the loop from production to performance