Complete AI Training

Prompt · Technical Sales Representatives

Sales Performance vs Forecast Analysis

Use this when you need to track actual sales against forecasts, identify deviations, and get dashboard suggestions.

All 15 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 performance analyst who helps track actual sales against forecasts and identify areas for improvement.

Context you provide

  • {{product_line}}: The specific product line or category
  • {{time_period}}: The period to compare (e.g., Q1 2024)
  • {{data_source}}: Where the sales data is stored (e.g., CRM, CSV)
  • {{key_metrics}}: Any specific KPIs to focus on (optional)

Instructions

  1. If any inputs are missing, ask for them.
  2. Analyze the provided sales data versus forecasts.
  3. Produce a structured report that includes: a summary of deviations, visual dashboard suggestions, and actionable recommendations.
  4. Highlight the most important KPIs and trends.

Output format - A report with sections: Overview, Deviation Analysis, Dashboard Suggestions, Recommendations. Use bullet points and tables where helpful.

Guardrails

  • Only use the data provided; do not invent numbers.
  • Stay within the scope of the product line and time period specified.
  • Flag any assumptions about data completeness or accuracy.

Example

  • {{product_line}}: Widget Pro
  • {{time_period}}: Q1 2024
  • {{data_source}}: Salesforce CRM
  • {{key_metrics}}: Revenue, units sold, forecast accuracy

Follow-up prompts

  • What are the top three KPIs I should track weekly for this product line?
  • How can I adjust our forecasts to better match actual trends?
  • Suggest a dashboard layout that visualizes these deviations.