How to use BigQuery without GA360: insights from Measurefest 2019

Adam Englebright•12 September 2019•1 min read

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

Suggested content

Measurelab awarded Google Cloud Marketing Analytics Specialisation

At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s biggest consultancies by September, we would've been surprised. Not because we don't believe in ourselves, but because these things feel so distant - until suddenly, they’re not. So, here it is: we’ve been awarded the Marketing Analytics Services Partner Specialisation in Google Cloud Partner Advantage. What’s the big deal? In Google’s own words (with the obligatory Zs): “Spec

Will Hayes•11 Sept 2025

BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights

BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation: your analytics data and generative AI are now best friends, and they’re hanging out right inside SQL. That opens up a whole world of new analysis options for GA4 data, but it also raises some questions: * How do you actually set it up? * What’s it good for (and when should you avoid it)? * Why would you batch the query? Let’s walk through it step by step. Step 1: H

Katie Kaczmarek•3 Sept 2025

How to start forecasting in BigQuery with zero training

If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t

Katie Kaczmarek•14 Jul 2025