BigQuery
MeasureFest October 2022: Why GA4 means you need to get on board with BigQuery
This is my first time speaking at any analyics conference, let alone MeasureFest, and I'm looking forward to sharing my…
How to review SQL code in BigQuery for duplication and errors
Sometimes we can spend hours, days or even weeks writing SQL in BigQuery. Hopefully what you have ended up with…
Change your Google Analytics data retention settings
It may be news to some: Google Analytics does not keep all of your data forever. The data storage and…
How to access BigQuery data from server-side GTM (via Firestore)
This solution allows for data, contained within BigQuery to be queried and stored in Firestore where it can then be…
How to set up the GA4 BigQuery export
The act of enabling the export from Google Analytics 4 (GA4) to BigQuery is actually a relatively simple process. However…
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,…
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…
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.…