TestedSales Operations, CRM & ProductivityQuick Win (under 10 min)

Close Rate Calculation Rep Ranking Performance

Generate a rep-by-rep close rate breakdown and performance ranking from pipeline or activity data.

About this prompt

This prompt calculates individual rep close rates and ranks performance across the team, giving sales managers and directors a clear view of who is converting and who needs coaching. It's built for pipeline reviews, QBRs, and one-on-ones where you need data-backed context before the conversation. Use it when you have deal outcome data by rep and want a structured performance summary without pulling a custom CRM report.

The prompt

From this dataset of rep activities and closed deals, calculate the close rate for each rep and rank them. Data: [Upload rep performance CSV]. Output a ranked list and a sentence for each rep's streng
The rest of this prompt is Pro.Copying the full text is Pro. Browsing stays free, and 100 prompts are free in full.
Copy prompt
☆ Save to library
Send to a teammate
Email it
Link copied — paste it in Slack
Copying the full text is Pro.

Variables to replace

UPLOAD REP PERFORMANCE CSV

How to run it

  1. Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot — it's tuned to run in any of them.
  2. Replace the variables — swap each bracketed token for your deal's specifics. The variables list above explains every field.
  3. Make it yours — run it, keep what's strong, and tighten your inputs on the next pass. The prompt improves with your context.

What good output looks like

Make it yours

StagePipeline Management
SeatSales Manager, Sales Director, RevOps / Sales Ops
DifficultyBasic
Time to valueQuick Win (under 10 min)
Works withAI-Agnostic
CategorySales Operations, CRM & Productivity
Promptifi ProFull text of all 2,900+ prompts, every workflow, unlimited saves.Start Pro — $4.99/moor $99 once, lifetime
You're ProFull library open. Copy, save, and chain anything.

Stop rewriting. Start closing.

Copy prompt
Start Pro — $4.99/mo