GSC BigQuery Query Library
Reusable BigQuery patterns for extracting search performance, query/page diagnostics, CTR opportunities, and trend checks from exported Google Search Console data.
SEO engineering scripts, tools, and workflows.
A growing resource hub for practical SEO engineering assets people can reference, adapt, and use across search data analysis, crawl diagnostics, internal linking, and AI crawler workflows.
Resource types
- Query libraries: reusable SQL patterns for search data.
- Visualizers: workflows that make technical SEO systems easier to inspect.
- Analyzers: scripts that turn logs and crawl data into decisions.
Current resources
Internal Link Graph Visualizer
A workflow for turning crawl exports into a link graph that highlights hub pages, orphan risks, depth problems, and internal PageRank flow.
AI Crawler Log Analyzer
A log-analysis framework for separating AI crawler activity from classic search bots and understanding which URLs are being requested by LLM-driven systems.
How to use this collection
- Use each page as a reference brief before adapting the workflow to your stack, data warehouse, crawler, or log format.
- Pair scripts with manual QA so automation supports search decisions instead of replacing judgment.
- Expect the collection to expand as more SEO engineering tools and workflows are documented.