How to Build a Data Enrichment Waterfall

Understand Why Waterfalls Outperform Single Providers

No single data provider has 100% coverage. A waterfall approach queries multiple providers in sequence, stopping when the data is found.

1. Benchmark your current enrichment coverage. Pull a sample of 500 leads and check what percentage have complete firmographic data (company name, size, industry, location) and valid contact data (email, phone, title). Most teams using a single provider see 60-75% coverage.
2. Identify the gaps. Which fields are most often missing or incorrect? Common problem areas are direct phone numbers (40-60% coverage), company revenue data (50-70% coverage), and technology stack information (30-50% coverage).
3. Research providers that excel in your gap areas. Different providers have different strengths:

Provider Type	Strengths	Typical Coverage	Cost Model
Clearbit / ZoomInfo	Broad firmographic and contact data	60-80%	Per-record or subscription
Apollo / Lusha	Contact emails and direct dials	50-70%	Per-credit
BuiltWith / Wappalyzer	Technology stack data	70-90% for web tech	Per-lookup or subscription
Crunchbase / PitchBook	Funding, revenue, leadership	60-80% for funded companies	Subscription
LinkedIn Sales Navigator	Title, role, and company verification	90%+	Subscription

4. Select 2-3 providers that complement each other. You want the highest combined coverage at the lowest total cost, not the single best provider.

Design Your Waterfall Logic

The order in which you query providers matters. Put the cheapest or most reliable provider first.

1. Define the fields you need enriched. Separate them into critical fields (must-have for routing and scoring) and nice-to-have fields (helpful for personalization).
2. Set your waterfall order based on coverage and cost. For each field, query Provider A first. If Provider A returns no result or low-confidence data, query Provider B. If Provider B also fails, query Provider C.
3. Define confidence thresholds. Not all enriched data is equally reliable. Set rules like: accept email data only if the provider gives a confidence score above 85%. Accept phone numbers only if verified within the last 90 days.
4. Handle conflicts between providers. When two providers return different values for the same field (for example, different employee counts), define a tiebreaker rule. Options include: always trust the most recent data, prefer the provider with higher historical accuracy, or flag the record for manual review.

Implement the Waterfall

Build the technical integration that runs your waterfall automatically on every new lead.

1. Trigger the waterfall on two events: new lead creation and scheduled re-enrichment (every 90 days for existing records).
2. Build the waterfall as an API chain. When a new lead enters your CRM, call Provider A’s API with the lead’s email and company domain. Parse the response and fill in available fields. If critical fields are still empty, call Provider B.
3. Log every API call, response, and enrichment action. You need this data to audit coverage rates, track costs per provider, and identify when a provider’s data quality drops.
4. Set rate limits and error handling. If a provider’s API times out or returns an error, skip to the next provider instead of retrying immediately. Queue failed lookups for a retry batch at the end of the day.
5. Store the data source for each enriched field. When you update a company’s employee count, tag it with the provider name and timestamp. This helps you trace data quality issues later.

Monitor and Optimize

An enrichment waterfall is a living system that needs regular tuning.

1. Track enrichment coverage weekly. Build a dashboard showing the percentage of leads with complete critical fields, broken down by provider. If a provider’s coverage drops below your threshold, investigate or replace it.
2. Measure cost per enriched record by provider. Divide each provider’s monthly cost by the number of records they successfully enriched. Some providers may have better coverage but worse unit economics.
3. Audit data accuracy quarterly. Pull a sample of 100 enriched records and manually verify the data. Check email deliverability, phone number validity, and firmographic accuracy. If accuracy drops below 85%, tighten your confidence thresholds or switch providers.
4. Review your waterfall order every 6 months. Provider coverage changes over time. A provider that was your best option last year may have been surpassed by a newer entrant.