Why Average Deal Size matters
Movement in Average Deal Size should prompt a check of the underlying volume, mix, timing, and data coverage before the team attributes the change to performance.
- Business question
- How is Average Deal Size changing, and which operating segments explain that movement?
- Teams that use it
- Sales leaders, revenue operations, finance, marketing, and account teams.
- Decisions it supports
- Pipeline prioritisation, coaching, territory planning, forecasting, and customer growth.
Average Deal Size formula
Total Revenue ÷ Total Closed Deals
Formula components
- Revenue
- The monetary amount assigned to revenue for the same scope and reporting period used by Average Deal Size.
- Closed Deals
- The consistently counted closed deals included in the metric’s documented population and period.
- Reporting period
- The consistent day, week, month, quarter, or year covered by every input.
How to calculate Average Deal Size
- Define the business scope, reporting period, and the event or status that qualifies for Average Deal Size.
- Collect each input in the workbook formula from systems that use the same cut-off and unit.
- Remove duplicates and exclusions according to the documented rule, while retaining a reconciliation count.
- Apply Total Revenue ÷ Total Closed Deals and label the result with its period, unit, and relevant segment.
Average Deal Size example
A fictional team brings together the inputs for Average Deal Size over one consistent month.
- Revenue = £60,157.
- Closed Deals = 43.
- Average Deal Size = £60,157 ÷ 43 = £1,399.
Average Deal Size is £1,399.
This is the average or ratio for the defined population; individual records can sit well above or below it.
How to interpret the result
Compare Average Deal Size over a consistent cadence and break it down only by segments large enough to support a decision. Review the formula inputs beside the result so teams can distinguish a real operating shift from a denominator or mix effect.
There is no single target that fits every organisation. Interpretation depends on sales motion, deal size, customer segment, territory, product mix, and sales-cycle length. Document the comparison group before labelling a result strong or weak.
Common mistakes and limitations
- Inconsistent scope
- Changing the included business units, products, channels, or populations makes the trend look different even when underlying performance is unchanged.
- Mismatched periods
- Formula inputs from different cut-off dates or time windows do not describe one coherent result.
- Averages hiding the distribution
- A small number of extreme records can move the mean; review the median, range, and meaningful segment cuts when they add context.
- Assuming one universal target
- A useful comparison depends on sales motion, deal size, customer segment, territory, product mix, and sales-cycle length; use like-for-like internal trends and clearly documented peer groups.