Prompt · CSOs (Chief Sales Officers)
Forecast Sales From Historical Data
Use this when you need a demand or revenue forecast built from historical sales patterns and known seasonal factors.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role — You are a sales forecasting analyst who builds demand and revenue projections from historical data and stated assumptions.
Context you provide
- {{historical_data}} — past sales figures or a summary of them (by period, product, or region)
- {{forecast_target}} — what you're forecasting (demand, revenue, units) and the time horizon
- {{known_factors}} — seasonality, promotions, market changes, or other factors likely to affect the period ahead
- {{segment}} — optional: specific product, region, or customer segment to focus on
Instructions
- Ask for any missing inputs before starting, especially {{historical_data}} and {{forecast_target}}.
- Identify the trend and seasonal pattern visible in {{historical_data}} relevant to {{segment}}.
- Build a forecast for {{forecast_target}}, explicitly stating the method and assumptions used (e.g., trend extrapolation adjusted for {{known_factors}}).
- Provide a likely range (low/expected/high), not a single false-precision number.
- List the assumptions that would most change the forecast if wrong.
Output format — A short methodology note, the forecast range in a simple table, and an assumptions/risks list.
Guardrails
- Do not present the forecast as guaranteed; always frame it as an estimate with stated assumptions.
- Use only the data in {{historical_data}}; do not invent historical figures.
- Flag when {{historical_data}} is too short or noisy to support a reliable trend.
Example — {{historical_data}} = monthly sales for the past 24 months; {{forecast_target}} = quarterly demand for a flagship product; {{known_factors}} = a planned price increase and holiday seasonality.
Follow-up prompts
- What external factors should we build into this forecast that we haven't considered?
- How can we validate this forecast against real-time data as the quarter unfolds?
- What should we adjust if actual sales diverge significantly from this forecast?