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
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
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.
How to Set Up a Google Analytics 4 Property
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
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
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?
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
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
The purpose of conversion modeling is to fill the gaps in your data that are created by cookie restrictions and cross-