dbt_ga4_export v0.1.0

This is the initial release of the GA4 Export dbt package!

What does this dbt package do?

This package models GA4 Export data from Fivetran's connector. It uses data in the format described by this ERD.

The main focus of the package is to transform the source event table into commonly used GA4 reports. The package includes the following:

Materializes GA4 Export staging and output models which leverage data in the format described by this ERD.
The staging event table cleans, tests, and prepares your GA4 Export data from Fivetran's connector by doing the following:
- Renames fields for consistency and standardization. For example, name is renamed to event_name.
- Adds column-level testing where applicable. For example, all primary keys are tested for uniqueness and non-null values.
- Generates a comprehensive data dictionary of your GA4 Export data through the dbt docs site.
The following GA4 reports are reproduced in this package as titular tables:

Table	GA4 Report
ga4_export__traffic_acquisition_session_source_medium_report	traffic_acquisition_session_source_medium_report
ga4_export__user_acquisition_first_user_source_medium_report	user_acquisition_first_user_source_medium_report
ga4_export__events_report	events_report
ga4_export__conversions_report	conversions_report

For more information, refer to the README.