Deal size distribution

Deal size distribution is the pattern of deal values across your active pipeline and closed business. It shows how many deals fall into each value band, from small self-serve transactions to large enterprise contracts, and what proportion of total pipeline value each band represents.

The metric matters because average deal size alone can be deeply misleading. A team with an average deal size of fifty thousand pounds might have a balanced spread of deals between twenty thousand and eighty thousand, or it might have ninety small deals at five thousand and one outlier at five hundred thousand. These two scenarios have completely different risk profiles, sales motions, and forecasting reliability.

Deal size distribution is particularly important for revenue planning and forecast accuracy. A pipeline dominated by a few large deals is inherently riskier than one with many smaller deals, because losing a single large opportunity can blow the quarter. Conversely, a pipeline with only small deals may struggle to hit aggressive revenue targets even with strong win rates.

In CRM systems, deal size distribution is typically visualised as a histogram or bucket chart, grouping opportunities into value bands. Most sales leaders review it monthly or quarterly alongside pipeline coverage and stage distribution.

There is no single formula for deal size distribution. Instead, it is analysed by grouping deals into value bands and examining the count and total value in each band. Define bands that match your business: for example, under ten thousand pounds, ten to fifty thousand, fifty to one hundred thousand, and above one hundred thousand.

For each band, calculate the number of deals, the total pipeline value, and the percentage of total pipeline that the band represents. Then compare these distributions across time periods, rep segments, and lead sources.

Two summary statistics are particularly useful. The median deal size tells you the typical deal, unaffected by outliers. The concentration ratio tells you what percentage of total pipeline value comes from the top 10% or 20% of deals. A high concentration ratio signals risk because a small number of deal outcomes will determine whether you hit target.

Deal size distribution feeds into pipeline value and ultimately revenue. It interacts with win rate and sales cycle length, both of which typically vary by deal size band.

The tree illustrates why deal size distribution cannot be viewed in isolation. A shift towards larger deals increases average deal size but typically reduces win rate and extends sales cycle length. The net effect on revenue depends on the magnitude of each change. A metric tree lets you model these trade-offs explicitly rather than guessing.

1. 1

   Set explicit targets by deal size band

   Rather than targeting a single revenue number, set targets for each deal size band. This forces the team to maintain a balanced pipeline and prevents over-reliance on a small number of large deals.

2. 2

   Align sales resources to deal size segments

   Different deal sizes require different sales motions. Assign enterprise reps to large opportunities and inside sales or self-serve flows to smaller ones. Misallocating expensive enterprise reps to small deals destroys unit economics.

3. 3

   Monitor concentration risk weekly

   Track what percentage of your pipeline and forecast sits in the top five or ten deals. If concentration is too high, proactively generate more mid-market pipeline to reduce the impact of any single deal slipping.

4. 4

   Use deal size bands in forecasting models

   Apply different win rates and cycle times to each band rather than using a single blended rate. This produces significantly more accurate forecasts because large and small deals behave differently.

5. 5

   Analyse deal size trends over time

   A gradual shift in distribution can signal market changes, pricing issues, or changes in your ideal customer profile. Track median deal size and band proportions quarterly to spot trends early.