Fall-through waterfall
An ordered chain of providers where each is called only if the cheaper one before it returned blank, so you pay for exactly one hit per record.
WhenAny field where no single vendor has full coverage (email, mobile, firmographics) and vendors overlap. This is the base primitive under every enrichment play.
each finder column runs IF prior column IS BLANK, stop on first hit, write {value, source, confidence}- How it works
- Rank providers cheapest-first, best-coverage-first as the tiebreak, not by brand.
- Call provider 1; if it returns a value, stop and record the source.
- If blank, fall through to provider 2, then 3, each gated on the prior being empty.
- Stamp every hit with source and confidence so you can audit which vendor earned the credit.
A 4-tool email waterfall reaches ~68% found and ~62% valid, a +23% relative lift on valid-email rate over the best single provider, at ~$0.56 per valid email (site metrics). Stop-on-first-hit is what keeps the lift from costing 4x.