What Is Quota Attainment?什么是配额达成率？
Quota attainment is the percentage of an assigned sales quota achieved during the same defined period. The standard formula is credited sales result divided by assigned quota, multiplied by 100. If a representative receives $180,000 of eligible credit against a $200,000 quarterly quota, attainment is 90%.
配额达成率是在同一明确期间内，已完成业绩占所分配销售配额的百分比。标准公式为“计入业绩 ÷ 分配配额 × 100”。如果某销售人员在季度内获得 180,000 美元合格业绩归属，而季度配额为 200,000 美元，则达成率为 90%。
Formula: Quota attainment (%) = eligible credited result ÷ effective quota × 100. “Eligible,” “credited,” and “effective” must be defined. Bookings, billings, recognized revenue, annual recurring revenue, units, margin, and new customers are not interchangeable.
公式：配额达成率（%）= 符合条件的计入业绩 ÷ 生效配额 × 100。“符合条件”“计入”和“生效”都必须定义。签约、开票、确认收入、年度经常性收入、件数、毛利和新客户数不能互换。
Attainment above 100% means the credited result exceeded quota; it does not automatically define commission payout. Compensation plans may apply thresholds, caps, accelerators, clawbacks, or different credit timing. Keep performance measurement and compensation calculation as related but separately governed processes.
达成率超过 100% 表示计入业绩超过配额，但不会自动决定佣金支付。薪酬计划可能应用门槛、上限、加速系数、追回或不同归属时间。绩效衡量与薪酬计算彼此相关，但应作为独立受治理流程管理。
What Quota Attainment Can—and Cannot—Tell You配额达成率能说明什么，不能说明什么
Quota attainment provides a normalized view of actual performance against an assigned expectation. Leaders use it for periodic performance review, capacity planning, forecast context, territory and quota calibration, enablement analysis, and compensation inputs. A distribution of attainment also reveals whether a plan depends on a few overperformers or whether results are broadly supported.
配额达成率把实际业绩与分配预期标准化比较。管理者可将其用于周期绩效复盘、产能规划、预测背景、区域和配额校准、赋能分析以及薪酬输入。达成率分布还能说明计划是依赖少数超额完成者，还是由广泛成员共同支撑。
The metric does not prove effort, skill, forecast quality, profitability, customer health, or causal impact. A high result can reflect territory potential, inherited pipeline, one large deal, favorable timing, or a low quota. A low result can reflect a new territory, an unrealistic quota, poor lead supply, delayed approvals, or seller execution. Diagnose with pipeline, win rate, cycle time, margin, retention, activity quality, and qualitative evidence.
该指标不能证明努力程度、技能、预测质量、盈利能力、客户健康或因果影响。高达成率可能来自区域潜力、继承管道、单笔大额交易、有利时点或偏低配额；低达成率可能来自新区域、不现实配额、线索供应不足、审批延迟或销售执行。应结合管道、赢率、销售周期、毛利、留存、活动质量和定性证据诊断。
Choose the Correct Quota and Result Type选择正确的配额和业绩类型
The formula stays simple, but the numerator and denominator change with the plan. Never mix a revenue result with a unit quota or a bookings result with recognized revenue quota. Label the business measure, currency, period, population, and credit policy beside the percentage.
公式很简单，但分子和分母会随计划变化。不要用收入结果除以件数配额，也不要用签约业绩除以确认收入配额。应在百分比旁标明业务指标、币种、期间、人群和归属政策。
| Quota type配额类型 | Eligible numerator合格分子 | Important control重要控制 |
|---|---|---|
| Bookings / contract value签约 / 合同金额 | Approved credited bookings under the plan definition符合计划定义且已批准归属的签约金额 | Cancellation, renewal, term, and discount rules取消、续约、期限和折扣规则 |
| Revenue收入 | Booked, billed, or recognized revenue—choose one签约、开票或确认收入，只能选择一种 | Finance reconciliation and recognition timing财务核对和确认时间 |
| Recurring revenue经常性收入 | Eligible new, expansion, renewal, or net recurring value符合条件的新增、扩展、续约或净经常性价值 | Term normalization, churn, and contraction policy期限标准化、流失和收缩政策 |
| Units / transactions件数 / 交易数 | Accepted units, contracts, accounts, or transactions已接受的件数、合同、客户或交易 | Eligibility, returns, duplicate and quality rules资格、退货、重复和质量规则 |
| Margin / contribution毛利 / 贡献 | Credited gross margin or contribution under finance rules按财务规则归属的毛利或贡献 | Cost allocation, discounting, and true-up timing成本分配、折扣和追溯调整时间 |
Define a Quota Attainment Metric Contract定义配额达成率指标契约
Before calculation, document the performance measure, quota source, credit source, period calendar, currency, ownership grain, quota version, proration policy, exclusions, approval status, refresh cadence, and accountable owner. Preserve effective dates so a later quota or territory change does not silently rewrite a closed month.
计算前应记录绩效指标、配额来源、业绩归属来源、期间日历、币种、归属粒度、配额版本、按比例调整政策、排除项、批准状态、刷新节奏和负责人。应保留生效日期，避免后续配额或区域变化静默改写已关闭月份。
- Numerator contract: qualifying event, amount basis, credit recipient, split percentage, approval state, reversal, and posting date.分子契约：资格事件、金额基准、归属人员、拆分比例、批准状态、冲销和入账日期。
- Denominator contract: assigned quota, effective start and end, role, territory, measure, currency, version, and proration.分母契约：分配配额、生效起止、角色、区域、指标、币种、版本和按比例调整。
- Comparison contract: person or team, period, ramp status, leave treatment, cohort, benchmark, and minimum sample.比较契约：个人或团队、期间、爬坡状态、休假处理、分群、基线和最低样本量。
Quota Attainment Formula Examples配额达成率公式示例
Hypothetical individual example: a representative has $240,000 in approved quarterly credit and a $200,000 effective quota. Attainment is $240,000 ÷ $200,000 × 100 = 120%. The percentage may be displayed above 100%; whether compensation accelerates is governed by the separate plan.
假设个人示例：某销售人员季度已批准归属业绩为 240,000 美元，生效配额为 200,000 美元。达成率为 240,000 ÷ 200,000 × 100 = 120%。百分比可以显示超过 100%；薪酬是否加速由独立计划管理。
Hypothetical team example: Rep A has $90,000 credit against a $100,000 quota; Rep B has $240,000 against a $300,000 quota. Individual attainment is 90% and 80%. Team attainment is ($90,000 + $240,000) ÷ ($100,000 + $300,000) = 82.5%. A simple average gives 85% and is wrong for the team rollup because the quotas differ.
假设团队示例：A 的业绩为 90,000 美元、配额 100,000 美元；B 的业绩为 240,000 美元、配额 300,000 美元。个人达成率分别为 90% 和 80%。团队达成率为（90,000 + 240,000）÷（100,000 + 300,000）= 82.5%。简单平均得到 85%，但因个人配额不同，这不是正确团队汇总。
Rollup rule: calculate team attainment from summed eligible results divided by summed effective quotas. Do not average percentages unless every underlying quota is equal and the population is intentionally unweighted.
汇总规则：团队达成率应由合格业绩总和除以生效配额总和。除非所有底层配额相等且明确采用不加权人群，否则不要平均百分比。
Handle Proration, Ramp, Leave, and Quota Changes处理按比例调整、爬坡、休假和配额变更
When a seller joins, leaves, changes roles, takes eligible leave, or has a mid-period quota revision, use the approved effective quota rather than the latest full-period value. A common day-based starting point is full-period quota multiplied by eligible active days divided by eligible period days, but the organization's plan and local rules are authoritative.
销售人员入职、离职、变更角色、发生合格休假或期间内修订配额时，应使用已批准的生效配额，而不是最新的完整期间数值。常见按天起点是“完整期间配额 × 合格在岗天数 ÷ 期间合格天数”，但应以组织计划和当地规则为准。
Do not prorate the denominator informally after observing poor results. Store each quota version with effective dates, reason, approver, currency, and measure. For quarterly reporting, calculate from the effective monthly or daily components when policies changed inside the quarter. Decide whether credit earned before a territory transfer remains with the original owner, moves with the account, or is split.
不要在观察到结果不佳后非正式调整分母。每个配额版本都应保存生效日期、原因、批准人、币种和指标。季度内政策发生变化时，季度报告应根据生效月度或每日组成计算。还要决定区域转移前获得的业绩是保留给原负责人、随客户转移还是拆分。
Reusable Quota Attainment Template可复用配额达成率模板
Use one row per person, quota measure, and effective period. If quotas or roles change mid-period, split the row at the effective date rather than overwriting it. The review view can aggregate these governed rows later.
每行对应一个人员、一个配额指标和一个生效期间。如果配额或角色在期间内变化，应按生效日期拆行，而不是覆盖原值。复盘视图可随后汇总这些受治理记录。
| Template field模板字段 | Purpose用途 | Validation验证 |
|---|---|---|
| Person, role, team, territory人员、角色、团队、区域 | Defines owner and comparison cohort定义负责人和比较分群 | Effective-dated assignment带生效日期的分配 |
| Measure, period, currency指标、期间、币种 | Keeps numerator and denominator compatible保持分子分母相容 | Approved calendar and conversion rule已批准日历和换算规则 |
| Original and effective quota原始与生效配额 | Shows proration and revisions展示按比例调整和修订 | Version, date, reason, approver版本、日期、原因、批准人 |
| Eligible credited result符合条件的计入业绩 | Provides the governed numerator提供受治理分子 | Source IDs, splits, approval, reversals源 ID、拆分、批准、冲销 |
| Attainment and gap达成率与差额 | Result ÷ quota; result − quota业绩 ÷ 配额；业绩 − 配额 | Zero/blank denominator and rounding零值/空分母和舍入 |
| Status, evidence, action状态、证据、行动 | Connects metric to review workflow把指标连接到复盘流程 | Owner, due date, next review负责人、截止日期、下次复盘 |
Analyze the Distribution, Not Only the Average分析分布，而不只看平均数
Report weighted team attainment alongside the median, percent of eligible sellers at or above quota, distribution bands, sample count, and contribution concentration. A team can meet its aggregate quota while most sellers miss because one large contributor offsets the rest. Conversely, broad attainment just below 100% may indicate a systemic target or pipeline gap.
应在加权团队达成率之外，同时报告中位数、达到或超过配额的合格销售人员占比、分布区间、样本数和贡献集中度。团队可能因一名大型贡献者抵消其他成员而完成总体配额，但多数销售人员仍未达标。相反，广泛集中在略低于 100% 的结果可能表示系统性目标或管道缺口。
Compare like roles, tenure, markets, products, account books, lead sources, deal bands, and ramp states. Do not rank a new-territory representative against an established-account owner without context. Suppress or flag very small cohorts, and preserve qualitative review before using the metric for consequential people decisions.
比较时应匹配角色、任期、市场、产品、客户组合、线索来源、交易区间和爬坡状态。不要在缺少背景时把新区域销售人员与成熟客户负责人排名。对极小分群应隐藏或标记，并在指标用于重要人员决策前保留定性复核。
Diagnose Why Quota Attainment Changed诊断配额达成率为何变化
Start with arithmetic: attainment can change because the credited result changed, the effective quota changed, or both. Then trace result mechanics through available pipeline, stage conversion, win rate, deal value, sales cycle, slippage, product and territory mix, discounting, and recognized timing. Separate observed facts from hypotheses.
先从算术开始：达成率变化可能来自计入业绩变化、生效配额变化或两者同时变化。随后沿着可用管道、阶段转化、赢率、交易金额、销售周期、延期、产品与区域组合、折扣和确认时点追踪结果机制。应区分已观察事实与假设。
Did assignment, proration, territory, role, currency, or quota version change?
分配、按比例调整、区域、角色、币种或配额版本是否变化？
Was enough qualified pipeline available, balanced, and scheduled for the period?
期间内是否有足够、均衡且计划成交的合格管道？
Did stage movement, win rate, deal size, cycle, or slippage change?
阶段推进、赢率、交易规模、周期或延期是否变化？
Were results late, unapproved, split, duplicated, reversed, or mapped incorrectly?
业绩是否延迟、未批准、拆分、重复、冲销或映射错误？
Prepare the Data Needed for Reliable Attainment准备可靠达成率所需数据
A current CRM opportunity snapshot is not enough. Reliable calculation usually needs immutable transaction or opportunity IDs, credit allocations, approval and reversal events, quota assignments and versions, effective-dated people and territory history, business calendars, currency rates, product mappings, and finance-controlled results. Keep the raw event grain separate from the reporting aggregate.
当前 CRM 商机快照并不够。可靠计算通常需要不可变交易或商机 ID、业绩归属分配、批准和冲销事件、配额分配与版本、带生效日期的人员和区域历史、业务日历、汇率、产品映射以及财务控制结果。原始事件粒度应与报告汇总分开。
- Quota table: assignment key, person/team key, measure, amount, currency, period, effective dates, proration, version, status, approver.配额表：分配主键、人员/团队主键、指标、金额、币种、期间、生效日期、按比例调整、版本、状态、批准人。
- Credit table: source transaction, recipient, eligible amount, split factor, posting date, approval, reversal, product, account, territory.业绩归属表：源交易、归属人员、合格金额、拆分系数、入账日期、批准、冲销、产品、客户、区域。
- Control tables: people history, role and ramp, calendar, currency, product, finance totals, exclusion reasons, and reconciliation status.控制表：人员历史、角色与爬坡、日历、币种、产品、财务总数、排除原因和核对状态。
How to Calculate Quota Attainment Step by Step如何逐步计算配额达成率
- Choose the decision and grain. Define whether the result serves a rep review, team rollup, planning, or compensation input and select person/team by effective period.选择决策和粒度。明确结果用于个人复盘、团队汇总、规划还是薪酬输入，并选择按生效期间的人员/团队粒度。
- Freeze the metric contract. Align measure, currency, calendar, credit event, quota version, proration, exclusions, and approval state.冻结指标契约。对齐指标、币种、日历、归属事件、配额版本、按比例调整、排除项和批准状态。
- Build effective quota. Split mid-period changes, apply only approved proration, and preserve original plus revised values.建立生效配额。拆分期间内变更，只应用已批准的比例调整，并保留原始值和修订值。
- Aggregate eligible credit. Apply splits once, remove reversals and ineligible records, and reconcile source IDs and totals.汇总合格业绩。只应用一次拆分，移除冲销和不合格记录，并核对源 ID 与总数。
- Calculate and roll up. Divide credit by quota at the governed grain; for teams, sum credit and quota before division.计算并汇总。在受治理粒度上用业绩除以配额；团队层先分别求业绩和配额总和再相除。
- Validate and interpret. Check exceptions, distribution, concentration, guardrails, evidence, owners, and next-review actions.验证并解读。检查异常、分布、集中度、护栏、证据、负责人和下次复盘行动。
Choose a Quota Attainment Tracking Tool选择配额达成率跟踪工具
A spreadsheet can support a controlled pilot when rows, versions, approvals, and access are limited. CRM reports fit operational review when quotas and eligible outcomes are governed in the same CRM. Compensation systems are appropriate when plan administration, crediting, disputes, adjustments, and payout calculations require dedicated controls. BI platforms support recurring cross-team reporting, semantic measures, access control, and distribution.
当行数、版本、批准和访问有限时，电子表格可支持受控试点。配额和合格结果都在同一 CRM 治理时，CRM 报告适合运营复盘。计划管理、归属、争议、调整和支付计算需要专门控制时，薪酬系统更适合。BI 平台则支持周期性跨团队报告、语义指标、访问控制和分发。
Evaluate effective-dated quota modeling, credit lineage, split handling, approvals, reversals, currency, restatements, row-level permissions, audit history, reconciliation, and drill-through. Select the tool after defining the metric contract. For wider platform criteria, see the InfiniSynapse data analytics platform evaluation guide.
应评估按生效日期的配额建模、业绩血缘、拆分处理、批准、冲销、币种、重述、行级权限、审计历史、核对和下钻。应在定义指标契约后再选工具。更广泛的平台标准可参阅 InfiniSynapse 的数据分析平台评估指南。
Analyze Quota Attainment With InfiniSynapse使用 InfiniSynapse 分析配额达成率
When quota, credit, CRM history, workforce assignments, and finance evidence are distributed across connected databases, warehouses, and files, InfiniSynapse can support iterative analysis over governed sources. Prepare one decision question, source owners, stable business keys, effective-date rules, metric contracts, permissions, expected totals, and validation criteria.
当配额、业绩归属、CRM 历史、人员分配和财务证据分散在已连接数据库、数据仓库和文件中时，InfiniSynapse 可以支持基于受治理数据源的迭代分析。应准备一个决策问题、数据源负责人、稳定业务主键、生效日期规则、指标契约、权限、预期总数和验证标准。
Use natural language to investigate quotas, eligible credit, teams, periods, and related pipeline or revenue evidence across connected sources, then validate fields, joins, formulas, versions, exclusions, and outputs before acting. InfiniSynapse is not a CRM, quota-setting authority, compensation administration system, payroll engine, or sales execution platform.
使用自然语言跨已连接数据源调查配额、合格业绩归属、团队、期间及相关管道或收入证据，并在行动前验证字段、连接、公式、版本、排除项和输出。InfiniSynapse 不是 CRM、配额设定权威、薪酬管理系统、工资引擎或销售执行平台。
Try cross-source sales analysis体验跨源销售分析Validate Quota Attainment Before Publishing发布配额达成率前进行验证
- Reconcile quotas: compare assigned and effective totals by measure, currency, period, team, version, and approval status with the authoritative plan.核对配额：按指标、币种、期间、团队、版本和批准状态，将分配及生效总额与权威计划核对。
- Reconcile credit: match distinct transactions and eligible amounts to CRM, order, billing, or finance controls; test splits and reversals.核对业绩：将去重交易和合格金额与 CRM、订单、开票或财务控制核对，并检验拆分和冲销。
- Test joins: compare rows, distinct assignment and transaction keys, quotas, and credit before and after people, territory, product, and calendar joins.检验连接：比较连接人员、区域、产品和日历前后的行数、去重分配与交易主键、配额和业绩。
- Test exceptions: flag missing or zero quota, duplicate credit, over-allocation, unmapped person, invalid dates, currency gaps, unapproved changes, and reopened periods.检验异常：标记缺失或零配额、重复归属、过度分配、未映射人员、无效日期、币种缺口、未批准变更和重开期间。
- Back-test: recompute a frozen period and confirm current quotas, owners, territories, exchange rates, and transaction states did not rewrite history.回测：重算冻结期间，确认当前配额、负责人、区域、汇率和交易状态没有改写历史。
Quota Attainment FAQ配额达成率常见问题
Divide eligible credited sales results by the effective quota for the same measure and period, then multiply by 100. Define the result basis, credit policy, currency, quota version, proration, and exclusions.
用同一指标和期间的符合条件计入业绩除以生效配额，再乘以 100。应定义业绩基准、归属政策、币种、配额版本、按比例调整和排除项。
Yes. It means eligible credited results exceeded the effective quota. Do not cap the analytical metric unless the stated use requires it; commission payout rules are governed separately.
可以。这表示符合条件的计入业绩超过生效配额。除非明确用途要求，否则不应限制分析指标；佣金支付规则应独立治理。
Sum all eligible credited results and divide by the sum of effective quotas, then multiply by 100. Do not average individual percentages when quotas differ.
将所有符合条件的计入业绩求和，除以生效配额总和，再乘以 100。个人配额不同时，不要平均个人百分比。
There is no universal rate that proves a quota is fair or performance is healthy. Review weighted attainment, median, distribution, concentration, comparable cohorts, quota design, pipeline, conversion, margin, and customer outcomes.
不存在能够证明配额公平或绩效健康的通用比例。应复核加权达成率、中位数、分布、集中度、可比分群、配额设计、管道、转化、毛利和客户结果。
Use the measure defined in the approved quota plan. The numerator and denominator must match: bookings with bookings quota, recognized revenue with recognized revenue quota, and so on.
应使用已批准配额计划定义的指标。分子与分母必须匹配：签约业绩对应签约配额，确认收入对应确认收入配额，依此类推。
No. Attainment is a performance ratio. A compensation plan can use it as an input but may apply thresholds, rates, caps, accelerators, adjustments, clawbacks, and eligibility rules.
不同。达成率是绩效比率。薪酬计划可将其作为输入，但可能应用门槛、费率、上限、加速系数、调整、追回和资格规则。