Marketing attribution modelling
Attribution modelling splits the credit for each sale among the channels a customer touched. You see last click, first click and linear side by side on the same conversions, so you know how much of a channel's figure comes from the choice of model.
One month, three models, example
Paid social: 60 conversions under last click, 510 under first click
-
Paid search
Last click 410First click 230Linear 355230 to 410
-
Paid social
Last click 60First click 510Linear 25560 to 510
-
Email
Last click 430First click 40Linear 21040 to 430
-
Organic search
Last click 100First click 220Linear 180100 to 220
- Conversions
- 1,000 orders in one month, from the order system
- Lookback window
- 30 days, held fixed
- Same paths under every model
| Channel | Last click | First click | Linear | Range |
|---|---|---|---|---|
| Paid search | 410 | 230 | 355 | 230 to 410 |
| Paid social | 60 | 510 | 255 | 60 to 510 |
| 430 | 40 | 210 | 40 to 430 | |
| Organic search | 100 | 220 | 180 | 100 to 220 |
| Total | 1,000 | 1,000 | 1,000 |
Show the numbers
| Path | Orders |
|---|---|
| S | 140 |
| E | 40 |
| O | 100 |
| P | 60 |
| P → S | 120 |
| P → E | 150 |
| S → E | 90 |
| O → S | 60 |
| P → S → E | 90 |
| P → O → S | 90 |
| O → S → E | 60 |
| Total | 1,000 |
What this fixes
What an attribution modelling project hands over
Paid social goes from 60 orders to 510 when the model changes, and not one customer did anything differently.
How a marketing attribution model is set up
- 1
Scoping
We agree the conversion, orders net of cancellations from the order system, then the channels and the decision the numbers feed.
- 2
Path table
Touches join to orders, the lookback window cuts them, and orders with no path stay in view.
- 3
Comparison
The three models run on the same rows, and any channel whose range is wider than the decision can absorb goes on the shortlist.
- 4
Handover
The SQL, the path table and the model note are in your warehouse, and the monthly refresh runs without us.
Where multi touch attribution goes wrong
Every column in the comparison adds up to the same orders, so the only thing that changes between columns is the rule.
Attribution modelling for ecommerce
Attribution splits credit between channels. What each channel adds to sales in total, TV and radio included, is a question for marketing mix modelling.
Questions people ask
Which attribution model should we use?
The one that matches the decision: first click for which channels find new customers, last click for what closes the sale. Report on one with its lookback window written down, and show the other two beside it.
Do you set up marketing attribution for ecommerce brands?
Yes. Each order from the order system, net of cancellations, gets matched to its touches inside the agreed window, and orders with no path stay counted and shown.
What about data-driven attribution?
It goes in as a fourth column if your GA4 property or Google Ads account uses it. It still only shares credit among the touches your tracking recorded, so only a holdout test shows cause.
Is multi touch attribution the same as incrementality testing?
No. Attribution shares out credit for conversions that happened, and a holdout test counts the orders that go missing when a channel pauses. The channel with the widest range across models is the first to test.
How long should the lookback window be?
Long enough to cover first touch to purchase in your own data. We set it where the path table's curve of days to order flattens, and it holds until a dated line in the model note changes it.
Do two of your teams credit the same channel differently?
On the call we look at whether your order data and touch data can be joined into one path table.