The Analyst’s Guide to GA4 [Google Analytics 4]
If you’re an Analyst ramping up on GA4, this guide is for you.
BigQuery + GA4: How To Get the First or Most Recent Event for a User
This post will show you how to analyze the first or most recent activity for a user.
How to Use Window Functions to Create a Moving Average in BigQuery
In this post I will explain how to use the Over clause to create a moving average, and provide a tutorial for visualizing COVID-19 cases in your area.
How to Flatten a BigQuery Table with UNNEST
The UNNEST operator allows you to run queries that flatten the data into the simple format required by your data visualization tools (including Looker Studio).
Looker Studio + BigQuery + GA4: How to View Multiple Parameters on the Same Event
This post will show you how to create a table that shows multiple different parameters of the same GA4 event as dimensions using Looker Studio and BigQuery.
Looker Studio + BigQuery + GA4: Viewing a Parameter Across Multiple Events
Sometimes you have multiple actions with separate event names that share a common parameter. This post will allow you to view how frequently each event occurs by the value of your event parameter.
Using BigQuery and Looker Studio with Google Analytics 4
The goal of this post is to share tips and best practices for visualizing your Google Analytics 4 data in BigQuery and Looker Studio, and give you a few samples to help get started.