Data Enrichment Waterfall
Querying multiple data providers in sequence, using the next only where the previous returned nothing, to raise coverage without paying for duplicate lookups.
Why sequence beats a single provider
No provider has complete coverage, and their gaps differ by geography and company size. A waterfall raises fill rate substantially while only paying the second and third provider for records the first could not resolve.
Decide precedence deliberately
How to build one
Order providers by accuracy for the specific field, not by overall reputation. Providers differ by field, and the best for firmographics is rarely the best for contact data.
Test accuracy on a sample you can verify independently before setting the order, rather than comparing providers against each other.
Stop at the first acceptable answer and record which provider supplied it. Without provenance you cannot tune the order later.
Measure marginal fill rate per provider. A provider adding two percent coverage at full price is a candidate for removal.
Re-test the order annually. Provider quality moves, and a waterfall set two years ago is probably in the wrong sequence.
Where it misleads
Waterfalls optimise for coverage, and coverage is not accuracy — filling a field with a poor answer looks identical to filling it with a good one.
Each additional provider adds cost and latency for diminishing returns, and the last provider in the chain rarely justifies itself.
Without per-field provenance the whole dataset becomes unattributable, so a systematic error cannot be traced to its source.
Cascading through providers can produce internally inconsistent records, where fields on one account come from sources that disagree.
RELATED TERMS
Account Scoring
Scoring at the account level rather than the individual, reflecting that B2B purchases are made by groups.
Data Hygiene
The continuous practice of keeping records accurate, complete and current — as distinct from data quality, which is the state that practice produces.
Enrichment
Appending third-party data to records so routing, scoring and segmentation have fields to operate on.
Lead Routing
The rules assigning each inbound lead to a specific owner — by territory, segment, product, account ownership or round-robin.
COMMON QUESTIONS
- What is a data enrichment waterfall?
- Querying multiple data providers in sequence, using the next only where the previous one failed to return an acceptable answer. It raises coverage above what any single provider achieves, at the cost of more spend, more latency and more complexity.
- How do you order providers in a waterfall?
- By measured accuracy for the specific field, not by overall reputation — providers differ substantially by field. Test each against a sample you can verify independently rather than against each other, because two providers agreeing on a wrong answer proves nothing.
- Is a waterfall worth the cost?
- Measure marginal fill rate per provider before deciding. The first two usually earn their place; the third and fourth frequently add a couple of percentage points of coverage at full price. The test is whether the marginal records enriched actually change any decision.
- Why does provenance matter in a waterfall?
- Because without recording which provider supplied each field, a systematic error cannot be traced to its source and the order cannot be tuned. It also makes internally inconsistent records — where fields come from providers that disagree — impossible to diagnose.
Learn how to apply this: CRM Admin 101
Definitions are the vocabulary. The courses are where you learn to operate it, with the interactive audit tools.
See the course