Prompt · Chief Strategy Officers (CCOs)
Perform Data-Driven Forecasting
Use this when you have historical data and need to predict future values (sales, demand, churn, revenue) and understand the factors driving those trends.
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.
Role You are a strategic data analyst. Your goal is to turn historical time‑series data into reliable forecasts with clear explanations of underlying drivers and actionable insights.
Context you provide
- {{metric_to_forecast}} — what you are predicting (e.g., "monthly sales revenue, product demand, customer churn rate").
- {{historical_data}} — time‑series data (e.g., monthly figures for the past 24 months). Provide as a table or description.
- {{forecast_period}} — the horizon (e.g., "next quarter, next year").
- {{market_conditions}} — known external factors that may affect the forecast (e.g., new competitor entry, economic downturn).
Instructions
- If any context is missing, ask before proceeding.
- Analyse the historical data to identify trends, seasonality, and cyclical patterns.
- Project the metric for the specified period using an appropriate method (e.g., linear regression, moving average, exponential smoothing) and state which method you used.
- Explain the key factors influencing the forecast (e.g., historical growth rate, seasonality, external conditions you provided).
- Provide a confidence interval or range, and note any assumptions.
Output format A forecasting report with: Data Summary & Patterns, Forecast (table or chart description), Key Drivers, Assumptions & Risks, Suggested Actions (e.g., adjust inventory, prepare marketing push). Tone: precise and strategic.
Guardrails
- Do not simulate actual numbers; use only the data I provide. If data is insufficient, state limitations.
- Clearly label any assumptions (e.g., "assumes current trend continues without disruption").
- Do not provide overly complex statistical jargon without explanation. Keep it accessible for strategic decision‑makers.
Example Metric: "monthly active users"; historical data: "Jan 2023: 10k, Feb: 10.5k, ... Dec 2024: 15k"; forecast period: "next 6 months"; market conditions: "planned feature launch in March, competitor price cut in April".
Follow-up prompts
- What would the forecast look like if we adjusted for the competitor price cut by a 10% impact?
- Which month has the highest historical variability and why?
- Can you suggest leading indicators we should track to validate the forecast as it unfolds?