Python, analytics, experiments, and repeatable workflows for better decisions.
17 field notes · Page 1 of 2
Keyword clustering is the step where keyword research becomes content strategy. Without clustering, you have a list of keywords. With it, you have a content architecture that maps…
Read the field note ↗Screaming Frog, Sitebulb, and DeepCrawl are excellent tools for standard audits. They are not excellent for custom signal extraction, real-time crawl integration with BigQuery…
Read the field note ↗The Google Search Console UI is a toy for the scale of analysis that actually drives decisions. 16-month data retention, 1,000-row export limits, no cross-property queries, no JOIN…
Read the field note ↗No anomalies detected.
Read the field note ↗SEO forecasting has a credibility problem. Projections delivered to stakeholders are routinely either wildly optimistic (because they were built to justify budget) or uselessly…
Read the field note ↗Published: April 29, 2026 · Reading time: ~18 min · Audience: senior SEOs, data scientists, technical strategists
Read the field note ↗Rankings are a vanity metric until they're tied to dollars. In 2026, no CFO or board member signs off on an expanded SEO budget because a brand moved from position 8 to position 4…
Read the field note ↗Published 19 May 2026 · Andrii · ~3,100 words
Read the field note ↗Published 19 May 2026. I maintain seven production Looker Studio dashboards connected to GA4 BigQuery exports. Five of them broke partially or completely in 2025 due to schema…
Read the field note ↗I've rebuilt this thing three times. First rebuild was in late Q3 2024 when our GA4 BigQuery export started producing session-scoped rows that didn't join cleanly to GSC click data.…
Read the field note ↗After rebuilding every n8n SEO workflow for AI-agent compatibility in early 2026, here are the 9 that actually survived and why 14 others got killed.
Read the field note ↗A frank audit of my personal Python SEO toolkit after LLM APIs dropped to near-zero cost: what I retired, what I kept, and what I rebuilt from scratch.
Read the field note ↗Get a focused SEO audit or a consultation on your next technical decision. We’ll agree on the scope and fee before any work begins.
