What Is Pipeline Coverage?
Pipeline coverage is the ratio of total qualified opportunity value to the revenue target for a given period, telling sales leaders whether the team has enough deals to hit quota even if some slip or are lost. A ratio sitting below 3x in a CRM export often signals a gap that needs immediate attention.
See the exact formula, how to filter stale deals before calculating the ratio, and how to track both weighted and unweighted views in a spreadsheet.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| opportunity_id |
| stage |
| close_date |
| deal_value |
| probability |
| owner_name |
| weighted_value |
| created_date |
| account_name |
| revenue_target |
What usually goes wrong with it
Stale opportunities inflate the ratio
Opportunities with close_dates more than 90 days in the past and no status update inflate the total, making the multiple appear stronger than it is.
DataMimi Datamimi flags stale opportunities by comparing close_date to today and removes them automatically so the ratio reflects current pipeline only.
Weighted vs unweighted creates confusion
Some teams calculate the ratio using raw deal_value; others use probability-weighted weighted_value — mixing the two methods across quarters makes trend data incomparable.
DataMimi It calculates both unweighted and probability-weighted multiples in parallel columns so teams can compare both views without maintaining two separate models.
Revenue target not in the CRM export
revenue_target is usually set in a separate planning spreadsheet rather than the CRM, requiring a manual lookup to add it to the calculation.
DataMimi It accepts a separate revenue target file and joins it to the CRM export on period and owner_name so the ratio is calculated in one step.
Common questions
What is pipeline coverage?
Pipeline coverage is the ratio of qualified opportunity value to the revenue target for a period — a 3x multiple means there is three times more pipeline than quota, providing buffer for deals that slip.
What multiple should a sales team target?
Most organizations target 3x to 4x; teams with lower average deal sizes or faster sales cycles may target 5x to account for higher volume variability.
How do I calculate it in a spreadsheet?
Sum all qualified opportunity deal_value values with close_dates in the target period; divide by the revenue_target for that period; the result is your coverage multiple.
Should I use probability-weighted values?
Weighted values are more accurate because they account for win probability at each stage; unweighted figures are simpler and more commonly used for high-level board reporting.
How much does Datamimi cost?
Datamimi offers a Free plan at $0/month (40 credits, no credit card required), Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, up to 3 simultaneous files), Pro at $59/month (5,000 credits with rollover), and Team at $199/month (20,000 credits, 5 users).
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file