Forecast Confidence

Run a 10,000-iteration Monte Carlo forecast on your pipeline CSV to get P50/P70/P90 revenue confidence intervals, an ASCII distribution histogram, and what-if scenarios for slipped deal dates.

Install
cmdop skills install agensi-forecast-confidence

Forecast Confidence is a skill that takes deal-level CSV exports from CRM tools such as Salesforce, HubSpot, or custom spreadsheets and runs 10,000 Monte Carlo simulation iterations to produce probabilistic revenue projections. Rather than applying a flat close-probability multiplier to each deal, the skill models volatility across the full pipeline and returns statistical confidence intervals at the P50, P70, and P90 percentiles, giving sales teams a data-backed answer to whether they will hit a revenue target rather than a single weighted estimate.

The output includes a P50 median forecast, detailed confidence intervals, an ASCII distribution histogram that visualizes the revenue spread, and data-quality warnings when input data is incomplete. When stage conversion rates are missing from the CSV, the skill applies industry-standard stage defaults to maintain simulation integrity. The skill also supports what-if scenario analysis: changing close dates or deal amounts recalculates the quarterly floor and ceiling so teams can test the impact of slippage before it happens. Accuracy scoring evaluates individual rep performance against historical stage conversion deltas.

This skill is appropriate when a pipeline exists as a structured CSV and the goal is statistically grounded forecasting. It is not a live CRM integration and does not query a database directly; it requires a CSV export as its input. There are no environment variables to configure and no package installation steps.

Use cases

  • Generate P50/P70/P90 revenue confidence intervals from a quarterly pipeline CSV export
  • Visualize deal value distribution across a sales pipeline using an ASCII histogram
  • Test how slipped close dates affect the quarterly revenue floor and ceiling via what-if scenarios
  • Apply industry-standard stage conversion defaults when CRM data is incomplete
  • Score individual sales rep accuracy against historical stage conversion rates
  • Differentiate between weighted-pipeline estimates and Monte Carlo simulated outcomes in an executive report

When to use it

  • A structured deal-level CSV export from Salesforce, HubSpot, or a spreadsheet is available
  • The team needs P-value confidence intervals rather than a single weighted forecast number
  • Quarterly revenue planning requires scenario testing for deal slippage or amount changes
  • Historical stage conversion data is available to benchmark rep-level accuracy

When not to use it

  • A live, real-time CRM database query is needed — this skill only processes CSV file input
  • The pipeline has no deal-level data; aggregate summaries are insufficient input
  • A non-CSV data format is the only available export from the CRM system
  • Forecasting outside a sales revenue context where the stage-based model does not apply