How-to
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…
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,…
How to force a hit-level segment in Universal Analytics
Note: This how-to is for forcing a hit-level condition within a session-level segment. It is not commonly understood that if…
5 new GA4 features we want Google to introduce in 2022
Let’s talk Google Analytics 4 and what’s in store this year. There are some features missing from GA4 and it's…
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.…
How to enable the GA4/Firebase DebugView for Android apps
Want to know how to enable the GA4/Firebase DebugView for Android apps? Let's take you through the process step-by-step! 1.…
How to write a value to a cookie using GTM
Guide If there is a value stored in a variable (either as a Global JavaScript variable on a webpage or…
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…