The purpose of this post is to share how you can use BigQuery to create a first-touch attribution model for a Google Analytics 4 property…
This is a quick post to highlight how you can simplify your SQL using the WITH clause. I’ve used this technique a lot lately to…
When working with Google Analytics 4 data in BigQuery, it is common to analyze the first or most recent activity for a user. For example:…
In this post I will explain how to use the Over clause to create a moving average, and provide a tutorial for visualizing COVID-19 cases in your area.
The goal of this post is to share tips and best practices for visualizing your Firebase Analytics data in BigQuery and Data Studio, and give you a few samples to help get started.
Sometimes you have multiple actions with separate event names that share a common parameter. This post will allow you to view how frequently each event occurs by the value of your event parameter.
This post will show you how to create a table that shows multiple different parameters of the same firebase event as dimensions using Data Studio and BigQuery.
The UNNEST operator allows you to run queries that flatten the data into the simple format required by your data visualization tools (such as Data Studio).
At first glance the User ID seems simple enough, but it can get a big complex when you start pulling reports. The purpose of this post is to explain how the User ID is used to generate reports.