Email Waterfall in Clay: 95% Hit Rate Setup

If you're running outbound, your pipeline lives or dies on email coverage. Spray one provider across your list and you'll get 40–60% coverage at best. The rest? Wasted rows, missed pipeline, and money left on the table.

An email waterfall fixes this. You chain multiple data providers together so that every record gets the best possible shot at a verified email. When your primary misses, a fallback fires. When the fallback misses, the next one fires. At the end, you validate everything so nothing bounces.

This guide walks you through building that waterfall in Clay with LeadMagic as the primary provider. By the end, you'll have a repeatable workflow that hits 95%+ email coverage with bounce rates under 2%.

Why an Email Waterfall Matters

Single-provider enrichment has a ceiling. Every provider has coverage gaps—certain industries, company sizes, regions, or seniority levels where their data falls short. The typical provider covers 40–70% of a given B2B list. That means if you send 5,000 contacts through one provider, you're leaving 1,500–3,000 records without emails.

An email waterfall changes the math:

• Provider 1 covers 65% of your list
• Provider 2 catches another 20% of the remaining
• Provider 3 picks up another 10% of what's left
• Validation removes anything risky

End result: 90–95% of your list has a verified, deliverable email. Your SDRs actually have someone to email, and your domain stays healthy.

Prerequisites

Before you start building, make sure you have:

• Clay account — Any paid plan works. Free tier limits enrichment volume.
• LeadMagic API key — Sign up at leadmagic.io and grab your key from the dashboard. You'll use this inside Clay's integration settings.
• Contact list — At minimum, you need first name, last name, and company domain for each record. LinkedIn profile URLs are a bonus but not required.
• At least one fallback provider — Apollo, Hunter, Clearbit, Dropcontact, or any other email enrichment tool available in Clay's marketplace.

Understanding Email Waterfall Architecture

A waterfall follows a simple pattern: primary → fallback → validate → catch-all resolve. Here's how the logic flows:

1. Primary enrichment — Run your most accurate provider on every record. LeadMagic's Email Finder returns real-time verified results with 97% accuracy, which is why it goes first.
2. Conditional fallback(s) — For records where the primary returned no result, run a secondary provider. You can chain 2–3 fallbacks, each gated by a condition that checks if the previous step was empty.
3. Consolidation — Merge results from all providers into a single email column using a formula.
4. Validation — Run every found email through LeadMagic Email Validation to confirm deliverability. This catches stale data, typos, and emails that providers marked as "found" but are actually dead.
5. Catch-all resolution — For emails flagged as "catch-all" or "unknown" during validation, run them through LeadMagic Catch-All Validation to resolve them to definitive valid/invalid status. This step alone can recover 20-30% of enterprise contacts that standard validation marks as unverifiable — most of your highest-value prospects sit behind catch-all domains.
6. Filtering — Remove invalid and risky emails. Export clean, verified contacts to your outreach tool.

The order of providers matters. Put your most accurate provider first because you'll use their result by default when it's available. Cheaper but less accurate providers go later as fallbacks—you only pay for records your primary missed.

Step-by-Step Tutorial

Step 1: Prepare Your Contact Data

Your waterfall is only as good as your input data. Garbage in, garbage out.

Required fields:

Optional but helpful fields:

Data quality tips before import:

• Strip whitespace from names and domains. " sarah " won't match as well as "sarah".
• Remove https://, www., and trailing slashes from domains. You want acme.com, not https://www.acme.com/.
• De-duplicate by LinkedIn URL or name+domain combo. Running duplicates through enrichment just wastes credits.
• Remove personal email domains (gmail.com, yahoo.com, outlook.com). You're looking for business emails—personal domains won't return useful results.
• Verify that domains are active. A quick bulk DNS check saves you from spending credits on dead companies.

Step 2: Create Your Clay Table and Import Data

1. Log in to Clay and click Create Table.
2. Choose your import method:
   • CSV upload — Drag and drop your file. Clay auto-detects columns.
   • CRM integration — Connect HubSpot, Salesforce, or Outreach and pull contacts directly.
   • Clay's Find People — Build a list from scratch using Clay's prospecting tools.
3. Verify column mapping. Make sure Clay correctly identified First Name, Last Name, and Domain. Rename columns if needed for clarity.
4. Spot-check 10–20 rows to confirm data looks clean. Fix any issues before running enrichment—it's cheaper to clean data than to re-run failed enrichments.

Step 3: Add LeadMagic Email Finder as Primary Enrichment

This is your first enrichment column—the one that runs on every row.

1. Click Add Column → Enrichment.
2. Search for "LeadMagic" in the provider marketplace.
3. Select "Email Finder".
4. Map your input fields:
   • first_name → your First Name column
   • last_name → your Last Name column
   • domain → your Domain column
5. Click Run Enrichment to process all rows.

LeadMagic runs real-time lookups. It doesn't just guess email patterns—it verifies that the mailbox actually exists before returning a result. This is why it sits at the top of your waterfall: when LeadMagic returns an email, you can trust it.

Expect a 60–75% hit rate on this first pass, depending on your list composition. Tech companies and mid-market firms tend to have higher coverage. Small businesses and certain industries (healthcare, government) trend lower.

For contacts where the standard email finder doesn't return results, consider also using LeadMagic's Catch-All Email Finder. Catch-all domains accept all emails at the domain level, making verification harder—the catch-all finder is purpose-built for these edge cases.

Step 4: Configure Conditional Fallback Providers

Now you'll add a second enrichment column that only fires when LeadMagic returned no result.

1. Click Add Column → Enrichment.
2. Select your fallback provider (Apollo, Hunter, Dropcontact, etc.).
3. Set the condition: Click the condition/filter icon and configure it so the enrichment only runs "If LeadMagic Email Finder → Email is empty". This is the critical step—without the condition, you'll waste credits re-looking up emails you already found.
4. Map the same input fields (first name, last name, domain).
5. Run enrichment.

Want a third fallback? Repeat the process. Add another enrichment column with the condition "If Fallback 1 email is also empty." Each additional provider has diminishing returns, so 2–3 total providers is usually the sweet spot.

Recommended provider order:

Step 5: Build the Consolidation Formula

You now have 2–3 email columns from different providers. You need a single "Best Email" column.

1. Click Add Column → Formula.
2. Name it something clear like Best Email.
3. Enter the formula:

IF({LeadMagic Email} != "", {LeadMagic Email},
  IF({Fallback 1 Email} != "", {Fallback 1 Email},
    IF({Fallback 2 Email} != "", {Fallback 2 Email}, "")))

Or the simpler Clay shorthand:

{LeadMagic Email} || {Fallback 1 Email} || {Fallback 2 Email}

This prioritizes LeadMagic results (highest accuracy), then falls through to each fallback in order. The first non-empty value wins.

Step 6: Add LeadMagic Email Validation as the Final Step

Never skip validation. Even the best providers occasionally return emails that worked six months ago but have since been deactivated. Validation catches these before they bounce and hurt your sender reputation.

1. Click Add Column → Enrichment.
2. Search for "LeadMagic" → Select "Email Validation".
3. Map the input: point it at your Best Email consolidation column.
4. Set the condition: Only run if Best Email is not empty. No point validating blank cells.
5. Run validation.

LeadMagic Email Validation returns one of these statuses:

Step 7: Filter and Segment Results

Now clean up your table for export.

1. Filter out invalid emails — Add a filter: Validation Status = valid. This is your safe-to-send list.
2. Handle risky emails separately — Create a view for Status = risky. These are often catch-all domains. You can still email them, but monitor bounces closely.
3. Tag coverage gaps — Records with no email after the full waterfall are worth investigating manually or enriching through a different data source.
4. Export your clean list — Push results to your CRM or sequencing tool via Clay's integrations, or export as CSV.

Cost Analysis by Batch Size

Here's what a typical waterfall costs using LeadMagic as primary with one fallback provider. Costs assume LeadMagic's standard credit-based pricing.

A few things to note:

• The fallback column only runs on the ~35% of records where LeadMagic didn't return a result. Conditional logic saves you from paying for the full list on every provider.
• Validation runs on all found emails (typically 90–95% of total rows).
• At ~$0.06 per verified email, you're spending less than a single cent per valid contact. Compare that to buying a list at $0.50–$1.00 per contact with no verification.
• LeadMagic uses flexible credit-based plans — no annual contracts or per-seat fees. You pay for what you use.

Optimizing Your Waterfall for Different Use Cases

Cold Outbound (High Volume)

When you're prospecting at scale—thousands of contacts per week—optimize for speed and cost.

• Use exactly 2 providers (LeadMagic + one fallback). Three providers adds marginal coverage at higher cost.
• Accept "valid" status only. Skip risky emails entirely to protect domain reputation.
• Batch process in Clay. Run 1,000–2,000 rows at a time rather than trickling records through.
• Re-validate emails that are older than 90 days before re-using them.

Account-Based Marketing (ABM)

When you're targeting specific high-value accounts, coverage matters more than cost.

• Use 3 providers to maximize hit rate on your small, critical list.
• Manually research the remaining gaps. For a 200-person ABM list, it's worth spending time to find the last 5%.
• Validate more aggressively. Even "risky" emails should be re-checked or verified through an alternative method.
• Enrich with company data to make sure you're targeting the right accounts.

Re-Enrichment (Existing Database)

Your CRM data decays at 30% per year. People change jobs, companies rebrand, emails get deactivated.

• Run your existing email list through LeadMagic Email Validation first, before doing any re-enrichment. Remove known-bad records.
• Only re-enrich contacts where the email is now invalid or the person changed companies (use Job Change Detector for this).
• Merge new results with existing data carefully. Don't overwrite a known-good email with a new lookup that returned a different result unless you've validated the new one.

Pro Tips and Advanced Techniques

1. Use LinkedIn URLs when available. If your contact list includes LinkedIn profile URLs, map those as an additional input. It increases match confidence significantly because there's no ambiguity about which "Sarah Johnson" you're looking for.

2. Separate catch-all domains. Before running your waterfall, add a column that checks whether the domain is catch-all. For catch-all domains, use LeadMagic's Catch-All Email Finder instead of the standard finder. This purpose-built tool handles the edge cases that regular finders miss.

3. Don't over-waterfall. Adding a 4th or 5th provider almost never moves the needle. If 3 providers couldn't find the email, the issue is likely data quality (wrong domain, person left the company) rather than provider coverage. Move on.

4. Build a monitoring view. Create a Clay view that shows your waterfall hit rates by provider. Track which provider is pulling its weight and which isn't. If a fallback provider consistently returns less than 5% incremental coverage, drop it and save the credits.

5. Automate the pipeline. Use Clay's webhook triggers or CRM integrations to automatically enrich new contacts as they enter your funnel. Build the waterfall once, and it runs itself.

6. Segment by domain type. Enterprise domains (fortune500.com) and SMB domains (smallbiz.io) have different enrichment characteristics. You may want different waterfall configurations for each segment.

7. Cache and de-duplicate. Before running enrichment, check if you've already enriched a contact in a previous batch. Clay doesn't automatically de-duplicate across tables, so maintain a master enrichment log to avoid paying twice for the same lookup.

Troubleshooting Common Issues

LeadMagic returns no results for a batch of contacts. Check your input data. The most common cause is malformed domains (extra spaces, http:// prefix, or the company name instead of the domain). Also verify your API key is active and has credits remaining in the LeadMagic dashboard.

High "risky" rate from validation. This usually means a large portion of your list uses catch-all email domains. Catch-all servers accept all incoming mail regardless of whether the specific mailbox exists, so validation can't confirm deliverability. Use LeadMagic's Catch-All Email Finder for these domains.

Fallback provider running on all rows instead of just misses. Your condition is misconfigured. Make sure the condition checks that the output of the LeadMagic Email Finder column (the email result) is empty, not that the column itself doesn't exist. In Clay, the condition should be: "If [LeadMagic Email Finder] → [email field] is empty."

Enrichment credits being consumed but no results showing. This can happen when input data maps incorrectly—for example, mapping "Company Name" to the domain field instead of the actual domain. Double-check your field mappings. "Acme Corp" is not a valid domain; "acme.com" is.

Bounce rate above 2% despite validation. If you're emailing contacts validated more than 30 days ago, re-validate before sending. Email addresses decay fast—people leave companies, mailboxes get deactivated, domains expire. Also make sure you're filtering out "risky" and "unknown" statuses for cold outbound.

Clay table running slowly or timing out. Large tables (10K+ rows) can slow down when running multiple enrichment columns. Break your list into batches of 2,000–3,000 rows and run them sequentially. This also makes it easier to spot-check results between batches.

What's Next

Once your waterfall is built and running, you'll want to expand your enrichment stack:

• Email Finder — Deep dive into LeadMagic's email lookup capabilities and accuracy benchmarks.
• Email Validation — Learn more about validation statuses and how to interpret edge cases.
• Waterfall Enrichment — Explore broader waterfall strategies beyond just email, including mobile numbers and company data.
• Clay Integration — Full documentation on all LeadMagic enrichments available in Clay.
• Catch-All Email Finder — Handle the trickiest email domains that standard finders miss.

Your waterfall is a living system. Monitor hit rates, swap underperforming providers, and keep your input data clean. Do that, and 95%+ coverage is repeatable on every list you run.