GA4 BigQuery export analysis, queried for you
Tracking Whisper connects to a BigQuery dataset you pick, read only. It lists the tables and runs queries on the GA4 BigQuery export to answer questions the standard reports cannot, such as paths, raw event parameters and exact deduplication checks. Query costs are billed by Google to the project.
What it can answer
The raw export holds every event with all its parameters. Questions that GA4's reports round, sample or leave out can be answered row by row.
- Exact counts of duplicate transaction ids
- Event parameters that never reached the GA4 interface
- Funnels and paths across sessions
How it queries the GA4 BigQuery export
The agent first lists the tables of the dataset. Daily tables are folded into one line with their date span, so a GA4 export shows as events_* and events_intraday_*. It then writes one standard SQL SELECT at a time, filtered on the dates it needs.
- Read-only SELECT statements only
- Each query tried dry first
- Refused if it would read more than 2 GB
- At most 200 rows back per query
GA4 analysis on raw events
Ask the question in your own words, and the agent writes the SQL, runs it and explains the result. It shows the query it ran, so an analyst on your team can check it or run it again.
- How many purchases share a transaction ID
- Which pages come before a lead form
- What a parameter held on the events of one day
Cost and safety
Queries are read only and run in your project. Google bills BigQuery queries to that project, which is why the agent keeps them small and shows what it ran.
The streaming export in monitoring
In the week after a container change, monitoring looks every quarter of an hour at whether the busy events still arrive. An owner or admin can pick the dataset's streaming export as the source of that look. Its queries are fixed, tried dry first and held to 1 GB, and GA4's realtime report is asked too before anything counts as missing.
Which plan reads BigQuery
BigQuery is part of the All data package, together with GA4, Google Ads, Meta, Search Console, Google Sheets and the files you upload. The agent can then join what the export shows with what the other sources report.
Questions
Does it write to my dataset?
No. BigQuery is read only.
Does it switch on the GA4 BigQuery export?
No. It reads a dataset that exists. The export is linked in GA4's admin by someone with the right access to the property and the Google Cloud project.
What does a query cost?
Google bills each query to your project by the data it reads. Every query is tried dry first and refused if it would read more than 2 GB, and the agent filters on the dates it needs.
Can it read other datasets in the project?
The agent works in the dataset picked for the client. It lists that dataset's tables and runs its queries there.
What happens when a query would be too large?
It is refused before it runs, so it reads nothing and costs nothing. The agent can then narrow the dates or the columns and try again.
Do I need BigQuery for GA4 analysis?
No. Most questions are answered from GA4's own reports. BigQuery helps when you need raw events, exact counts or paths across sessions.