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
Insights & Updates
Blog
Insights on marketing analytics, data strategy, and performance optimization from the DiveTeam experts.
Showing 1 - 12 of 41 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>
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
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
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
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
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
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-