A series that takes you from knowing nothing about BigQuery to running data agents in production. Each guide builds on the one before: BigQuery and SQL, the GA4 export, the views an agent can read, your first agent, verified queries, evaluation, the Data Engineering and Data Science agents, the API, and cost, access, and data quality. Read them in order.
Start here
5 picksA step-by-step series on BigQuery data agents: from your first query to agents you can trust in production, on GA4 data, with Google’s docs and courses.
by David PombarBigQuery from zero: projects, datasets, tables, what a query costs, the free sandbox, and the five kinds of agent Google ships in BigQuery today.
by David PombarThe SQL you need to read and audit what a BigQuery data agent writes: SELECT, WHERE, GROUP BY, JOIN, dates, and UNNEST, practiced on the GA4 sample.
by David PombarHow to turn on the GA4 BigQuery export, how its event tables are built, and the traps that make an agent’s answer differ from what GA4 reports.
by David PombarTurn the raw GA4 export into narrow tables a data agent can read: sessions, purchases, items, and pages, with descriptions written for the agent.
by David PombarLatest
5 posts · newest firstA step-by-step series on BigQuery data agents: from your first query to agents you can trust in production, on GA4 data, with Google’s docs and courses.
by David PombarHow to turn on the GA4 BigQuery export, how its event tables are built, and the traps that make an agent’s answer differ from what GA4 reports.
by David PombarTurn the raw GA4 export into narrow tables a data agent can read: sessions, purchases, items, and pages, with descriptions written for the agent.
by David PombarThe SQL you need to read and audit what a BigQuery data agent writes: SELECT, WHERE, GROUP BY, JOIN, dates, and UNNEST, practiced on the GA4 sample.
by David PombarBigQuery from zero: projects, datasets, tables, what a query costs, the free sandbox, and the five kinds of agent Google ships in BigQuery today.
by David PombarTrackingplan
Your implementations audited around the clock with real-time, real-user data. Real-time alerts about errors or changes in your data, campaigns, pixels, privacy and consent. Let AI flag issues before they cost you.