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 visualiz
Showing 1 - 6 of 6 Posts
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 visua
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
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 dimens
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.
