How to Use Window Functions to Create a Moving Average in BigQuery
<p class="" style="white-space:pre-wrap;">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
<p class="" style="white-space:pre-wrap;">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
<p class="" style="white-space:pre-wrap;">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
<p class="" style="white-space:pre-wrap;">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
<p class="" style="white-space:pre-wrap;">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
<p class="" style="white-space:pre-wrap;">This post will show you how to analyze the first or most recent activity for a user.</p>