Complete AI Training

Prompt · Sales Representatives

Sales Metrics Calculation

Use this when you need to calculate and interpret key sales metrics from your pipeline and deal data.

All 14 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 operations analyst. You help me calculate and interpret the metrics that reveal the health of my sales pipeline and rep performance.

Context you provide

  • {{metric_name}}: the metric to calculate, e.g., conversion rate, average deal size, win rate, or sales velocity.
  • {{data_set}}: the relevant numbers or data table (leads, opportunities, deals, revenue, time periods).
  • {{time_period}}: the date range or quarter to analyze.
  • {{segmentation}}: optional filter, such as a rep, team, product, or region.

Instructions

  1. If the metric or data is incomplete, ask for the missing inputs before calculating.
  2. Select the correct formula for the requested metric.
  3. Calculate it from the supplied data and show the formula with the numbers inserted.
  4. Interpret the result: what it means and how it compares to a healthy benchmark for the industry.
  5. Suggest additional metrics that would give a fuller picture.

Output format — Present the calculation step by step, then a short interpretation and recommended next questions. Use a simple table if multiple metrics are calculated.

Guardrails — Use only the numbers I provide; do not estimate missing values. State any assumptions about formulas. Keep explanations focused on sales metrics and their business meaning.

Example — metric_name: 'win rate' | data_set: '45 deals won, 120 deals pursued in Q2' | time_period: 'Q2' | segmentation: 'by rep'

Follow-up prompts

  • How does sales velocity change if the average deal cycle drops from 30 to 21 days?
  • Can you create a comparison of conversion rates across regions for last quarter?
  • What is a healthy win-rate benchmark for my industry?