sales-operations by borghei/claude-skills
npx skills add https://github.com/borghei/claude-skills --skill sales-operations专家级销售运营,致力于收入优化。
┌─────────────────────────────────────────────────────────────┐
│ 销售业绩 - [期间] │
├─────────────────────────────────────────────────────────────┤
│ 收入 销售漏斗 赢单率 销售周期 │
│ $2.4M $8.2M 28% 45 天 │
│ 对比配额: 102% 覆盖率: 3.4x 对比上季: +3% 对比上季: -5天│
├─────────────────────────────────────────────────────────────┤
│ 按阶段划分的销售漏斗 │
│ 潜在客户: $1.2M (15%) ████ │
│ 发现阶段: $2.1M (26%) ███████ │
│ 演示阶段: $2.8M (34%) █████████ │
│ 提案阶段: $1.5M (18%) █████ │
│ 谈判阶段: $0.6M (7%) ██ │
├─────────────────────────────────────────────────────────────┤
│ 销售代表表现 │
│ 代表 A: $520K (115%) 代表 B: $480K (107%) 代表 C: $420K (93%)│
└─────────────────────────────────────────────────────────────┘
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
活动指标:
| 指标 | 公式 | 目标 |
|---|---|---|
| 每日通话数 | 总通话数 / 天数 | 50+ |
| 每周会议数 | 总会议数 / 周数 | 15+ |
| 每月提案数 | 总提案数 / 月数 | 8+ |
销售漏斗指标:
| 指标 | 公式 | 目标 |
|---|---|---|
| 漏斗覆盖率 | 销售漏斗总额 / 配额 | 3倍以上 |
| 漏斗流速 | 赢单数 / 平均销售周期 | - |
| 阶段转化率 | 阶段 N+1 的数量 / 阶段 N 的数量 | 因阶段而异 |
结果指标:
| 指标 | 公式 | 目标 |
|---|---|---|
| 赢单率 | 赢单数 / (赢单数 + 输单数) | 25%以上 |
| 平均交易规模 | 收入 / 交易数 | $[X] |
| 销售周期 | 平均成交天数 | <60 |
| 配额达成率 | 实际完成 / 配额 | 100%以上 |
平衡性:
覆盖性:
增长性:
# 区域计划: [区域/细分市场]
## 概览
- 总客户数: [数量]
- 总年度经常性收入潜力: $[金额]
- 销售代表数量: [数量]
## 区域分配
### 区域 1: [名称]
- 销售代表: [姓名]
- 客户数: [数量]
- 年度经常性收入潜力: $[金额]
- 指定客户: [列表]
- 地理覆盖范围: [区域]
### 区域 2: [名称]
...
## 按区域划分的指标
| 区域 | 客户数 | 潜力 | 配额 | 覆盖率 |
|-----------|----------|-----------|-------|----------|
| [T1] | X | $Y | $Z | W% |
## 参与规则
- 客户所有权: [规则]
- 线索分配: [规则]
- 分成: [规则]
def score_account(account):
"""
为区域分配和优先级排序对客户进行评分
"""
score = 0
# 公司规模 (0-30 分)
if account['employees'] > 5000:
score += 30
elif account['employees'] > 1000:
score += 20
elif account['employees'] > 200:
score += 10
# 行业契合度 (0-25 分)
if account['industry'] in ['Technology', 'Finance']:
score += 25
elif account['industry'] in ['Healthcare', 'Manufacturing']:
score += 15
# 互动参与度 (0-25 分)
if account['website_visits'] > 10:
score += 15
if account['content_downloads'] > 0:
score += 10
# 意向信号 (0-20 分)
if account['intent_score'] > 80:
score += 20
elif account['intent_score'] > 50:
score += 10
return score
自上而下法:
公司收入目标: $50M
├── 增长率: 30%
├── 团队容量: 20 名销售代表
├── 平均配额: $2.5M
└── 调整: 根据区域 ±20%
自下而上法:
客户潜力分析:
├── 现有客户: $30M
├── 销售漏斗价值: $15M
├── 新客户潜力: $10M
├── 总计: $55M
└── 风险调整: -10%
最终: $49.5M
| 销售代表 | 区域潜力 | 历史表现 | 适应期 | 最终配额 |
|---|---|---|---|---|
| 代表 A | $3M | 110% | 完全 | $2.7M |
| 代表 B | $2.8M | 95% | 完全 | $2.4M |
| 代表 C | $2.5M | 不适用 | 50% | $1.2M |
目标总薪酬 (OTE)
├── 基本工资: 50-60%
└── 可变薪酬: 40-50%
├── 佣金: 80%
│ ├── 新业务: 60%
│ └── 扩展业务: 40%
└── 奖金: 20%
├── 季度加速器
└── 特别销售激励计划
佣金率
├── 0-50% 配额达成: 0.5倍 基准率
├── 50-100% 配额达成: 1倍 基准率
├── 100-150% 配额达成: 1.5倍 基准率
└── 150%+ 配额达成: 2倍 基准率
# 销售薪酬计划: [职位]
## 计划概览
- 职位: [职位名称]
- 目标总薪酬: $[金额]
- 基本工资/可变薪酬比例: [X/Y]%
- 支付周期: [频率]
## 佣金结构
### 新业务
- 费率: 年度合同价值的 [X]%
- 加速器:
- 100-120%: 1.2倍 乘数
- 120%+: 1.5倍 乘数
### 续约/扩展业务
- 费率: 年度合同价值的 [Y]%
- 扩展业务: 与新业务相同
- 续约业务: 降低的费率
## 配额
- 年度: $[金额]
- 季度: $[金额]
- 适应期配额: [如适用]
## 支付条款
- 佣金支付时间: [时间]
- 追回期: [时长]
- 预支佣金: [如适用]
## 特别激励
- [特别销售激励计划 1]: [详情]
- [特别销售激励计划 2]: [详情]
| 类别 | 定义 | 权重 |
|---|---|---|
| 已关闭 | 已签署合同 | 100% |
| 承诺 | 口头承诺,高置信度 | 90% |
| 最佳情况 | 强有力机会,很可能成交 | 50% |
| 销售漏斗 | 活跃机会 | 20% |
| 上升空间 | 早期阶段 | 5% |
┌─────────────────────────────────────────────────────────────┐
│ 第四季度预测 - 第 8 周 │
├─────────────────────────────────────────────────────────────┤
│ 配额: $10M │
│ │
│ 类别 交易数 金额 加权金额 │
│ 已关闭 12 $2.4M $2.4M │
│ 承诺 8 $1.8M $1.6M │
│ 最佳情况 15 $3.2M $1.6M │
│ 销售漏斗 22 $4.5M $0.9M │
│ ───────────────────────────────────────────── │
│ 加权总计 $11.9M $6.5M │
├─────────────────────────────────────────────────────────────┤
│ 预测: $4.0M (已关闭 + 承诺) │
│ 上升空间: $5.6M (包含最佳情况) │
│ 与配额的差距: $6.0M │
│ 销售漏斗所需的赢单率: 35% │
└─────────────────────────────────────────────────────────────┘
阶段分析
├── 各阶段平均停留时间
├── 转化率
├── 流失原因
└── 瓶颈识别
活动分析
├── 各阶段活动
├── 活动与结果比率
├── 时间分配
└── 最佳销售代表实践
工具使用情况
├── CRM 采用率
├── 功能使用情况
├── 数据质量
└── 自动化机会
数据质量检查:
references/analytics.md - 销售分析指南references/territory.md - 区域规划references/compensation.md - 薪酬设计原则references/forecasting.md - 预测方法# 销售漏斗分析器
python scripts/pipeline_analyzer.py --data opportunities.csv
# 区域优化器
python scripts/territory_optimizer.py --accounts accounts.csv --reps 10
# 配额计算器
python scripts/quota_calculator.py --target 50000000 --reps team.csv
# 预测报告器
python scripts/forecast_report.py --quarter Q4 --output report.html
每周安装量
94
代码仓库
GitHub 星标数
29
首次出现
2026年1月24日
安全审计
安装于
opencode71
claude-code70
codex67
gemini-cli67
cursor64
github-copilot59
Expert-level sales operations for revenue optimization.
┌─────────────────────────────────────────────────────────────┐
│ Sales Performance - [Period] │
├─────────────────────────────────────────────────────────────┤
│ Revenue Pipeline Win Rate Cycle Time │
│ $2.4M $8.2M 28% 45 days │
│ vs Quota: 102% Coverage: 3.4x vs LQ: +3% vs LQ: -5d │
├─────────────────────────────────────────────────────────────┤
│ PIPELINE BY STAGE │
│ Prospect: $1.2M (15%) ████ │
│ Discovery: $2.1M (26%) ███████ │
│ Demo: $2.8M (34%) █████████ │
│ Proposal: $1.5M (18%) █████ │
│ Negotiation: $0.6M (7%) ██ │
├─────────────────────────────────────────────────────────────┤
│ REP PERFORMANCE │
│ Rep A: $520K (115%) Rep B: $480K (107%) Rep C: $420K (93%)│
└─────────────────────────────────────────────────────────────┘
Activity Metrics:
| Metric | Formula | Target |
|---|---|---|
| Calls/Day | Total calls / Days | 50+ |
| Meetings/Week | Total meetings / Weeks | 15+ |
| Proposals/Month | Total proposals / Months | 8+ |
Pipeline Metrics:
| Metric | Formula | Target |
|---|---|---|
| Pipeline Coverage | Pipeline / Quota | 3x+ |
| Pipeline Velocity | Won Deals / Avg Cycle Time | - |
| Stage Conversion | Stage N+1 / Stage N | Varies |
Outcome Metrics:
| Metric | Formula | Target |
|---|---|---|
| Win Rate | Won / (Won + Lost) | 25%+ |
| Average Deal Size | Revenue / Deals | $[X] |
| Sales Cycle | Avg days to close | <60 |
| Quota Attainment | Actual / Quota | 100%+ |
Balance:
Coverage:
Growth:
# Territory Plan: [Region/Segment]
## Overview
- Total accounts: [Number]
- Total ARR potential: $[Amount]
- Rep count: [Number]
## Territory Assignment
### Territory 1: [Name]
- Rep: [Name]
- Accounts: [Number]
- ARR Potential: $[Amount]
- Named accounts: [List]
- Geographic coverage: [Area]
### Territory 2: [Name]
...
## Metrics by Territory
| Territory | Accounts | Potential | Quota | Coverage |
|-----------|----------|-----------|-------|----------|
| [T1] | X | $Y | $Z | W% |
## Rules of Engagement
- Account ownership: [Rules]
- Lead routing: [Rules]
- Splits: [Rules]
def score_account(account):
"""
Score accounts for territory assignment and prioritization
"""
score = 0
# Company size (0-30 points)
if account['employees'] > 5000:
score += 30
elif account['employees'] > 1000:
score += 20
elif account['employees'] > 200:
score += 10
# Industry fit (0-25 points)
if account['industry'] in ['Technology', 'Finance']:
score += 25
elif account['industry'] in ['Healthcare', 'Manufacturing']:
score += 15
# Engagement (0-25 points)
if account['website_visits'] > 10:
score += 15
if account['content_downloads'] > 0:
score += 10
# Intent signals (0-20 points)
if account['intent_score'] > 80:
score += 20
elif account['intent_score'] > 50:
score += 10
return score
Top-Down:
Company Revenue Target: $50M
├── Growth Rate: 30%
├── Team Capacity: 20 reps
├── Average Quota: $2.5M
└── Adjustments: ±20% based on territory
Bottom-Up:
Account Potential Analysis:
├── Existing accounts: $30M
├── Pipeline value: $15M
├── New logo potential: $10M
├── Total: $55M
└── Risk adjustment: -10%
Final: $49.5M
| Rep | Territory Potential | Historical | Ramp | Final Quota |
|---|---|---|---|---|
| Rep A | $3M | 110% | Full | $2.7M |
| Rep B | $2.8M | 95% | Full | $2.4M |
| Rep C | $2.5M | N/A | 50% | $1.2M |
TOTAL ON-TARGET EARNINGS (OTE)
├── Base Salary: 50-60%
└── Variable: 40-50%
├── Commission: 80%
│ ├── New Business: 60%
│ └── Expansion: 40%
└── Bonus: 20%
├── Quarterly accelerators
└── SPIFs
COMMISSION RATE
├── 0-50% quota: 0.5x rate
├── 50-100% quota: 1x rate
├── 100-150% quota: 1.5x rate
└── 150%+ quota: 2x rate
# Sales Compensation Plan: [Role]
## Plan Overview
- Role: [Role Name]
- OTE: $[Amount]
- Base/Variable Split: [X/Y]%
- Pay Period: [Frequency]
## Commission Structure
### New Business
- Rate: [X]% of ACV
- Accelerators:
- 100-120%: 1.2x multiplier
- 120%+: 1.5x multiplier
### Renewal/Expansion
- Rate: [Y]% of ACV
- Expansion: Same as new business
- Renewal: Reduced rate
## Quota
- Annual: $[Amount]
- Quarterly: $[Amount]
- Ramped: [If applicable]
## Payment Terms
- Commission paid: [Timing]
- Clawback period: [Duration]
- Draw: [If applicable]
## Special Incentives
- [SPIF 1]: [Details]
- [SPIF 2]: [Details]
| Category | Definition | Weighting |
|---|---|---|
| Closed | Signed contract | 100% |
| Commit | Verbal commit, high confidence | 90% |
| Best Case | Strong opportunity, likely to close | 50% |
| Pipeline | Active opportunity | 20% |
| Upside | Early stage | 5% |
┌─────────────────────────────────────────────────────────────┐
│ Q4 Forecast - Week 8 │
├─────────────────────────────────────────────────────────────┤
│ Quota: $10M │
│ │
│ Category Deals Amount Weighted │
│ Closed 12 $2.4M $2.4M │
│ Commit 8 $1.8M $1.6M │
│ Best Case 15 $3.2M $1.6M │
│ Pipeline 22 $4.5M $0.9M │
│ ───────────────────────────────────────────── │
│ Weighted Total $11.9M $6.5M │
├─────────────────────────────────────────────────────────────┤
│ Forecast: $4.0M (Closed + Commit) │
│ Upside: $5.6M (with Best Case) │
│ Gap to Quota: $6.0M │
│ Required Win Rate on Pipeline: 35% │
└─────────────────────────────────────────────────────────────┘
STAGE ANALYSIS
├── Average time in stage
├── Conversion rate
├── Drop-off reasons
└── Bottleneck identification
ACTIVITY ANALYSIS
├── Activities per stage
├── Activity to outcome ratio
├── Time allocation
└── Best rep practices
TOOL UTILIZATION
├── CRM adoption
├── Feature usage
├── Data quality
└── Automation opportunities
Data Quality Checks:
references/analytics.md - Sales analytics guidereferences/territory.md - Territory planningreferences/compensation.md - Comp design principlesreferences/forecasting.md - Forecasting methodology# Pipeline analyzer
python scripts/pipeline_analyzer.py --data opportunities.csv
# Territory optimizer
python scripts/territory_optimizer.py --accounts accounts.csv --reps 10
# Quota calculator
python scripts/quota_calculator.py --target 50000000 --reps team.csv
# Forecast reporter
python scripts/forecast_report.py --quarter Q4 --output report.html
Weekly Installs
94
Repository
GitHub Stars
29
First Seen
Jan 24, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
opencode71
claude-code70
codex67
gemini-cli67
cursor64
github-copilot59
Excel财务建模规范与xlsx文件处理指南:专业格式、零错误公式与数据分析
44,500 周安装