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
Workflows
Upstream Data Mart Dependencies
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 Transform Code Sequence - Data Mart page
Script Manifest File (YML)
Transformation Code Requirements
The following code should be added in the Script Manifest file
Order Channel
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
Order Channel Staging
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:
Fairing Order Attribution
Add self-reported (survey) attribution if Fairing is enabled as an extractor
Order Attribution
Build the final attribution tables
Last updated