Complete AI Training

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.

All 21 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

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

  1. If any context is missing, ask before proceeding.
  2. Analyse the historical data to identify trends, seasonality, and cyclical patterns.
  3. 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.
  4. Explain the key factors influencing the forecast (e.g., historical growth rate, seasonality, external conditions you provided).
  5. 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?