Often Google Cloud Platforms billing dashboard suffices to capture and manage how much you are spending on the platform each month. …

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…

How often have you been asked to upload a google sheet or CSV into BigQuery, especially for a sheet which updates regularly? …

When 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…

As 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. …

Working with marketing data from Google Analytics is a fab way of assessing your digital marketing performance very quickly, but how often have you come across issues with spellings or deviations of source and medium names. …

One of my favourite things is working on data warehouses using BigQuery; in fact, BigQuery provides a wealth of tools to automate and process data to build a robust ETL. As you may know, BigQuery has some super powerful features, which allow us to build, manipulate and even run machine…

Working with apps and marketing data, you can imagine I spend a huge amount of time working with the GA4 (also known as the Firebase) data streams. This has helped me build up an itinerary of tips and tricks when…

Working as a data specialist with an app development background in mobile games, I have seen the good the bad and the ugly of tracking KPIs on user acquisition- including once being asked to calculate a KPI based on how many Olympic swimming pools could be filled by potions popped…