Sales AI Skill

Attribution Roi Analysis

Measure marketing and sales attribution to understand which channels, campaigns, and touchpoints drive revenue, enabling data-driven investment decisions. Use when analyzing marketing attribution, calculating sales ROI, measuring channel performance, multi-...

Attribution & ROI Analysis

Connect revenue to its source with multi-touch attribution and ROI measurement across all channels.

Workflow

Aggregate touchpoint data across marketing, sales, and customer success channels.
Apply attribution model(s) to distribute credit across the buyer journey.
Calculate ROI by channel, campaign, and individual touchpoint.
Identify high-performing and under-performing channels.
Optimize budget allocation based on attribution insights.
Generate monthly attribution reports for marketing and sales leadership.
Iterate model based on data quality and business changes.

Attribution Models

ATTRIBUTION MODELS COMPARISON
================================

MODEL 1: FIRST-TOUCH ATTRIBUTION
  ──────────────────────────────
  Credit: 100% to first touchpoint that introduced prospect
  Best for: Understanding top-of-funnel effectiveness
  Use case: Evaluating awareness campaigns, brand marketing
  
  Example Journey:
    Blog post (first touch) → 100% credit
    Email nurture → 0% credit
    Sales call → 0% credit
    Demo → 0% credit
    Close → 0% credit
  
  Pros: Simple, highlights acquisition channels
  Cons: Ignores mid-funnel influence; undervalues sales efforts

MODEL 2: LAST-TOUCH ATTRIBUTION
  ──────────────────────────────
  Credit: 100% to last touchpoint before conversion
  Best for: Understanding closing effectiveness
  Use case: Evaluating sales process, final conversion drivers
  
  Example Journey:
    Blog post → 0% credit
    Email nurture → 0% credit
    Sales call → 0% credit
    Demo (last touch) → 100% credit
    Close → 0% credit
  
  Pros: Simple, highlights closing channels
  Cons: Ignores awareness and nurturing; overvalues last step

MODEL 3: LINEAR ATTRIBUTION
  ──────────────────────────
  Credit: Equal credit to all touchpoints in journey
  Best for: Recognizing all contributors equally
  Use case: Balanced view of full buyer journey
  
  Example Journey (5 touchpoints):
    Blog post → 20% credit
    Email nurture → 20% credit
    Sales call → 20% credit
    Demo → 20% credit
    Proposal → 20% credit
  
  Pros: Fair across all channels
  Cons: Doesn't weight by impact; treats all touches equally

MODEL 4: TIME-DECAY ATTRIBUTION
  ──────────────────────────────
  Credit: Increasing credit to touchpoints closer to conversion
  Best for: Recognizing accelerating influence near close
  Use case: Longer sales cycles where recent touches matter more
  
  Example Journey (decay factor: half-life = 7 days):
    Blog post (30 days before close) → 5% credit
    Email nurture (20 days before) → 10% credit
    Sales call (10 days before) → 25% credit
    Demo (3 days before) → 40% credit
    Proposal (1 day before) → 20% credit
  
  Pros: Reflects increasing urgency near conversion
  Cons: Undervalues early awareness; decay rate is arbitrary

MODEL 5: POSITION-BASED (U-Shaped)
  ────────────────────────────────
  Credit: 40% first touch, 40% last touch, 20% middle (split equally)
  Best for: Balancing acquisition and closing credit
  Use case: Most common enterprise attribution model
  
  Example Journey (5 touchpoints):
    Blog post (first) → 40% credit
    Email nurture (middle) → 6.7% credit
    Sales call (middle) → 6.7% credit
    Demo (middle) → 6.7% credit
    Proposal (last) → 40% credit
  
  Pros: Balances top and bottom of funnel
  Cons: Arbitrary split percentages; middle touches undervalued

MODEL 6: DATA-DRIVEN (Algorithmic)
  ────────────────────────────────
  Credit: Machine learning model assigns credit based on actual impact
  Best for: Most accurate attribution (when data quality supports it)
  Use case: Enterprise with 12+ months of clean touchpoint data
  
  Method:
    - Analyze all historical buyer journeys
    - Identify which touchpoint combinations correlate with wins
    - Weight credit based on statistical contribution
    - Continuously learn and adjust weights
  
  Pros: Most accurate; adapts to changing buyer behavior
  Cons: Requires large data volumes; "black box" model; hard to explain

RECOMMENDED APPROACH:
  ───────────────────
  Use MULTI-MODEL DASHBOARD — show revenue through 3+ models simultaneously:
  1. Position-Based (primary model for reporting)
  2. Time-Decay (secondary model for trend analysis)
  3. Data-Driven (tertiary model for optimization)
  
  This avoids over-reliance on single model and reveals model sensitivity.

ROI Calculation Framework

CHANNEL ROI CALCULATION
=========================

FORMULA:
  ROI = (Revenue Attributed - Channel Cost) / Channel Cost × 100
  
  ROAS (Return on Ad Spend) = Revenue Attributed / Ad Spend

CHANNEL ROI ANALYSIS:
  ╔═══════════════════════╦═══════════════╦═══════════════╦═══════════════╗
  ║ Channel               ║ Cost (Monthly)║ Revenue       ║ ROI           ║
  ╠═══════════════════════╬═══════════════╬═══════════════╬═══════════════╣
  ║ Paid Search           ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Paid Social           ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Content Marketing     ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Email Marketing       ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Outbound Sales        ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ LinkedIn Ads          ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Webinars              ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Events/Conferences    ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Referral Program      ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ║ Organic Search        ║ $[amount]     ║ $[amount]     ║ [X]%          ║
  ╚═══════════════════════╩═══════════════╩═══════════════╩═══════════════╝

CAMPAIGN-LEVEL ROI:
  ╔═══════════════════════╦═══════════════╦═══════════════╦═══════════════╗
  ║ Campaign              ║ Spend         ║ Leads         ║ Revenue / ROI ║
  ╠═══════════════════════╬═══════════════╬═══════════════╬═══════════════╣
  ║ [Campaign 1]          ║ $[amount]     ║ [count]       ║ $[amt] / [X]% ║
  ║ [Campaign 2]          ║ $[amount]     ║ [count]       ║ $[amt] / [X]% ║
  ╚═══════════════════════╩═══════════════╩═══════════════╩═══════════════╝

FULL-FUNNEL ROI METRICS:
  ──────────────────────
  MQL → SQL rate: [%] (target: 15-25%)
  SQL → Opportunity rate: [%] (target: 40-60%)
  Opportunity → Closed Won rate: [%] (target: 25-40%)
  Overall Lead-to-Customer rate: [%] (target: 5-15%)
  CAC by channel: [$ per channel]
  LTV:CAC ratio: [X:1] (target: 3:1+)
  Payback period by channel: [X months per channel]
  Blended CAC: [$ amount]
  Blended LTV:CAC: [X:1]

Attribution Reporting

MONTHLY ATTRIBUTION REPORT
============================

EXECUTIVE SUMMARY:
  Total Revenue: [$ amount]
  Total Marketing + Sales Spend: [$ amount]
  Blended ROI: [X]%
  Blended CAC: [$ amount]
  New Customers: [count]
  Top 3 Revenue-Driving Channels: [list]
  Biggest Opportunity: [channel/insight]

CHANNEL PERFORMANCE RANKING:
  ╔═══╦═══════════════════════╦═══════════════╦═══════════════╦═══════════╗
  ║ # ║ Channel               ║ Revenue ($)   ║ ROI           ║ Trend     ║
  ╠═══╬═══════════════════════╬═══════════════╬═══════════════╬═══════════╣
  ║ 1 ║ [Channel name]        ║ [$ amount]    ║ [X]%          ║ [↑/→/↓]   ║
  ║ 2 ║ [Channel name]        ║ [$ amount]    ║ [X]%          ║ [↑/→/↓]   ║
  ║ 3 ║ [Channel name]        ║ [$ amount]    ║ [$ amount]    ║ [↑/→/↓]   ║
  ╚═══╩═══════════════════════╩═══════════════╩═══════════════╩═══════════╝

BUDGET RECOMMENDATIONS:
  ────────────────────
  Increase Budget (+):
    - [Channel]: [ROI]% with room to scale; recommend +[X]% budget
    - [Channel]: [ROI]% and under-utilized; recommend +[X]% budget
  
  Maintain Budget (→):
    - [Channel]: [ROI]% performing at target; maintain current spend
  
  Decrease Budget (-):
    - [Channel]: [ROI]% below target; recommend -[X]% budget
    - [Channel]: [ROI]% with diminishing returns; recommend -[X]% budget
  
  Reallocation Opportunity:
    - Shift [$ amount] from [underperforming channel] to [high-performing]
    - Projected ROI improvement: [X]% → [Y]%

BUYER JOURNEY INSIGHTS:
  ─────────────────────
  Average touchpoints per deal: [X]
  Average days from first touch to close: [X]
  Most common first touch: [channel]
  Most common last touch: [channel]
  Critical mid-funnel touch: [channel/activity]
  Touchpoints that never lead to close: [channels to investigate]

Edge Cases

Offline touchpoints: Phone calls, in-person meetings, referrals not tracked digitally
Mitigation: CRM activity logging for all offline interactions
Reps required to log call outcomes and meeting details in CRM
Use Gong/Chorus to capture call-based touchpoints automatically
Self-reported source on Opportunity creation ("How did you hear about us?")

Dark social: Shares via email, Slack, DMs that don't track referral source
Mitigation: UTM parameters on all shareable links
Branded short links for tracking (bit.ly with campaign tags)
Promotional codes for specific channels/people
Accept some untracked revenue; estimate dark social % based on surveys

Attribution window mismatch: Long sales cycles exceed standard attribution windows
Mitigation: Use 12-month attribution window for enterprise deals
Model-based attribution that doesn't rely on fixed windows
Separate reporting for short-cycle (SMB) and long-cycle (enterprise) deals
Track "influenced revenue" in addition to "attributed revenue"

Integration Points

Google Analytics 4: Web analytics, UTM tracking, conversion events
HubSpot/Salesforce: CRM touchpoint data, opportunity history
Attribution platforms (Tribaly, Rockerbox): Multi-touch attribution modeling
Marketing automation (Marketo, HubSpot): Campaign data, email tracking
Ad platforms (Google Ads, LinkedIn Ads, Meta): Ad spend and conversion data
Tableau/Looker: Attribution dashboards and reporting
Salesloft/Outreach: Sales activity data for attribution