How to Combine Multiple Columns for Email Campaigns in Clay

·

Hi Clay team, if i have 3 columns that im using to get an email how do I add all 3 to the campaing? I only see I can add one, but not all the columns have the email so I need to use a diffrent column

1 comment

Channeled
APP
·
·
When adding leads to a campaign in Clay, you can only map one column as the email field. However, there's a solution for your situation where emails are spread across multiple columns: 1. Create a new formula column that combines your email columns 2. Use conditional logic in the formula to check each column and return the first valid email For example, your formula might look like: LBKSIF(NOT(ISBLANK([Email Column 1])), [Email Column 1], IF(NOT(ISBLANK([Email Column 2])), [Email Column 2], [Email Column 3]))LBKSThis creates a "waterfall" effect that checks each column in order and returns the first non-blank email. Then use this new column when setting up your campaign enrichment. If you encounter a "missing input" error, double-check that you're using the correct column names in your formula.
Sources: Push Data To Your Email Sequencer [Clay 101] - Clay University Push Data To Your Email Sequencer [Automated Outbound] - Clay University