How to build a pipeline coverage report
A pipeline coverage report is an early-warning system. It tells you weeks before period close whether there is enough pipeline to hit the number, when you can still do something about it.
Two refinements separate a useful coverage report from a misleading one: setting the target from your real win rate rather than a generic 3x, and reading coverage against time remaining, since late-period pipeline cannot all close.
- Pipeline / quota Per rep and team
- 1 / win rate The target multiple
- vs time left Timing matters
Short answer
Build a pipeline coverage report by dividing open pipeline expected to close in the period by quota, for each rep and the team. Set the target multiple from your win rate (about 1 divided by win rate), and show coverage against time remaining in the period so thin coverage surfaces while there is still time to build pipeline.
Step by step
Total qualifying pipeline
For each rep and the team, sum open deals expected to close in the period. Exclude far-future close dates so coverage reflects what can actually land in time.
Divide by quota
Coverage equals qualifying pipeline divided by quota. Compute it per rep and rolled up to the team.
Set the target from win rate
Use roughly 1 divided by your win rate as the target multiple, not a blanket 3x. A 20 percent win rate needs 5x; a 33 percent win rate needs 3x.
Overlay time remaining
Show coverage against days left in the period. Adequate coverage early can be inadequate late, when little new pipeline can still close. Flag reps whose coverage is thin for the time left.
Common mistakes
Using a flat 3x target for everyone. If your win rate is 20 percent, 3x coverage falls short. Tie the target to each team's actual win rate for an accurate read.
Ignoring timing. Coverage without a time dimension treats week-one and week-twelve pipeline as equal, which they are not. Always read coverage against the calendar.
How Ardovo handles it
Ardovo computes coverage per rep and team against a win-rate-adjusted target and overlays time remaining. Rook warns early when coverage is thin for the days left and suggests which accounts to work to close the gap.
Frequently asked questions
How do you build a pipeline coverage report?
Divide open pipeline expected to close in the period by quota, per rep and team. Set the target multiple from your win rate, and read coverage against time remaining so thin coverage surfaces early.
What coverage target should the report use?
Roughly 1 divided by your win rate, not a blanket 3x. A 25 percent win rate implies a 4x target; a 33 percent win rate implies 3x. Tying the target to real win rate keeps the report honest.
Why does time remaining matter for coverage?
Because late-period pipeline cannot all close before the period ends. Adequate coverage in week one may be inadequate in week ten. Reading coverage against the calendar shows whether the pipeline can realistically convert in time.