--- name: marketing-attribution description: "Design and implement marketing attribution models to accurately measure channel contribution, customer journey impact, and marketing ROI across touchpoints. Use when building attribution frameworks, analyzing marketing effectiveness, optimizing channel mix, or evaluating campaign performance. Triggers on phrases like 'attribution model', 'multi-touch attribution', 'MTA', 'marketing mix modeling', 'MMM', 'channel performance', 'customer journey', 'conversion attribution', 'last-click', 'first-click', 'data-driven attribution', 'incremental testing', 'marketing ROI'." --- # Marketing Attribution & Analytics Design and implement marketing attribution models to accurately measure channel contribution, customer journey impact, and marketing ROI across all touchpoints, enabling data-driven budget allocation and channel optimization decisions. ## Workflow ### Phase 1: Attribution Framework Design 1. **Data foundation assessment**: - Data sources inventory (web analytics, CRM, ad platforms, email, social) - Data quality audit (completeness, accuracy, consistency) - Identity resolution strategy (cross-device, cross-channel stitching) - Privacy compliance review (GDPR, CCPA, cookie deprecation impact) 2. **Attribution model selection**: - Rule-based models: last-click, first-click, linear, time-decay, position-based - Data-driven models: Markov chains, Shapley value, algorithmic attribution - Incremental testing: geo-experiments, holdout groups, A/B tests - Marketing Mix Modeling (MMM): regression-based, aggregate-level analysis 3. **Touchpoint taxonomy development**: - Channel classification (paid search, organic, social, email, display, referral) - Campaign taxonomy (brand vs. performance, acquisition vs. retention) - Touchpoint definition (view, click, engagement, conversion) - Attribution window configuration (1-day, 7-day, 30-day, 90-day) ### Phase 2: Implementation & Analysis 1. **Data pipeline construction**: - ETL processes for data collection and normalization - Customer journey reconstruction (touchpoint sequencing) - Conversion event definition and tracking - Revenue/CRM data integration 2. **Model calibration and validation**: - Back-testing against known outcomes - Sensitivity analysis (window length, channel grouping) - Statistical significance testing - Sanity checks vs. business intuition 3. **Channel performance analysis**: - Contribution analysis (assisted conversions, revenue influence) - Cost per acquisition by channel (fully attributed) - Return on ad spend (ROAS) with proper attribution - Customer acquisition cost (CAC) by channel 4. **Journey analysis**: - Common path identification (most frequent sequences) - Drop-off analysis (where journeys terminate) - Touchpoint depth analysis (average touches per conversion) - Time-to-conversion by journey type ### Phase 3: Optimization & Reporting 1. **Budget optimization recommendations**: - Reallocation analysis (shift from low to high performers) - Incremental vs. cannibalization assessment - Channel synergy identification (complementary vs. redundant) - Scenario modeling (what-if budget changes) 2. **Reporting and dashboard design**: - Executive summary (top-line impact, ROI, key insights) - Channel performance detail (contribution, efficiency, trends) - Journey visualization (path analysis, funnel insights) - Alerting for anomalous performance 3. **Continuous improvement**: - Model retraining and recalibration schedule - New channel/source integration - Attribution window optimization - Incremental testing program ## Templates ### Attribution Model Comparison Framework ``` MARKETING ATTRIBUTION — Model Comparison ========================================== Analysis Period: Q4 2024 | Total Conversions: 12,480 | Revenue: $4.2M ATTRIBUTION MODEL RESULTS COMPARISON: ┌────────────────────────────┬──────────┬───────────┬────────────┬───────────┐ │ Channel │ Last- │ Data- │ MMM │ Incremental│ │ │ Click │ Driven │ (Aggregate)│ (Test) │ ├────────────────────────────┼──────────┼───────────┼────────────┼───────────┤ │ Paid Search │ 38.2% │ 22.4% │ 24.1% │ 21.8% │ │ Organic Search │ 12.1% │ 18.7% │ 20.3% │ 19.5% │ │ Paid Social │ 8.4% │ 12.3% │ 11.8% │ 10.9% │ │ Email Marketing │ 14.6% │ 9.2% │ 8.7% │ 8.4% │ │ Display/Programmatic │ 2.1% │ 6.8% │ 7.2% │ 5.1% │ │ Affiliate/Partner │ 6.3% │ 5.9% │ 6.1% │ 6.3% │ │ Content/Blog │ 1.8% │ 7.4% │ 7.8% │ 6.2% │ │ Referral/PR │ 3.2% │ 5.1% │ 5.4% │ 4.8% │ │ Brand/Direct │ 13.3% │ 14.2% │ 18.6% │ 17.0% │ ├────────────────────────────┼──────────┼───────────┼────────────┼───────────┤ │ TOTAL │100.0% │ 100.0% │ 100.0% │ 100.0% │ └────────────────────────────┴──────────┴───────────┴────────────┴───────────┘ KEY INSIGHTS: 1. Paid Search: Over-attributed by 16% in last-click model. Data-driven and MMM models show more realistic contribution. Still the largest channel but with diminishing returns at current spend levels. 2. Organic Search & Content: Under-attributed by last-click by 6-8%. These are strong upper-funnel channels driving awareness that feeds paid channels later. Investment justified by long-term value. 3. Display/Programmatic: Last-click dramatically under-represents (2.1% vs. 6.8% data-driven). View-through conversions are significant for this channel. Retargeting effectiveness confirmed. 4. Email Marketing: Over-attributed by last-click (14.6% vs. 9.2%). Much of email activity captures credit for conversions already influenced by other channels. Still valuable for retention and re-engagement. 5. Brand/Direct: Consistent across models but MMM shows higher contribution (18.6%) — brand building has substantial halo effect on all channels. RECOMMENDED APPROACH: Primary model: Data-Driven Attribution (DDA) for tactical optimization Validation model: Incremental testing (quarterly geo-experiments) Strategic model: MMM for annual budget planning and long-term trends Confidence level: 92% (cross-model alignment strong for top 5 channels) ``` ### Attribution Analysis Report ``` ATTRIBUTION ANALYSIS — Q4 2024 ================================ Report Date: 2025-01-15 | Model: Data-Driven + MMM Validation EXECUTIVE SUMMARY: Total marketing-driven revenue: $4.2M Overall ROAS: 3.8x ($4.2M revenue / $1.1M spend) CAC (fully attributed): $87.50 Conversions: 12,480 Average journey depth: 4.2 touchpoints Average time to conversion: 12.3 days CHANNEL PERFORMANCE RANKING (by fully-attributed ROI): ┌────┬──────────────────────┬──────────┬──────────┬────────────┬───────────┐ │ # │ Channel │ Spend │ Conv. │ Revenue │ ROAS │ ├────┼──────────────────────┼──────────┼──────────┼────────────┼───────────┤ │ 1 │ Organic Search │ $0* │ 2,334 │ $728,000 │ ∞ │ │ 2 │ Affiliate/Partner │ $82,000 │ 737 │ $312,000 │ 3.8x │ │ 3 │ Paid Search │$340,000 │ 2,796 │$1,014,000 │ 3.0x │ │ 4 │ Email Marketing │ $45,000 │ 1,148 │ $365,000 │ 8.1x* │ │ 5 │ Paid Social │$210,000 │ 1,535 │ $517,000 │ 2.5x │ │ 6 │ Content/Blog │ $68,000 │ 923 │ $313,000 │ 4.6x* │ │ 7 │ Display/Programmatic │$156,000 │ 849 │ $284,000 │ 1.8x │ │ 8 │ Referral/PR │ $42,000 │ 637 │ $202,000 │ 4.8x* │ │ 9 │ Brand/Direct │ $78,000 │ 1,761 │ $442,000 │ 5.7x* │ ├────┴──────────────────────┴──────────┴──────────┴────────────┴───────────┤ │ TOTALS │$981,000 │12,480 │$4,217,000 │ 4.3x │ └────┴──────────────────────┴──────────┴──────────┴────────────┴───────────┘ * ROAS includes internal cost estimates only (not external ad spend) BUDGET OPTIMIZATION RECOMMENDATIONS: Increase (+15-20%): → Paid Search (still strongest performer, room for efficiency gains) → Content/Blog (high ROI, low absolute spend, strong top-of-funnel) → Paid Social (retargeting segment specifically — 4.2x ROAS) Maintain (current allocation): → Affiliate/Partner (strong ROI, strategic channel) → Email Marketing (high ROI, retention-critical) → Brand/Direct (halo effect validates investment) Decrease (-10-15%): → Display/Programmatic (broad reach segment — low ROAS at 1.2x) → Paid Social (cold audience acquisition — 1.8x ROAS) Projected impact of reallocation: Revenue: +$180,000 (4.3% lift) CAC: -$4.20 (4.8% reduction) Overall ROAS: 4.0x (from 3.8x) CUSTOMER JOURNEY INSIGHTS: Most common paths to conversion: 1. Organic → Paid Search → Conversion (14.2% of journeys) 2. Paid Social → Email → Conversion (11.8% of journeys) 3. Display → Paid Search → Email → Conversion (9.7% of journeys) 4. Direct → Conversion (8.4% of journeys — brand recognition) 5. Content → Organic → Paid Search → Conversion (7.1% of journeys) Average touches before conversion: 4.2 High-intent purchases: 2.8 touches Consideration purchases: 5.6 touches Time to conversion by channel first touch: Paid Search: 8.2 days Organic: 10.1 days Paid Social: 14.3 days Display: 18.7 days Email: 6.5 days (re-engagement) INCREMENTAL TESTING RESULTS (Q4 Geo-Test): Test market: Seattle, WA (4-week display ad suppression) Control market: Portland, OR (matched demographics, size) Result: Display suppression reduced conversions by 5.1% in test market Conclusion: Display incremental contribution confirmed at ~5% (consistent with data-driven attribution model) NEXT STEPS: 1. Implement recommended budget reallocation (Q1 2025) 2. Set up incremental test for paid social cold audience 3. Recalibrate attribution windows (test 45-day vs. current 30-day) 4. Integrate offline conversion data (store visits, call tracking) 5. Quarterly MMM refresh (annual comprehensive, quarterly update) ``` ## Integration Points - **Analytics platforms**: Google Analytics 4, Adobe Analytics, Mixpanel, Amplitude - **Attribution tools**: Northbeam, Rocksmith, Triple Whale, AppsFlyer - **Ad platforms**: Google Ads, Meta Ads, LinkedIn Ads, TikTok Ads, Programmatic DSPs - **CRM**: Salesforce, HubSpot, Dynamics 365 (revenue data, customer data) - **Email platforms**: Mailchimp, Klaviyo, Braze, SendGrid - **Data warehouses**: Snowflake, BigQuery, Redshift, Databricks - **BI tools**: Tableau, Looker, Power BI, Mode, Looker Studio - **Experimentation**: Optimizely, VWO, Google Optimize (A/B testing) - **MMM platforms**: Robyn (Meta open-source), Lightstep, Kineto, BigCast - **Identity resolution**: Segment, mParticle, LiveRamp, BlueKai ## Edge Cases | Scenario | Handling | |----------|----------| | Cookie deprecation impacting attribution | Shift toward first-party data; implement server-side tagging; increase MMM reliance | | Cross-device journey fragmentation | Implement user ID-based tracking where possible; probabilistic matching; device graph | | Private browser / ITP blocking | Focus on aggregated analysis; MMM for high-level trends; incrementality tests | | Long sales cycle exceeding attribution window | Extend window; model-assisted attribution; CRM-integrated attribution | | Channel overlap / cannibalization | Incremental testing; marginal value analysis; holdout experiments | | Attribution data conflicts between platforms | Establish source of truth; data reconciliation process; platform-specific caveats | | New channel launch with no historical data | Start with rule-based; collect data; transition to data-driven after 90 days | | Budget constraints limiting test capability | Use quasi-experimental methods; regression discontinuity; synthetic control | ## Output ### Attribution Performance Dashboard ``` MARKETING ATTRIBUTION — Performance Dashboard ================================================ Period: Q4 2024 (Oct 1 — Dec 31) | Model: Data-Driven Attribution OVERVIEW: Total revenue attributed: $4.2M [██████████████████████████████████] 100% Total conversions: 12,480 Overall ROAS: 3.8x ✓ (target: ≥ 3.5x) CAC: $87.50 ✓ (target: < $95) Avg journey depth: 4.2 touches | Avg time to convert: 12.3 days TOP 5 CHANNELS BY REVENUE CONTRIBUTION: 1. Paid Search: $1.01M (24.0%) | ROAS: 3.0x | Trend: ↗ +5.2% 2. Brand/Direct: $442K (10.5%) | ROAS: 5.7x | Trend: → flat 3. Paid Social: $517K (12.3%) | ROAS: 2.5x | Trend: ↘ -2.1% 4. Email: $365K (8.7%) | ROAS: 8.1x | Trend: ↗ +8.4% 5. Organic Search: $728K (17.3%) | N/A | Trend: ↗ +3.7% CHANNEL EFFICIENCY RANKING (ROAS): 1. Email: 8.1x [████████████████████████████████████████] 2. Brand/Direct: 5.7x [██████████████████████████████████░░░░] 3. Content/Blog: 4.6x [███████████████████████████████░░░░░░░] 4. Affiliate: 3.8x [█████████████████████████████░░░░░░░░░] 5. Paid Search: 3.0x [███████████████████████████░░░░░░░░░░░] 6. Paid Social: 2.5x [██████████████████████████░░░░░░░░░░░░] 7. Display: 1.8x [███████████████████████░░░░░░░░░░░░░░░] TREND ANALYSIS (Quarter-over-Quarter): ┌──────────────────────┬─────────┬─────────┬─────────┬───────────┐ │ Channel │ Q2 2024 │ Q3 2024 │ Q4 2024 │ QoQ Trend │ ├──────────────────────┼─────────┼─────────┼─────────┼───────────┤ │ Overall ROAS │ 3.6x │ 3.4x │ 3.8x │ ↗ +11.8% │ │ Paid Search ROAS │ 3.2x │ 2.9x │ 3.0x │ ↗ +3.4% │ │ Paid Social ROAS │ 2.8x │ 2.6x │ 2.5x │ ↘ -3.8% │ │ Display ROAS │ 2.1x │ 1.9x │ 1.8x │ ↘ -5.3% │ │ Organic contribution │ 16.8% │ 17.1% │ 17.3% │ ↗ +1.2pp │ │ Email ROAS │ 7.2x │ 7.5x │ 8.1x │ ↗ +8.0% │ └──────────────────────┴─────────┴─────────┴─────────┴───────────┘ BUDGET vs. PERFORMANCE: Total spend: $981,000 | Budget: $1,000,000 | Utilization: 98.1% Overspend channels: Paid Search (+3.2%), Paid Social (+5.1%) Underspend channels: Content (-12.4%), Email (-8.7%) Budget efficiency score: 82/100 ⚠ (Reallocation recommended — see optimization report) DATA QUALITY: Tracking coverage: 94.2% ✓ (target: > 90%) Identity resolution rate: 78.4% ⚠ (target: > 85%) Data freshness: 2 hours ✓ (target: < 4 hours) Attribution model confidence: 92% ✓ (target: > 85%) ACTION ITEMS: 1. Decrease Display/Programmatic spend by 12% (reallocating to Content) 2. Increase Content/Blog investment by 20% (strong ROI, under-funded) 3. Investigate Paid Social ROAS decline (creative fatigue? audience shift?) 4. Schedule Q1 incremental test (paid social cold audience) 5. Improve identity resolution (implement first-party ID strategy) ```