search

mozilla / bigquery-etl

Bigquery ETL
https://mozilla.github.io/bigquery-etl
Mozilla Public License 2.0
251 stars 98 forks source link

Monitor plus Attribution: Update ETL to store the channel for relevant Bigquery Tables and Looker explore #6014

Open data-sync-user opened 1 month ago

data-sync-user commented 1 month ago

To implement the methodology from  Monitor Plus Attribution Channel Group Categorization proposal, the URL will include the “channel” parameter with other attribution parameters a.k.a. UTM parameters.

The task for this ticket from the proposal would be[ ﹍the requirement 1-d of the Option 1﹍|https://docs.google.com/document/d/1OidUVgldjhZ4BPv3tZAmC0SBiWJT_Ae4h8FuRRyNE1o/edit#bookmark=id.ave0gni5c7eu]: Update the ETL to store the channel for the relevant Bigquery tables and Looker explorers.

Also the custom logic to sort attributions to channels for the attribution data before the proposed method is implemented should be built for the relevant derived table.

┆Issue is synchronized with this Jira Task

data-sync-user commented 1 month ago

➤ Yeonjoo Yoo commented:

cc: Sean Rose Edward Cho Tony Cinotto

data-sync-user commented 1 month ago

➤ Misun Mizener commented:

Moved to DENG and assigned Sean Rose - let me know if I need to reassign!