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 - 8 of 8 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
Cross-Stream First-Touch Attribution with Google Analytics 4 and BigQuery
This post will share how you can use BigQuery to create a first-touch attribution model in Google Analytics 4 that cro
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.
Mastering BigQuery Access Management
This video series will teach you everything you need to know about managing access to the data you have stored in BigQ
Integrating BigQuery with Google Analytics
This post will guide you through the process of integrating a Firebase Analytics project with Google’s fully managed d