Skip to main content

Overview

Here you will find the high level overview of this project.

First and foremost, this project is based off of the dbt GA4 Package by Velir, but has been modified and refactored for internal purposes. This project uses Google Analytics 4 BigQuery Exports as its source data, and offers useful base transformations to provide report-ready dimension & fact models that can be used for reporting purposes, blending with other data, and/or feature engineering for ML models.

Find more info about Google Analytics 4 BigQuery Exports here.

Features Overview​

  • Four final tables (ga4__events, ga4__pages, ga4__sesssions, and ga4__users) that are completed unnested to be wide & denomalized for easy querying by the end-user.
  • Conversion of the the day-shared events_YYYYMMDD & events_intraday_YYYYMMDD tables into singular date-partitionioned incremental base models.
  • Dynamically flattens event_params into their own individual columns.
  • Dynamically flattens user_props into their own individual columns.
  • Dynamically extracts & flattens URL query_params (e.g., gclid, fbclid, _ga) into their own individual columns.
  • Custom Variables. See here for more info.
  • Custom Marcros. See here for more info.