Sales Attribution by Advertising Channel (Marketing Mix Modeling)
The Account Director of an advertising agency must show the client how much each channel (TV, Meta Ads, Google Search, Influencers) contributes to weekly sales in order to reallocate the budget for the next half-year.
Where the money comes from
What to do now
- 1Gather weekly sales and spend by channel for 2-3 years.
- 2Build the attribution model and validate it with a geographic test.
- 3Reallocate 20% of the budget according to marginal return.
For your committee
One page with the decision, the impact, the risks, the steps and the KPI to track.
The print dialog opens: choose "Save as PDF".
Watch out: more volume is not always more profit
Allocating budget by attributed sales and not by margin: a channel that sells a lot of low-margin or promoted product can be the least profitable.
KPI for the committee
Incremental margin per euro invested in each channel.
Detail for your data team
Proposed technique: Linear Regression
Why: Linear Regression (the basis of modern MMM models) makes it possible to break total sales down into the exact sum of the contribution of each advertising channel, being 100% explainable to the Marketing Director.
Cost of getting it wrong: Investing blindly without measuring attribution wastes hundreds of thousands of euros on channels that do not generate incremental sales.
Data needed: Media Agency: Historical weekly spend in euros for each advertising medium (last 104 weeks).; Client (Sales): Total weekly revenue (online + physical stores) and active price promotions.