A W-shaped attribution model assigns credit to first contact, lead creation, and opportunity creation. Follow a dated CRM journey, reconcile its allocation to deal value, and keep missing milestones visible.
A W shaped attribution model allocates credit across first contact, lead creation, and opportunity creation, with a smaller share for eligible interactions between them. A common convention gives each milestone 30% and shares the remaining 10% across intermediate touches. The useful business question is whether the exported milestone assignments match the dated customer journey and sum back to the deal value.
Adobe's attribution documentation describes the three 30% milestone shares and a remaining 10% allocation to intermediary touchpoints. Treat that as a stated convention, not a requirement that every reporting system implements identically.
First contact is the earliest eligible interaction in the tracked journey. Lead creation is the interaction associated with the person becoming known under the chosen definition. Opportunity creation is the eligible interaction associated with creation of the sales opportunity. Confirm whether the source system uses the closest interaction, the most recent preceding interaction, or another rule when attaching that milestone.
Dates alone do not settle every assignment. Adobe's field glossary distinguishes touchpoint date from touchpoint position and notes that one touchpoint can hold multiple positions. Preserve both fields in the export instead of inferring that each stage must have a different interaction.
Covirage is not affiliated with Adobe.
The existing marketing attribution comparison covers the broader choice among credit rules. Use this three-milestone view when the business wants to distinguish initial discovery, identification, and entry into the sales process.
The interaction file needs a unique touch ID, contact or account ID, opportunity ID, timestamp, channel, campaign, supplied milestone role, and supplied allocation percentage. Retain the original timestamp and time zone when several interactions occurred on the same date.
The opportunity file needs one row per opportunity with its creation date, outcome, close date, currency, and the amount being attributed. Choose whether the amount means pipeline, closed-won bookings, or recognized revenue. A single review should not mix these bases under a column called revenue.
For an account sale, identify which contacts belong to that opportunity. Do not attach every interaction from every employee at the account to every deal. Revenue operations should approve the contact-to-opportunity relationship and how renewals are separated from new business.
Put the milestone definition and missing-data policy beside the export. Versioned metric definitions explain why changing the policy without labeling the change makes period comparisons unreliable.
A US business software provider closes a $120,000 contract on September 20, 2026. This example allocates closed-won contract value rather than recognized accounting revenue. Its approved policy gives each milestone 30% and splits the intermediate pool equally between the two eligible middle touches.
Touch credit = Eligible deal value × Assigned allocation percentage
Intermediate weight per touch = Intermediate pool / Eligible intermediate touch count
The intermediate share is 10% / 2 = 5% per touch. The dated interaction export and calculation are:
| Touch date | Interaction and channel | Assigned role | Weight | Credit calculation (USD) | Credit (USD) |
|---|---|---|---|---|---|
| July 1, 2026 | Paid search visit | First contact | 30% | 120,000 × 30% | 36,000 |
| July 3, 2026 | Display interaction | Intermediate | 5% | 120,000 × 5% | 6,000 |
| July 5, 2026 | Webinar registration | Lead creation | 30% | 120,000 × 30% | 36,000 |
| July 12, 2026 | Email interaction | Intermediate | 5% | 120,000 × 5% | 6,000 |
| July 15, 2026 | Paid social pricing-page visit | Opportunity creation | 30% | 120,000 × 30% | 36,000 |
| Total | 100% | 120,000 |
The CRM opportunity creation date is July 15, 2026, and the supplied mapping ties the pricing-page interaction to that milestone. The contract closes later; the close date determines eligibility for this closed-won report but does not receive a separate milestone share.
Check the weights first: 30% + 5% + 30% + 5% + 30% = 100%. Then check dollars: 36,000 + 6,000 + 36,000 + 6,000 + 36,000 = $120,000. Finally, check that the distinct opportunity file contains the same $120,000 once, rather than once for every touch.
Channel totals come from summing touch credit by channel. They must preserve the opportunity total. Those totals describe assigned credit; they do not show how much business would disappear if a channel stopped.
Now change one input: the lead-creation touch cannot be matched to a reliable interaction record. The deal amount and other assignments remain unchanged. For this review, the company retains the lead milestone's weight in an unresolved category until it can verify the mapping.
| Allocation status | Share of deal | Credit (USD) |
|---|---|---|
| Known first, intermediate, and opportunity touches | 70% | 84,000 |
| Unresolved lead-creation milestone | 30% | 36,000 |
| Total | 100% | 120,000 |
Known credit is 120,000 − 36,000 = $84,000, or 70%. The unresolved $36,000 stays visible. Giving it to the webinar channel merely because webinars usually create leads would manufacture a fact that the export does not establish.
Other cases need separate handling. If first contact and lead creation are the same verified touch, their combined 30% + 30% = 60% credit is $72,000 on this deal. If there are no intermediate touches, do not divide by zero: inspect the supplied fallback policy and reconcile its exported result. Do not assume the unused pool disappears or is always redistributed in the same way.
Marketing operations can compare which channels appear at discovery versus lead creation. Sales operations can investigate opportunity-creation mappings and long gaps between milestones. Finance can confirm that the credited amount uses the same deal population and value basis as the commercial report.
A channel repeatedly assigned opportunity-creation credit may deserve closer investigation, but milestone proximity is not proof of incremental impact. The algorithmic attribution guide explains why a different credit method still needs a separate causal interpretation. Use the revenue operations measures for the wider handoff questions beyond attribution.
Bring your dated CRM interactions, supplied milestone allocations, and opportunity outcome export to Covirage. Covirage maps the columns, and its tools compute and check the allocation totals against the supplied deal values; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See sales insights for the supporting business context.
The standard three-milestone approach emphasizes first contact, lead creation, and opportunity creation. A separate closed-won milestone belongs to a different attribution convention. A closed-won deal value can still be the amount allocated across the earlier W-shaped milestones.
One interaction can hold both milestone roles. Keep a unique touch ID and preserve the two supplied milestone weights. Its combined credit is the sum of those weights; do not create an extra interaction or duplicate the full deal amount.
Follow the documented attribution policy rather than silently redistributing credit. For review, retain the missing milestone's allocation as unresolved, identify the affected deals, and separate them from complete journeys. Any approved redistribution should be labeled so later comparisons use the same basis.