4112_CST_BAS_daily_attribution_cost_per_order Transformation

Target Database Table

drp.daily_attribution_cpo_cpa.

Script Description and Logic

Summarizes Order Channel and Order Status by date to determine the number of orders and first orders for each channel/vendor combination. It then merges the order and first order count with the marketing spend to calculate the CPO and CPA. number of orders and first orders for each channel/vendor combination. It then merges the order and first order count with the marketing spend to calculate the CPO and CPA.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab,

4112_CST_BAS_daily_attribution_cost_per_order Transformation

Calculated and Derived Fields

Coming soon.

All content © Daasity 2021. Do not copy, share or distribute.