Metric Definition
Average deal value over time
Track from
Deal size trend analysis
Deal size trend analysis tracks how the average value of closed deals changes over time and explains what is driving the movement. It shows whether each new customer is worth more or less than the last cohort, which feeds directly into revenue forecasting. A rising trend can fund growth, while a quiet decline erodes the economics of every other go-to-market motion.
8 min read
What is deal size trend analysis?
Deal size trend analysis tracks how the average value of closed deals changes over time and explains what is driving the movement. The base figure is average deal size, total closed-won revenue divided by the number of deals won. If a quarter closes 40 deals worth 800,000 pounds, the average deal size is 20,000 pounds. The analysis is the line you draw through that figure quarter after quarter, and the work of explaining why the line bends.
A single average deal size is a snapshot. The trend is the story. A team holding steady at 20,000 pounds is in a very different position to one sliding from 28,000 to 16,000 over four quarters, even if a single quarter looks identical. Because so many downstream models depend on it, payback periods, quota plans, and hiring all assume a deal size, a quiet drift in the trend can quietly invalidate every plan built on the old number.
Definition note
Average deal size is sensitive to outliers. One unusually large deal can lift a quarterly average and create the illusion of a rising trend. For a more honest read, track the median alongside the mean, or split new business from expansion, so a single landmark deal does not get mistaken for a structural shift.
How to calculate deal size trend analysis
Calculate average deal size for each period, then plot the series and read the direction. Keep the deal definition steady across periods, decide whether expansion and renewals count, and apply that rule consistently. Switching from new-business-only to all-revenue partway through the series will manufacture a trend that does not exist.
For a worked example, take four quarters of new business: 18,000 pounds, then 21,000, then 19,000, then 24,000. The trend is upward despite the dip in the third quarter, and the average deal size has grown by a third across the year. Read this trend next to average deal size as a point-in-time figure and your revenue growth rate to separate volume growth from value growth.
- 1
Total closed-won revenue
The summed value of all deals closed as won in the period. Decide once whether this includes expansion and renewal, then hold that rule fixed.
- 2
Number of deals won
The count of closed-won deals in the same period. The denominator must match the revenue numerator exactly in scope.
- 3
Period and cadence
The interval each point covers, usually a month or quarter. Consistent cadence is what makes the line readable as a trend.
- 4
Central measure
Whether you plot the mean or the median. The median resists outliers and is often the more honest line for low-volume teams.
Deal size trend analysis in a metric tree
A moving average deal size hides a mix of forces that point in different directions. The trend can rise because you are landing larger logos, or fall because discounting has crept up, and the single line cannot tell you which. A metric tree decomposes the trend into the drivers beneath it, segment mix, product mix, discount depth, and seat count, so a change in the headline maps to a specific lever.
KPI Tree connects each of those branches to the team that controls it. Segment mix sits with marketing and sales targeting, discount depth sits with sales operations and deal desk, and product mix sits with product marketing. When the trend bends, the push goes to the owner of the branch responsible, so a slide in average deal size becomes a precise conversation about, say, creeping discounts in one segment rather than a generic worry that deals are shrinking.
Metric tree insight
A flat average deal size often hides two branches cancelling out. Rising discount depth can mask a shift toward larger enterprise deals, leaving the headline unchanged while the underlying economics deteriorate. The tree exposes the offsetting moves the single average conceals.
Deal size trend analysis benchmarks
Absolute deal sizes vary so widely by market that cross-company benchmarks are close to meaningless. The useful benchmark is the trend itself, judged against your own targeting strategy. The table reads the direction of the trend and what each direction tends to signal, so you can tell a healthy move upmarket from an unhealthy slide.
| Trend direction | Typical cause | What to check |
|---|---|---|
| Rising steadily | Moving upmarket or better packaging | Cycle length and win rate are holding up |
| Flat | Stable mix or two branches offsetting | Discount depth against segment mix |
| Falling slowly | Discount creep or smaller segments | Average discount and SMB deal share |
| Falling sharply | Pricing change or a lost large segment | Plan distribution and lost enterprise deals |
How to improve deal size trend analysis
Improving the trend is not about chasing bigger logos blindly. It is about understanding which branch is moving the line and adjusting that lever deliberately. The plays below target the most common drivers, from segment targeting through to discount discipline.
Target larger segments
Shift lead generation and outbound toward accounts with bigger budgets. A change in segment mix is usually the strongest lever on the trend.
Tighten discount discipline
Track average discount depth as its own branch and set approval thresholds. Discount creep erodes deal size quietly across many small deals.
Raise add-on attach
Bundle complementary products and price multi-product deals deliberately. Higher attach lifts average value without changing who you sell to.
Sell longer terms
Encourage multi-year and annual commitments where they fit. Longer contract terms raise booked deal value and improve revenue predictability.
Common mistakes when tracking deal size trend analysis
- 1
Reading the mean without the median
One landmark deal can lift the average and fake an upward trend. Plot the median beside the mean to catch outlier distortion.
- 2
Mixing new business with expansion
Blending new logos and upsell into one average hides which motion is driving the move. Split them so the trend stays interpretable.
- 3
Changing the deal definition mid-series
Including renewals from one quarter onward manufactures a trend break. Fix the scope once and apply it across the whole series.
- 4
Ignoring volume alongside value
A rising deal size with falling deal count can mean total revenue is flat or shrinking. Always read the trend next to deal volume.
Related metrics
Average deal size
Sales Metrics
Metric Definition
Average Deal Size = Total Revenue from Closed Deals / Number of Closed Deals
Average deal size measures the mean revenue value of closed-won deals. It is a fundamental sales metric that directly influences pipeline velocity, quota planning, and the economics of your go-to-market model.
Win rate
Sales Metrics
Metric Definition
Win Rate = (Closed-Won Deals / Total Closed Deals) × 100
Win rate measures the percentage of sales opportunities that result in a closed-won deal. It is the single most revealing metric of sales effectiveness, indicating how well your team converts qualified pipeline into revenue.
Sales pipeline velocity
Sales Metrics
Metric Definition
Pipeline Velocity = (Opportunities × Deal Value × Win Rate) / Sales Cycle Length
Sales pipeline velocity measures how quickly deals move through your pipeline and generate revenue. It combines the four core levers of sales performance into a single metric that reveals the rate at which your pipeline converts to closed revenue.
Revenue growth rate
Top-line growth velocity
Financial Metrics
Metric Definition
Revenue Growth Rate = ((Current Period Revenue - Prior Period Revenue) / Prior Period Revenue) x 100
Revenue growth rate measures the percentage increase in revenue over a specified period. It is the most watched metric for assessing whether a business is expanding, stagnating, or declining, and it directly drives company valuation.
Why did my metric change? A diagnostic framework
Metric Definition
This framework helps you pinpoint what is driving average deal value up or down as you watch the trend move over time.
Metric trees for sales teams
Metric Definition
See where average deal value sits within a wider sales metric tree alongside the drivers that the sales team can act on.
Track the deal size trend as a tree with owners on every driver
Model your average deal size in KPI Tree and decompose the trend into segment mix, product mix, and discounting. Put a RACI owner on each branch so when the line bends, the accountable person sees which lever moved and can respond before the next forecast is built on a stale number.
