mcpField
R
revenue-attribution

revenue-attribution

github.com/guia-matthieu营销与增长150204 次安装4 周前更新
代码仓库

关于 revenue-attribution

revenue-attribution 是一项分析营销与销售触点如何促成收入的技能。它应用并比较多触点归因模型,帮助 RevOps 和营销团队评估渠道并为预算决策提供依据。

主要功能

  1. 01讲解多触点归因模型
  2. 02计算触点的收入贡献
  3. 03比较渠道表现
  4. 04对比不同模型结果
  5. 05识别渠道投资回报率

适用场景

  1. 01向管理层说明营销支出
  2. 02评估营销活动投资回报
  3. 03比较多笔交易的渠道贡献
  4. 04编制归因报告

安装

复制下面的命令,在终端中运行。

$npx skills add https://github.com/guia-matthieu/clawfu-skills --skill revenue-attribution

安装后在 Claude Code 中输入/revenue-attribution确认已加载。

详细介绍

收入归因

使用多触点归因模型确定哪些营销和销售活动能够推动收入,从而更明智地分配预算并优化营销活动。

适用场景

  • 向管理层说明营销支出的合理性
  • 优化渠道组合分配
  • 评估营销活动的 ROI
  • 解决营销与销售之间的业绩归属争议
  • 构建归因报告

方法论基础

基于 Bizible/Marketo Multi-Touch Attribution 和 Google Analytics Attribution Models,涵盖:

  • 首次触点归因(认知度归属)
  • 最后触点归因(转化归属)
  • 线性归因(平均分配归属)
  • 时间衰减归因(按近期程度加权)
  • 基于位置的归因(U 型、W 型)

Claude 的工作与由你决定的事项

Claude 的工作由你决定
解释归因模型选择适合业务的模型
计算归属分配如何根据洞察采取行动
找出表现最佳的渠道预算重新分配的金额
展示模型对比最终归因政策
指出差异异常情况处理

此技能的功能

  1. 模型讲解 - 解释不同的归因方法
  2. 归属计算 - 将模型应用于触点数据
  3. 渠道分析 - 按来源比较表现
  4. 模型对比 - 展示不同模型下的结果差异
  5. 优化建议 - 指出应增加或减少投资的渠道

使用方法

Analyze attribution for this closed-won deal:

Deal: [Company Name]
Value: $[Amount]
Close Date: [Date]
Sales Cycle: [Days]

Touchpoint Journey:
1. [Date] - [Channel] - [Action]
2. [Date] - [Channel] - [Action]
...
[List all touchpoints chronologically]

Questions:
- Which channels deserve credit?
- Compare first-touch vs last-touch
- Recommend budget allocation

说明

步骤 1:了解归因模型
模型逻辑适用场景
首次触点100% 归于首次互动衡量认知度
最后触点100% 归于最终转化直接响应
线性在所有触点间平均分配考虑周期较长的决策
时间衰减将更多归属分配给近期触点有销售协助的客户旅程
基于位置40/20/40(首次/中间/最后)平衡视角
W 型30/30/30 + 剩余 10%纳入 MQL 阶段
步骤 2:梳理客户旅程

记录所有触点,包括:

  • 时间戳 - 触点发生的时间
  • 渠道 - 来源(付费、自然流量、电子邮件、活动等)
  • 行动 - 发生的事项(访问、下载、演示等)
  • 阶段 - 认知、考虑、决策
步骤 3:应用归因模型

首次触点示例:

Journey: Paid Search → Email → Webinar → Demo → Close
Revenue: $50,000

First-Touch Attribution:
- Paid Search: $50,000 (100%)
- All others: $0

线性示例:

Same journey, 4 touchpoints:
- Paid Search: $12,500 (25%)
- Email: $12,500 (25%)
- Webinar: $12,500 (25%)
- Demo: $12,500 (25%)

基于位置的归因(40/20/40):

- Paid Search: $20,000 (40% - first)
- Email: $5,000 (10% - middle)
- Webinar: $5,000 (10% - middle)
- Demo: $20,000 (40% - last)
步骤 4:按渠道汇总

汇总所有交易的归因结果,查看各渠道的总贡献:

Channel Performance (Position-Based):
- Paid Search: $500K attributed (35%)
- Events: $300K attributed (21%)
- Organic: $280K attributed (19%)
- Email: $220K attributed (15%)
- Referral: $150K attributed (10%)
步骤 5:计算各渠道的 ROI
Channel ROI = Attributed Revenue / Channel Spend

Example:
- Paid Search: $500K revenue / $100K spend = 5x ROI
- Events: $300K revenue / $200K spend = 1.5x ROI

示例

示例 1:交易级归因

输入:

Analyze attribution for TechStart Inc:

Deal: TechStart Inc
Value: $75,000 ARR
Close Date: March 15
Sales Cycle: 62 days

Touchpoint Journey:
1. Jan 12 - Google Ads - Clicked ad, visited pricing
2. Jan 15 - Organic Search - Blog post read
3. Jan 22 - LinkedIn Ad - Whitepaper download (MQL)
4. Feb 1 - Email nurture - Opened 3 emails
5. Feb 10 - Webinar - Attended "Product Demo Day"
6. Feb 18 - Direct - Requested demo (SQL)
7. Mar 5 - Sales - Discovery call
8. Mar 12 - Sales - Proposal review
9. Mar 15 - Direct - Signed contract

Compare first-touch, last-touch, and position-based.

输出:

## Attribution Analysis: TechStart Inc ($75,000)

### Journey Summary
- **Total Touchpoints**: 9
- **Marketing Touchpoints**: 6 (Jan 12 - Feb 18)
- **Sales Touchpoints**: 3 (Mar 5 - Mar 15)
- **Sales Cycle**: 62 days
- **Key Conversion**: LinkedIn whitepaper (MQL), Demo request (SQL)

### Model Comparison

| Channel | First-Touch | Last-Touch | Position-Based | Linear |
|---------|-------------|------------|----------------|--------|
| Google Ads | $75,000 | $0 | $22,500 | $8,333 |
| Organic Search | $0 | $0 | $3,750 | $8,333 |
| LinkedIn Ads | $0 | $0 | $7,500 | $8,333 |
| Email | $0 | $0 | $3,750 | $8,333 |
| Webinar | $0 | $0 | $3,750 | $8,333 |
| Direct (Demo) | $0 | $0 | $7,500 | $8,333 |
| Sales | $0 | $75,000 | $26,250 | $25,000 |

### Position-Based Breakdown (Recommended)

**First Touch (30%): $22,500**
- Google Ads gets full first-touch credit
- Drove initial awareness and pricing interest

**MQL Touch (30%): $22,500**
- LinkedIn Ads: $15,000 (whitepaper = MQL)
- Webinar: $7,500 (influenced SQL)

**Last Touch (30%): $22,500**
- Demo Request: $7,500
- Sales (Close): $15,000

**Middle Touches (10%): $7,500**
- Organic: $2,500
- Email: $2,500
- Other: $2,500

### Insights

1. **Google Ads** initiated the journey - valuable for awareness
2. **LinkedIn Ads** drove the MQL - critical conversion point
3. **Sales** closed but didn't initiate - last-touch overstates
4. **Email** nurtured but didn't convert alone - assist role

### Channel Recommendations

| Channel | Attribution | Action |
|---------|-------------|--------|
| Google Ads | High first-touch | Maintain/increase for awareness |
| LinkedIn Ads | High MQL driver | Invest more for lead gen |
| Webinar | Solid influence | Continue as mid-funnel |
| Email | Assist role | Optimize, don't cut |
示例 2:多笔交易的渠道分析

输入:

Analyze Q1 attribution across these closed deals:

Deal 1: $50K - Google Ads → Email → Demo → Close
Deal 2: $30K - Event → LinkedIn → Demo → Close
Deal 3: $80K - Referral → Demo → Close
Deal 4: $45K - Organic → Webinar → Email → Demo → Close
Deal 5: $25K - Google Ads → Event → Demo → Close

Total Q1 Revenue: $230K

Channel Spend:
- Google Ads: $15K
- Events: $25K
- LinkedIn: $8K
- Email: $3K
- Webinar: $5K
- Referral: $0

Which channels should we invest more in?

输出:

## Q1 Channel Attribution Analysis

### Total Revenue: $230,000

### Attribution by Model

#### Position-Based Attribution (40/20/40)

| Channel | First | Middle | Last | Total | % of Rev |
|---------|-------|--------|------|-------|----------|
| Google Ads | $30,000 | $2,500 | $0 | $32,500 | 14% |
| Events | $12,000 | $5,000 | $0 | $17,000 | 7% |
| LinkedIn | $0 | $6,000 | $0 | $6,000 | 3% |
| Email | $0 | $11,000 | $0 | $11,000 | 5% |
| Webinar | $0 | $9,000 | $0 | $9,000 | 4% |
| Referral | $32,000 | $0 | $0 | $32,000 | 14% |
| Demo | $0 | $0 | $30,500 | $30,500 | 13% |
| Sales/Close | $0 | $0 | $92,000 | $92,000 | 40% |

### ROI Analysis

| Channel | Attributed Rev | Spend | ROI |
|---------|----------------|-------|-----|
| Referral | $32,000 | $0 | ∞ (Best) |
| Google Ads | $32,500 | $15,000 | 2.2x |
| Webinar | $9,000 | $5,000 | 1.8x |
| LinkedIn | $6,000 | $8,000 | 0.75x |
| Events | $17,000 | $25,000 | 0.68x |
| Email | $11,000 | $3,000 | 3.7x |

### Efficiency Ranking

1. **🥇 Referral** - $0 cost, $32K attributed → Infinite ROI
2. **🥈 Email** - 3.7x ROI → High-value nurture
3. **🥉 Google Ads** - 2.2x ROI → Profitable acquisition
4. **Webinar** - 1.8x ROI → Solid mid-funnel
5. **LinkedIn** - 0.75x ROI → Below break-even
6. **Events** - 0.68x ROI → Expensive for return

### Recommendations

**Increase Investment:**
- **Referral Program**: 14% of revenue at $0 cost
  - Formalize referral rewards
  - Target: 2x referral deals in Q2

- **Email Nurture**: 3.7x ROI
  - Expand sequences
  - Add $2K budget for tools

- **Google Ads**: 2.2x ROI
  - Profitable, test 20% budget increase
  - Focus on high-intent keywords

**Optimize/Test:**
- **LinkedIn**: 0.75x is below target
  - Test new audiences before cutting
  - Could be essential for certain segments

**Reduce/Reallocate:**
- **Events**: $25K for $17K attributed
  - Evaluate which events drive pipeline
  - Consider smaller, targeted events
  - Reallocate $10K to Google Ads

### Proposed Q2 Budget Shift

| Channel | Q1 Spend | Q2 Proposed | Change |
|---------|----------|-------------|--------|
| Google Ads | $15K | $20K | +$5K |
| Events | $25K | $15K | -$10K |
| LinkedIn | $8K | $8K | — |
| Email | $3K | $5K | +$2K |
| Webinar | $5K | $6K | +$1K |
| Referral | $0 | $2K (rewards) | +$2K |
| **Total** | **$56K** | **$56K** | Rebalanced |

技能边界

此技能擅长的工作
  • 解释归因模型的运作机制
  • 计算各触点的归属
  • 并排比较不同模型
  • 识别渠道效率
此技能无法完成的工作
  • 访问实际的 CRM/分析数据
  • 自动追踪线下触点
  • 计入品牌提升效果
  • 证明因果关系(只能证明相关性)
需要升级至人工处理的情况
  • 为公司选择正式的归因模型
  • 预算分配决策超过 $50K
  • 涉及多位利益相关者的复杂 B2B 客户旅程
  • 对账不同系统中的归因结果

迭代指南

后续提示词
  • “如果使用时间衰减模型,结果会如何变化?”
  • “如果排除销售触点,会怎样?”
  • “按交易规模展示渠道表现。”
  • “为所有 Q1 交易构建归因分析(我会提供数据)。”
归因成熟度
  1. 基础:仅使用最后触点归因
  2. 中级:对比首次触点和最后触点
  3. 高级:基于位置的归因或自定义归因
  4. 专家:基于 ML 的算法归因

检查清单与模板

归因报告模板
## Attribution Report: [Period]

### Summary
- Total Revenue: $X
- Deals Analyzed: X
- Model Used: [Position-Based]

### Channel Attribution
| Channel | Revenue | % | ROI |
|---------|---------|---|-----|

### Top Insights
1.
2.
3.

### Budget Recommendations
| Channel | Current | Recommended | Rationale |
|---------|---------|-------------|-----------|
触点追踪清单
  • 所有营销活动均包含 UTM 参数
  • CRM 已与营销自动化系统同步
  • 手动记录线下事件
  • 为销售活动添加时间戳
  • 追踪内容下载

参考资料

  • Bizible 多触点归因指南
  • Google Analytics 归因建模
  • Forrester B2B 归因研究
  • Marketo 收入周期分析

相关技能

  • pipeline-forecasting - 按来源预测收入
  • lead-scoring - 按归因渠道评分
  • ad-spend-optimizer - 自动调整预算

技能元数据

  • 领域:RevOps
  • 复杂度:高级
  • 模式:centaur
  • 价值实现时间:分析需 30-60 分钟
  • 前置条件:触点数据、交易金额、渠道支出

评论

支持 Markdown