Library › Sales AI › Revenue operations
Bucket open opportunities by age and total each bucket
- For Revenue operations
- You practice Asking for a format you can use
- Time about 5 minutes
- Level Intermediate
About this exercise
Bucket the 8 open opportunities by age in days (today is Nov 6 2026, age = days since created) into a markdown table with columns Age bucket | Deals | Amount and rows 0-30, 31-60, 61-90, 90+, then a Total row. Amounts are in $K and written like $80K. An opportunity aged exactly 30 days is in 0-30. No bold and nothing outside the table.
Common mistakes when you ask AI for this
- Wrong boundary. The AI puts the 30-day deal in 31-60. Try: Add: "Exactly 30 days is in 0-30."
- Arithmetic errors. The AI sums amounts wrongly. Try: Add: "List the deals in each bucket before adding."
- Commentary. The AI agrees with the manager. Try: Add: "Nothing outside the table."
- Bold totals. The AI bolds the Total row. Try: Add: "No bold anywhere."
What a strong prompt includes
- Names the columns
- Lists the buckets
- States the boundary
- Adds a Total row
- Only the table
Related exercises
- Accept the buyer's counteroffer on three stated conditions (Sales AI · Sales and customer success)
- Adapt one ad image to 3 sizes with Midjourney (Image & Video AI · Marketing and content)
- Age open requisitions as of today and flag the old ones (Finance AI · FP&A and financial analysts)
- Announce a discount-approval process change in three bullets (Sales AI · Managers and team leads)
- Announce a new win in Slack without revealing the price (Sales AI · Sales and customer success)