Data
AI agent for BigQuery: true ROAS and first-party analysis
TL;DR
The agent reads from BigQuery — running SQL it writes itself from a plain-language question — so you can join Google Ads or DV360 spend with your own GA4, CRM or revenue tables and compute true ROAS from numbers you trust, not platform-reported conversions. It's read-only: the agent queries whatever project and dataset you select in the context picker, and never creates, inserts, updates or deletes a table.
What the agent does with BigQuery
- Writes and runs SQL against your chosen project/dataset from a plain-language question.
- Joins ad-platform cost data (Google Ads, DV360) with your own GA4, CRM or order tables for true, margin-aware ROAS.
- Hands off to the Python sandbox for anything SQL can't express cleanly — cohort/LTV math, custom charts.
Real use cases
| Goal you'd type | What the agent does |
|---|---|
| "Join last month's Google Ads cost with our Shopify order revenue and give me true ROAS per campaign." | Writes the SQL join keyed on campaign/date/order id and returns per-campaign profit-aware ROAS. |
| "What's the 90-day repeat-purchase rate for customers who came from paid search vs. organic?" | Queries your CRM/orders tables joined with attribution data and computes the cohort comparison. |
| "Pull a custom report: spend, impressions and margin by DV360 line item for Q2." | Runs the SQL directly against whatever tables hold that data in your warehouse. |
Guardrails
- Read-only — the agent never runs CREATE, INSERT, UPDATE or DELETE against your warehouse.
- Scoped to the project/dataset you select in the context picker; it doesn't discover or query tables outside that scope.
Frequently asked questions
- Can the agent write to my BigQuery tables?
- No — the connection is read-only. It queries your data and returns results; it never creates, modifies or deletes tables.
- Do I need to know SQL to use this?
- No — describe the question in plain language and the agent writes the SQL. If you already know exactly what query you want, you can also just ask for that directly.
- How is this different from just trusting Google Ads' reported conversions?
- Platform-reported conversions use the platform's own attribution and can miss refunds or offline revenue. Joining spend with your own warehouse data gives you a ROAS number built from what actually happened.