1 day agoGoogle 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 read
Apr 22BigQuery: 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 read
Apr 20BigQuery: 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 read
Mar 29BigQuery: 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 read
Mar 29BigQuery: 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 read
Mar 28Google 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 read
Mar 5BigQuery: Soundex function and UTMs reducing hardcoding on spelling errorsWorking 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. …Bigquery4 min read
Jan 11How to time-travel with BigQuery and undelete tablesOne 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…Bigquery3 min read
Aug 24, 2021BigQuery – Getting started on the BigQuery Google Analytics 4 and Firebase datasetsWorking 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…Bigquery5 min read
Aug 17, 2021User Acquisition KPI: the good, the bad and the ugly!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…Mobile Apps5 min read