wowprompt

Sales Pipeline Review With Deal Risk Scoring

Scores every open deal for risk, flags stalled opportunities and sets the next action for each before the quarter closes. Use it in a weekly pipeline meeting or during Q4 when the forecast needs to be honest.

A pipeline review with a deal risk table scored on five factors, a stalled deals list, a commit versus upside forecast and next actions
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Open deals: [paste one row per deal: name, value, stage, expected close date, last activity date, decision maker engaged (yes or no), next step agreed (yes or no), notes]
  • Quarter end date: [for example 31 December 2026]
  • Quarter target and closed so far: [amounts]

Task

Review the pipeline deal by deal and score the risk that each deal will not close by the expected date.

Scoring

Give each deal 0 to 2 points on five factors, where 2 is low risk:

  1. Decision maker engaged.
  2. Next step agreed with a date.
  3. Activity in the last 14 days.
  4. Close date realistic for the stage.
  5. Budget confirmed.

Total of 8 to 10 is low risk, 5 to 7 is medium, 0 to 4 is high.

Output format

  1. Risk table: | Deal | Value | Stage | Score | Risk | Main risk reason | Next action | Owner role |
  2. Stalled deals: no activity in 21 days or close date already passed.
  3. Forecast: | Category | Deals | Total value |, with commit (low risk), best case (medium) and at risk (high).
  4. Gap to target and the three deals most worth extra effort.

Rules

  • Base scores only on the data given; mark missing data as a risk.
  • Next actions start with a verb and are doable this week.
pipeline reviewdeal risk assessmentsales pipeline analysissales forecast reviewq4 pipelinedeal inspection

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