View: Intermediary DRP Table(s): drp.daily_attribution_cpo_cpa

Source Database Table

drp.daily_attribution_cpo_cpa

Script that Populates Database Table

4112_CST_BAS_daily_attribution_cost_per_order.sql

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

 <insert table here-manual>

SQL Flow

Calculated and Derived Fields

 <insert table here-manual>

 

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