Business Strategy

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.

Anselm Fowel / Public collection19 Feb 2026

Your prompt

The prompt

**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.**

1,283 characters

Your prompt

Recent articles