Fix uniqueness test for fct_ga4__pages - Githubissues

Velir / dbt-ga4

dbt Package for modeling raw data exported by Google Analytics 4. BigQuery support, only.

MIT License

289 stars 128 forks source link

Fix uniqueness test for fct_ga4__pages #305

Closed yamotech closed 3 months ago

yamotech commented 3 months ago

Description & motivation

Fix uniqueness test for fct_ga4__pages.

Multiple records can have the same event_date_dt and page_location. Adding stream_id as a condition makes them unique.

Data stream: Lives within a property, and is the source of data from an app or website. The best practice is to use a maximum of 3 data streams per property: 1 single web data stream to measure the web user journey and 1 app data stream each for iOS and Android.

[GA4] Google Analytics account structure - Analytics Help

Checklist

[x] I have verified that these changes work locally
[na] I have updated the README.md (if applicable)
[x] I have added tests & descriptions to my models (and macros if applicable)
[x] I have run dbt test and python -m pytest . to validate existing tests