Attribution Report That Credits the Wrong Channel
A retailer runs paid search, organic, email, and a webinar program. Marketing ops built a 'Program Performance' report using program cost and program member success, but the CMO says the numbers don't match the CRM's opportunity pipeline. Investigation reveals: (1) the same person can be a member of multiple programs, and success is counted per program; (2) the webinar program's members were imported from a list and marked successful in bulk; (3) the CRM opportunity is linked to the lead but the report only shows 'program members' not 'opportunities influenced'; (4) email program cost was entered as a lump sum for the year rather than per-send. The CMO wants channel ROI that reconciles to pipeline.
1. Explain why the current report overstates some channels and cannot reconcile to pipeline, using the four observed issues.
Read the worked answer
Each issue distorts the picture differently:
- Multi-program membership + per-program success double-counts the same person across channels. One buyer who touched email, webinar, and paid search is counted as a success in all three, inflating every channel and making totals exceed reality.
- Bulk-marked webinar success credits the webinar for people who may never have engaged; success should reflect actual attendance/engagement, not list import.
- Members ≠ opportunities influenced. The report counts program members, not opportunities the program touched. Pipeline reconciliation requires linking program membership to CRM opportunities, which the current report doesn't do.
- Lump-sum email cost understates per-send cost efficiency or distorts ROI because cost isn't allocated to the period/send that generated responses.
Together these make the report internally inconsistent and unreconcilable to CRM pipeline: it measures activity and membership, not influenced revenue.
2. Propose a reporting approach that reconciles to pipeline and fairly allocates credit, and state the tradeoffs.
Read the worked answer
Approach:
- Report on opportunities influenced, not members. Use program membership joined to CRM opportunities so the denominator is real pipeline. Reconcile totals to CRM opportunity counts.
- Define success by real engagement (attended, responded), not bulk import flags. Clean up the webinar program's success statuses.
- Choose an attribution model explicitly - first-touch, last-touch, or multi-touch - and state it. Multi-touch splits credit across programs a person touched, avoiding double-count; single-touch is simpler but over-credits one channel.
- Allocate cost per send/period so ROI uses the cost that generated the responses.
Tradeoffs: multi-touch is fairer but harder to explain and requires complete touch tracking; single-touch is easy but misleads the CMO. Reconciling to pipeline requires reliable program-to-opportunity linkage, which may need cleanup. Recommend multi-touch with a documented model and a reconciliation check against CRM pipeline each period.