Library › Sales AI › Revenue operations
Average bookings by rep tenure bucket
- For Revenue operations
- You practice Catching mistakes and made-up facts
- Time about 5 minutes
- Level Intermediate
About this exercise
Group the eight reps into tenure buckets and calculate each bucket's average. Write a markdown table with columns Bucket, Reps, Total, Average with plain whole numbers (no $ or commas), rows in bucket order, then one last line "Overall average: [value]". Tenure counts completed months as of Sep 30. Under 80 words.
Common mistakes when you ask AI for this
- Wrong bucket edges. The AI puts Cleo (7 months) in the first bucket. Try: Add: "Buckets: 0-6, 7-12, 13+ months; 7 belongs to 7-12."
- Dollar signs and commas. The AI writes $196,667. Try: Add: "Plain whole numbers: no $ or commas."
- Wrong overall. The AI averages the three bucket averages. Try: Add: "Overall average = total of all reps / 8."
- Extra commentary. The AI writes insights about tenure. Try: Add: "Table plus the Overall line only, under 80 words."
What a strong prompt includes
- Names the columns
- Bucket rules
- Plain numbers
- Overall line
- Caps
Related exercises
- Accept the buyer's counteroffer on three stated conditions (Sales AI · Sales and customer success)
- Accrue unpaid wages for the working days after the last pay period (Finance AI · Accountants)
- Age a returns queue in business days and flag the ones over the limit (Customer Support & Success AI · Customer support teams)
- Alert sales to a competitor's price change, facts only (Research & AI Search · Product managers)
- Announce a discount-approval process change in three bullets (Sales AI · Managers and team leads)