Running a Second Work Email Waterfall for Rows without Emails | Clay Team

Hi Clay Team. Say I just finished running a Work Email Waterfall, and of course, there would be some rows that no emails were found. Is it possible that I can add another Work Email waterfall (using the providers I did not use previously), and only run for the rows that never found emails? Or do I need to upload a new table with the rows that did not find any emails?

10 comments

Clay Team
APP
·
·
Hey there Paul happy to help. Yes, it is possible to add another email provider without having to start over you can accomplish this by using a formula in the new email provider to only run if your email column does not have a value.
Paul F.
·
·
So I click on Enrich Data>Work Email and can find it there?
Clay Team
APP
·
·
Let me make a loom for you.
Paul F.
·
·
That's awesome Luis! 😄
Clay Team
APP
·
·
Sorry for the wait. Here you go https://www.loom.com/share/51c472f8c4654feabe2a1202b5c5f388
Paul F.
·
·
thaankyou
Kareem Amin
·
·
Keethu R. please test with Paul the new way for editing waterfalls once it’s ready
👍1
Paul F.
·
·
One thing I noticed here, btw, is that, after adding a new provider, the new emails found by the latest provider will only be under Column of the new Provider. So basically there's gonna be two columns of Work Emails for the table. In the image below, emails found using providers 1-4 will be placed on the column @ Work Email, but the 5th provider will only have the email over at "Find Work Email (5)" If you get what Im saying
Clay Team
APP
·
·
You can merge the columns that have the emails into one, by clicking on "New Column" and selecting merge columns. From here choose the columns that contain the emails and they will go into one singular column.
Keethu R.
·
·
Hi Paul F., as Kareem mentioned, we will be launching editable waterfalls very soon and would love to have you try it out and get your thoughts on it! I'll DM you to set up some time to go over it and chat if you would be open to that!