search

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

Set "Direct" instead "(none)" for last_non_direct_default_channel_grouping #300

Closed ageofneil closed 4 months ago

ageofneil commented 4 months ago

I customized my package significantly, but "(none)" was displayed instead of "Direct" for last_non_direct_default_channel_grouping on my end.

The solution I implemented was to update stg_ga4__sessions_traffic_sources_last_non_direct_daily.sql. I changed:

coalesce(last_non_direct_source.session_default_channel_grouping, '(none)') as last_non_direct_default_channel_grouping

To:

coalesce(last_non_direct_source.session_default_channel_grouping, 'Direct') as last_non_direct_default_channel_grouping.

adamribaudo-velir commented 4 months ago

Great catch! I'll update that now.