Event Calendar

Wednesday, October 26, 2022

Using dbt with the GA4 BigQuery export

Start Date: 10/26/2022 5:30 PM PDT
End Date: 10/26/2022 7:30 PM PDT

Venue Name: Mogo Inc.

2100 - 401 W Georgia St
Floor 21st
Vancouver, AL  Canada  BC V6B 5A1

The most common answer to any “how do you do this in GA4?” question is “to use the BigQuery export!”. However, using the raw data exported to BigQuery can often prove challenging. There is an open-source dbt-GA4 package that creates report-ready tables from the raw BigQuery export and greatly reduces the effort and knowledge required to model BigQuery GA4 data.


In this session, you will learn the following

  • The basics of dbt: what it is and how it works
  • How to set up, configure and utilize the dbt-GA4 package
  • See examples of what can be achieved with the package’s modeled data


Damon Gudaitis

Damon Gudaitis is a core contributor to the dbt-GA4 open source package. Moreover, Damon has successfully deployed it on half-a-dozen websites since the project’s inception (June 2022). In addition, Damon serves as a freelancer with Caret Juice Marketing and handles all BigQuery requirements for analytics agency - Three Ventures Inc.  In his spare time, Damon is tasked as a Chapter Leader for the DAA (Digital Analytics Association) in Vancouver, while serving as the Technical Engineering Officer for the DAA Implementation Task Force.


October 26, 2022 dbt and GA4

5:30 Reception

6:00 Session Start

7:15 Q&A

7:30 Session End