Open Source DBT Model

GA4 MetricsDBT Model Template

Free, open-source DBT models for transforming GA4 BigQuery export data into actionable metrics. Available for instant download on GitHub.

Download Now Documentation

15 min

Setup Time

50+

Metrics Available

Free

Cost

Key Features

Pre-built GA4 metrics
BigQuery optimization
Open source code
Community supported

Open Source

MIT licensed. Free to use in commercial projects. Contribute back to the community.

Common GA4 Data Challenges

Why working with raw GA4 BigQuery export data is difficult

Complex Raw Data

GA4 BigQuery export data is nested and hard to query directly

Impact: Hours spent writing and debugging SQL queries

Solution: Pre-built, tested data models that flatten and organize the data

Performance Issues

Inefficient queries lead to high BigQuery costs

Impact: Increased processing costs and slow query response times

Solution: Optimized models with proper partitioning and clustering

Inconsistent Metrics

Different teams calculate metrics differently

Impact: Misaligned reporting and decision making

Solution: Standardized metrics definitions across your organization

Maintenance Burden

Keeping up with GA4 schema changes is time-consuming

Impact: Broken queries and outdated metrics

Solution: Community-maintained models that adapt to GA4 updates

Key Benefits

Transform raw GA4 data into actionable insights faster

Instant Value

Start analyzing GA4 data in minutes, not weeks

Pre-built metrics
Ready-to-use models
Tested SQL logic
Immediate insights

Time Savings

Focus on insights instead of data preparation

Automated processing
Optimized queries
Efficient transforms
Quick deployment

Enterprise Ready

Production-grade data models for any scale

Performance tested
Modular design
Easy customization
Scalable architecture

Available Metrics

Comprehensive GA4 metrics and analytics capabilities powered by dbt

Traffic Metrics

Daily Unique Visitors
Monthly Unique Visitors
Quarterly Averages
Year-over-Year Comparisons
Source Channel Attribution
Spot Value Analysis

Session Analytics

Session Length
First/Last Host URL
Referrer Host
Visitor Source Channel
Page Views Analysis
Events Tracking

Conversion Metrics

Conversion Tracking
Source Channel Performance
Monthly Conversion Rates
Quarterly Conversion Averages
Year-over-Year Conversion
First-touch Attribution

Installation Guide

Get your GA4 metrics pipeline running in minutes

1. Install the Package

packages:
  - package: Datomni/ga4_metrics
    version: ">=0.1.0"

Add this to your packages.yml and run dbt deps

2. Configure Database Settings

vars:
    ga4_schema: analytics
    ga4_database: your_database_name
    ga4_events_tbl: "events_*"
    timezone: "UTC"

Optional: Customize your database settings in dbt_project.yml

3. Configure Traffic Sources

vars:
    conversion_event: "free_trial_initiated"
    traffic_source_medium_types: {
        'organic': [ 'organic' ],
        'paid': [ 'cpc', '(none)' ],
        'referral': [ 'referral' ]
    }

Optional: Define your conversion events and traffic sources