Back to SEO Week 2026
Sam Torres

Photo · seoweek.org

Speaker Profile

Sam Torres

Sr Mgr Tech SEO

Pipedrive

The Ecosystem2 talks

About

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.

Talks · 2

talkTech SEO Connect 2024· Friday, October 18, 2024· Raleigh

BigQuery for SEOs

9:00 PM9:45 PM · Tech SEO Connect 2024

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.

  • 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