Tracking · Forecast / Deal Hygiene Rules

Build a Pipeline Coverage Ratio Rule

Set a hard pipeline coverage ratio rule (e.g., 3x remaining quota) and define the actions that trigger when reps fall below it.

foundermanagerAdvanced⏱ Prevents quarterly quota misses
When to use
Use this when reps are coasting on lagging deals and not generating new pipeline early in the quarter. The rule creates an early-warning system before quota misses are inevitable.
The prompt
You are a head of sales at a digital agency who has used coverage-ratio rules to prevent end-of-quarter pipeline crises.
Agency: [AGENCY_NAME] — [SERVICES] | CRM: [CRM_TOOL] | Avg win rate: [WIN_RATE] | Sales cycle: [SALES_CYCLE_DAYS] days | Quarterly quota: [QUOTA] | Target coverage multiple: [COVERAGE_TARGET].
Build a Pipeline Coverage Ratio rule. Define the target multiple based on [WIN_RATE], the measurement cadence, what counts as "in-quarter" pipeline, what falls below threshold triggers, and the manager actions.

- Target multiple must be derived from inverse of [WIN_RATE] (e.g., 25% win rate → 4x minimum).
- "In-quarter" pipeline = open deals with close date in current quarter, in Pipeline/Best Case/Commit.
- Measurement cadence: weekly on Friday EOD.
- Below-threshold triggers must escalate over time (3 weeks below = intervention).
- Rule must be calculable as a single [CRM_TOOL] report or formula.

Rule document with: Formula, Target Multiple Justification, Measurement Cadence, Threshold Bands (Healthy / Caution / At Risk), Action Matrix, and [CRM_TOOL] Setup. Include a worked example with the agency's numbers.
Variables
  • [AGENCY_NAME] — Your agency
  • [SERVICES] — Services
  • [CRM_TOOL] — CRM
  • [WIN_RATE] — Overall win rate from qualified opp to closed won
  • [SALES_CYCLE_DAYS] — Avg cycle in days
  • [QUOTA] — Quarterly quota per rep
  • [COVERAGE_TARGET] — Target ratio — e.g., 3x or 4x
Example input
Agency: Refraction Agency — paid social + creative | CRM: Pipedrive | Win rate: 28% | Cycle: 32 days | Quota: $150K/qtr | Target: 3.5x.
Example output
REFRACTION AGENCY — PIPELINE COVERAGE RATIO RULE

Formula: In-Quarter Pipeline $ ÷ Remaining Quota $ = Coverage Ratio
Target: 3.5x (derived from 28% win rate, inverse = 3.57)

Measurement: Friday EOD via Pipedrive saved report "In-Quarter Pipeline by Rep."

Threshold Bands:
- Healthy: ≥ 3.5x — no action.
- Caution: 2.5x-3.49x — rep adds 1 prospecting block to next week's calendar.
- At Risk: < 2.5x — mandatory pipeline-gen blitz + manager joins next 2 discovery calls.
- Critical: < 2.5x for 3 consecutive weeks — formal pipeline plan + weekly manager review.

Worked example: Rep Sarah has $52K remaining quota, $98K in-quarter pipeline = 1.88x → At Risk band triggered.

Pipedrive Setup: Custom field "Coverage Ratio" computed weekly via report; auto-Slack alert when rep drops below 2.5x.
Pro tips
  • Use inverse of your true win rate as a floor — 30% win rate = 3.3x minimum, no exceptions.
  • Track coverage by stage too — heavy late-stage but thin early-stage signals a cliff coming next quarter.
  • Display coverage ratios on a public team dashboard; transparency drives prospecting behavior.
Works with
ClaudeChatGPTGemini
Done with prompts? Time to install the system
Book a STAOS call
Related prompts