Blog

Measured results and the arguments behind them. Two kinds of writing: what I found when I measured something, and what I think it means.

Writing

  1. Case studies

    Case study: an SEO data warehouse in BigQuery built from five sources (B2B SaaS)

    Five SEO data sources (GA4, Search Console, Bing, Clarity, Screaming Frog) in one BigQuery table, and three findings no single tool showed on its own.

    Own measurement, five sources in BigQuery, 30 days.

  2. Case studies

    Case study: WordPress to Astro and Cloudflare Workers — crawling, response time and indexing after the move

    411 → 129 msGooglebot response time

    kk.coach moved from WordPress to static Astro pages on Cloudflare Workers. Googlebot sent 136 requests on launch day, response time fell from 411 to 129 ms, and 37 of 40 sitemap URLs reached search in 24 days.

    Own measurement · kk.coach · Google Search Console (Crawl stats, Page indexing, Performance) · July 24 – October 21, 2026.

  3. Case studies

    Case study: SEO for an agricultural ecommerce catalog of 10,000+ products

    +38%Google impressions, October year over year

    SEO for a 10,000+ product store on ShopRenter: category structure, content, two-week sprints, and 38% more impressions in October than a year earlier.

    Own measurement, Google Search Console and GA4, June 2025 – October 2026.

  4. Case studies

    Case study: AI search and a 14% drop in organic clicks (B2B SaaS)

    −14%organic clicks, rankings unchanged

    A B2B SaaS site kept its impressions and its positions, and lost 14% of its clicks over six months. What that changed about which pages are worth improving.

    Own measurement · Search Console + Bing Webmaster Tools, six-month window · anonymized client project

  5. Case studies

    Case study: site speed and conversion rate in an ecommerce store

    r = −0.81load time vs. conversion rate

    An ecommerce store where load time and conversion rate correlated at −0.81 — strong enough to move speed out of the backlog and into the revenue conversation.

    Own measurement · GA4 → BigQuery, mobile sessions, anonymized client project

  6. Perspective

    Building your own SERP tracker: what it costs and when it’s worth it

    Most SEO platforms are priced like a toolbox when the job needs one screwdriver. What it cost to build a focused rank tracker instead, and who shouldn’t.

  7. Perspective

    How AI search changes the B2B buyer journey

    B2B companies notice AI search as lost clicks. The bigger change is that the early part of the buying process now happens somewhere you can’t measure.

Next step

Want this run on your own numbers?

Reading about a method is one thing. If you’d rather see it applied to your site, send me your URL and one sentence about what isn’t working.

Let’s talk