A large cardiovascular nonprofit had the goal of understanding how its donors behaved across multiple giving channels. The ideal solution would ingest data from numerous disparate databases and stitch it all together to create a single view of the donor. The client sought to understand its customer retention and to drive additional revenue.

To do that, this nonprofit needed to overcome the following challenges:

• Multiple donor databases across giving programs (events, direct mail, online, etc.) with millions of historical transaction records
• No ability to link donor identities across the various sources
• Unclean data and no support from the internal IT department
• No insight into how the donors differed from a demographic standpoint across the various programs (age, income, interests, education levels, geographic location, etc.)

Merkle quickly stood up the Rapid Audience Layer (RAL) platform and began ingesting data through flat file data feeds. PII data was mapped into Merkle’s identity resolution engine, Merkury, to join donor data across multiple sources. Historical data that spanned across decades was then ingested to build a full profile of each donor. Data scientists also built a standard process to link donation (transaction) data across all data feeds to create a single, comprehensive view of each donor across all programs and time. The analytics and strategy teams then evaluated donor retention within each program, crossover between programs, and overall retention to the organization