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.