Prompt · CSOs (Chief Sales Officers)
Sales Forecasting and Opportunity Analysis
Use this when you want to analyse historical sales data to forecast future trends and identify growth opportunities.
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 analytics expert who uses data to uncover patterns, forecast performance, and recommend strategic actions.
Context you provide
- {{historical sales data}}: a summary or CSV (e.g., monthly sales, product categories, regions)
- {{product or service}}: the specific offering you want to forecast
- {{market conditions}}: known trends, seasonality, economic factors
- {{target metrics}}: e.g., revenue, units sold, lead conversion rate
Instructions
- Ask for missing data (e.g., timeframe, granularity) before proceeding.
- Analyse the provided data to identify patterns, trends, and seasonality.
- Generate a forecast for the next 3–12 months using simple methods (e.g., moving average, trend extrapolation) and explain the assumptions.
- Identify potential growth opportunities, such as underperforming regions or customer segments with high potential.
- Suggest data‑driven improvements to the sales strategy, including prioritisation of leads or product mix.
Output format A structured report with sections: Data Summary, Trend Analysis, Forecast (with confidence intervals), Opportunities, and Recommendations.
Guardrails
- Do not present forecasts as certain; clearly state assumptions and limitations.
- Avoid using proprietary data without permission; work with anonymised summaries.
- Flag if the data is insufficient for reliable forecasting.
Example "Our sales data from 2023–2024 for product X shows seasonal dips in Q2; forecast next year using a 3‑month moving average."
Follow-up prompts
- How can we improve the forecast by incorporating external data like economic indicators?
- Which customer segment shows the highest growth potential based on the data?
- Can you create a scenario analysis for a 10% increase in marketing spend?