wowprompt

Weekly sales forecast call with commit, best case and gaps

Turns a deal list into a weekly forecast a sales manager can defend: deals sorted into commit, best case and pipeline by evidence, the gap to the monthly or quarterly target, and the questions to ask each rep. Use it for Monday forecast calls, month-end and quarter-end, when optimistic stages make the number unreliable.

A forecast sheet with deals sorted into commit, best case and pipeline, totals against the target, the gap, and questions for each sales rep
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Period and target: [e.g. October, 45 lakh in new bookings]
  • Booked so far: [e.g. 21 lakh]
  • Open deals: [paste rows: deal, rep, value, stage, expected close date, last buyer contact, next step, decision maker met yes or no]
  • Rules your team uses for commit: [e.g. verbal yes and paperwork sent, or none]

Task

Build an honest forecast from evidence, not from stage names.

Sort each deal

  1. Commit: decision maker met, budget confirmed, paperwork or purchase order in progress, close date inside the period.
  2. Best case: strong interest and a clear next step, but one item above is missing.
  3. Pipeline: everything else, including deals with no buyer contact in 14 days.
  4. Move any deal whose close date has slipped twice down one level.

Output format

  1. | Deal | Rep | Value | Rep's stage | Forecast level | Evidence | Missing |
  2. Totals: booked, commit, best case, and the gap to target.
  3. What it takes to close the gap: the three deals that matter most and the action on each.
  4. Questions for each rep, two per deal in commit and best case.
  5. Deals to close out as lost this week.

Rules

  • Values only as given; do not discount or inflate.
  • A deal with no next step in the diary is never commit.
  • Use lakhs and crores if the inputs do.
sales forecastforecast callcommit and best casesales target gapdeal forecastingsales manager review

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity