• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Donor Science Consulting

Donor Science Consulting

  • Home
  • About Us
  • Services
    • Data Mining
    • Discover New Major Gift Donors
    • DonorFAM
    • DonorFocus Model Scoring
    • DonorSearch Wealth & Philanthropy Append
    • Survey creation
  • CLIENTS & TESTIMONIALS
  • blog
  • Podcast
  • Contact Us

DonorFocus Documentation

Introduction

Welcome!  The main purpose of DonorFocus is to use your NeonCRM database to help you zero in on the annual giving donors most likely to bring value to your organization. When you contact only those donors most likely to respond, you waste considerably less money on your direct marketing campaigns and get a significantly higher donation return for your investment. The app does this by creating three predictive models that score each of your donors based on their annual giving:

Renew Score Model: Likelihood to renew their giving next year
UPG Score Model: Likelihood to upgrade their giving next year
Churn Score Model: Likelihood to churn next year
React Score Model: Likelihood to reactivate next year if they’ve lapsed

Using these scores, the app will recommend what you should do for each donor as a next step:

Churn Risk, Steward Carefully
Renew, Same Ask
Renew, Upgrade Ask Amount
Reactivate, Same Ask
Solicit with Extreme Caution

Once the scoring is finished (it shouldn’t take more than a couple of minutes at the longest), you can then download a list of your donor IDs, scored and labelled by recommended next step!

Registering for DonorFocus & Your NeonCRM API Key

When you register for an account to use DonorFocus (online registration form here) you will see an optional text entry field that allows you to enter in your NeonCRM API key.  See below for a screenshot of the field. 

The API key is a lengthy sequence of letters and numbers that will allow DonorFocus to pull data from your NeonCRM database.  For information on how to retrieve the API key for your organization, please refer to the documentation below:

API Keys

Which fields are retrieved from your neoncrm database?

The only data DonorFocus downloads from your NeonCRM database comes from the following fields in your Donations table:

  • Account ID
  • Donation Date
  • Donation Amount
  • Campaign Code
  • First Donation Date
  • Campaign Purpose
  • Fund Code

Summary of Recommendations

Once you’ve clicked ‘Download and Go‘ and generated models for your data, this tab will show you a graph containing counts of how many donors fell into each recommended action category. The graph is reactive in that if you want to solicit fewer donors for renewal and reactivation, decrease the slider value (at the bottom left) and the numbers in each ‘renew’ and ‘reactivate’ action group will in turn decrease.  If the number of people in the “Solicit with Extreme Caution” segment is too large for your liking, you can increase the number, shown under “Feeling confident?”, up to 3, and this will draw people out of the segment on the basis of their last year of donation.

Once you are satisfied with the scoring and recommendations, click the ‘Download a list..’ button to download a list of your donor IDs scored according to the three models along with recommended next steps for each donor.

Please monitor the ‘Warning Messages’ section for helpful notifications of whether there were any problems processing and modeling your data along the way.

 

Donor summary by recommendations

As soon as the app has created recommendations for you, this tab will display a helpful statistical summary table of the donors who fall into each recommended action group.  This table is meant to answer the question “Who are the people best suited to each recommended action?”

The metrics in the table are aggregated on the basis of either calendar, or fiscal year. This depends on how each organization using the app operates.

A few points of clarification:

– Average Last Year of Giving means when the donors in that group tended to give their most recent gift.  In groups like “Reactivate, Same Ask” and “Solicit with Extreme Caution”, there are donors who last gave in very different years.  This measure summarizes the average of those years.

– Median is the middle point in a group of numbers.  It’s like the average, except it’s less influenced by extreme outliers like the average is.

– Average Years of Donation on File summarizes the number of years during which donors were actively giving.  For example, if the file submitted has 10 years of history in total, and “Donor A” gave during 4 of them, then they would have 4 years of donation on file.

Giving preference explorer

This section uses the information in the submitted gift history file to answer the question: “What are the giving habits/preferences of the donors in each of the recommended action groups?”.  Giving preferences are broken down into separate tabs according to three categories:

  1. Largest last appeal
    1. This is simply the top 5 appeals to which donors gave their largest gift amounts in their most recent year on file.
  2. Lifetime preference by appeal type
    1. Here you will find the top 5 appeal type codes to which donors gave the most of their money across their entire lifetime on file.
  3. Lifetime preference by fund type
    1. Here you will find the top 5 fund type codes to which donors gave the most of their money across their entire lifetime on file.
Each graph gives you the option of visualizing the recommended action group of your choice, as well as the metric of your choice (# of donors vs. median donation $).  The below image is animated to show you the various possibilities in this section.

Using your donorfocus recommendations

Once you click “Download a list of your scored Donor IDs”, your computer will download a CSV data file where each row represents a donor (the ID is the first column) and each column is a characteristic of those donors.

Although you might want to create a custom communications strategy on the basis of any one of these characteristics, the core columns that will help you with your donor communications strategy are “Recommended_Action” and “Recommended_Action_Expanded”.  The first column contains the recommended actions that you saw in the first graph on the main screen of DonorFocus.  The second column alters these recommendations on the basis of whether or not each donor is a new donor (defined as someone who has only ever given 1 gift in their lifetime on file).

To use these recommendations, you need to create one or two custom account fields in NeonCRM (depending on whether you want to use one or both recommendation fields).  To read about how to create custom account fields, see here.  For documentation on how to import data into NeonCRM, see here.  Once your recommendations are imported, you can then use them as you would any other piece of data on your donors in your subsequent campaigns.

CONTACT US

Footer

MATT.DUBINS@DONORSCIENCE.CA
TORONTO:416-477-3619
TOLL FREE:1-855-267-1128

TORONTO, ONTARIO
M2R 3W5 CANADA

  • Facebook
  • LinkedIn
  • Twitter