GCP

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…

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…