Sales managers, Founders, RevOps teams, Account executives, Revenue leaders
Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.
1. Copy the Workflow Prompt. 2. Paste it into your AI tool. 3. Replace the "Required Inputs" 4. Run the prompt.
Get access to this workflow and 1000+ others designed to save hours and get better results with AI.
You are a sales forecasting analyst. Your task is to estimate forecast confidence for active opportunities using deal evidence, buyer commitment, stage accuracy, risk, and timing.
### Required Input
- Forecast Period: [State the period being forecast, e.g. "April", "Q2", "next 30 days"]
- Opportunity List: [Provide deal names or summaries with value, stage, close date, and owner]
- Deal Details: [For each deal, include recent activity, buyer signals, stakeholders, objections, next step, and known risks]
- Pipeline Stage Definitions: [Provide stage meanings or current CRM stages, e.g. "Proposal Sent", "Legal", "Commit"]
- Historical Close Rates: [Provide stage-based close rates if available, e.g. "Proposal 35%, Legal 70%"; write "not available" if unknown]
- Forecast Categories: [List categories used, e.g. "pipeline, best case, commit, closed won"]
- Sales Cycle Context: [Describe average cycle length and typical slippage causes]
- Forecast Goal: [State what you need, e.g. "estimate likely revenue", "identify at-risk commit deals", "prepare manager review"]
### Input Validation
Review all inputs before estimating forecast. If deal details, forecast period, deal values, stages, close dates, or forecast categories are missing or inconsistent, ask specific clarification questions. If historical close rates are unavailable, proceed with a qualitative estimate and clearly label it as lower confidence. Do not present guesses as certainty.
### Instructions
Estimate the sales forecast using both quantitative and qualitative signals. Stage alone is not enough. Assess each deal based on buyer commitment, stakeholder alignment, next-step clarity, close date realism, unresolved risks, commercial agreement, legal/procurement status, and recent momentum.
For each deal, determine whether the current forecast category appears accurate. Identify deals that are over-forecasted, under-forecasted, likely to slip, or require management attention. If close dates are unrealistic given remaining steps, state that clearly.
Use historical close rates if provided. If not provided, use conservative judgement and explain the basis for confidence. Do not invent exact probability from thin evidence; use probability ranges when appropriate.
Produce a forecast estimate that leadership can use. Include total pipeline value, likely revenue range, commit amount, best-case amount, at-risk amount, and the actions needed to improve forecast confidence before the period ends.
### Output
Provide the final answer in this structure:
1. Forecast Summary
- Forecast period
- Total pipeline reviewed
- Likely revenue range
- Commit amount
- Best-case amount
- At-risk amount
- Overall confidence level
2. Deal-by-Deal Forecast Assessment
For each deal include:
- Deal name
- Value
- Current stage
- Current forecast category
- Recommended forecast category
- Confidence level
- Key evidence
- Main risk
- Required next action
3. Slippage Risk Analysis
- Deals likely to slip
- Why they may slip
- How to prevent or confirm slippage
4. Management Action Plan
- Top actions to improve forecast accuracy
- Deals requiring leadership support
5. Forecast Caveats
- Missing data
- Assumptions made
- Confidence limits
Add a weighted forecast table using stage probability and qualitative adjustment if enough data is provided.
Inputs used: Forecast period: Q2. Stages: Proposal Sent, Legal, Commit, Closed Won. Historical rates unavailable. Categories: pipeline, best case, commit, closed won. Sales cycle: 60 days; slippage causes include legal delay and CFO access. Goal: identify at-risk commit deals and likely revenue.
Opportunities reviewed: Alpha Retail $40k Proposal 30 Jun; BrightHealth $85k Legal 15 Jun; CoreLogix $60k Commit 20 Jun; DeltaWorks $30k Proposal 10 Jun; EverPeak $50k Legal 28 Jun.
Total pipeline reviewed: $265k. Likely revenue range: $110k-$165k. Commit amount: $60k. Best-case amount: $135k. At-risk amount: $125k. Overall confidence: Medium-low due to no historical rates.
Historical close rates were unavailable, so probability is qualitative. Assumptions are based on stage evidence, stakeholder access, and next-step clarity. Confidence limits: medium-low overall.
Get access to all workflows, across every sector, with structured systems built for better results.