Sales Pipeline Analytics & Forecasting
Audit pipeline for forecast accuracy, identify stalled deals and acceleration opportunities, assess win rates by stage and rep, score deals by close probability, and create coaching points and bottleneck fixes for weekly execution.
Use This When
Planning, analysis, client strategy sessions, decision support.
Inputs Needed
Business model, goal, constraints, market, competitors, budget, timeline, internal capabilities.
Expected Output
Executive summary, diagnosis, options, risks, recommended path, implementation plan, KPIs.
The Workflow Prompt
You are a business strategist and operator. Objective: Sales Pipeline Analytics & Forecasting Context: Audit pipeline for forecast accuracy, identify stalled deals and acceleration opportunities, assess win rates by stage and rep, score deals by close probability, and create coaching points and bottleneck fixes for weekly execution. Original task: **Act as a sales analytics expert.Analyze our sales pipeline for [SALES_PERIOD]. Pipeline data: [OPPORTUNITY_STAGE_DATA, WIN_RATES_BY_STAGE, SALES_CYCLE_LENGTH]. Current forecast vs. actual: [FORECAST_ACCURACY]. Your task:(1) What's driving variance between forecast and actual?(2) Which sales reps are accurately forecasting vs. sandbagging or being overly optimistic?(3) Where are deals stalling in the pipeline?(4) How long is the typical sales cycle and is it changing?(5) What's the actual win rate by deal stage, rep, and market segment?(6) Which opportunities are most likely to close?(7) Where should we focus sales efforts for maximum impact? Analyze deal health: scoring factors that predict close probability. Identify:(1) Opportunities to accelerate close(2) Stuck deals and how to unstick them(3) Sales cycle optimization opportunities(4) Rep performance drivers. Model: If we improve win rate by X% in stage Y, what's the revenue impact? Present as: Pipeline Overview → Stage-by-Stage Analysis → Win Rate & Sales Cycle Analysis → Deal Health Assessment → Sales Rep Performance Analysis → Bottleneck Identification → Acceleration Opportunities → Forecast Confidence Assessment → Rep-Specific Coaching Points. Make it actionable for weekly sales reviews.** Inputs I may provide: Business model, goal, constraints, market, competitors, budget, timeline, internal capabilities. Operating instructions: - First, restate the objective in one clear sentence. - If critical information is missing, ask up to 5 focused questions. If there is enough information to proceed, make practical assumptions and label them. - Use a Detailed response style. - Be specific to the business, audience, channel, and constraints provided. - Avoid generic AI advice. Give concrete recommendations, examples, templates, copy, or steps I can use. - When current facts, competitors, laws, prices, policies, or market claims matter, use current research and cite sources. - Do not expose hidden chain-of-thought. Provide a concise rationale or decision summary instead. - End with a short QA checklist that helps me verify the output. Required output: Executive summary, diagnosis, options, risks, recommended path, implementation plan, KPIs. Caution: Do not treat output as professional legal, medical, financial, or compliance advice; verify with a qualified expert. Use live web research or source documents before finalizing claims.
QA Follow-Up Checklist
After the AI returns its output, verify against:
- Output is specific to the provided business/context.
- Assumptions are clearly labeled.
- No unsupported claims without source checks.
- Next actions are clear and usable.
Follow-Up Prompt
Now turn the result for 'Sales Pipeline Analytics & Forecasting' into a client-ready version: tighten wording, remove fluff, add missing assumptions, and provide the next 3 actions.
Avoid / Cautions
Do not treat output as professional legal, medical, financial, or compliance advice; verify with a qualified expert. Use live web research or source documents before finalizing claims.
How Different Verticals Use This Workflow
Restaurant & Hospitality
A catering company with a 5-person sales team forecasts $4.8M in pipeline but only closes $1.9M. They run the analysis on 18 months of HubSpot data — output reveals that 60% of stalled deals sit in 'proposal sent' because reps don't have a structured follow-up sequence past day 7. The fix is a 14-day touch cadence baked into the pipeline stage definition; forecast accuracy improves from 31% to 68% over two quarters.
Retail & E-commerce
A wholesale brand selling into independent retailers runs the analysis on their B2B pipeline of 300 active accounts. The model surfaces that deals over $25K close at 41% but deals under $10K close at 12% — and reps are spending 60% of time on the small ones because they're 'easier conversations.' Output is a deal-size threshold for SDR vs. AE handoff plus a 'minimum order to engage' policy that lifts rep productivity 2.3x in a quarter.
Professional Services & B2B
A 25-rep SaaS sales team has been missing forecast for three quarters running. They feed in Salesforce data plus rep-level forecast vs. actual. The analysis identifies that two senior reps systematically sandbag (call deals 30%, close 75%) and three new reps systematically inflate (call 80%, close 40%). The output is a weighted forecast that adjusts per-rep historical accuracy, not the raw commit number — first quarter post-implementation lands within 4% of forecast.
Beauty & Personal Care
A skincare brand selling into spa channels and medical practices has two distinct sales motions running through one pipeline. The analysis splits them out and reveals med-spa deals close 3x faster but at 40% the deal size — and the sales team has been optimizing the wrong KPI (deal count vs. revenue per quarter). Output is a re-segmented pipeline and a rep specialization recommendation that lifts revenue per rep 28% in two quarters.
Local & Trade Services
A commercial cleaning company tracking 80 active proposals can't tell why win rate dropped from 35% to 22%. The analysis surfaces that the median time from site walk to proposal stretched from 4 days to 11 days during a staffing crunch — and prospects who waited more than 7 days closed at 8%. The fix is a hard SLA on proposal turnaround and a stripped-down 'quote within 48 hours' template for sub-$50K opportunities. Win rate recovers to 31% within a quarter.
Frequently Asked
What inputs separate a useful pipeline read from generic CRM hygiene advice?
Stage-by-stage win rate over the trailing four quarters (not lifetime — markets shift), median deal age in each stage, and rep-level forecast accuracy on the last 12 weeks. Without rep accuracy data, you can't tell sandbagging from optimism, and the coaching recommendations become generic 'have better discovery calls' fluff. Force the model to refuse the analysis if those three aren't present.
How do I keep the output from being a 40-page deck nobody reads?
Ask it to compress to three artifacts: a one-page weekly forecast confidence summary (commit/best/upside with the assumptions that would break each), a rep scorecard showing forecast accuracy and stage-conversion deltas, and a 'top 10 deals to unstick' list with the specific action per deal. Anything beyond that is for the QBR, not the Monday sales meeting.
Should I run this on Claude Opus or ChatGPT Thinking?
Opus when you're doing the diagnostic pass — it's better at finding the non-obvious pattern (e.g., 'win rate drops 22% when the champion changes mid-cycle' is the kind of insight Opus surfaces and ChatGPT misses). ChatGPT Thinking when you're doing the weekly numerical refresh and consistency matters more than insight. The team that uses both gets a better answer than either alone.
What's the failure mode that makes this analysis worse than nothing?
Acting on a small sample. If you have 80 deals in pipeline and 12 closed-won last quarter, your 'stage 3 win rate' is statistical noise. The fix: pre-commit to a minimum sample size before acting on any rep-level finding (40 deals minimum), and present everything else as hypothesis worth investigating in 1:1s, not law. Reps fired or PIP'd off thin pipeline data is the avoidable disaster here.