# 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.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Sales, Meetings, Fill-in Template, Step-by-step
- Source: https://www.thinkwithprompt.com/prompts/calculate-how-much-pipeline-i-need-to-hit-my-number

## Prompt

```text
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.
```

## 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

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.