Shuttle SEO Engine
The Problem
SEO at scale requires constant monitoring, content optimisation, and technical fixes. With 378+ pages across blog posts, guides, PSP comparisons, and glossary pages, manual management wasn’t an option.
What I Built
A complete SEO operations engine that collects data, identifies opportunities, and executes fixes:
Data Collection & Analysis
- Daily Google Search Console collection into SQLite (~20K+ historical queries)
- Trend tracking with position, CTR, and impression monitoring
- Cannibalisation detection identifying pages competing for the same queries
- CLI dashboard with commands:
collect,report,cannibalize,alerts,enrich,serve
Content Operations
- 13+ waves of blog rewrites targeting high-impression GSC queries
- Content push automation to Caisy CMS — publish, update, and internal link in one command
- Vertical content clusters: insurance, hospitality, CCaaS, AI voice, BPO, travel
- Programmatic SEO for PSP provider comparisons
Technical SEO
- Canonical tags, meta descriptions, JSON-LD schema fixes
- Wave-based 301 redirects for cannibalisation cleanup
- Title and description optimisation for CTR
- Breadcrumb, FAQ, Article, and CollectionPage structured data
- Google Indexing API submissions for accelerated discovery
Scale
- 378+ pages managed: 195 blog posts, 44 guides, 35 PSP pages, 32 glossary pages
- SEO audit score: improved to 7.5/10 with all critical/high fixes applied
- 350+ content updates executed
Tech Stack
- Node.js with ES modules
- SQLite (better-sqlite3) for data persistence
- Google Search Console API, Google Analytics 4, Google Indexing API
- Caisy CMS (GraphQL) for content management
- DataForSEO API for keyword metrics