Analyze · Forecasting & Gap-to-Quota

Analyze the Gap to Quota for This Quarter

Quantify the dollar gap between your weighted pipeline and quota, then break it into the exact actions needed to close it.

foundermanagerIntermediate⏱ 60-90 minutes per quarter
When to use
Use mid-quarter when leadership asks 'are we going to hit?' Run it after weekly pipeline review so the numbers are fresh. Especially valuable when you need to translate a vague 'we're behind' into a specific deal count, dollar number, and meeting volume.
The prompt
You are a sales leader who runs forecast calls at digital marketing agencies. You quantify gaps in deals, dollars, and meetings — not vibes.
Agency: [AGENCY_NAME] — [SERVICES]
Quota: [QUOTA] | Closed-won to date: [CLOSED_WON_TO_DATE] | Quarter end: [QUARTER_END_DATE]
Avg deal: [AVG_DEAL_SIZE] | Win rate by stage: [HISTORICAL_WIN_RATE] | Cycle: [CYCLE_DAYS] days
Open pipeline:
[PIPELINE_DATA]
Calculate the gap to quota in dollars, then translate it into the specific number of deals, weighted pipeline, and net-new meetings required to close it before [QUARTER_END_DATE].

- Show ALL math: closed + weighted pipeline = forecast; quota − forecast = gap.
- Never round generously — round down on weighted pipeline, round up on gap.
- Only count open deals whose stage win rate × amount can realistically close in remaining days (compare to [CYCLE_DAYS]).
- Flag any deal whose forecast category looks inflated vs. stage.
- If gap can't be closed by existing pipeline, calculate how many net-new opps at [AVG_DEAL_SIZE] are needed.

1. Today's number: Closed $ | Weighted Pipeline $ | Forecast $ | Quota $ | Gap $
2. Gap math (line by line)
3. Path to close the gap: (a) deals to convert from existing pipeline, (b) net-new opps needed, (c) meetings needed assuming meeting→opp rate of 50%
4. 3 inflated-forecast deals to scrub first
Variables
  • [AGENCY_NAME] — Your agency name
  • [SERVICES] — Service lines you sell
  • [QUOTA] — Quarterly quota in dollars
  • [CLOSED_WON_TO_DATE] — Revenue closed so far this quarter
  • [QUARTER_END_DATE] — Quarter end date
  • [AVG_DEAL_SIZE] — Average deal size
  • [HISTORICAL_WIN_RATE] — Win rate per stage
  • [CYCLE_DAYS] — Average sales cycle days
  • [PIPELINE_DATA] — Open deals: name, stage, amount, close date, notes
Example input
Agency: PixelForge — web design + SEO
Quota: $300k | Closed-won to date: $115k | Quarter end: 2026-06-30
Avg deal: $22k | Win rate: Disco 10%, Proposal 35%, Negotiation 65% | Cycle: 60 days
Pipeline (today 2026-05-25):
- Harbor Realty | Negotiation | $30k | 2026-06-15
- IronGate Fitness | Proposal | $44k | 2026-06-25
- Juno Cafe | Discovery | $18k | 2026-07-05
Example output
Today's number:
- Closed: $115k | Weighted pipeline: ($30k×0.65)+($44k×0.35)+($0 Juno, out of quarter) = $19.5k + $15.4k = $34.9k
- Forecast: $149.9k | Quota: $300k | Gap: $150.1k

Gap math: $300k − $115k − $34.9k = $150.1k short.

Path to close:
(a) Convert all in-quarter open deals at full value: +$74k (still short).
(b) Net-new needed at $22k avg, 35% proposal win rate = ~20 new proposals OR ~7 closed deals from net-new opps.
(c) At 50% meeting→opp conversion, that's ~40 first meetings — not realistic in 36 days given 60-day cycle.

Scrub first: Juno Cafe (out of quarter, should be Omit), Harbor Realty (verify verbal before holding Commit), IronGate (Proposal stage with 65% rep call looks inflated vs. 35% historical).
Pro tips
  • Re-run weekly so you see the gap shrinking (or not) in real numbers, not feelings.
  • If net-new meetings required exceed what your team has ever booked, the honest answer is 'we're going to miss' — start expectation-setting now.
  • Pair this with the Pull-Forward Deals prompt to find quick wins inside the existing pipeline.
Works with
ClaudeChatGPTGemini
Done with prompts? Time to install the system
Book a STAOS call
Related prompts