BigQuery for SEOs

Raleigh, North Carolina

Speaker

Sam Torres

Chief Digital Officer, Gray Dot Company

Senior Manager of Technical SEO at Pipedrive. Treats ML as research infrastructure — embeddings, clustering, LLM pipelines — and ships ready-to-run notebooks instead of half-baked prompts.

LinkedIn Open profile

Abstract

BigQuery solves GSC's 16-month limit and Looker Studio sampling problem — at $10/month for most clients. Build aggregate tables, schedule them daily, connect Looker to those.

Suggested takeaways

→10 GB free storage + 1 TB free queries/month = most clients pay <$10/mo
→GSC site-level vs URL-level tables → different aggregation grains
→Aggregate tables (pre-processed daily) save Looker Studio costs
→Scheduled queries auto-refresh aggregates — connect dashboards there
→Start small with the basic SELECT/FROM/WHERE/ORDER BY pattern

My notes

From

Tech SEO Connect 2024 · BigQuery for SEOs

Friday, October 18, 2024 · Sam Torres

Notes coming soon

Field notes will appear here once published. (If this is your notebook, tap Take Notes in the bottom-right to unlock the editor.)

Can GSC Be the Source of SEO Decisions?

8:15 PM

What I Learned From Auditing Over 1,000,000 Websites

9:45 PM