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 benchmarksPipeline 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
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
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.
Forecast Accuracy
CRMMetric 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.
Quota Attainment
CRMMetric 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.
Explore pipeline coverage ratio across integrations
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.