Description
Contains marketing ad platform reported orders, revenue, spend, CPO, ROAS. Also aggregates marketing spend from BSD.
Common Use Cases
- Show difference from ad platform reported performance, first click performance and last click performance.
- Total CPO, CPA, ROAS by vendor.
Views
View | Cardinality | Relationship | Join |
---|---|---|---|
marketing_performance | - | self | - |
master_spend | left_outer | one_to_one | ${marketing_performance.id} = ${master_spend.id} |
retail_calendar | left_outer | many_to_one | ${marketing_performance.activity_date} = ${retail_calendar.calendar_date} |
Flow
All content © Daasity 2021. Do not copy, share or distribute.