Data Mining a Non-Profit File for High Value Donors and Planned Givers
Presented by Perry D. Drake and Rhonda Knehans Drake at the SAS 2004 Data Mining Technology Conference, Las Vegas, Nevada
A non-profit organization needed to identify best donors in order to focus planned giving activities against the donors most likely to develop into “Planned Givers” and other “High Value Donors.”
The challenges regarding the objectives were:
The successful development of identifying “Planned Givers” and “High Value Donors” began with the creation of cohort groups with appeal and donation activity frozen in time relative to a donors first gift.
Once the cohort groups were defined, data was then explored through factor analysis followed by segmentation and regression modeling to understand the importance of various appeal strategies and their correlation to “Planned Giver” activity. In particular, we examine how premiums with appeals, holiday appeals and a club approach to appeals impacts the likelihood of a donor to becoming a “Planned Giver.”
Using this combined segmentation and model strategy the increased likelihood of identifying planned givers rose from 1.1 percent to over 7.0 percent. This represents a gain of over 600 in the ability to identify this highly desirable group.