Channel Attribution Data Mart Code
This page provides information on the transform code block that is needed to create Channel Attribution Data Mart and what should be added to a Script Manifest file in order to execute the code
Last updated
This page provides information on the transform code block that is needed to create Channel Attribution Data Mart and what should be added to a Script Manifest file in order to execute the code
Last updated
This data mart and code block is dependent on the following data marts being updated in order to update with new data:
UOS
UTS
The proper sequence of either a Workflow or position in a Script Manifest file to populate this Data Mart is highlighted in the page
The following code should be added in the Script Manifest file
Implement all of the Staging and Attribution blocks to create the following tables:
[dm_chn.dim_order_attribution_detail]
[dm_chn.dim_order_attribution]
Add the Enquire block if you have the Fairing extractor installed and want to incorproate survey based data into your attribution
Enable this code if you need to reset the order attribution:
Create the final Order Channel tables
Determine the orders and channel for each of the attribution methods:
Add self-reported (survey) attribution if Fairing is enabled as an extractor
Build the final attribution tables