Explore: Marketing Performance

Description

Contains marketing ad platform reported orders, revenue, spend, CPO, ROAS. Also aggregates marketing spend from BSD.

Common Use Cases

  1. Show difference from ad platform reported performance, first click performance and last click performance.
  2. 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.