pipeline-review
Audit pipeline health from CRM data — identify at-risk deals, surface stalled opportunities, flag forecast risk, and recommend where to focus.
Stage: Pipeline and deal management
Pipeline Review
Use this skill to get a structured health check on your pipeline. Bring your deal data and get back: a coverage assessment, at-risk deal flags, stall analysis, and a recommended focus list for the week.
Works with HubSpot MCP (if connected), pasted deal data, or a CSV export from your CRM. No Saber CLI required.
Input
Ask the user how they want to provide pipeline data:
Option A — HubSpot MCP (if available) Check for HubSpot tools in the available tool list. If connected, pull deals directly:
Fetch all open deals from HubSpot, including: deal name, company, stage, amount,
close date, last activity date, owner, and any custom signal properties.Option B — Paste or describe Ask the user to paste a pipeline export or describe their open deals. Minimum useful fields:
- Company name
- Deal stage
- Deal value / ACV
- Expected close date
- Last activity date
- Owner
Option C — CSV If the user uploads a CSV, parse it and proceed with whatever fields are present.
Step 1 — Pipeline overview
Calculate and present:
PIPELINE OVERVIEW
Total open pipeline: $[X]
Deal count: [N] deals across [N] reps
Average deal size: $[X]
Weighted pipeline: $[X] (stage-weighted by typical conversion rates)
BY STAGE
[Stage name]: [N] deals, $[X] value, avg [N] days in stage
[...]
COVERAGE
Quota this period: $[X]
Pipeline: $[X]
Coverage ratio: [X]x
[Flag if below 3x]Step 2 — At-risk deals
Flag deals showing risk signals:
Stalled — in the same stage for longer than typical No recent activity — no logged activity in 14+ days Slipping close date — close date has moved more than once Single-threaded — only one contact on the deal Missing next step — no scheduled next activity Late-stage with no economic buyer — in proposal/negotiation but no exec engaged
AT-RISK DEALS
🔴 [Company] — $[X] — [Stage]
Risk: [Stalled 28 days / No activity since [date] / Close date moved 3x]
Owner: [Name]
Recommended action: [Specific suggested next step]
🟡 [Company] — $[X] — [Stage]
Risk: [Watch area]
[...]Step 3 — Forecast analysis
Assess commit and best-case forecast:
FORECAST
Commit (high confidence): $[X] — [N] deals
Best case (likely to close): $[X] — [N] deals
Pipeline (needs work): $[X] — [N] deals
FORECAST RISK
[Deal name]: $[X] — [reason this might not close as forecast]
[...]
GAP TO QUOTA
[If commit covers quota: "Commit covers quota — focus on best-case upside"]
[If gap exists: "Gap of $[X] — need to close [N] deals from best-case or pull something forward"]Step 4 — Where to focus
Recommend the top 5 deals to prioritise this week, with reasoning:
FOCUS LIST — This Week
1. [Company] — $[X] — [Stage]
Why: [Highest value deal with a clear path to close / decision expected this week / at risk of stalling]
Next step: [Specific action]
2. [...]Step 5 — Pipeline health score
Rate overall pipeline health:
- Coverage — is there enough pipeline to hit quota?
- Velocity — are deals moving through stages at a healthy pace?
- Distribution — is pipeline too concentrated in one stage or one rep?
- Quality — are deals well-qualified or are there a lot of early-stage unknowns?
PIPELINE HEALTH
Coverage: [Green / Yellow / Red] — [X]x coverage
Velocity: [Green / Yellow / Red] — avg [N] days per stage
Distribution: [Green / Yellow / Red] — [observation]
Quality: [Green / Yellow / Red] — [observation]
OVERALL: [Healthy / Needs attention / At risk]Step 6 — Suggest next steps
- Use
deal-coachingon the top 2–3 at-risk deals for deeper analysis - Use
write-outreachto re-engage stalled deals with a signal-informed message - Use
find-expansion-accountsto identify upsell opportunities in the existing customer base - Schedule a follow-up pipeline review in 2 weeks to track movement