How to use BigQuery without GA360: insights from Measurefest 2019

Adam Englebright•12 September 2019•1 min read
How to use BigQuery without GA360: insights from Measurefest 2019

Speaking at Measurefest

For the first time in a few years, I took to the stage at Measurefest to talk about how to get your data from Google Analytics into BigQuery, and what you can do with it when you get there.

Affordable BigQuery solutions

Obviously, Analytics 360 can do this, but it costs $$$ per year. I outlined some more affordable methods, including third-party connector solutions, and provided a detailed example of how we would use our own Pipelines solution and what we could achieve with it. Sadly, unlike last time, there wasn't a central Garfield-based metaphor—Calvin and Hobbes put in several appearances, but as visual flair only.

Speaker presenting about BigQuery Without Analytics 360 at a Measurefest conference

The impact of App + Web

I ended the talk with a brief overview of the changes that App + Web will bring to the analytics landscape - both in general and specifically pertaining to this question (since Firebase plugs into BigQuery directly, it changes the game somewhat!) - Mark has talked more about that here.

Slides and next steps

My slides are below, and if you're interested in talking more about our pipeline solutions, App + Web or BigQuery/Google Cloud services, please get in touch!

https://www.slideshare.net/AdamEnglebright/bigquery-without-analytics-360-measurefest-2019-adam-englebright/edit?src=slideview&type=privacy

Need help with your data platform?

We build intelligence platforms on BigQuery, Dataform and Google Cloud - from setup to ongoing optimisation.

See how we can help

How ready is your data?

Take our short assessment to find out where your data stack stands and what to prioritise next.

Take the assessment

Suggested content

BigQuery Tips: When your query is technically correct but BigQuery won't run it

There is a particular kind of frustration that comes from staring at a query you know is correct and watching it fail. No syntax error. No logic problem. Just a wall. We hit two of them on the same project. What we were building The job was to migrate ga4_daily_snapshot for a large enterprise client from a BigQuery scheduled query into a proper Dataform pipeline. The scheduled query had been added to over time until it was too large to maintain with any confidence. Moving it to Dataform w

Katie Kaczmarek•17 Aug 2026

BigQuery Tips: The subquery in your WHERE clause that's scanning your entire table

There is a pattern that appears in a lot of BigQuery pipelines and looks completely reasonable. You have a control table that stores the latest processed date. Rather than hardcoding a date into your query, you pull it dynamically: SELECT * FROM `project.dataset.events` WHERE event_date = ( SELECT latest FROM `project.dataset.control_table` ); The query returns the right results. The logic is clean. And if your events table is large and date-partitioned, you might be scanning the entire

Katie Kaczmarek•13 Aug 2026

BigQuery Tips: Arrays in BigQuery - what they are and how to get data out of them

If you have ever opened a GA4 export in BigQuery for the first time and found yourself looking at a column called event_params that seemed to contain an entire table inside each row, this post is for you. Arrays are not trying to make your life harder. Once you understand why they exist and what to do with them, they stop being intimidating. Why BigQuery uses arrays GA4 tracks events. Each event can have many parameters. A purchase event might have a transaction ID, a value, a currency an

Katie Kaczmarek•10 Aug 2026