KPI Tree

Salesforce Metric

CRM

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.

Full guide: definition, formula, and benchmarks

Pipeline Coverage Ratio

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.

How to calculate pipeline coverage ratio

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

Why pipeline coverage ratio matters for Salesforce users

Pipeline coverage is the earliest reliable indicator of whether revenue targets will be achieved. Most organisations need three to four times coverage to hit quota, but the required ratio depends on historical win rates, average deal sizes, and the mix of pipeline stages. Salesforce contains all the data needed to calculate the precise coverage ratio required, yet many teams use rule-of-thumb multiples that do not reflect their actual conversion patterns.

Coverage ratio is most powerful when segmented by rep, team, and time horizon. A team with adequate overall coverage but one rep at 1.5x coverage has a localised risk that aggregate metrics hide. Similarly, coverage that looks healthy for the current quarter but thin for next quarter reveals a pipeline generation problem that needs attention now, not in sixty days.

Understand and act on pipeline coverage ratio with KPI Tree

Sync Salesforce opportunity values, stages, and quota data into your warehouse. KPI Tree calculates coverage ratios by rep, team, segment, and time period, applying historical win rates to determine required coverage levels.

Add pipeline coverage as a strategic health metric at the top of your metric tree. Assign ownership to sales leaders for their team's coverage, set threshold alerts when coverage drops below required levels, and track coverage trajectories to predict whether pipeline generation rates will sustain future quota achievement.

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

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

Quota Attainment

CRM

Metric Definition

Quota Attainment = (Closed-Won Revenue / Assigned Quota) x 100

Quota attainment measures the percentage of assigned revenue quota that a rep, team, or territory has achieved through closed-won opportunities in Salesforce. It is the ultimate accountability metric for sales, directly connecting individual and team performance to the revenue commitments that drive business planning.

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