Explore: Marketing Performance

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

Show difference from ad platform reported performance, first click performance and last click performance.
Total CPO, CPA, ROAS by vendor.

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}