Library › Sales AI › Revenue operations
Rank channels by cost per opportunity from lowest to highest
- For Revenue operations
- You practice Asking for a format you can use
- Time about 5 minutes
- Level Intermediate
About this exercise
Make a markdown table with columns Channel | Spend | Opps | Cost per opp and one row per channel sorted from the lowest cost per opportunity to the highest. Cost per opp is spend divided by opportunities created, rounded to the nearest dollar. Use opportunities created, not leads. No bold, nothing outside the table, under 70 words.
Common mistakes when you ask AI for this
- Dividing by leads. The AI computes cost per lead. Try: Add: "Use opportunities created, not leads."
- Wrong sort. The AI keeps the input order. Try: Add: "Sort lowest cost per opp to highest."
- Extra commentary. The AI agrees with the marketing lead. Try: Add: "Nothing outside the table, no bold."
- Wrong columns. The AI adds a leads column. Try: Add: "Exactly the four columns listed."
What a strong prompt includes
- Names the columns
- Defines cost per opp
- Sorts rows
- Rounds
- Table only
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)