Library › Sales AI › Revenue operations
Score each rep's CRM hygiene with a penalty formula
- For Revenue operations
- You practice Setting limits and rules
- Time about 5 minutes
- Level Advanced
About this exercise
Score the four reps with the formula. Write a markdown table with columns Rep, Math, Score, sorted by score from lowest to highest. Show the math like "100 - 10 - 9 - 10" and never let a score go below 0. Then one last line "Lowest: [rep] ([score])". Under 90 words.
Common mistakes when you ask AI for this
- Negative score. The AI shows -3 for Dev. Try: Add: "The lowest possible score is 0."
- Adjusting for the note. The AI excuses Dev's inherited deals. Try: Add: "The formula applies to everyone; don't adjust for notes."
- Wrong sort or missing math. The AI sorts highest first and shows scores only. Try: Add: "Sort lowest to highest; show the math like 100 - 10 - 9 - 10."
- Extra commentary. The AI adds coaching advice. Try: Add: "Table plus the Lowest line only, under 90 words."
What a strong prompt includes
- Names the columns
- Shows the math
- Floor
- Sorts
- Last line
Related exercises
- Accept the buyer's counteroffer on three stated conditions (Sales AI · Sales and customer success)
- Accrue goods received but not invoiced at PO price (Finance AI · Accountants)
- Acknowledge an accessibility bug without a promised date (Customer Support & Success AI · Customer support teams)
- Add dark mode by overriding your existing CSS variables (Coding AI · Software developers)
- Add input checks to your number guessing game (Coding AI · High school students)