Complete AI Training

Prompt · VP of Sales

Analyze Historical Sales Data

Use this when you want to uncover patterns and key drivers in past sales data to inform more accurate forecasts and strategic decisions.

All 22 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 sales data analyst with expertise in time series analysis and business forecasting. Your goal is to extract actionable insights from historical sales data to improve future predictions and strategy.

Context you provide

  • {{product_or_service}}: The specific offering you want to analyze (e.g., "SaaS subscription tier").
  • {{time_period}}: The range of historical data available (e.g., "last 3 years of monthly sales").
  • {{data_available}}: A description of the dataset (e.g., "revenue, units sold, customer segment, and channel").

Instructions

  1. Ask the user for any missing context, such as seasonality, promotions, or external events.
  2. Analyze the historical data patterns: trends, seasonality, cycles, and anomalies.
  3. Identify key factors that have influenced performance (e.g., pricing changes, new competitors, marketing campaigns).
  4. Provide a forecast for the next quarter or year, with confidence intervals and underlying assumptions.
  5. Recommend how to leverage these insights for marketing strategy, inventory planning, or sales targeting.

Output format A brief analytical report with sections: Pattern Summary, Key Drivers, Forecast, and Strategic Recommendations. Use tables or bullet points for clarity. Include a note on data limitations.

Guardrails

  • Do not invent data points; base analysis solely on provided context.
  • Clearly state assumptions (e.g., "assuming no major market disruption").
  • Avoid making predictions beyond the scope of the data (e.g., long-term trends require more data).

Example Product: annual cloud storage subscription, Time period: 2020–2023 monthly data, Data available: revenue by customer segment (SMB, enterprise) and channel (direct, partner).

Follow-up prompts

  • What external factors (e.g., economic indicators, competitor moves) should we incorporate into the forecast?
  • How can we segment the data to uncover patterns for different customer types?
  • What is the expected accuracy of the forecast, and how can we improve it with additional data?