Practical guides on Google Search Console, BigQuery, and SEO data analysis.
Remove the 1,000-row cap and get unlimited keyword access. A complete step-by-step guide to setting up the GSC bulk data export, including IAM permissions, table schemas, and the mistakes that trip people up.
BigQuery cost controls are off by default. Learn how to implement five layers of protection — maximum bytes billed, custom daily quotas, budget alerts, partitioning, and dry runs — before a runaway query wrecks your budget.
Google Search Console deletes keyword data after 16 months, permanently and without warning. Here is how to preserve your entire keyword history using BigQuery, what you lose if you wait, and how to analyse it once it is safe.
Position #1 CTR dropped from 28% in 2024 to 19% in 2025. The benchmarks most people use are out of date. Here are the current click-through rates by position, what SERP features do to those numbers, and how to read your own data against them.
There are five distinct causes of high impressions with near-zero clicks in GSC, and each requires a different fix. Most guides treat them all the same — which is why most efforts to improve this don't work.
Most CTR advice focuses only on title tags. There are six levers — and some of the others have higher ROI. A systematic guide to title tags, URL structure, meta descriptions, schema markup, featured snippets, and AI Overview citation.
Most CTR drops in 2025 have nothing to do with your snippet quality. AI Overviews, the 50-week GSC impression bug, and zero-click search growth are the three structural causes to rule out before touching your title tags.
Page 2 keywords already have Google's trust signal. A keyword at position 15 with 5,000 monthly impressions generates 32 clicks. At position 3, those same impressions produce 510 clicks. Here is how to find and prioritize them.