MBA Digital Attribution Concept Card Template
Last click, first click, linear, time decay, position-based, Shapley and Markov removal effect, attribution versus incrementality, GA4, ATT, Chrome
使い方: Use it when you read or build channel attribution reports and must decide what they support. Compare several models on the same paths, then frame the experiment that settles the disagreement. The main pitfall is treating attributed conversions as incremental.
プレビュー
Digital Attribution Concept Card: [Brand, funnel or course]
A concept card for multi-touch attribution as a brand and digital marketing elective teaches it: rules-based models (last click, first click, linear, time decay, position-based), algorithmic models (Shapley value and Markov chain removal effect), the data-driven models in today's analytics tools, the difference between attribution and incrementality, and the privacy changes that limit user-level tracking. It is for MBA students and for managers who read channel reports and must decide how much each channel really earns. It builds on the core card mba/mba-marketing-mix-card (average versus marginal return, allocation) and on its sibling elective cards mba/mba-marketing-experiments-card and mba/mba-marketing-mix-modeling-card, and does not re-teach them. Source basis: Shapley (1953), Shao and Li (2011), Dalessandro et al. (2012), Li and Kannan (2014), Anderl et al. (2016), Berman (2018) and Gordon et al. (2019, 2023), written up in original words with fictional Northfield Outdoor Co. data. Every number was computed in Python and is shown with its Excel formula. Replace every [bracketed] value and every row marked Example.
Document control
| Field | Value |
|---|---|
| Document ID | [MKT-ATT-001] |
| Course or project | [Brand and digital elective / quarterly channel review] |
| Learner or analyst | [Your name] |
| Decision owner | [@owner] |
| Reviewed by | [Study group / analytics lead] |
| Data set | [Northfield Outdoor Co. web journeys, one quarter (fictional) / your data and source] |
| Conversion definition | [Online purchase] |
| Lookback window | [30 days before conversion] |
| Channels | [Paid search, paid social, email / your channel grouping] |
| Models compared | [Last click, first click, linear, time decay (7-day half-life), position-based 40/20/40, Shapley] |
| Software | Excel (SUMPRODUCT, POWER, MMULT, MINVERSE); analytics tool exports |
| Last updated | YYYY-MM-DD |
| Version | [0.1] |
| Classification | [Course work / internal] |
When to use it
One-sentence rule: use attribution to describe how customer journeys are made up and to share credit consistently across digital touchpoints for day-to-day optimisation; do not use it on its own to decide how much a channel adds to total sales.
| Good uses | Poor uses |
|---|---|
| Comparing keywords, ads or creatives within a channel | Setting the total budget of a channel (use experiments and MMM) |
| Seeing which channels open and which close journeys | Measuring offline channels such as TV or catalogue |
| Consistent credit rules for bidding algorithms | Proving that a channel causes sales |
| Spotting channels that only appear at the end (possible "credit takers") | Comparing channels measured under different windows |
| A common language with agencies and platforms | Judging brand-building activity with a 7-day window |
The idea in plain language
A customer who buys online often touches several channels first: sees a social ad, later searches the brand, opens an email, then buys. Attribution decides how to split the credit for that purchase among the touchpoints. Rules-based models apply a fixed rule (all to the last click, equal shares, more to recent touches). Algorithmic models use the data on converting and non-converting journeys to decide the split.
Two facts limit every attribution model:
- Attribution allocates all conversions on tracked paths to channels. It has no "would have bought anyway" bucket. A loyal customer who would have bought regardless and clicked a brand-search ad on the way gives that ad full credit under last click. Experiments measure that missing base directly (mba/mba-marketing-experiments-card).
- It sees only what is tracked. Offline exposure, views without clicks, other devices and users who decline tracking are partly or wholly invisible, and the visible share is shrinking.
Berman (2018) showed formally that common attribution rules can reward publishers for showing ads to people who would have converted anyway, and Li and Kannan (2014) found with a field experiment that last-click rules misstate the contribution of several channels. Gordon et al. (2019, 2023) compared observational ad measurement with large experiments and found the observational methods often far off. Attribution remains useful, but as a description and a consistent bookkeeping rule, checked against experiments.
Models and formulas
Rules-based models for a converting path with touches (in time order) and days before conversion:
| Model | Weight of touch | Rewards |
|---|---|---|
| Last click | , others 0 | Channels that close (brand search, email) |
| First click | , others 0 | Channels that open (social, display) |
| Linear | Presence on the path | |
| Time decay, half-life | Recent touches | |
| Position-based (40/20/40) | 40% first, 40% last, 20% shared by the middle; 50/50 for two touches | Openers and closers |
Shapley value (Shapley 1953). Treat channels as players and a value function as what a set of channels achieves together. Each channel gets its average marginal contribution over all orders in which channels could join:
The Shapley value is the only allocation that is efficient (credits sum to ), symmetric, gives zero to a channel that never adds anything, and is additive. A simple, common choice in attribution is to estimate as the conversion rate of users exposed to exactly the channels in ; Dalessandro et al. (2012) set out the link between attribution and the Shapley value, building on the data-driven models of Shao and Li (2011).
Markov chain removal effect (Anderl et al. 2016). Model journeys as transitions between states (start, channels, conversion, null). is the probability of reaching conversion from start. The removal effect of channel is the share of conversions lost if is removed (its visits go to null):
With transient-state matrix and absorption vector into conversion, the conversion probabilities from each
state are (Excel: =MMULT(MINVERSE(I-Q), r)).
| Symbol | Meaning |
|---|---|
| , | Number of touches on a path; days from touch to conversion |
| Time-decay half-life (7 days in this card) | |
| , | Set of channels, number of channels |
| Value of channel set (here, conversion rate of users exposed to exactly ) | |
| Shapley credit of channel | |
| , | Transition probabilities among channel states; probabilities into conversion |
| Removal effect of channel |
Assumptions and limits
| Assumption | What it means | Reality check | Consequence |
|---|---|---|---|
| Paths are complete | Every touch is recorded | Views, other devices, offline and opted-out users are missing | Credit drifts to trackable click channels |
| Touches cause conversions | Credit equals contribution | Targeting puts ads in front of likely buyers | Credit exceeds incremental effect (Berman 2018) |
| Exposed and unexposed users are comparable (Shapley on observed rates) | is causal | Selection: people who see email are existing customers | Shapley values inherit the selection bias |
| First-order Markov | The next step depends only on the current channel | Real journeys have longer memory | Removal effects are approximate |
| Fixed window | Touches older than the lookback are ignored | Brand advertising works over months | Long-term effects disappear |
How managers use it in practice
- Analytics tools (dated fact, checked 28 October 2026). Google Analytics 4 offers data-driven attribution, paid and organic last click, and Google paid channels last click; Google's help page states that the first click, linear, time decay and position-based models were removed in November 2023 (GA4 attribution help). Rules-based models therefore live mainly in spreadsheets, warehouses and other tools. Check the current list before you rely on it.
- Browser and mobile privacy (dated facts, checked 28 October 2026). Apple requires apps to obtain permission through App Tracking Transparency before tracking users across other companies' apps and websites or accessing the advertising identifier, on iOS, iPadOS and tvOS 14.5 or later (Apple user privacy and data use); Apple's privacy-preserving ad attribution frameworks (SKAdNetwork and the newer AdAttributionKit, available from iOS and iPadOS 17.4 per Apple's developer documentation) report aggregated, delayed results instead. Google announced on 22 April 2025 that Chrome would keep its current approach of letting users choose about third-party cookies rather than introduce a new standalone prompt, and on 17 October 2025 that it was retiring several Privacy Sandbox technologies, including the Attribution Reporting API (Privacy Sandbox update). These rules change: re-check the official pages, and treat consent and tracking as legal questions for counsel, not for this card.
- Triangulation. Mature teams use attribution for within-channel optimisation, MMM for cross-channel budgets (mba/mba-marketing-mix-modeling-card) and experiments to calibrate both (mba/mba-marketing-experiments-card).
- Incrementality factors. A holdout result divides attributed conversions into incremental and non-incremental; the ratio is then applied to attribution reports until the next test.
Worked example A (fully solved): Northfield's three digital channels
Situation (fictional). In one quarter Northfield Outdoor Co. records 1,650 online purchases on journeys that touched paid search, paid social or email (30-day lookback). Spend: search USD 90,000, social USD 60,000, email USD 10,000. Average order value USD 110.
Converting paths (days before purchase in brackets):
| Path | Sequence | Purchases |
|---|---|---|
| P1 (Example) | Social (10) then Search (1) | 300 |
| P2 (Example) | Search (0) | 500 |
| P3 (Example) | Social (14) then Email (5) then Search (0) | 200 |
| P4 (Example) | Email (0) | 150 |
| P5 (Example) | Search (6) then Email (0) | 250 |
| P6 (Example) | Social (9) then Search (3) then Email (0) | 100 |
| P7 (Example) | Social (0) | 80 |
| P8 (Example) | Social (8) then Email (1) | 70 |
Step 1: rules-based models
Time-decay weights, half-life 7 days: raw weight =POWER(2,-days/7), normalised by the path total. P1: raw 0.3715
and 0.9057, normalised 0.2909 (social) and 0.7091 (search). P3: 0.1344, 0.3278, 0.5378. P5: 0.3557, 0.6443. P6: 0.1905,
0.3451, 0.4644. P8: 0.3333, 0.6667. Channel credit is =SUMPRODUCT(weights, purchases) over the paths.
| Model | Search | Social | Search share | Social share | Email share | |
|---|---|---|---|---|---|---|
| Last click | 1,000.0 | 80.0 | 570.0 | 60.6% | 4.8% | 34.5% |
| First click | 750.0 | 750.0 | 150.0 | 45.5% | 45.5% | 9.1% |
| Linear | 875.0 | 365.0 | 410.0 | 53.0% | 22.1% | 24.8% |
| Time decay (7 days) | 943.7 | 236.5 | 469.7 | 57.2% | 14.3% | 28.5% |
| Position-based 40/20/40 | 875.0 | 385.0 | 390.0 | 53.0% | 23.3% | 23.6% |
Social's credit ranges from 80 to 750 purchases depending on the rule: a factor of more than nine. Nothing in the data says which rule is right; each encodes a belief about how journeys work.
Step 2: Shapley values from conversion rates
The analytics team also has all users in the quarter, grouped by the exact set of channels they were exposed to, including users with no paid touch and users who did not buy:
| Channel set | Users | Purchases | Conversion rate |
|---|---|---|---|
| None (organic and direct only) (Example) | 500,000 | 2,000 | 0.40% |
| Search only (Example) | 50,000 | 500 | 1.00% |
| Social only (Example) | 16,000 | 80 | 0.50% |
| Email only (Example) | 15,000 | 150 | 1.00% |
| Search and social (Example) | 15,000 | 300 | 2.00% |
| Search and email (Example) | 10,000 | 250 | 2.50% |
| Social and email (Example) | 5,000 | 70 | 1.40% |
| All three (Example) | 8,000 | 300 | 3.75% |
Take = conversion rate of the set. For a user exposed to all three, the rate exceeds the no-touch base by pp. Search's marginal contributions: joining nothing 0.60 pp; joining social 1.50 pp; joining email 1.50 pp; joining both 2.35 pp. With three players the weights are 1/3 for the empty and full coalitions and 1/6 for each one-channel coalition:
Likewise pp and pp; the three sum to 3.35 pp
(efficiency). Excel: put the eight rates in a table and compute each marginal contribution by subtraction, then
=SUMPRODUCT(weights, marginals).
From rates to purchases. For each channel set, purchases at the base rate (0.40% of its users) go to a "base" bucket and the rest are split by the Shapley values of the channels in that set. For example, search and social: 15,000 users, base 60, incremental 240, split search 157.5 and social 82.5. Summed over all sets:
| Search | Social | Base (would have bought anyway) | Total | ||
|---|---|---|---|---|---|
| Shapley purchases | 681.2 | 165.7 | 327.2 | 476.0 | 1,650.0 |
| Share | 41.3% | 10.0% | 19.8% | 28.8% | 100% |
Step 3: money
| Model | Search ROAS | Social ROAS | Email ROAS |
|---|---|---|---|
| Last click | 1.22 | 0.15 | 6.27 |
| First click | 0.92 | 1.38 | 1.65 |
| Linear | 1.07 | 0.67 | 4.51 |
| Shapley with base | 0.83 | 0.30 | 3.60 |
ROAS = credited purchases times USD 110 divided by spend; for example, last-click search =1000*110/90000 = 1.22.
Step 4: interpretation
- Social looks like a disaster under last click (ROAS 0.15) and a winner under first click (1.38). Its users have a conversion rate on their own (0.50%) barely above the base (0.40%), and the Shapley view gives it 10% of purchases. But Shapley on observed rates is still not causal: social reaches colder prospects, so its users differ from non-exposed users before any ad.
- Email looks excellent under every model. Most email recipients are existing customers with high purchase propensity; the Shapley base bucket shows that part of what rules-based models credit to channels would have happened anyway, and email is the channel most exposed to this selection.
- Search keeps the largest share under every model; much of it is brand search by people already looking for Northfield.
- Decision. Do not move budget on any of these numbers alone. Use them to frame the next experiments: a social holdout (the channel with the widest disagreement and the largest spend relative to credit) and an email holdout (likely the largest gap between credit and increment). The paid-social holdout in mba/mba-marketing-experiments-card is exactly this test.
Worked example B (half solved): two-channel Shapley and time decay
Two channels A and B. Conversion rates: no touch 0.5%, A only 1.3%, B only 0.9%, both 2.1%.
- With two players, = = [ ] pp.
- = [ ] pp. Check: = = [ ] pp.
- 12,000 users saw both channels. Split their 252 purchases into base, A and B: base [ ], A [ ], B [ ].
- Time decay with a 7-day half-life for the path Social (12 days) then Email (2 days) then Search (0 days): raw
weights
=POWER(2,-12/7)= 0.3048,=POWER(2,-2/7)= [ ], 1.0000. Sum [ ]. Normalised weights [ ], [ ], 0.4706. - Under last click, which channel gets this path's purchase? Under position-based? [ ]
- In one sentence, why is the Shapley split of the 252 purchases still not proof that A caused 120 of them? [ ]
Exercise C (unsolved): Markov removal effect
Northfield's mobile app team has 1,600 journeys (fictional), each starting at "Start" and ending in purchase or null:
| Path | Purchases | No purchase |
|---|---|---|
| Social then Search (Example) | 30 | 270 |
| Search (Example) | 50 | 450 |
| Social (Example) | 5 | 495 |
| Email then Search (Example) | 20 | 80 |
| Social then Email (Example) | 10 | 190 |
- Count transitions between states (Start, Social, Search, Email, Purchase, Null) and convert them to probabilities.
- Compute from Start with the absorbing-chain formula. Check it against 115/1,600.
- Remove each channel in turn (send its visits to Null) and compute the removal effects.
- Normalise the removal effects and allocate the 115 purchases. Compare with last click.
- Which channel gains most moving from last click to the Markov view, and why?
Connections to other cards
- Core marketing mix: mba/mba-marketing-mix-card for average versus marginal return; attribution ROAS is an average.
- Experiments: mba/mba-marketing-experiments-card measures what attribution cannot: the increment.
- MMM: mba/mba-marketing-mix-modeling-card for the top-down, all-channel view.
- Game theory: the Shapley value comes from cooperative game theory (mba/mba-game-theory-card covers the non-cooperative side).
- Customer value: mba/mba-customer-lifetime-value-card, to value a credited new customer beyond the first order.
- Brand: mba/mba-brand-equity-card. Brand search volume is partly an outcome of brand building, which last-click attribution credits to search.
- Course map: mba/mba-marketing-analytics-guide.
Common mistakes and misconceptions
- Treating attributed conversions as incremental. Every rules-based model gives the whole 1,650 to channels; the Shapley view puts 476 in a base bucket, and a holdout may find more.
- Cutting upper-funnel channels on last-click ROAS. Social at 0.15 under last click and 1.38 under first click is a model choice, not a measurement.
- Comparing reports with different windows or channel groupings. Align them before comparing.
- Believing "data-driven" means causal. Data-driven models learn from observed paths and inherit their selection bias.
- Ignoring non-converting paths. Path-only models cannot tell whether a channel raises conversion rates; Shapley and Markov models need the non-converters too.
- Forgetting what is not tracked: views without clicks, offline media, other devices and users who decline tracking.
- Rewarding brand search for demand created elsewhere. Brand search is often the last step of a journey started by TV, social or word of mouth.
- Letting each platform grade itself. Platforms count conversions on their own terms; the sum of platform-reported conversions often exceeds actual sales.
- Treating tool settings as permanent. Available models and privacy rules change; date every report.
Self-test questions
- In one sentence, what is the difference between attribution and incrementality?
- Under which rules-based model does Northfield's social get the most credit, and why?
- Write the time-decay weight for a touch 14 days before purchase with a 7-day half-life, before normalising.
- State the four properties that characterise the Shapley value.
- In example A, what is search's marginal contribution when it joins social, and where does it come from?
- Why do Shapley values computed from observed conversion rates still carry selection bias?
- Define the removal effect in a Markov attribution model.
- Which attribution models does Google Analytics 4 offer as of October 2026, according to Google's help page?
- Why does App Tracking Transparency make user-level attribution harder on iOS?
- Which experiment would you run first after reading example A, and why?
My notes and next steps
| Date | Note | Next step |
|---|---|---|
| YYYY-MM-DD | [What I understood today] | [Card or exercise to do next] |
| YYYY-MM-DD | Example: Attribution divides credit; only a holdout measures the increment | Do Exercise C, then design an email holdout |
| YYYY-MM-DD | [What still confuses me] | [Question for office hours] |
Sources and further reading
- Shapley, L. S. (1953). A value for n-person games. In H. W. Kuhn and A. W. Tucker (eds.), Contributions to the Theory of Games, Volume II (Annals of Mathematics Studies 28), 307-317. Princeton University Press.
- Shao, X., and Li, L. (2011). Data-driven multi-touch attribution models. Proceedings of the 17th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, 258-264.
- Dalessandro, B., Perlich, C., Stitelman, O., and Provost, F. (2012). Causally motivated attribution for online advertising. Proceedings of the Sixth International Workshop on Data Mining for Online Advertising and Internet Economy (ADKDD), 1-9.
- Li, H., and Kannan, P. K. (2014). Attributing conversions in a multichannel online marketing environment: an empirical model and a field experiment. Journal of Marketing Research, 51(1), 40-56.
- Anderl, E., Becker, I., von Wangenheim, F., and Schumann, J. H. (2016). Mapping the customer journey: lessons learned from graph-based online attribution modeling. International Journal of Research in Marketing, 33(3), 457-474.
- Berman, R. (2018). Beyond the last touch: attribution in online advertising. Marketing Science, 37(5), 771-792.
- Gordon, B. R., Zettelmeyer, F., Bhargava, N., and Chapsky, D. (2019). A comparison of approaches to advertising measurement: evidence from big field experiments at Facebook. Marketing Science, 38(2), 193-225.
- Gordon, B. R., Moakler, R., and Zettelmeyer, F. (2023). Close enough? A large-scale exploration of non-experimental approaches to advertising measurement. Marketing Science, 42(4), 768-793.
- Official pages (checked 28 October 2026): Google Analytics help, "Select attribution settings" (support.google.com/analytics/answer/10596866); Apple, "User privacy and data use" (developer.apple.com/app-store/user-privacy-and-data-use); Google Privacy Sandbox blog, "Update on plans for Privacy Sandbox technologies" (17 October 2025) and "Next steps for Privacy Sandbox and tracking protections in Chrome" (22 April 2025).
- Textbooks (further reading, by name only): Kotler and Keller, Marketing Management; Chaffey and Ellis-Chadwick, Digital Marketing; Kohavi, Tang and Xu, Trustworthy Online Controlled Experiments.
Answer key
Worked example B. (1) ; pp. (2) pp; sum 1.60 pp = 2.1 - 0.5. (3) Base ; A ; B ; total 252. (4) 0.8203; sum 2.1251; normalised 0.1434, 0.3860, 0.4706. (5) Last click: search. Position-based: social 40%, email 20%, search 40%. (6) The rates come from users who chose or were targeted into each exposure, so the difference between groups mixes the ads' effect with who the users are; only random assignment separates the two.
Exercise C. (1) From Start: social 0.6250, search 0.3125, email 0.0625. From social: search 0.3000, email 0.2000, purchase 0.0050, null 0.4950. From email: search 0.3333, purchase 0.0333, null 0.6333. From search: purchase 0.1111, null 0.8889. (2) = 0.07187 = 115/1,600. (3) Without search 0.00937 (removal effect 0.8696); without social 0.03912 (0.4557); without email 0.05868 (0.1836). (4) Shares 57.6%, 30.2%, 12.2%: search 66.3, social 34.7, email 14.0 purchases; last click gives search 100, social 5, email 10. (5) Social, from 5 to 34.7, because it starts many journeys that end in search; last click ignores openers.
Self-test.
- Attribution divides the credit for observed conversions among touchpoints; incrementality measures how many conversions would not have happened without the channel.
- First click (750 purchases), because social opens most multi-touch journeys (P1, P3, P6, P8).
- .
- Efficiency, symmetry, null player (zero for a channel that never adds anything) and additivity.
- 1.50 pp: the "search and social" rate (2.00%) minus the "social only" rate (0.50%).
- Users self-select or are targeted into channels (email goes to existing customers), so their conversion rates differ for reasons other than the ads.
- The share of conversions lost when the channel is removed from the journey graph and its visits go to null.
- Data-driven attribution, paid and organic last click, and Google paid channels last click (first click, linear, time decay and position-based were removed in November 2023, per Google's help page).
- Apps need the user's permission to track across other companies' apps and websites or to read the advertising identifier; without it, cross-app user-level paths cannot be joined, so fewer journeys are visible.
- A social holdout (widest disagreement between models, large spend) or an email holdout (largest likely gap between credit and increment); either turns a model argument into a measurement.
Revision history
| Version | Date | Author | Change summary |
|---|---|---|---|
| 0.1 | YYYY-MM-DD | [Your name] | First draft from the template |
| 0.2 | YYYY-MM-DD | [Your name] | Example: Added the email holdout result as an incrementality factor |
Standard and licence note
Based on cooperative game theory (Shapley 1953) and the attribution and advertising measurement literature (Shao and Li 2011; Dalessandro et al. 2012; Li and Kannan 2014; Anderl et al. 2016; Berman 2018; Gordon et al. 2019, 2023), with tool and privacy facts from the official Google and Apple pages checked on 28 October 2026. The text, data and exercises are original and fictional; no textbook, published case or course material was copied or paraphrased. This template is not affiliated with or endorsed by any business school, publisher, author, analytics vendor, platform or browser maker. Check the current official pages before you rely on a tool setting or privacy rule. Template licence: MIT.
関連テンプレート
Digital Transformation Concept Card Template
Digital transformation card: complements and the J-curve, Venkatraman levels, digital maturity grid, operational backbone vs digital platform, adoption-curve business case, pilot vs big bang, product to service shift
MBA・ビジネススクールAccretion and Dilution Concept Card Template
Full merger EPS model: payment mix, cash on hand, debt, PPA amortisation, synergy phase-in, break-even synergies, EPS-neutral price, leverage, ownership
MBA・ビジネススクールMBA Activity-Based Costing Concept Card Template (ABC, TDABC)
ABC card: cost hierarchy, two-stage ABC versus plant-wide rate, time-driven ABC with capacity cost rate and time equations, cost to serve, whale curve