KPI Tree

Salesforce Metric

CRM

Pipeline value measures the total monetary value of all open opportunities in Salesforce at a given point in time. It provides a snapshot of the revenue potential currently in the sales pipeline, segmented by stage, expected close date, owner, territory, and product to give a comprehensive view of future revenue potential.

Full guide: definition, formula, and benchmarks

Pipeline Value

Pipeline value measures the total monetary value of all open opportunities in Salesforce at a given point in time. It provides a snapshot of the revenue potential currently in the sales pipeline, segmented by stage, expected close date, owner, territory, and product to give a comprehensive view of future revenue potential.

Why pipeline value matters for Salesforce users

Pipeline value is the most fundamental sales metric in Salesforce because it represents the total revenue opportunity the organisation is actively pursuing. But raw pipeline value is frequently misleading: it includes aged deals unlikely to close, opportunities with inflated values, and deals in early stages with low conversion probability. The value of pipeline tracking comes from segmenting it by stage, age, and segment to distinguish between high-quality pipeline likely to convert and low-quality pipeline that inflates coverage ratios.

Pipeline value trends over time reveal the health of the demand generation engine. Declining pipeline value signals future revenue shortfalls months before they materialise in bookings. Growing pipeline value with stable or declining win rates suggests a quality problem masked by volume. Tracking pipeline value alongside conversion metrics creates a complete picture of whether the sales organisation has both sufficient quantity and quality of pipeline to achieve its targets.

Understand and act on pipeline value with KPI Tree

Sync Salesforce opportunity records with values, stages, and expected close dates into your warehouse. KPI Tree captures pipeline snapshots over time and calculates pipeline value by stage, age band, segment, territory, and owner.

Add pipeline value to your metric tree as a top-level health metric with stage-level and segment-level breakdowns as children. Assign ownership to sales leaders for their territory pipeline, set alerts for pipeline value drops that threaten coverage, and track pipeline value trends period-over-period alongside win rates to ensure both quantity and quality are maintained.

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

Pipeline Coverage Ratio

CRM

Metric Definition

Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target or Quota

Pipeline coverage ratio measures the total value of open pipeline in Salesforce divided by the revenue target or quota for a given period. It indicates whether sufficient pipeline exists to absorb normal loss and slippage rates while still achieving the revenue goal.

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

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

Forecast Accuracy

CRM

Metric Definition

Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100

Forecast accuracy measures the percentage deviation between revenue forecasts derived from Salesforce pipeline data and actual closed revenue for a given period. It evaluates the reliability of opportunity stage probabilities, close date predictions, and deal value estimates across the sales organisation.

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