What Are Sales KPIs?什么是 Sales KPIs?
Sales KPIs are a deliberately small set of measurements used to judge progress toward defined sales objectives and trigger a named decision or action. A useful KPI has a written formula, governed source, owner, target, scope, review cadence, diagnostic context, and response when performance moves outside an agreed range. Every KPI is a metric, but a metric becomes “key” only when it is material to an objective and actively managed.
Sales KPIs 是一组经过刻意筛选的少量衡量指标,用于判断明确销售目标的进展,并触发指定决策或行动。有效 KPI 应具备书面公式、受治理数据源、负责人、目标、范围、复核节奏、诊断背景,以及当表现超出约定范围时的响应措施。每个 KPI 都是指标,但只有与目标实质相关且被主动管理的指标才是“关键”指标。
This metric-and-template page helps teams select and operationalize a scorecard. It does not repeat the complete taxonomy, warehouse modeling, and metric-contract methodology in the sales metrics guide. It also excludes dashboard software selection, which belongs on the planned sales performance dashboard page.
本指标与模板页帮助团队选择并落地记分卡,不重复销售指标指南中的完整分类、Warehouse 建模和指标契约方法,也不覆盖 Dashboard 软件选型;后者属于规划中的 Sales Performance Dashboard 页面。
Build a Balanced Sales KPI System建立均衡的 Sales KPI 体系
A scorecard should connect five layers rather than optimize one number in isolation: controllable activity quality, qualified pipeline supply, conversion and speed, forecast control, and realized commercial outcomes. Outcomes tell you whether the objective was achieved; upstream indicators help you act before the period is over. Guardrails prevent a local improvement from damaging deal quality, margin, retention, or data integrity.
记分卡应连接五个层次,而不是孤立优化单一数字:可控制的活动质量、合格 Pipeline 供给、转化与速度、预测控制以及已实现商业结果。结果指标说明目标是否达成,上游指标帮助团队在期间结束前采取行动;护栏则防止局部改善损害交易质量、利润、留存或数据完整性。
Qualified pipeline created, stage progression, aging, activity-to-opportunity conversion, and forecast movement can change before final revenue is known.
合格 Pipeline 新增、阶段推进、老化、活动到商机转化及预测变化会在最终收入确定前发生。
Bookings, revenue, win rate, average deal size, growth, and quota attainment confirm what a mature cohort or period produced.
Bookings、Revenue、Win Rate、Average Deal Size、增长率与 Quota Attainment 用于确认成熟队列或期间最终产生的结果。
15 Sales KPIs, Definitions, and Formulas15项 Sales KPIs:定义与公式
| KPIKPI | Controlled formula or definition受控公式或定义 | Primary decision主要决策 |
|---|---|---|
| 1. Quota attainment1. Quota 达成率 | Credited performance ÷ effective quota × 100计入绩效 ÷ 有效 Quota × 100 | Target progress by eligible rep, team, and period按合格销售、团队与期间判断目标进展 |
| 2. Bookings or revenue attainment2. 签约额或收入达成率 | Governed actual ÷ matched target × 100; never mix bookings and recognized revenue受治理实际值 ÷ 匹配目标 × 100;不得混用签约额与确认收入 | Company or segment outcome control公司或分群结果控制 |
| 3. Sales growth rate3. 销售增长率 | (Current comparable value − prior value) ÷ prior value × 100(当前可比值 − 前期值)÷ 前期值 × 100 | Trend versus a comparable period与可比期间比较趋势 |
| 4. Qualified pipeline created4. 新增合格 Pipeline | Count or value of opportunities whose qualification event occurred in the reporting window报告窗口内发生资格确认事件的商机数量或金额 | Future supply versus target need未来供给与目标需求比较 |
| 5. Pipeline coverage ratio5. Pipeline 覆盖率 | Eligible open pipeline for the target period ÷ remaining target目标期间合格进行中 Pipeline ÷ 剩余目标 | Whether supply is sufficient under stated assumptions在明确假设下判断供给是否充足 |
| 6. Stage conversion rate6. 阶段转化率 | Distinct opportunities reaching the defined next stage ÷ starting-stage entry cohort × 100到达指定下一阶段的独立商机数 ÷ 起始阶段进入队列 × 100 | Locate a pipeline gate with concentrated loss定位损失集中的 Pipeline 门槛 |
| 7. Win rate7. 赢单率 | Closed-won opportunities ÷ eligible closed cohort × 100; label count or value weightingClosed-Won 商机 ÷ 合格关闭队列 × 100;注明按数量或金额加权 | Outcome quality for comparable opportunities可比商机的结果质量 |
| 8. Average deal size8. 平均交易金额 | Governed won amount ÷ closed-won opportunity count受治理赢单金额 ÷ Closed-Won 商机数 | Mix, pricing, and capacity assumptions组合、定价与产能假设 |
| 9. Sales cycle length9. 销售周期长度 | Close timestamp − defined start timestamp; report median and percentiles as well as mean关闭时间 − 定义起始时间;除均值外报告中位数与分位数 | Cycle delay and capacity planning周期延迟与产能规划 |
| 10. Sales velocity10. Sales Velocity | Qualified opportunities × average deal value × win rate ÷ average sales-cycle length合格商机数 × 平均交易金额 × 赢单率 ÷ 平均销售周期 | Value flow per consistent time unit每个一致时间单位的价值流 |
| 11. Forecast error and bias11. 预测误差与偏差 | Forecast − governed actual; report signed and absolute error by cutoff and horizon预测值 − 受治理实际值;按截止点与预测期报告有符号和绝对误差 | Forecast reliability and systematic over- or under-forecasting预测可靠性及系统性高估或低估 |
| 12. Slippage rate12. 延期率 | Eligible opportunities moved beyond the target period ÷ starting open cohort × 100移出目标期间的合格商机数 ÷ 期初进行中队列 × 100 | Timing risk hidden by open pipeline value进行中 Pipeline 金额掩盖的时间风险 |
| 13. Activity-to-opportunity conversion13. 活动到商机转化率 | Qualified opportunities created ÷ eligible accepted contacts or leads × 100新增合格商机数 ÷ 合格已接受联系人或 Leads × 100 | Prospecting quality rather than activity volume alone衡量 Prospecting 质量而非仅活动数量 |
| 14. Rep ramp time14. 销售人员 Ramp 时间 | Date a defined sustained productivity threshold is reached − eligible start date达到定义持续生产力门槛的日期 − 合格起始日期 | Hiring, enablement, and capacity timing招聘、赋能与产能时间 |
| 15. Revenue per selling FTE15. 每销售 FTE 收入 | Governed revenue for the period ÷ average eligible selling full-time equivalents期间受治理收入 ÷ 平均合格销售全职当量 | Productivity trend with role and ramp controls控制角色与 Ramp 后的生产力趋势 |
These formulas are templates, not complete semantic definitions. Each still needs an eligibility rule, time basis, currency policy, owner, exclusions, treatment of reopened records, and source-of-truth field. Follow the dedicated sales velocity formula guide where that composite KPI is used.
这些公式只是模板,并非完整语义定义。每项仍需明确合格规则、时间口径、币种政策、负责人、排除项、重新开启记录处理方式与事实来源字段。使用该复合 KPI 时,可参阅专门的 Sales Velocity 公式指南。
How to Choose the Right Sales KPIs如何选择合适的 Sales KPIs
- Start with one decision.从一个决策开始。
Name the objective, accountable role, decision, deadline, and consequence of inaction. “Improve sales” is not specific enough.
明确目标、责任角色、决策、截止时间与不行动后果。“提升销售”不够具体。
- Choose one or two outcome KPIs.选择一到两个结果 KPI。
Use the metric that directly confirms the objective, such as qualified bookings attainment—not a convenient proxy.
使用直接确认目标的指标,例如合格签约额达成率,而不是方便但间接的代理指标。
- Map controllable drivers.映射可控制驱动因素。
Select two to four upstream indicators with a plausible, testable relationship to the outcome and enough time to act.
选择两到四个与结果具有可检验合理关系、且仍留有行动时间的上游指标。
- Add guardrails.增加护栏。
Monitor quality, margin, aging, retention, or data completeness when optimizing a primary KPI could create harmful behavior.
当优化主 KPI 可能产生有害行为时,监控质量、利润、老化、留存或数据完整性。
- Remove unactionable measures.删除不可行动指标。
Move useful diagnostics to drill-down reports. A scorecard is not an inventory of every available field.
把有用诊断项移入下钻报告。记分卡不是所有可用字段的清单。
Sales KPI Definition TemplateSales KPI 定义模板
Create one version-controlled record for each KPI before placing it on a scorecard. Copy these fields into a spreadsheet, analytics catalog, or governance document:
在把 KPI 放入记分卡前,为每项指标建立一条可版本控制的记录。可将以下字段复制到电子表格、分析目录或治理文档:
- Purpose: objective, decision, owner, audience, and action threshold.目的:目标、决策、负责人、受众与行动阈值。
- Formula: numerator, denominator, aggregation, weighting, unit, currency, and rounding.公式:分子、分母、汇总、加权、单位、币种与舍入。
- Population: entity grain, eligible cohort, segments, exclusions, and reopened-record policy.总体:实体粒度、合格队列、分群、排除项与重新开启记录政策。
- Time: event date, fiscal calendar, timezone, observation window, maturity rule, and snapshot cutoff.时间:事件日期、财务日历、时区、观察窗口、成熟规则与快照截止点。
- Data: source systems, fields, joins, owner, refresh schedule, reconciliation, and quality test.数据:源系统、字段、关联、负责人、刷新计划、对账与质量测试。
- Governance: baseline, target, effective date, review cadence, alert range, guardrail, and change history.治理:基线、目标、生效日期、复核节奏、预警范围、护栏与变更历史。
Sales KPI Scorecard Template by Role按角色划分的 Sales KPI 记分卡模板
| Role角色 | Compact scorecard精简记分卡 | Review and action复核与行动 |
|---|---|---|
| SDR / BDRSDR / BDR | Accepted contacts, activity-to-opportunity conversion, qualified pipeline created, speed to first qualified response已接受联系人、活动到商机转化、新增合格 Pipeline、首次合格响应速度 | Weekly coaching on list, message, qualification, and handoff quality每周针对名单、信息、资格确认与交接质量进行辅导 |
| Account executiveAccount Executive | Quota attainment, qualified pipeline created, stage conversion, aging, win rate, cycle length, forecast movementQuota 达成、新增合格 Pipeline、阶段转化、老化、赢单率、周期长度、预测变化 | Weekly deal and pipeline review; monthly cohort review每周交易与 Pipeline 复核;每月队列复核 |
| Sales manager销售经理 | Team attainment, coverage, conversion, slippage, forecast bias, rep ramp, data completeness团队达成、覆盖率、转化、延期、预测偏差、销售 Ramp、数据完整性 | Weekly capacity and risk actions; monthly process and coaching decisions每周产能与风险行动;每月流程与辅导决策 |
| Revenue leadership收入管理层 | Bookings or revenue attainment, growth, coverage, win rate, velocity, forecast error, productivity签约额或收入达成、增长、覆盖率、赢单率、Velocity、预测误差、生产力 | Monthly and quarterly resource, target, territory, and investment decisions每月和每季度进行资源、目标、区域与投资决策 |
Do not use a single ranking scorecard for every role. An SDR should not own recognized revenue timing, and an account executive should not be penalized for inherited territory capacity without adjustment. Preserve shared outcome visibility while assigning only controllable KPIs to performance management.
不要为所有角色使用同一排名记分卡。SDR 不应负责确认收入时间,Account Executive 也不应在未调整的情况下因继承区域产能受到惩罚。可以共享结果可见性,但绩效管理只应分配可控制 KPI。
Set Sales KPI Targets Without False Benchmarks设定 Sales KPI 目标并避免虚假基准
An external benchmark is context, not a target. Sales motion, market, product maturity, territory potential, source mix, deal size, accounting policy, and definition choices can make two identically named KPIs incomparable. Start with a reconciled internal baseline by segment, model the capacity and conversion changes required by the plan, then set a target range and review date. Record which assumptions are controllable.
外部基准只是背景,不是目标。销售模式、市场、产品成熟度、区域潜力、来源组合、交易规模、会计政策与定义选择,都可能使两个同名 KPI 无法比较。应先建立按分群对账的内部基线,再建模计划所需的产能与转化变化,随后设置目标范围和复核日期,并记录哪些假设可控制。
Target rule: store baseline, target, effective period, owner, model assumptions, confidence or tolerance range, and guardrails together. A target without its definition and capacity model is only a number.
目标规则:把基线、目标、生效期间、负责人、模型假设、置信或容忍范围及护栏共同保存。缺少定义与产能模型的目标只是一个数字。
Worked Example: From Revenue Target to Weekly KPIs示例:从收入目标拆解到每周 KPI
Hypothetical example: all figures illustrate the method and are not a benchmark, forecast, or customer result.
假设示例:所有数字仅用于说明方法,不是基准、预测或客户结果。
A team has a quarterly new-bookings target of $2.4 million and $600,000 already closed, leaving $1.8 million. It has $5.4 million of eligible open pipeline for the quarter, so current coverage against the remaining target is 5.4 ÷ 1.8 = 3.0. Historical mature cohorts in the same segment show a 25% amount-weighted win rate, which would imply $1.35 million from that open population before timing or deal-specific adjustments.
某团队季度新增签约额目标为 240 万美元,已完成 60 万美元,剩余 180 万美元。该季度合格进行中 Pipeline 为 540 万美元,因此相对剩余目标的当前覆盖率为 5.4 ÷ 1.8 = 3.0。同分群成熟历史队列显示金额加权赢单率为 25%,在考虑时间或交易特定调整前,该进行中总体隐含约 135 万美元结果。
The scorecard should not conclude that “3× coverage is enough.” It exposes a modeled gap of $450,000, then asks whether more qualified pipeline can mature in time, conversion can improve without weakening qualification, slippage can be reduced, or the forecast should be revised. Weekly leading KPIs become qualified pipeline created, late-stage slippage, and stage progression; guardrails include opportunity quality and discount. Quarterly outcomes remain bookings attainment and win rate.
记分卡不能因此断言“3倍覆盖足够”。它应暴露 45 万美元的模型缺口,再判断能否及时增加成熟合格 Pipeline、在不削弱资格标准的情况下提升转化、减少延期,或是否需要调整预测。每周领先 KPI 变为新增合格 Pipeline、后期延期与阶段推进;护栏包括商机质量与折扣。季度结果仍为签约额达成率与赢单率。
Match Each KPI to a Review Cadence让每项 KPI 匹配复核节奏
| Cadence节奏 | Use用途 | Avoid避免事项 |
|---|---|---|
| Daily每日 | Operational exceptions, response queues, missing required fields, urgent deal events运营异常、响应队列、必填字段缺失、紧急交易事件 | Judging immature win rate or revenue trend判断未成熟的赢单率或收入趋势 |
| Weekly每周 | Pipeline creation, aging, progression, slippage, forecast movement, and assigned actionsPipeline 新增、老化、推进、延期、预测变化与分配行动 | Changing targets after every noisy movement因每次噪声变化而修改目标 |
| Monthly每月 | Mature cohort conversion, win rate, cycle, productivity, mix, and coaching patterns成熟队列转化、赢单率、周期、生产力、组合与辅导模式 | Comparing teams without territory and role controls缺少区域与角色控制时比较团队 |
| Quarterly每季度 | Attainment, growth, capacity, target quality, metric relevance, and definition changes达成、增长、产能、目标质量、指标相关性与定义变化 | Rewriting history after governance changes治理变化后重写历史 |
Data Required for Reliable Sales KPIs可靠 Sales KPIs 所需数据
CRM current state is not enough for most flow and forecast KPIs. Preserve opportunity stage events or point-in-time snapshots, amount and close-date changes, owners, forecast categories, activities, and outcomes. Join effective-dated quotas, territories, role and employment history, product and price data, and governed booking or revenue actuals. Use stable identifiers and record source timestamps.
对于大多数流动与预测 KPI,仅有 CRM 当前状态并不足够。应保留商机阶段事件或时点快照、金额和成交日期变化、负责人、预测类别、活动与结果,并关联带生效日期的 Quota、区域、角色与雇佣历史、产品和价格数据,以及受治理签约或收入实际值。应使用稳定标识符并记录来源时间戳。
Reconcile totals before interpreting rates: won amounts to the approved bookings source, recognized revenue to finance, active rep counts to effective employment dates, and quota to the matching period and currency. A visually polished KPI based on unmatched grains is not reliable.
解释比率前应先对账总量:赢单金额与批准的 Bookings 来源、确认收入与财务、在职销售人数与生效雇佣日期、Quota 与匹配期间和币种进行核对。基于不匹配粒度的精美 KPI 并不可靠。
Validate a Sales KPI Before Publishing It发布前验证 Sales KPI
- Reconcile: tie numerator and denominator totals to approved source reports for selected periods.对账:将所选期间的分子与分母总量和批准来源报告核对。
- Trace: sample records from the displayed result back to CRM, quota, billing, or warehouse rows.追溯:从展示结果抽样追溯到 CRM、Quota、Billing 或 Warehouse 记录。
- Test boundaries: inspect zero denominators, missing dates, duplicate IDs, reopened deals, currency changes, and late-arriving data.测试边界:检查零分母、日期缺失、重复 ID、重开交易、币种变化与迟到数据。
- Compare independently: reproduce a small cohort outside the dashboard and verify filters and time logic.独立比较:在 Dashboard 外复现一个小队列,核实筛选与时间逻辑。
- Challenge behavior: ask how the KPI could be gamed and whether a guardrail detects the unintended result.质疑行为:判断 KPI 如何被操纵,以及护栏能否发现非预期结果。
Common Sales KPI MistakesSales KPI 常见错误
| Mistake错误 | Control控制措施 |
|---|---|
| Tracking every available metric追踪所有可用指标 | Keep a small scorecard; move diagnostics to drill-down views保持精简记分卡;将诊断项移入下钻视图 |
| Copying external benchmarks as targets把外部基准直接当作目标 | Use reconciled internal baselines and a capacity model使用已对账内部基线与产能模型 |
| Rewarding volume without quality只奖励数量而忽略质量 | Pair activity with accepted-opportunity conversion and downstream outcomes将活动与已接受商机转化及下游结果配对 |
| Mixing bookings, billings, and revenue混用签约额、计费额与收入 | Use separate definitions, sources, dates, and targets使用独立定义、来源、日期与目标 |
| Comparing immature cohorts比较未成熟队列 | Fix entry cohorts and observation windows; label still-open records固定进入队列和观察窗口;标记仍进行中记录 |
Analyze and Validate Sales KPIs with InfiniSynapse使用 InfiniSynapse 分析并验证 Sales KPIs
Prepare approved read access to CRM history, targets, role and territory tables, and governed booking or revenue actuals, plus written KPI definitions. Use InfiniSynapse to join sources, calculate a scorecard, segment changes, inspect drivers, trace exceptions to records, and retain a verifiable analysis path. Confirm important outputs against governed source systems; operational CRM updates and compensation administration remain in their owning systems.
准备对 CRM 历史、目标、角色与区域表、受治理签约或收入实际值的已批准只读访问,以及书面 KPI 定义。使用 InfiniSynapse 关联数据源、计算记分卡、分群分析变化、检查驱动因素、把异常追溯到记录,并保留可验证分析路径。重要输出应与受治理源系统核对;运营 CRM 更新与薪酬管理仍保留在各自所属系统。
Try cross-source sales KPI analysis试用跨源 Sales KPI 分析Sales KPI Implementation ChecklistSales KPI 实施检查清单
- Each KPI has one objective, decision, accountable owner, and named action.每项 KPI 都有一个目标、决策、责任人与指定行动。
- Formula, cohort, time basis, source, exclusions, and change history are written.公式、队列、时间口径、来源、排除项与变更历史均已书面化。
- Leading indicators, lagging outcomes, and guardrails form a plausible causal chain.领先指标、滞后结果与护栏形成合理因果链。
- Targets use reconciled baselines, capacity assumptions, ranges, and effective dates.目标使用已对账基线、产能假设、范围与生效日期。
- Scorecards differ by role and assign performance only where control is reasonable.记分卡按角色区分,只在控制合理的范围内分配绩效。
- Results reconcile, trace to records, handle edge cases, and have a scheduled relevance review.结果能够对账、追溯记录、处理边界情况,并有定期相关性复核。
Frequently Asked Questions常见问题
What are the most important sales KPIs?最重要的 Sales KPIs 有哪些?
There is no universal list. A balanced B2B scorecard often includes target attainment, qualified pipeline created, coverage, stage conversion, win rate, cycle length, slippage, forecast error, and one or two controllable activity-quality indicators. Select only KPIs tied to a current objective, owner, decision, and action.
不存在通用清单。均衡的 B2B 记分卡通常包含目标达成、新增合格 Pipeline、覆盖率、阶段转化、赢单率、周期长度、延期、预测误差,以及一到两个可控制的活动质量指标。只选择与当前目标、负责人、决策和行动相关的 KPI。
What is the difference between a sales KPI and a sales metric?Sales KPI 与 Sales Metric 有什么区别?
A sales metric is any consistently defined measurement. A sales KPI is a metric deliberately selected as material to an objective and managed through an owner, target, review cadence, threshold, and action. Every KPI is a metric; most diagnostic metrics should not occupy the primary scorecard.
Sales Metric 是任何保持一致定义的衡量;Sales KPI 是被刻意选择为与目标实质相关,并通过负责人、目标、复核节奏、阈值与行动进行管理的指标。每个 KPI 都是 Metric,但多数诊断指标不应占据主记分卡。
How many sales KPIs should a team track?团队应该追踪多少项 Sales KPIs?
Use the smallest set that supports the decisions at that role and cadence. A practical scorecard may contain one or two outcome KPIs, two to four leading indicators, and one or two guardrails. Keep additional diagnostics available for investigation rather than promoting every metric to KPI status.
应使用能够支持对应角色与节奏决策的最小集合。实用记分卡可包含一到两个结果 KPI、两到四个领先指标与一到两个护栏;其他诊断项应保留用于调查,而不是把每个指标都提升为 KPI。
How do you set targets for sales KPIs?如何设定 Sales KPI 目标?
Reconcile an internal baseline for a comparable segment and period, model the capacity and conversion changes required by the business plan, then set a range with an owner, effective date, review point, and guardrails. Treat external benchmarks as context unless definitions and populations are truly comparable.
先为可比分群与期间对账内部基线,再建模业务计划所需的产能与转化变化,随后设定包含负责人、生效日期、复核点与护栏的范围。除非定义与总体真正可比,否则外部基准只能作为背景。
How often should sales KPIs be reviewed?Sales KPIs 应多久复核一次?
Review operational exceptions daily, actionable pipeline and forecast indicators weekly, mature conversion and productivity cohorts monthly, and targets, capacity, metric relevance, and definitions quarterly. The cadence should reflect data latency, cohort maturity, decision timing, and the time available to act.
运营异常可每日复核,可行动的 Pipeline 与预测指标每周复核,成熟转化和生产力队列每月复核,目标、产能、指标相关性与定义每季度复核。节奏应反映数据延迟、队列成熟度、决策时间与可行动时间。
Official Sources and Verification Notes官方来源与验证说明
Definitions and examples were checked against official material on Salesforce sales KPIs and formulas, Microsoft sales KPI measures and data sources, Microsoft opportunity management, and HubSpot pipeline configuration. Vendor examples illustrate possible definitions; they do not establish universal targets. Use governed company definitions and reconcile results before decisions.
定义与示例参考了关于 Salesforce Sales KPI 与公式、Microsoft 销售 KPI 衡量与数据源、Microsoft 商机管理以及 HubSpot Pipeline 配置的官方资料。供应商示例只说明可能定义,并不建立通用目标;决策前应使用受治理的企业定义并对账结果。
