Sessionize GA4 BQ Data Using Cloud Dataform

Photo by Sergio Capuzzimati on Unsplash

In this blog post, I’ll guide you through the installation of a GA4 Dataform solution. This particular solution focuses on building last non-direct session and event attribution for Google Analytics 4 (GA4) BigQuery exports.

What is GA4 Dataform?

GA4 Dataform is a Dataform project offering pre-built SQL data models. These models simplify the process of transforming raw GA4 data within BigQuery into more usable tables (e.g., sessions, events, and others). It’s a fantastic foundation if you’re aiming to develop your own custom attribution model leveraging GA4 data.

Deploy GA4 Dataform

One way you could deploy GA4 Dataform is by connecting it to your own GitHub repository.

Prerequisites

• A Google Cloud Project with an active billing account.
• A BigQuery table containing your GA4 data exports.

1- Clone the GA4 Dataform Repository

Fork or clone the GA4 Dataform repository into your own GitHub account.Repository to clone: https://github.com/google-marketing-solutions/ga4_dataform

2- Create or use an existing Google Cloud Project