KPI Tree

Salesforce Metric

CRM

Deal stage progression measures the rate and pattern of opportunity movement through pipeline stages in Salesforce. It tracks forward progression, stage skipping, regression (deals moving backwards), and stagnation (deals stuck in a stage), providing a comprehensive view of how effectively the sales process advances deals toward close.

Deal Stage Progression

Deal stage progression measures the rate and pattern of opportunity movement through pipeline stages in Salesforce. It tracks forward progression, stage skipping, regression (deals moving backwards), and stagnation (deals stuck in a stage), providing a comprehensive view of how effectively the sales process advances deals toward close.

Why deal stage progression matters for Salesforce users

Salesforce opportunity stages are designed to represent a linear sales process, but real deals rarely follow a straight path. Deals regress when buyers raise new objections, skip stages when champions accelerate decisions, and stall when procurement gets involved. Understanding these patterns is essential for accurate forecasting and process improvement.

Progression analysis reveals which stages serve as genuine gates versus administrative checkboxes. If deals frequently skip from discovery to proposal without passing through a formal solution design stage, either the stage is unnecessary or reps are not following the process. Both insights lead to process improvements: removing unnecessary stages reduces friction, while enforcing critical stages improves deal quality and win rates.

Understand and act on deal stage progression with KPI Tree

Sync Salesforce opportunity stage history with timestamps into your warehouse. KPI Tree analyses progression patterns, calculating forward movement rates, regression frequencies, skip patterns, and stagnation durations per stage.

Build a stage progression branch in your metric tree showing movement patterns at each transition. Assign stage ownership to sales managers, set alerts for increased regression or stagnation at any stage, and compare progression patterns across deal types and reps to identify where the process helps and where it hinders.

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

Win Rate

CRM

Metric Definition

Opportunity Win Rate = (Closed-Won Opportunities / Total Closed Opportunities) x 100

Opportunity win rate measures the percentage of closed opportunities in Salesforce that result in a won outcome. It is the definitive measure of sales effectiveness, capturing the combined impact of qualification, competitive positioning, pricing, negotiation, and execution across the entire pipeline.

View metric

Sales Pipeline Velocity

CRM

Metric Definition

Pipeline Velocity = (Number of Opportunities x Average Deal Value x Win Rate) / Sales Cycle Length

Pipeline velocity quantifies the rate at which opportunities in Salesforce convert into revenue. It combines the number of qualified opportunities, average deal value, win rate, and sales cycle length into a single metric representing the revenue-generating throughput of the sales organisation per unit of time.

View metric

Sales Cycle Length

CRM

Metric Definition

Sales Cycle Length = Average(Close Date - Opportunity Created Date)

Sales cycle length measures the average number of days from opportunity creation in Salesforce to a closed-won outcome. It captures the full duration of the active sales process and is a critical input for pipeline velocity, coverage calculations, and revenue forecasting.

View metric

Opportunity Aging

CRM

Metric Definition

Opportunity aging analyses the age distribution of open opportunities in Salesforce by measuring days since creation or days in current stage. It identifies opportunities that have exceeded normal timelines, categorises pipeline into age buckets, and quantifies the proportion of pipeline at risk of being stale or unlikely to close.

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