Velir / dbt-ga4

dbt Package for modeling raw data exported by Google Analytics 4. BigQuery support, only.
MIT License
312 stars 134 forks source link

Default Channel Grouping definition mismatches #212

Closed ryan-systematik closed 1 year ago

ryan-systematik commented 1 year ago

This issue is to list all of the mismatches between the channel definitions in this package and GA4 and create a place for discussing any fixes. I'll keep this post as a list of issues and reserve any discussion for the comments.

Channels for Google Ads traffic

All (nt): What field is "Source platform" Paid Sopping (nt): What field is "Google Ads campaign type"? Paid Search, Paid Video, Display, Cross-network Paid Social (nt): What field is "Google Ads network type"

Channels for Display & Video 360 traffic

All (nt): What fields are "Source platform" and "DV360 creative format"?

Channels for Search Ads 360

All (nt): What fields are "Source platform" and "SA360 engine account type"?

Channels for Merchant Center traffic

Organic Shopping (nt): What field is "Source platform"

Channels for manual traffic

Cross-network (nt): Is "Campaign Name" utm_campaign? Paid Shopping (mm): Google assigns all traffic from Paid Shopping sites to this category we only assign traffic from those sites that also have a paid medium. Organic Shopping (mm): No "Campaign name" condition in package definition