E EREACE
Back
Improve margin and mixAdvertising Agency / AdTech - Marketing and Advertising

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.

Estimated annual impact on EBITDA
+€2.88M
Advertiser with €12M of media spend. Illustrative example with indicative figures: replace them with your own company figures.

Where the money comes from

Budget reallocation to profitable channels
+€1.90M
Cut of channels with no return
+€1.10M
Cost of the study
-€120k
Annual EBITDA impact
+€2.88M
Adds profitReduces profitSystem cost

What to do now

  1. 1Gather weekly sales and spend by channel for 2-3 years.
  2. 2Build the attribution model and validate it with a geographic test.
  3. 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.

The Ereace system

Test decisions with synthetic people before you test them with real ones.

This tool helps you decide with numbers. Before you invest, understand, test and rehearse the decision with the people involved: your customers, your team or your committee.

Understand
QualiSynth

Before you invest, find out what your customers think, need or reject about the initiative.

Test
StrataSynth

Put the offer, the message or the journey in front of synthetic people who do not always follow the happy path.

Train
ArenaSynth

Rehearse the committee presentation or the vendor negotiation against synthetic decision-makers.

See all Ereace products

About this tool. It is free and made by Ereace, an AI-native product studio and human intelligence ecosystem: it connects real human signals, synthetic people and the systems built around them, so teams can understand, test and act on human behavior before decisions reach the real world. About Ereace

Comments or suggestions? info@ereace.es