Automate Keyword Clustering at Scale: From a Raw Export to Content Topics with Embeddings + HDBSCAN
A working Python + n8n pipeline that groups thousands of keywords into content topics by intent using embeddings, UMAP and HDBSCAN.
-
-
The Hidden Signature That Triggers Google’s Helpful Content Penalty (And It’s Not What You Think)
A 1,200-post site lost 99.6% of its traffic in a single day despite averaging 1,250+ words per post. The reason is not depth — it is signature similarity at scale. Here is what Google’s classifier is actually reading.
-
Build an MCP Server for Google Search Console: Give Claude Live SEO Data Access
Stop writing a new script for every SEO question. Build a Model Context Protocol (MCP) server that exposes Google Search Console as tools an agent can drive live — with working Python code.
-
SEO Regression Testing in CI/CD: Block Bad SEO Before It Ships
Build an automated SEO regression testing pipeline in GitHub Actions that crawls a preview deployment, asserts SEO invariants with pytest, and fails the build before titles, canonicals, robots directives, or schema break in production.
-
Scraping Backbone Teardown: Bright Data vs Apify vs ScraperAPI for SEO Data Pipelines
Which scraping backbone should power your SEO data pipeline? A production teardown of Bright Data, Apify, and ScraperAPI across SERP collection, competitor crawling, and structured extraction — with code, failure modes, and a cost-per-record model.
-
Programmatic SEO at Scale: Build a 1,000-Page pSEO Pipeline with n8n, Python and Automated Schema
A production programmatic SEO pipeline in n8n + Python: enrichment that creates uniqueness, a quality gate that refuses thin pages, per-page JSON-LD, and an indexing controller that lifted indexation from 30% to 88%.
-
Reverse-Engineering a Competitor’s Programmatic SEO Setup: A Python Teardown of Sitemaps, Templates, and Internal Link Graphs
Treat a competitor’s programmatic SEO site as a black box and take it apart with Python: map the URL footprint from sitemaps, fingerprint the template, reconstruct the internal link graph, and estimate what actually ranks.
-
Detect Content Cannibalization at Scale with Vector Embeddings: A Python and n8n Pipeline
Spreadsheets break past a few hundred URLs. Use OpenAI embeddings, Search Console overlap, and an n8n workflow to flag cannibalization across thousands of pages, score severity, and pre-classify each pair as merge, differentiate, or canonical.
-
Generative Engine Optimization (GEO): A Practitioner’s Playbook for Getting Cited by ChatGPT and AI Overviews
A working playbook for getting cited by ChatGPT, Perplexity, and Google AI Overviews — structural patterns that win, plus a five-job automation stack you can ship this week.
-
Content Decay Detection at Scale: Build an Automated GSC + Python + n8n Pipeline That Flags Pages Losing Traffic
Stop losing rankings silently. A Python + n8n pipeline that pulls 16 months of GSC data, scores every URL for decay, and files refresh tickets weekly with a closed-loop verification step.
