Scenario & Sensitivity Model — Sales Ops
Model best/base/worst scenarios with transparent assumptions. Purpose-built for sales ops contexts.
A structured data analyst prompt for statistics & forecasting: model best/base/worst scenarios with transparent assumptions, tailored to CRM pipeline data: stages, conversion rates, and rep performance. It walks the model through a proven process with an explicit quality bar, and delivers a scenario model narrative.
The prompt
Variables to fill in: {{question}}{{data_description}}
You are a statistician who keeps analyses rigorous and explains uncertainty like a human. I need your help in the context of CRM pipeline data: stages, conversion rates, and rep performance.
TASK: Model best/base/worst scenarios with transparent assumptions.
DELIVERABLE: Produce a scenario model narrative: the 3–5 driving assumptions with ranges, the scenario outcomes with the math visible, the sensitivity ranking (which assumption moves the result most), and the leading indicators per scenario.
PROCESS:
1. Review the inputs below. If anything critical is missing or ambiguous, ask me up to three clarifying questions before producing the deliverable.
2. Check the assumptions the method requires against the data described in the inputs before recommending it.
3. Prefer the simplest method that answers the question; complexity must buy accuracy, not prestige.
4. Report uncertainty as ranges and probabilities in plain language, never just point estimates.
5. Produce the deliverable in a clean, skimmable format I can use directly.
QUALITY BAR:
- Statistical claims come with their assumptions and failure modes.
- Plain-language translations accompany every technical statement.
- Forecasts include the scenarios that would break them.
INPUTS:
- What you're testing, estimating, or forecasting: {{question}}
- The data: size, granularity, time span, known quirks: {{data_description}}Try it out
Open in Playground →Run this prompt on a real model without leaving the page. Every run is saved to your history for this prompt.
Fill in the variables
How to use
- 1Fill in the {{question}}, {{data_description}} variables with your real details — specifics in, specifics out.
- 2Paste the prompt into ChatGPT, Claude, Gemini, or any capable model.
- 3Answer the clarifying questions it asks; that step is what makes the output fit your situation.
- 4Iterate on the deliverable: ask for alternatives, tighter versions, or a different angle on any section.
Pro tips
- If the output feels generic, add more concrete detail to the inputs — names, numbers, and constraints sharpen everything.
- Works well in a thread: keep the conversation going to refine a scenario model narrative.