BigQuery

The GA4 data map

How to build an interactive GA4 BigQuery data schema

What and why? One of the great features of Google Analytics 4 (GA4) is the ability to pass data into…
The GA4 data map

GA4 BigQuery export schema

I've always found the GA360 interactive schema from E-Nor (now Merkle - Cardinal Path) by Justin Marciszewski to be a…

How to use the BigQuery Data Transfer Service for Google Ads

The BigQuery Data Transfer Service is a tool the GCP provides to automate data movement into BigQuery on a scheduled,…
Measurefest presentation

Keep up! - the ultimate analytics resource round-up

Over the years, I’ve stumbled across (and regularly returned to) a number of invaluable resources that help me keep up-to-date…
Reducing BigQuery processing costs

How to reduce the cost of BigQuery data processing

Every Google BigQuery code you run costs money – the amount you pay can vary hugely based on different factors.…
Export GA4 data to BigQuery

10 reasons to export your GA4 data to BigQuery

At Measurelab we love BigQuery and Google Analytics. It’s our ‘thing’. We're continually looking at ways to use these tools…

How to flatten tables with user-defined functions in BigQuery

As we all know Google is continuously improving and expanding the Google Cloud Platform and BigQuery has truly benefited from…

How to share access to a single BigQuery dataset with GCP IAM

At Measurelab we’ve heard some horror stories about the deletion of critical datasets. Even though Google BigQuery has the BigQuery…
Streaming to Google BigQuery

How data moves between Google Analytics 4, BigQuery and Data Studio

Over the last year or so I have been getting myself familiar with Google Analytics 4 (GA4 - previously App+Web),…

Data warehousing: What is BigQuery and how do I get started?

At Measurelab we live and breathe the Google Cloud Platform, so our specialists are experts in Bigquery. We have decided…