Library › Sales AI › Managers and team leads
Flag deals older than 1.5 times the median sales cycle
- For Managers and team leads
- You practice Setting limits and rules
- Time about 5 minutes
- Level Intermediate
About this exercise
Flag aging deals. First compute the threshold as 1.5 times the median sales cycle (from the notes, not the average). Write a markdown table with columns Deal | Age (days) | Flag, one row per deal in the order given, where Flag is "Aging" if the age is more than the threshold and "OK" otherwise. After the table add one line exactly in the form "Threshold: 1.5 x 50 = 75 days" using the real numbers. No bold, under 70 words.
Common mistakes when you ask AI for this
- Using the average. The AI uses 93 days. Try: Add: "Use the median, 50 days."
- Flagging exactly 75. The AI flags Bolt Inc. Try: Add: "Exactly the threshold is OK."
- Missing the threshold line. The AI skips it. Try: Add: "End with the Threshold line in the exact form."
- Bold and commentary. The AI bolds Aging rows. Try: Add: "No bold; nothing else."
What a strong prompt includes
- Names the columns
- Uses the median
- States the boundary
- Adds the Threshold line
- No bold
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)
- 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)
- Add labels to a signup form without rewriting the page (Coding AI · High school students)