GCP

Elevate your data analytics game with BigQuery
What is BigQuery? What is BigQuery? BigQuery is a powerful data warehousing tool within the Google Cloud Platform designed to…

The life of Brian: Measurelab's generative AI journey
I recently had the pleasure of attending the AI Summit London 24 which was chock full of fascinating talks, opinions…

How to set up an SFTP Server on GCP (for Google Analytics data import)
If you want to automate data import into Google Analytics 4 then (at the time of writing) you will need…
How to debug your SQL in BigQuery
How often have you run your code in BigQuery only to find a bit of data missing that you KNOW…

The Google Cloud tools of the marketing analytics trade
The Google Cloud Platform (GCP) is vast. It is composed of over 100 services which serve purposes across countless industries…

Backing up Universal Analytics data in BigQuery
No point kicking up a fuss about it now, Universal Analytics (UA) is on life support. It still contains all…

Why you should consider Server-Side GTM
Not another migration!? I know, I know, “not another piece of technology for web analytics,” you cry, “I just got…

UPDATE: a six-step framework to server-side GTM migrations
At this point, we are all familiar with Google Tag Manager (GTM), as well as its quirks, workarounds, and nuances.…

Why you should consider Cloud Run for server-side GTM
Here at Measurelab we have built up a good amount of experience in the world of server-side GTM (sGTM) migrations.…

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…