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
Connect your existing warehouse where Salesforce data already lands.
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
CRMMetric 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.
Sales Pipeline Velocity
CRMMetric 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.
Sales Cycle Length
CRMMetric 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.
Opportunity Aging
CRMMetric 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.
All Salesforce metrics
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.