Aggregating Email Validation Payloads for Efficient Filtering

Joe H. · 2026-01-07T03:08:47.248Z

I want to aggregate the payload from my email validation in the Find Work Email waterfall. I want to do this so I can filter based on sub-status like valid and valid catch-all. I also want to filter based on MX provider like Microsoft 365. How can I do this without clicking into the individual payloads for each validation, assuming there are 9 different providers?

Aggregating Email Validation Payloads for Efficient Filtering | Clay

11 comments

· Sorted by Oldest

Clay Support
APP
·
·
The validation columns from your email waterfall are hidden by default but contain all the payload data you need. [1]
To access this data for filtering:
1.
Unhide validation columns: Open the Columns Panel and unhide the validation columns to see detailed validation steps from each provider.
2.
Add filters: Click the Filters button at the top of your table, then use "Add filter" to filter by: • Sub-status (valid, valid catch-all, etc.) • SMTP/MX provider (Microsoft 365, etc.) [2]
3.
Use filter groups: For complex filtering across multiple validation columns, use "Add filter group" with AND/OR logic to combine conditions from different providers.
You can use text operators like "contains" or "equal to" to filter on specific sub-statuses or provider names across all your validation columns without manually checking each payload. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Joe H.
·
·
I'm saying that right now it seems like I need to click each validation column to show the substatus as a column. the substatus is nested in the payload. I have 9 different providers, and 9 different "validate x provider" columns
Clay Support
APP
·
·
You're right - to access nested payload data like substatus from each validation column, you need to create child columns from each parent validation column.
For each of your 9 validation columns:
1. Click on a cell in the validation column to open the Cell details panel
2. Hover over the substatus field in the payload
3. Click "Add as column" to create a new child column for that substatus [1]
This will give you 9 separate substatus columns that you can then filter on directly without clicking into individual payloads. You can do the same for MX provider data if it's nested in the validation payloads. [2]
Once you have these child columns created, you can use the regular filter functionality to filter by substatus values like "valid" or "valid catch-all" across all providers.
Clay Support
APP
·
·
Did that answer your question?
Joe H.
·
·
Yes but it's incredibly tedious
Clay Support
APP
·
·
I understand that creating child columns for each provider can be tedious. Could you share more about your workflow or what you hope to achieve? Maybe I can help you find a smoother approach.
Joe H.
·
·
Could Sculptor create the child columns for me if I asked it to?
Clay Support
APP
·
·
Yes, Sculptor could potentially help automate creating those child columns! Since Sculptor can build Clay tables and set up workflows, it might be able to create multiple child columns from your validation payloads at once. [1]
I'd definitely recommend trying Sculptor first - it's free and available in the top-right corner of your screen. Ask it to help create child columns for substatus and MX provider data from your 9 validation columns. Let me know if Sculptor helps solve this or if you need further assistance! [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with automating the creation of child columns or have other questions, I’m here to assist. Would you like to share more about your workflow or what you’re trying to achieve so I can provide better support?

Clay Support
APP
·
·
The validation columns from your email waterfall are hidden by default but contain all the payload data you need. [1]
To access this data for filtering:
1.
Unhide validation columns: Open the Columns Panel and unhide the validation columns to see detailed validation steps from each provider.
2.
Add filters: Click the Filters button at the top of your table, then use "Add filter" to filter by: • Sub-status (valid, valid catch-all, etc.) • SMTP/MX provider (Microsoft 365, etc.) [2]
3.
Use filter groups: For complex filtering across multiple validation columns, use "Add filter group" with AND/OR logic to combine conditions from different providers.
You can use text operators like "contains" or "equal to" to filter on specific sub-statuses or provider names across all your validation columns without manually checking each payload. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Joe H.
·
·
I'm saying that right now it seems like I need to click each validation column to show the substatus as a column. the substatus is nested in the payload. I have 9 different providers, and 9 different "validate x provider" columns
Clay Support
APP
·
·
You're right - to access nested payload data like substatus from each validation column, you need to create child columns from each parent validation column.
For each of your 9 validation columns:
1. Click on a cell in the validation column to open the Cell details panel
2. Hover over the substatus field in the payload
3. Click "Add as column" to create a new child column for that substatus [1]
This will give you 9 separate substatus columns that you can then filter on directly without clicking into individual payloads. You can do the same for MX provider data if it's nested in the validation payloads. [2]
Once you have these child columns created, you can use the regular filter functionality to filter by substatus values like "valid" or "valid catch-all" across all providers.
Clay Support
APP
·
·
Did that answer your question?
Joe H.
·
·
Yes but it's incredibly tedious
Clay Support
APP
·
·
I understand that creating child columns for each provider can be tedious. Could you share more about your workflow or what you hope to achieve? Maybe I can help you find a smoother approach.
Joe H.
·
·
Could Sculptor create the child columns for me if I asked it to?
Clay Support
APP
·
·
Yes, Sculptor could potentially help automate creating those child columns! Since Sculptor can build Clay tables and set up workflows, it might be able to create multiple child columns from your validation payloads at once. [1]
I'd definitely recommend trying Sculptor first - it's free and available in the top-right corner of your screen. Ask it to help create child columns for substatus and MX provider data from your 9 validation columns. Let me know if Sculptor helps solve this or if you need further assistance! [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with automating the creation of child columns or have other questions, I’m here to assist. Would you like to share more about your workflow or what you’re trying to achieve so I can provide better support?