KPI Tree

Salesforce Metric

Sales

Average Deal Size = Total Closed-Won Opportunity Amount in Period / Number of Closed-Won Opportunities in Period

Average Deal Size measures the mean revenue value of opportunities that reach a closed-won stage in Salesforce over a defined period. It is calculated from the Amount field on Opportunity records, filtered to the won stage, so it reflects the typical contract value your team actually closes rather than the value of open pipeline. Tracking it by record type, lead source or owner shows which deals and segments carry the most weight.

Full guide: definition, formula, and benchmarks

Average Deal Size

Average Deal Size measures the mean revenue value of opportunities that reach a closed-won stage in Salesforce over a defined period. It is calculated from the Amount field on Opportunity records, filtered to the won stage, so it reflects the typical contract value your team actually closes rather than the value of open pipeline. Tracking it by record type, lead source or owner shows which deals and segments carry the most weight.

How to calculate average deal size

Average Deal Size = Total Closed-Won Opportunity Amount in Period / Number of Closed-Won Opportunities in Period

Why average deal size matters for Salesforce users

Average Deal Size is one of the clearest signals of whether your team is moving up-market or stalling. A rising figure means you are winning larger contracts or pricing more effectively, while a flat or falling figure can mean discounting pressure, a shift towards smaller accounts, or reps closing whatever is easiest rather than what is most valuable.

It also underpins capacity and target planning. Once you know the typical value of a Salesforce closed-won deal, you can work backwards to how many opportunities each rep needs to hit quota, and you can spot when a single large deal is flattering the average rather than a genuine improvement across the board.

Understand and act on average deal size with KPI Tree

Sync your Salesforce Opportunity data into your warehouse and compute Average Deal Size in KPI Tree from closed-won Amount values, segmented by record type, owner or source. Link it into a metric tree alongside contract value analysis and customer lifetime value so you can see how deal size feeds total revenue and downstream account value rather than reading it in isolation.

Assign RACI ownership to a sales leader or revenue operations lead so there is clear accountability for the trend, and set a monthly review cadence in KPI Tree to catch shifts in segment mix or discounting early. Pairing the metric with its drivers means any movement comes with the context needed to act on it.

Get started with your Salesforce data

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Salesforce data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Related Salesforce metrics

Contract Value Analysis

CRM

Metric Definition

Contract value analysis examines the distribution and trends of contract values across Salesforce opportunities and contracts. It segments total contract value (TCV) and annual contract value (ACV) by customer segment, product mix, contract term length, and sales rep to identify pricing patterns, discount behaviours, and deal structuring trends that influence long-term revenue.

View metric

Customer Lifetime Value

CRM

Metric Definition

Customer Lifetime Value = Average Revenue per Customer per Year x Gross Margin % x Average Customer Lifespan

Customer lifetime value (CLV) estimates the total net revenue a customer will generate over their entire relationship with your business. Using Salesforce opportunity history, renewal data, expansion revenue, and churn patterns, CLV quantifies the long-term return on each customer acquisition and retention investment.

View metric

Customer Acquisition Cost

CRM

Metric Definition

Customer Acquisition Cost = Total Sales & Marketing Spend / Number of New Customers Won

Customer acquisition cost (CAC) measures the total sales and marketing investment required to win a new customer. Using Salesforce opportunity data, campaign costs, and activity records, CAC quantifies acquisition efficiency and determines the breakeven point for each new customer relationship.

View metric

Contact Conversion Rate

CRM

Metric Definition

Contact Conversion Rate = (Contacts with Opportunities / Total Qualified Contacts) x 100

Contact conversion rate measures the percentage of contacts in Salesforce that become associated with an opportunity. It evaluates the effectiveness of lead qualification, nurturing, and sales development at converting the contact database into active pipeline.

View metric

Empower your team to understand and act on Salesforce data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business