BigQuery · Status at source date: Newsletter archive
BigQuery adds multi-level aggregation
Google has added multi-level aggregation to BigQuery SQL, letting you nest one aggregate function inside another in a single query, as flagged by Luka Cempre on the GA4 export. It removes the subquery workarounds analysts used for aggregate-of-aggregate calculations.
Why it matters for advertisers
For you, this means simpler queries over GA4 and other warehouse data, so refactor the reports where nested aggregates were previously awkward.
Perspective from the original PMC newsletter.Sources & contributor credit
- Newsletter coverage · Paid Media Collective newsletter
Original newsletter text, contributor labels and media for this update.
- Source referenced in newsletterLinkedIn
Linked from the original newsletter. The source publication date has not been independently confirmed.
Original creator unverified
The names below are source credits. The original creator and first-reporting priority have not yet been independently verified.
Attribution evidence and limitations
Full attribution review pending.
A source link alone does not establish original authorship.
Original image and video creators have not yet been verified.
- Published on this site
This update reflects the dated source reporting. Availability may have changed. Further coverage of this same development will be added to this page.
Original newsletter text and archive evidence
BigQuery adds multi-level aggregation
Google has added multi-level aggregation to BigQuery SQL, letting you nest one aggregate function inside another in a single query, as flagged by Luka Cempre on the GA4 export. It removes the subquery workarounds analysts used for aggregate-of-aggregate calculations. For you, this means simpler queries over GA4 and other warehouse data, so refactor the reports where nested aggregates were previously awkward.
Source captured . No explicit first-contributor label was provided for this update.
