Let’s be honest: checking GA4 event parameters in a BigQuery export can be a nightmare. It’s a painful process, especially when you need to quickly scan parameters for a data check or to debug a GTM setup. You’re faced with…
How to filter internal website traffic when a client doesn’t have a static IP address? It’s a common challenge in the world of digital analytics. The answer, thankfully, is simpler than you might think. If you’re not using static IP…
If you’re missing direct custom domain mapping integration via Load Balancer in Cloud Run when deploying server-side GTM, you’re not alone. When you want to host a tagging server on your subdomain, Google recommends using a global external Application Load Balancer.…
Spreadsheets will never die. And as a data analyst or analytics engineer, you should know how to move data from Google Sheets to BigQuery. Maybe a business user refuses to give up their spreadsheets, or you’re working with a small…
Google Ads offers a vast amount of data, but efficiently managing and analyzing this data can be challenging. BigQuery not only helps with analysis but also streamlines data ingestion of Google Ads data. With the latest updates, users now have…
When choosing a deployment method, there are multiple options, each with its benefits and challenges. For example: For my sGTM deployments, I prefer Google Cloud Run. It provides auto-scaling, seamless integration with other Google Cloud services, is cost-efficient, and is…
Are you considering deploying server-side Google Tag Manager (sGTM) and looking for useful information? Many people still have misconceptions about what sGTM is and how it works. Based on the most common questions I’ve received from clients, I’ve put together…
Sometimes, you find a client-side GTM (cGTM) container with multiple conversion tags with similar configurations, like three purchase Google Ads tags for three distinct countries. While this setup might work, it’s far from optimal – especially when you use a…
Marketing on Facebook remains a widespread method for acquiring customers. Our clients have long used Facebook Pixel — a tag in the client-side Google Tag Manager (cGTM) — to track visitors and optimize campaigns. With the transition to server-side tagging,…
If you work with sharded tables like GA4 export to BigQuery, you may encounter a situation where raw or source data needs to be updated across multiple tables. Manually tackling such updates can be tedious and error-prone. How can we…