GA4 BigQuery Query Builder

The GA4 export puts almost everything worth querying inside a nested array, and the difference between a correct query and an expensive wrong one is a few characters. This builds the statement, names how many daily tables it reads, and points at what would otherwise be found out later.

Project

Dataset

From (YYYYMMDD)

To (YYYYMMDD)

Event name (empty = all)

Metric

Break down by

Own event parameter

Its value field