No image
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
Search
No image
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
No image
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
No image
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
No image
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
No image
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>
No image
How to Set Up a Google Analytics 4 Property
<p class="" style="white-space:pre-wrap;">To get started with Google Analytics 4 you’ll want to create a new Google Analytics property, and then set up data str
No image
How to Set Custom Dimensions and Metrics in Google Analytics 4
<p class="" style="white-space:pre-wrap;">In this post we will discuss how custom definitions have changed in Google Analytics 4, and review the steps to set th
No image
Goals vs. Conversion Events in Google Analytics
<p class="" style="white-space:pre-wrap;">Goals and conversion events are both used for the same purpose: to track when users take the actions that are importan
No image
Where did Bounce Rate go in Google Analytics 4?
<p class="" style="white-space:pre-wrap;">This post will give you the information you need to transition away from Bounce Rate to the new engagement metrics tha
No image
Translating Website Tags from Universal Analytics to Google Analytics 4
<p class="" style="white-space:pre-wrap;">This post will provide tips on how to map your existing Universal Analytics tags to Google Analytics 4 using either gt
No image
How Conversions are Modeled in Google Analytics 4
<p class="" style="white-space:pre-wrap;">The purpose of conversion modeling is to fill the gaps in your data that are created by cookie restrictions and cross-