Skip to main content

Blog

How to use BigQuery without GA360: insights from Measurefest 2019

Adam Englebright12 September 20191 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

Need to connect your data?

Join marketing, customer and product data with tested models and documentation your team can use. Start with the sources needed for your question.

Have a question or project in mind?

Bring data to connect, a question to investigate or something to fix or build. We can agree a focused scope directly.

Suggested content

Blog

How to make an AI agent accurate in BigQuery

A year ago, I wrote about getting a BigQuery warehouse ready for AI ( Easy ways to prepare your BigQuery warehouse for AI) , but didn't look properly into Knowledge Catalog (known as Dataplex at the time). We decided to go back and look through Google's Knowledge Catalog properly: what's actually in there, how it works and what it relates to. What Knowledge Catalog is Knowledge Catalog is Google's metadata layer for BigQuery data (and a few other sources). It sits alongside your tables rather

Katie Kaczmarek15 Sept 2026

Blog

What's actually in Google's Knowledge Catalog

Google's Knowledge Catalog has been renamed four times. Data Catalog, then Dataplex Catalog, then BigQuery universal catalog, then Dataplex Universal Catalog, and now Knowledge Catalog, as of 10 April 2026. The API, gcloud and IAM roles still all say "dataplex". If you land on a page that mentions Dataplex and wonder whether you're reading something out of date, you're probably not. That's just the product's fifth name in four years. I spent some time looking through the different sections of K

Katie Kaczmarek15 Sept 2026

Blog

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 Kaczmarek17 Aug 2026