Build a reliable sales forecast using weighted pipeline, historical patterns, and leading indicators that your team and investors can trust.
Paste into any LLM. Provide your pipeline and historical data. Use the model to forecast revenue with confidence intervals.
You are a revenue operations leader who has built forecasting models for companies from $1M to $500M ARR, consistently achieving forecast accuracy within 5-10% of actual results. [PIPELINE VALUE]: Total current pipeline by stage [HISTORICAL WIN RATES]: Close rates by stage and source [AVERAGE DEAL SIZE]: By segment or product [SALES CYCLE]: Average days to close [SEASONAL PATTERNS]: Any monthly or quarterly trends [TEAM SIZE]: Number of quota-carrying reps [QUOTA]: Individual and team quota [FORECAST PERIOD]: Month / Quarter / Year Build a comprehensive forecasting model: **1. Weighted Pipeline Forecast** - Stage-based probability assignments - Weighted value calculation by stage - Adjustments for deal age and velocity - Expected close date analysis - Forecast: committed, best case, upside **2. Historical Pattern Analysis** - Month-over-month close patterns - Seasonal adjustment factors - Rep performance distribution (top, mid, bottom) - Deal source performance differences - New vs. expansion revenue split **3. Leading Indicator Model** - Activity metrics that predict future closes - Pipeline generation rates needed - Conversion rate trends (improving or declining) - Average deal size trends - New pipeline vs. aging pipeline ratio **4. Scenario Planning** - Conservative forecast (80% confidence) - Base forecast (60% confidence) - Optimistic forecast (40% confidence) - Key assumptions behind each scenario - Sensitivity analysis: which variables matter most **5. Forecast Accuracy Tracking** - How to measure forecast accuracy - Common forecasting biases and corrections - Deal inspection criteria - Commit review process **6. Reporting Templates** - Weekly forecast update format - Monthly forecast review meeting agenda - Board-ready revenue forecast presentation - Rep-level forecast rollup
"Sales Forecasting Model Builder" is built on a principle most AI users overlook: models perform dramatically better when given role assignment and sequential task breakdown rather than open-ended questions. The AI will produce buyer-psychology-informed messaging that handles objections and moves deals forward, because the prompt's structure leaves no room for generic filler.
These sales tips will help you get stronger results when using "Sales Forecasting Model Builder" and similar prompts in this category.
"Sales Forecasting Model Builder" is particularly useful in these situations. If any of these scenarios sound familiar, this prompt will save you significant time.
When you use "Sales Forecasting Model Builder" with ChatGPT, Claude, or Gemini, here is what to expect in the AI output.
Adapt "Sales Forecasting Model Builder" to your specific situation by modifying these key areas. The more context you add, the better the results.