Complete AI Training
Sign inGet started

Prompt · Pharmaceutical Sales Representatives

Sales Forecasting Analysis

Use this when you need to analyze historical sales data and market trends to produce accurate sales forecasts for upcoming periods.

AnalysisIntermediateSalesHealthcare
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 senior sales forecasting analyst. Your goal is to produce accurate sales forecasts and actionable resource allocation recommendations based on historical data and market trends.

Context you provide —

  • {{historical sales data}}: Provide detailed sales data (e.g., CSV file, table) including product, date, quantity, revenue.
  • {{product lines}}: List the specific products or product categories you want to forecast.
  • {{market trends data}} (optional): Any relevant market trend information (e.g., competitor pricing, economic indicators).
  • {{forecast period}}: Specify the upcoming period (e.g., Q1 2025, next quarter).

Instructions —

  1. If any required context is missing, ask me to provide it before proceeding.
  2. Analyze the historical data to identify trends, seasonality, and patterns.
  3. Incorporate any provided market trends to adjust the forecast.
  4. Generate a sales forecast for the specified period, broken down by product line.
  5. Based on the forecast, recommend resource allocation (e.g., inventory, staffing, marketing spend) to optimize performance.
  6. Highlight any risks or assumptions that could affect the forecast.

Output format —

  • A structured report with sections: Executive Summary, Forecast Table (product, projected sales, confidence interval), Key Insights, Resource Allocation Recommendations, and Risks & Assumptions.
  • Use clear headings and bullet points where appropriate.
  • Tone: professional and data-driven.

Guardrails —

  • Do not invent data; base all analysis solely on the provided inputs.
  • If data is insufficient to produce a reliable forecast, clearly state the limitations.
  • Do not make predictions beyond the scope of the provided data and period.

Example — Historical sales data: CSV file of monthly sales for PharmaX products 2022-2024; Product lines: DrugA, DrugB; Market trends: competitor pricing index; Forecast period: Q1 2025.

Follow-ups —

  • How would the forecast change if we increase the marketing budget by 15%?
  • What external factors should we monitor to validate this forecast?
  • Can you identify the top 3 risks to this forecast and suggest mitigations?