Nov 27, 2022Member-onlyGA4: Why are my Looker Studio dashboards broken?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…Google Analytics3 min readGoogle Analytics3 min read
Oct 3, 2022Member-onlyBigQuery and GA4: how to redact parameters in codeAs 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…Bigquery4 min readBigquery4 min read
Jun 29, 2022BigQuery: Easily manage dataset access permissions with DCLAs 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…Bigquery3 min readBigquery3 min read
Jun 11, 2022BigQuery: A greener way to warehouseNowadays 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…6 min read6 min read
May 19, 2022Google Analytics and BigQuery: setting up your projectWith 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. …Google Cloud Platform7 min readGoogle Cloud Platform7 min read
Apr 22, 2022BigQuery: Using Audit logs to assess your consumptionOften Google Cloud Platforms billing dashboard suffices to capture and manage how much you are spending on the platform each month. …Google Cloud Platform5 min readGoogle Cloud Platform5 min read
Apr 20, 2022BigQuery: Asserting your data is viable for your codeHow 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…Bigquery3 min readBigquery3 min read
Mar 29, 2022BigQuery: Importing your data with SQL from Google cloud and drive storageHow often have you been asked to upload a google sheet or CSV into BigQuery, especially for a sheet which updates regularly? …Bigquery3 min readBigquery3 min read
Mar 29, 2022BigQuery: The art of unnesting google analytics 4 event parametersWhen you first catch a glimpse of the BigQuery Google Analytics or Firebase BigQuery tables, you may be instantly taken aback by the structure of these. Fear not, the data is nested (arrayed) and is incredibly powerful in storing huge volumes of data in a highly accessible format. Once you…Google Cloud Platform4 min readGoogle Cloud Platform4 min read
Mar 28, 2022Google BigQuery automation and Google Analytics 4 daily filesAs you may already know, Firebase and Google Analytics 4 both have a great feature in that they provide the daily event data in BigQuery tables. If you have selected the streaming option you will see an intraday table for today, and stacked daily event tables. …Bigquery5 min readBigquery5 min read
