关于 revenue-attribution
revenue-attribution 是一项分析营销与销售触点如何促成收入的技能。它应用并比较多触点归因模型,帮助 RevOps 和营销团队评估渠道并为预算决策提供依据。
主要功能
- 01讲解多触点归因模型
- 02计算触点的收入贡献
- 03比较渠道表现
- 04对比不同模型结果
- 05识别渠道投资回报率
适用场景
- 01向管理层说明营销支出
- 02评估营销活动投资回报
- 03比较多笔交易的渠道贡献
- 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 的工作 | 由你决定 |
|---|---|
| 解释归因模型 | 选择适合业务的模型 |
| 计算归属分配 | 如何根据洞察采取行动 |
| 找出表现最佳的渠道 | 预算重新分配的金额 |
| 展示模型对比 | 最终归因政策 |
| 指出差异 | 异常情况处理 |
此技能的功能
- 模型讲解 - 解释不同的归因方法
- 归属计算 - 将模型应用于触点数据
- 渠道分析 - 按来源比较表现
- 模型对比 - 展示不同模型下的结果差异
- 优化建议 - 指出应增加或减少投资的渠道
使用方法
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 交易构建归因分析(我会提供数据)。”
归因成熟度
- 基础:仅使用最后触点归因
- 中级:对比首次触点和最后触点
- 高级:基于位置的归因或自定义归因
- 专家:基于 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