Let’s be honest: checking GA4 event parameters in a BigQuery export can be a nightmare. It’s a painful process, especially when you need to quickly scan parameters for a data check or to debug a GTM setup. You’re faced with a wall of events and parameters, and it only takes a few minutes to get completely lost if you don’t know exactly what you’re looking for.
Because I’ve faced this exact frustration, I created a handy BigQuery Studio Notebook to make my (and your, of course) life easier. This simple tool takes messy event parameters, chooses the “top k” values for every key, and transforms them into a clean, organized HTML file. The output is easy to read, and you can quickly share it with colleagues or client.
How to Get Started
Getting started is straightforward. Just follow these three steps:
- Get the Notebook: Head over to the GitHub repository and either download the file or just copy the notebook’s URL.
- Open BigQuery Studio: Navigate to the “Notebooks” section and click the three dots to select Upload to notebooks.
- Upload: Provide the file or URL you copied and click Upload.
Once the notebook is imported, just set the necessary variables as instructed and run it.
A Quick Heads-Up
- First-Time Users: If this is your first time running a BigQuery Studio Notebook, you’ll need to enable the necessary APIs when prompted.
- Cost: Running notebooks isn’t free. You pay for the queried data and used processing power.
PS: This code is flexible! You should be able to use it in Colab, VS Code, or Jupyter Notebook as well. You’ll just need to install the required libraries and adjust the “Query data” cell to pull your data from BigQuery.