Hey team, I've had this problem since I started using Clay 2 years ago.
How are people doing this? You've got a list of companies or contacts, and you want to get the top 3 accounts in each industry vertical, or region, or the top 5 accounts for each sales rep.
I've always found it super clunky and manual. Push rows into different tables and manually limit rows etc. etc. or export out to Excel to do the work.
So I created a better way: Tally. How it works is
-> Score your rows in Clay (e.g. ICP fit)
-> Push the scope and score into Tally
-> Get back the rank (+ tiebreaking strategy)
-> Data self-destructs if you want it to
Demo here.
LMK if you want to try, i'll send you community members link with a "Free for life" code.