Audit driver-based models for compounding optimism bias

Expose subtle, compounding growth assumptions across pipeline stages and conversion metrics. Use this during quarterly budget reviews and board deck prep.

You getCompounding Risk Table, vulnerability Breakdown and recalibrated Model Baseline

Prompt

Prompt
Act as a revenue operations auditor evaluating a multi-quarter driver-based model for compounding optimism.

Review the provided drivers and assumptions using these rules:
- Track how small optimistic assumptions at each funnel stage multiply into unrealistic compound growth rates.
- Check whether downstream capacity assumptions (support staffing, onboarding bandwidth, server capacity) match upstream sales targets.
- Identify metrics where improvement is assumed across both volume and conversion rates simultaneously.
- General planning analysis only, not formal financial auditing or investment advice.

Output format:
1. Compounding Risk Table (Stage, Stated Assumption, Historical Benchmark, Multiplier Impact)
2. Vulnerability Breakdown (detailed explanation of top 3 compounding flaws)
3. Recalibrated Model Baseline (conservative adjustments with realistic friction included)

My model assumptions and driver data are below:

Example output

Example for: B2B SaaS pipeline model for the upcoming fiscal year

  1. Compounding Risk Table
StageStated AssumptionHistorical BenchmarkMultiplier Impact
Inbound Leads+25% QoQ+8% QoQ1.3x pipeline volume inflation
Demo-to-Opportunity45% conversion31% conversion1.45x qualified pipeline lift
Opportunity-to-Close28% win rate20% win rate1.4x bookings inflation
Net Compound LiftCombined driversBaseline run-rates2.64x unverified revenue surge
  1. Vulnerability Breakdown
  • Simultaneous volume and quality expansion: The model assumes inbound lead volume jumps 25% each quarter while demo-to-opportunity conversion improves by 14 points. In practice, higher lead volume dilutes lead quality.
  • Compounded win rate optimism: Multiplying elevated qualified counts by a 40% higher close rate creates a $1.2M ARR surplus that relies entirely on flawless top-of-funnel execution.
  • Headcount lag: Account executives are modeled to reach 100% quota in month two of onboarding, whereas historical ramp time is 4.5 months.
  1. Recalibrated Model Baseline
  • Anchor demo-to-opportunity conversion at the historical 31% median.
  • Adjust ramp-up attainment to 25% in month one, 50% in month two, and 75% in month three.
  • Reduce full-year forecasted bookings by 38% to establish an achievable target that preserves cash margins.
Written by AI from this prompt. Your results will vary.

Paste your funnel assumptions, conversion rates, and revenue drivers into ChatGPT, Claude, or Gemini. As a follow-up, ask the model to run a sensitivity analysis showing which single variable causes the largest revenue drop if missed by 10%.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis