Sales Pipeline Analysis
Turn a pipeline export into a decision doc. Numbers first, narrative second, actions third.
Inputs
Ask the user for:
- Pipeline export (CSV/sheet) with: account, stage, amount, close date, age in stage, owner, next step
- Quota/target for the period
- Historical stage-to-stage conversion rates (if known)
Analysis steps
- Coverage. Open pipe $ / remaining quota. Healthy = 3–4x. Flag if < 2.5x or > 6x (inflated).
- Stage mix. Sum by stage, compare to the funnel distribution that historically closed.
- Stage aging. For each deal, days in current stage. Anything > 1.5x median is stuck.
- Slip risk. Flag deals where: close date already moved ≥ 2x, next-step is blank or stale > 14 days, MEDDIC score low, no activity in last 21 days.
- Forecast math:
- Commit = deals w/ signed paper or verbal + strong Champion + EB aligned
- Best case = commit + late-stage deals with visible close plan
- Pipeline = best case + everything with realistic close this period
- The 3 moves. Across all findings, which 3 actions would most move the number? (Not 15 — three.)
Output template
# Pipeline Review — <period>
## Headline
Quota: $<x> · Commit: $<y> (<%>) · Best: $<z> (<%>) · Coverage: <n>x
## Coverage & mix
<table: stage, # deals, $ amount, % of total, healthy?>
## Stuck deals (>1.5x median stage age)
| Account | Stage | Days | Amount | Owner | Why stuck | Next move |
|---|---|---|---|---|---|---|
| … | | | | | | |
## Slip-risk deals this period
…
## The 3 moves
1. <action> — deals affected: <list> — owner: <name> — by: <date>
2. …
3. …
## Forecast risk
Upside: <$, what has to happen>
Downside: <$, which deals are most at risk>
Guardrails
- Reps inflate pipeline. If a deal has no verifiable next step in 21 days, mark it "inactive" — don't count in forecast.
- A close date that has moved twice is not a close date, it's a hope.
- Never present only the headline — always show the working.
- If pipeline coverage is > 6x, investigate whether leadership is rewarding pipeline creation over win rate.
1---2name: sales-pipeline-analysis3description: Analyze the sales pipeline — coverage, conversion rates, stage aging, slip risk, forecast — and surface the 3 actions that move the number. Use on "pipeline review", "forecast for the quarter", or "which deals are slipping?".4---56# Sales Pipeline Analysis78Turn a pipeline export into a decision doc. Numbers first, narrative second, actions third.910## Inputs1112Ask the user for:13- Pipeline export (CSV/sheet) with: account, stage, amount, close date, age in stage, owner, next step14- Quota/target for the period15- Historical stage-to-stage conversion rates (if known)1617## Analysis steps18191. **Coverage.** Open pipe $ / remaining quota. Healthy = 3–4x. Flag if < 2.5x or > 6x (inflated).202. **Stage mix.** Sum by stage, compare to the funnel distribution that historically closed.213. **Stage aging.** For each deal, days in current stage. Anything > 1.5x median is stuck.224. **Slip risk.** Flag deals where: close date already moved ≥ 2x, next-step is blank or stale > 14 days, MEDDIC score low, no activity in last 21 days.235. **Forecast math:**24 - Commit = deals w/ signed paper or verbal + strong Champion + EB aligned25 - Best case = commit + late-stage deals with visible close plan26 - Pipeline = best case + everything with realistic close this period276. **The 3 moves.** Across all findings, which 3 actions would most move the number? (Not 15 — three.)2829## Output template3031```32# Pipeline Review — <period>3334## Headline35Quota: $<x> · Commit: $<y> (<%>) · Best: $<z> (<%>) · Coverage: <n>x3637## Coverage & mix38<table: stage, # deals, $ amount, % of total, healthy?>3940## Stuck deals (>1.5x median stage age)41| Account | Stage | Days | Amount | Owner | Why stuck | Next move |42|---|---|---|---|---|---|---|43| … | | | | | | |4445## Slip-risk deals this period46…4748## The 3 moves491. <action> — deals affected: <list> — owner: <name> — by: <date>502. …513. …5253## Forecast risk54Upside: <$, what has to happen>55Downside: <$, which deals are most at risk>56```5758## Guardrails5960- Reps inflate pipeline. If a deal has no verifiable next step in 21 days, mark it "inactive" — don't count in forecast.61- A close date that has moved twice is not a close date, it's a hope.62- Never present only the headline — always show the working.63- If pipeline coverage is > 6x, investigate whether leadership is rewarding pipeline creation over win rate.
composio-community