Calculate how much pipeline I need to hit my number
Reverse-funnel math that turns your target into required pipeline, opportunities, meetings, and activities by month.
The prompt
Help me work backward from my revenue target to the pipeline and activity I need.
Target: [AMOUNT and period]
Already closed or committed: [AMOUNT]
Average deal size: [AMOUNT, by segment if different]
Win rate: [% from qualified opportunity to closed-won, by segment if known]
Average sales cycle: [days]
Stage conversion rates: [e.g. meeting to opportunity %, lead to meeting %]
Current open pipeline: [AMOUNT by expected close month]
Sources of pipeline: [e.g. inbound, outbound, partners, expansion, with recent share of each]
Steps:
1. Calculate the remaining gap and the qualified pipeline needed to cover it at my win rate. Show the coverage ratio this implies (e.g. 3x).
2. Use the sales cycle to show WHEN pipeline must be created to close in the period. Flag if the creation window has already passed for part of the target.
3. Work back through conversion rates to opportunities, meetings, and top-of-funnel activity per week, per source.
4. Compare required vs current pipeline and show the shortfall by month.
5. Run a sensitivity check: what if win rate drops 5 points or deal size drops 10%?
Return:
- The math step by step, with formulas, so I can rebuild it in a spreadsheet.
- A table: Month | Pipeline needed | Pipeline on hand | Gap | Opps to create.
- Weekly activity targets by source.
- The 3 levers that close the gap fastest.
Use only the inputs I give you. Label any assumption you must make.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- AMOUNT and period
- AMOUNT
- AMOUNT, by segment if different
- days
- e.g. meeting to opportunity %, lead to meeting %
- AMOUNT by expected close month
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Build a simple spreadsheet to track ticket sales for an eventStep-by-step setup for a ticket sales tracker with a data entry form, search, totals, and payment status for fundraisers and community events.
- Set the right list price for my home from comparable salesA price range based on comparable sales and market speed, with a pricing strategy and a plan for when to adjust.
- Choose a webinar topic and title people will register forA webinar topic, title, and promise that match what your buyers want and lead naturally to your offer.
- Identify the leading and lagging indicators for my business or teamSorts your metrics into leading and lagging indicators, links each lead to the outcome it predicts, and fills gaps in early-warning measures.