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.

Using Explores

Exploring data can be insightful and fun! Before you start your exploration, make sure to go through our Using Explores Bootcamp

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.