How do you calculate team quota attainment?
Divide total closed revenue for the team by total assigned quota for the team, using dollars on both sides of the division.``` Team quota attainment = Total closed revenue / Total assigned quota ```
That is the dollar-weighted figure, and it is the only version that reconciles to what the company actually booked. Every other roll-up method answers a different question. The alternative most teams reach for, averaging each rep's individual attainment percentage, produces a number that can differ from the revenue result by more than ten points.
Should you sum the dollars or average the percentages?
Sum the dollars. Averaging percentages weights a $200,000 quota the same as a $900,000 quota, which no revenue plan does.| Rep | Quota | Closed | Attainment |
|---|---|---|---|
| A | $900,000 | $612,000 | 68% |
| B | $700,000 | $511,000 | 73% |
| C | $500,000 | $525,000 | 105% |
| D | $400,000 | $460,000 | 115% |
| E | $300,000 | $384,000 | 128% |
| F | $200,000 | $280,000 | 140% |
| Total | $3,000,000 | $2,772,000 | 92.4% |
The divergence has a specific cause worth naming: the two largest quotas both missed, and the four smallest all cleared. Percentage averaging hides that entirely, because it counts rep F's $80,000 of overachievement as equal in weight to rep A's $288,000 shortfall.
What is participation rate and why report it?
Participation rate is the share of reps at or above 100% of individual quota, and it separates a broad result from a concentrated one. The team above has four of six reps over quota, a 67% participation rate, while still missing on dollars. The opposite pattern is more common and more dangerous: a team hitting 105% with two reps carrying the entire result and a 25% participation rate.Concentrated attainment does not repeat. One overperformer taking parental leave, changing territory, or leaving the company removes the entire beat. Read attainment and participation together, because either one alone supports the wrong conclusion about whether next quarter looks like this one.
How does quota over-assignment change the number?
It creates two legitimate attainment figures, and mixing them up is the most common reporting error in this metric. Most companies assign more quota than the revenue plan requires, so that a normal distribution of individual misses still delivers the company number.The team above carries $3,000,000 of assigned quota. If the company target for those territories is $2,700,000, over-assignment is 11%. Closing $2,772,000 means the team hit 92.4% of assigned quota and 102.7% of the company target at the same time. Sales leadership reads a miss, finance reads a beat, and both are correct.
Fix this by labeling the denominator every time the number appears. Report attainment against assigned quota for management decisions about coaching and territory, and against the company target for anything that touches the revenue forecast. Feeding an assigned-quota percentage into a forecast overstates the gap by exactly the over-assignment rate, which corrupts the sales forecasting process downstream.
Mean, median, or dollar-weighted?
Report all three, because each one answers a question the others cannot. The dollar-weighted figure reconciles to revenue. The median describes the experience of a typical rep on the team, which is what drives retention and comp plan credibility. The mean sits between them and moves whenever one rep has an unusual quarter.A large spread between median and dollar-weighted attainment is a segmentation signal. When the median runs well above the weighted figure, the quotas on the largest territories are either too high or unsupported by pipeline, and the fix is a territory or capacity change rather than a performance conversation.
What breaks team attainment reporting?
Timing, roster changes, and mid-quarter quota edits.Timing distorts every partial-period read. Q2 and Q4 typically run stronger than Q1 and Q3, and the third month of a quarter runs stronger than the first two. A team at 55% of quota at the end of month two is not tracking to 82% for the quarter, and linear extrapolation will say it is. Compare against the same point in prior quarters instead.
Roster changes break the denominator. When a rep leaves in month two, their quota usually stays in the team total while their pipeline gets redistributed and their closed revenue lands under someone else. Decide once whether departed reps stay in the denominator and apply it consistently, because switching between quarters makes the trend line meaningless.
Mid-quarter quota edits are the hardest to catch. A quota lowered in week ten raises attainment without a dollar of additional revenue, and the change leaves no trace in most dashboards. Snapshot assigned quota on day one of every period and report against the snapshot.
How should the number be used?
As a lagging check on capacity assumptions, not as the primary performance signal. Attainment reports what already happened. By the time a team lands at 92.4%, every decision that produced that result was made in prior quarters.The forward-looking version of this question is whether the pipeline supports the assigned quota, which is what pipeline coverage measures per rep. A team with three reps under 1.5x coverage in week two has next quarter's attainment problem already visible, and that is when it can still be fixed.
Frequently Asked Questions
What is the formula for team quota attainment?
Divide total closed revenue for the team by total assigned quota for the team. Use dollars in both the numerator and the denominator. Averaging each rep's attainment percentage answers a different question and returns a different number whenever quotas are unequal.
Why does average rep attainment look better than team attainment?
Because averaging percentages gives a rep carrying a $200,000 quota the same weight as one carrying $900,000. In a six-rep example the dollar-weighted team lands at 92.4% while the average of rep percentages reads 104.8%, and the gap is entirely explained by the largest quotas missing.
What is quota participation rate?
The share of reps who reached 100% of their individual quota. It is reported alongside attainment because a team can hit its number through two or three overperformers while most of the roster misses, which is a fragile result that will not repeat.
How does quota over-assignment affect the calculation?
It creates two valid attainment figures. A team assigned $3,000,000 against a company target of $2,700,000 carries 11% over-assignment, so closing $2,772,000 reads as 92.4% of assigned quota and 102.7% of the company target. Always state which denominator is in use.
Should the board see mean or median attainment?
Both, alongside the dollar-weighted team figure. The median describes the typical rep, the mean is pulled upward by top performers, and the dollar-weighted number is the only one that reconciles to actual revenue. Reporting a single figure without saying which one it is produces arguments rather than decisions.
See how ORM turns these insights into action
ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.
Schedule a Demo