Transcript Fundraising Intelligence - Institute of Fundraising
Fundraising Intelligence: Data Mining & Analytics 3 rd RIF Scotland October, 2011 Marcelle Jansen, WealthEngine
2
Agenda
•
Definitions
• Data Mining • Bringing Analytics to your Organization • Harnessing the Power of Data through Analytics – A Case Study
Definitions
3 • Data Mining: “
the extraction of meaningful patterns of information from databases”
• Analytics: “
how an entity arrives at an optimal or realistic decision based on existing data”
•
Predictive Modeling: “
the process by which a model is created or chosen to try to best predict the probability of an outcome”
4
The Goal: Fundraising Intelligence
“Fundraising Intelligence can be described as the process of gathering data, turning it into actionable information through analysis, and making it accessible to the right people, at the right time, to support fact-based decision making.”
5
“In God we trust. All others bring data.”
-- Barry Beracha Sara Lee Bakery retired CEO
Agenda
• Definitions •
Data Mining
• Bringing Analytics to your Organization • Harnessing the Power of Data through Analytics – A Case Study 6
Data Mining
• What data is important?
• What type of data should we collect?
7 • Where are the sources for data?
8
Key Considerations with Data
• Rules to Follow: – Clean – Consistent – Structured – Codified • GIGO: Garbage In Garbage Out
Data: Emirates Airlines Flight 407
9 • • • Context: Airbus A340-500 – Flight from Melbourne, Australia to Dubai on March 20, 2009 – Flight included 257 passengers and crew of 18 Events – Aircraft not accelerating normally – Traveled the length of the runway (more than 2 miles) still unable to lift-off – – Plane’s tail struck the ground at least 5 times before lift-off Clipped a strobe light and flattened a navigation antenna as it struggled to gain altitude Reaction – “This would have been the worst civil air disaster in Australia’s history by a very large margin” Ben Sandilands, Aviation Expert – “They were lucky that…a lot of people (didn’t lose) their lives” Dick Smith, former head of the Civil Aviation Safety Authority
What Happen on Flight 407!?!
Data: Emirates Airlines Flight 407
• Flight 407 had four experienced pilots in the cockpit – The captain and first officer completed a preflight checklist including a four-part process cross check • Data entry of plane’s calculated weight: 262 metric tons • Flight 407’s actual calculated weight: 362 metric tons – This is the equivalent of not calculating the weight of 20 African elephants stored in the belly of the plane • The Australia headline said it all: 10
11
“The Devil is in the Data”
‘The Devil is in the Data” The Australian, September 12, 2009
The Devil is in the Data: Types of Data
• Financial • Biographical • Philanthropic • Behavioral • Other………..
12
The Devil is in the Data: Sources of Data
• Internal • Volunteer Information • Research Information • Electronic Screening 13
14
Data, Data and More Data
• Giving History – First Gift Date / First Gift Amount – Last Gift Date / Last Gift Amount – Total Giving / Total # of gifts – Largest Gift Amount / Largest Gift Date – Average gift (annual vs. major) – Other factors?
15
Data, Data and More Data
• Relational – Family Ties (legacy alums, multiple family members with affiliations) – Alumni Association or Member – Volunteer Roles – Connection to an organization insider – Product Purchases
Data, Data and More Data
• Biographical – Age – Marital Status – Gender – Business Title – Email address – Business/home phone – Others?
16
Data, Data and More Data
• Contact – Last Staff Contact – Event Attendance – Last Solicitation – Amount of Last Solicitation – # of Contacts Overall – # of Contacts in last 3 years, 5 years – Others 17
Electronic Screening: Making It Work
• What should screening my data accomplish?
– Identify new prospects – Qualify existing prospects – Prioritize existing prospect pool – Segment prospects into solicitation pools 18
19
Electronic Screening Data
• How do I select the right type of screening for my organization?
– Determine your organizations needs – Do you need to screen your entire database or does it make more sense to screen a targeted sample – Do you want hard asset data?
– Or demographic data?
20
Electronic Screening Data
• Types of Data Returned – Geo-demographic Data – Hard Asset Data – Wealth Indicators
21
Electronic Screening Data: Results
• • • • • • Capacity Ratings Propensity to Give Ratings/Indicators Financial Information – Income – Real Estate – Stock Holdings Gifts to Others Age/Children Household Interests
22
Agenda
• Definitions • Data Mining •
Bringing Analytics to your Organization
• Harnessing the Power of Data through Analytics – A Case Study
Data Analysis vs. Statistical Modeling
Definition Techniques Tools
Data Analysis • Analysis of specific business questions and the development of foundational insights that feed into statistical modeling • • Hypothesis Based Approach (vs. Boiling the Ocean) Univariate & Bivariate Analysis • MS Excel most commonly used Statistical Modeling • Building statistical models to predict desired behaviors • • Multivariate Analysis Linear/Logistic Regression, Cluster Analysis, etc • SAS, SPSS are most popular 23
Modeling: What Do You Want To Accomplish
– Major Gift Model – Annual Fund Modeling – Planned Giving Model 24
Model Variables
Dependent Variables
• Overall likelihood of giving a gift • Likelihood of giving a gift over $X • Likelihood of being a Major Donor • Likelihood of upgrading a gift • Next Gift Amount • Lifetime Giving Amount • Next Ask Amount
Independent Variables
• Giving History RFM & Trend Attributes • Constituent Type Parents vs. Alumni • Wealth Indicators Capacity Ratings & Wealth Components • Demographics Age, Marital Status, Education • Contact Info Phone number, email address *RFM corresponds to Recency, Frequency, Monetary Value 25
26
Agenda
• Definitions • Data Mining • Bringing Analytics to your Organization •
Harnessing the Power of Data through Analytics
–
A Case Study
27
A Non-Profit Corporation Illustration
• • • Context – A Public Radio Station Understand the profile of the organization’s client base Rank order the client base on desired behavior using statistical models Determine criteria to identify best prospects in the broader universe • Available Data Organization data– Biographical, Giving History and Relational • Screening data – Wealth Attributes, Geo-demographic, and Philanthropic Objectives • Profiling analysis identified predictors of the desired behavior - Major Gifts greater than $250 • Rank order the client base • Profiling insights were used to develop a custom prospect identification strategy
28
Dependent Variable Illustration
Distribution by Largest Gift Amount
60% 50% 40% 30% 20% Dependent Variable Largest Gift >=$250 10% 0% 0-100 100-250 250-500 500-2K Largest Gift Amount 2K+ • Selected ‘Largest Gift of at least $250’ as the dependent variable • 6,149 donors met this threshold (incidence of 15% in the sample of 41,759 records) • Identified predictive attributes by analyzing across giving, wealth and demographic variables • Metrics used for analysis Incidence = (# of constituents with largest gift of at least $250)/(total number of constituents) Distribution = % of total constituents in a segment
Illustration: Number of gifts and years since first gift are strong predictors of giving at least $250 15% 10% 5% 0% 30% 25% 20% 8% 0-3 Gifts
By Number of Gifts
Incidence Distribution 24% 15% 4-6 Gifts 7+ Gifts
By Years Since First Gift
50% 45% 40% 15% 10% 5% 0% 35% 30% 25% 20% 25% 20% 15% 10% 5% 0% 24% 23% 18% 16% Incidence Distribution 12% 8% 45% 40% 35% 30% 25% 20% 15% 10% 5% Last 1.5
Years 1.5-3 Years 3-5 Years 5-7 Years 7-9 Years 10+ Years 0% 29
Illustration: Political giving and number of contact data points also strongly differentiate givers over $250
By Political Contribution Level By Number of Contact Methods
35% 30% 25% 20% 15% 11% 10% 5% 0% 0 Contributions 30 Incidence Distribution 21% $1 to $2,000 33% >=$2,000 80% 70% 60% 50% 40% 30% 20% 10% 0% 15% 10% 5% 0% 30% 25% 20% Incidence Distribution 12% 0 or 1 25% 2,3,4 90% 80% 30% 20% 10% 0% 70% 60% 50% 40%
Illustration: Property Value and Giving Capacity scores slope giving behavior (>=250) 31 15% 10% 5% 0% 40% 35% 30% 25% 20% 13% <=$500K
Property Value Giving Capacity
Incidence Distribution 18% <=$2MM 37% >$2MM 80% 30% 70% 25% 60% 50% 20% 40% 15% 30% 10% 20% 5% 10% 0% 0% 10% 14% Incidence Distribution 19% 26% $0 - $11K $11K - $226K $226K - $336K $336K+ 70% 60% 50% 40% 30% 20% 10% 0%
Statistical Modeling: Making it Work
• How will all this help me determine the philanthropic characteristics of my organization’s donor base?
– Allows you to determine which assets have the most impact on organizational giving – Allows you to become more efficient in selecting the best prospects for your programs and organization – Allows you to segment, build and grow your prospect pool to focus on your best prospects 32
33
Summary
• Fundraising intelligence allows you to optimize your data for: maximum return on investment, effective strategy development efficient fundraising management • It all starts with good data!
Questions?
Contact: 020 3318 4835 [email protected]
www.wealthengine.com