As of 13 August 2026, AI can calculate your sales win rate.
Most people should do this themselves; the prompt is on this page.
Can you do it?
5 minutesto a draft.
15 minutesto something you’d act on.
Cost, all in£0
Skill neededchat-fluent
Who has to check ityou
What the alternative costsA spreadsheet or your existing CRM is the alternative; the supplied tool data gives no price for either.
If this goes wrong: the rate uses the wrong denominator or period and leads to a misleading internal sales discussion, which you can correct by checking the source records.
What to actually do
Do it yourself
The route this page recommends
A chat interface, chat-fluent skill, and roughly 15 minutes until you can act on the result.
How to actually do it
- Open your CRM and set a reporting period, such as the current quarter, then export the opportunities with their current status and close date.
- Remove records that are cancelled, duplicated or disqualified, and confirm how your team defines closed won and closed lost.
- Paste the export or the two closed counts into the prompt, including the reporting period and whether the rate should be grouped by salesperson, month or another category.
- Ask the model to calculate the rate using closed won divided by closed won plus closed lost, and to list the records or counts it used.
- Recalculate the percentage with a calculator or spreadsheet and compare the won and lost totals against the CRM export.
- Send the verified rate and its definition to the relevant sales report or colleague, labelled with the reporting period.
Prompt
Calculate my sales win rate from the data below. Use this definition unless I explicitly provide another: win rate = closed won opportunities divided by all closed opportunities, where all closed opportunities means closed won plus closed lost. State the formula, show the counts used, calculate the percentage to one decimal place, and identify any missing, duplicated or ambiguous records. Do not include open opportunities, cancelled opportunities or disqualified opportunities unless I say to include them. If the data contains individual records, give a short summary by [month, quarter, salesperson or other grouping]. Do not invent or estimate any figures. Before calculating, ask one concise clarification question if the period, opportunity status or denominator is unclear. Data and context: [paste CRM export or provide the closed won count, closed lost count, reporting period and inclusion rules here].
Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.
Use a tool built for this
Second choiceHand it to a person
The distant thirdA person who owns the outcome does this end to end, worth it when the failure is dear.
What it gets wrong
- AI cannot decide which opportunity statuses your business should count as a win or a loss.
- AI cannot know whether your CRM contains stale, duplicated or missing opportunities unless the data exposes those problems.
- AI cannot replace an agreed company definition, so two teams can report different rates from the same pipeline.
- AI cannot validate records that are absent from the export or hidden by CRM permissions.
Even on a YES, the friction has a name: judgement under ambiguity and context depth.
How we scored this
Five axes, each scored nought to two by hand: ten means AI carries the task cleanly, and the thresholds that turn a total into YES, PARTLY or NO are published in the methodology. Each axis name links to its definition.
| Axis | Score (0–2) |
|---|---|
| Output | 2 |
| Inputs | 2 |
| Verification | 2 |
| Liability | 2 |
| Effort delta | 2 |
| Total | 10 / 10 |
The methodology and its thresholds are published in full.
FAQ
- Can AI calculate my sales win rate?
- Yes. Give it the closed won and closed lost opportunities, the reporting period and your inclusion rules, then check the totals against your CRM.
- What is the formula for sales win rate?
- Use closed won opportunities divided by all closed opportunities, where all closed opportunities means closed won plus closed lost. Multiply the result by 100 to express it as a percentage.
- Should open deals count in my win rate?
- Usually not when measuring the outcome of completed opportunities. Exclude open deals unless your organisation has explicitly chosen a different metric, and state that definition beside the result.
- Can AI calculate win rate from a CRM export?
- Yes, if the export contains reliable statuses and the relevant dates or reporting period. Check for duplicates, missing records and inconsistent status values before relying on the result.
Nearby answers
Assessed by gpt-5.6-luna (gpt-5.6-luna) on 2026-08-13, second-checked by an independent model. Wrong somewhere? Email [email protected] and it gets re-checked.
The newsletter
AI news, new answers and product picks, straight to your inbox.