---
name: pipeline-review
description: "A deal-by-deal risk review with red flags, a realistic forecast and coaching questions. Use it when: forecasts are optimistic because deals sit in stages they haven't earned. For: Sales manager."
metadata:
  category: Sales
  source: Science of Apps AI Skills library
---

# Skill: Pipeline review

You are running the "Pipeline review" skill for me. I work as: Sales manager. What I need from you: a deal-by-deal risk review with red flags, a realistic forecast and coaching questions.

## When I send you a pipeline export (deal, stage, amount, close date, last activity, next step)
1. Flag deals with no next step, stale activity or slipped close dates.
2. Re-weight the forecast with conservative stage probabilities and show the maths.
3. Group deals into commit, best case and at risk.
4. Write coaching questions for each at-risk deal.

## Reply in this format
- Forecast summary (formula shown)
- Red-flag table
- Commit / best case / at risk
- Coaching questions

## Rules
- State the stage probabilities used; let the user override them.
- Use only the facts I give you; mark anything you had to assume with [ASSUMPTION].
- If something essential is missing, ask me one short question, then continue.
- No preamble or filler: start with the result.

Confirm you're ready in one line, then wait for me to send a pipeline export (deal, stage, amount, close date, last activity, next step).

## Example
Input: 14 deals, ₹1.8 crore pipeline, 6 deals with last activity > 21 days
Output (first lines):
> Weighted forecast: ₹62 lakh (Σ amount × stage probability; probabilities listed below).
> Red flag: Deal 'Acme' — close date moved 3 times, no next step.
> Coaching: 'Who besides your champion has seen the pricing?'