Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Scoring and Ranking Prospects by Company in a Table | Clay

Scoring and Ranking Prospects by Company in a Table

·Dec 24, 2025 06:39 AM·

Let's say I have a table with prospects from multiple companies. Is there a way to score and rank them on a company level within the same table? instead of across all companies

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You can create company-level scoring within the same table using formulas and the Lookup Multiple Rows integration. [1]
Here's how:
1.
Add a Formula column to calculate company scores based on your criteria (headcount, industry, tech stack, etc.)
2.
Use Lookup Multiple Rows to count prospects per company and create relative rankings within each company
3.
Build multi-factor scoring that combines company attributes with prospect-level data - you can weight factors like growth rate, technology fit, funding, and competitive position [2]
The Formula Generator can help you create conditional logic to score prospects relative to others in their company rather than across your entire table. You can also use our built-in lead scoring feature (Add Enrichment → Score Row) which supports up to 15 custom criteria. [3]
Before diving into complex formulas, try Sculptor (top-right corner) - it can help you build this scoring system quickly and it's free to use!
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with scoring and ranking prospects by company, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any challenges you’re facing?