As you’ll probably already be aware, Google Analytics 4 (GA4) provides an fantastic dataset for BigQuery for all your raw user and event level data. This data is super easy to connect to Google cloud platform (GCP). However if you connect your GA4 property to a sandbox mode, the…

1. Why are my conversions attributed differently? Firstly we are looking at two very different tools, UA was set to a specific logic whereas GA4 now takes advantage of advanced AI and machine learning, coupled with a customisable attribution model for conversions. How does universal analytics model attribution? UA allocates create to the last click source and medium. This means whatever the last…

Google recently announced it would be enforcing its GA4 API quota limits, so what does this mean in plain English? On November 10th, the limit for the quotas of the Looker Studio (and in fact any other connector) using GA4 API came into force. This means that if you have…

As more and more people migrate from Universal Analytics to Google Analytics 4, we see more opportunities for people to use BigQuery to build truly enhanced reporting and optimised analytics. However, it is also now more challenging to redact PII via Google Tag Manager which creates more reliance on robust…

As we all know one of the biggest challenges of managing a data warehouse is permission to access data. Often this can be challenging to keep on top off, and even more so when you have specific dataset level permissions. Luckily BigQuery has recently released Data Control Language functionality, which…

Nowadays it’s incredibly easy to upload, store query and edit data, however, how often do we consider the carbon (and other) footprints in doing so. I attended an eye-opening conference hosted by Silicon Brighton which triggered how can I make my warehouses more sustainable. I am not an expert in…

With the onset of Universal Analytics sunsetting, and the fab Google Analytics 4 dataset, there has been a considerable uplift in users needing to set up BigQuery Projects to Stream their BigQuery data. In this post, I will walk you through step by step of setting up a Google Cloud…

Often Google Cloud Platforms billing dashboard suffices to capture and manage how much you are spending on the platform each month. However, this often will not allow you to optimise your spending and won’t show those queries running at the beginning of the month which can be hidden in the…

How often have you taken a peek at a report only to be thrown by really odd figures? This could be down to many reasons, but often if the code has been running well for some time, it’s likely to be the underlying data or dependent tables. Many programmers would…