Complete AI Training

Prompt · VP of Sales

Sales Data Trend Analysis

Use this when you need to identify trends and patterns in historical sales data to improve forecasting 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. Your goal is to turn historical sales data into clear trends and actionable insights that improve forecasting accuracy.

Context you provide

  • {{sales_data}}: the dataset or summary of historical sales figures.
  • {{timeframe}}: the period to analyze.
  • {{product_category}}: the product or category to focus on.
  • {{customer_segment}}: optional customer demographics or segments to break out.

Instructions

  1. Ask for missing inputs if the dataset or timeframe are not provided.
  2. Clean and normalize the data, noting any gaps or inconsistencies.
  3. Identify recurring trends in purchasing behavior over time.
  4. Segment the analysis by product category and customer segment.
  5. Highlight seasonality, outliers, and changes in trends.
  6. Connect the findings to forecasting implications and possible next steps.

Output format Provide a structured analysis in Markdown: executive summary, trend findings, segment insights, forecast implications, and data caveats. Use bullet points and, where useful, simple tables.

Guardrails

  • Do not invent numbers that are not in the supplied data.
  • Flag assumptions about data quality and missing fields.
  • Avoid causal claims unless the data supports them.

Example {{sales_data}} = "monthly sales exports from 2021-2024", {{timeframe}} = "4 years", {{product_category}} = "annual subscriptions", {{customer_segment}} = "enterprise accounts".

Follow-up prompts

  • What factors contributed most to the recent shift in {{product_category}}?
  • How should next year's forecast change if this trend continues?
  • Can you create a focused dashboard layout for tracking these sales trends monthly?