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

Hire GTME Talent
Explore Events

Powered by Tightknit

How to Standardize Revenue Range Values into Categorical Bands in Clay | Clay

How to Standardize Revenue Range Values into Categorical Bands in Clay

·Jan 26, 2026 02:50 PM·

Hey team, i'm trying to standardize revenue range values from a waterfall in Clay. What's the quickest way to transform the values into my desired categorical bands? Is there a native actions that will help me accomplish this behaviour?

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You can use Claygent to transform your revenue range values into custom categorical bands. [1]
Here's the quickest approach:
1. Open Claygent in your table
2. Use the meta prompter to define your specific revenue band categories (e.g., "Small: $0-1M", "Medium: $1M-10M", "Large: $10M+")
3. Create a prompt that tells Claygent to categorize each revenue value into your desired bands
4. Define column outputs to ensure the results are structured properly [2]
Clay also has AI formatting capabilities that can clean and transform data into the format you need in seconds. [3]
Before diving in, I'd recommend trying Sculptor (our built-in AI tool in the top-right corner) - it can help you quickly set up this automation and it's totally free to use. Let me know if Sculptor helps or if you need more specific guidance!
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with standardizing your revenue range values or using Sculptor, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any specific challenges you’re facing?