BigQuery — I’m a little in love with this resource

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 handling dates, unnesting data plus useful syntax which I use daily to help build analysis, reporting and models (all the fun stuff).

So firstly let me introduce you to the Google Analytics 4 eCommerce public dataset which was released last week:

This data contains 92 tables of daily event-based GA4 data —…


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 (and it was a lot). So here is my personal guide to KPIs which I have used in the past to assess the quality of marketing for the app I’ve worked on, and common pitfalls I’ve seen when using these.

User acquisition

AKA digital marketing in the world of web

The vast…


As we all know Google is continuously improving and expanding the Google Cloud Platform and BigQuery has truly benefited from this. Taking a simple scalable data warehouse into what is now a comprehensive and dynamic system. As you may guess, I’m a massive fan of BigQuery.

BigQuery offers a huge amount of functionality including DDL and DML, however, sometimes, there simply isn’t the function to help you complete what you are doing. Often in the past, I would end up accessing BigQuery via Python or SAS and applying the missing function.

However User Defined Functions cover some of the current…


It’s always a challenge making BigQuery DataWarehouses more efficient. So today I want to share with you the joys of DDL and how you can reduce the time it takes to produce tables from your queries. In the past 6 months BigQuery’s DDL and DML functionality has exploded with plenty of new features and massive time savers, which mean less time spent trying to keep your BigQuery warehouse tidy.

So firstly- what even is DDL and why would you even use it?

DDL stands for Data Definition Language and is primarily used to create and modify tables. …

Lace Chantelle Rogers

Lead data specialist, and programming obsessive. Specialising in data team development. Love statistical languages and focusing on the GCP platform on apps.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store