Staupell Analytics Group, Analytics Experts for Nonprofits, Improving Fundraising

  • Home
  • Workbooks
  • Capabilities
    • Analytics
    • Pipeline Development
    • Data Management
  • About Us
    • About Us
    • Partnerships >
      • Lauren Schler Consulting LLC
      • CampusWorks
      • TouchPoints
      • Advizor Solutions
  • Contact
  • Blog
  • Home
  • Workbooks
  • Capabilities
    • Analytics
    • Pipeline Development
    • Data Management
  • About Us
    • About Us
    • Partnerships >
      • Lauren Schler Consulting LLC
      • CampusWorks
      • TouchPoints
      • Advizor Solutions
  • Contact
  • Blog

Driven by Data Blog

Dependent Variables In Action

12/13/2015

0 Comments

 
Picture
In data mining, we frequently choose the dependent variable that is easiest to acquire from our primary databases. Most often, we start with the prospect’s lifetime giving (I admit that I teach that as well). However, we want to be careful when thinking about which giving variable is going to actually answer the question we have, and we have to make the best choice among all of our giving values, including single gifts and totals, to get the information that we need to make strategic decisions. Let’s take a look at some of these and how we might use them in visualizations, modeling, and mining.

Lifetime Giving measures only lifetime customer value. In addition, it is often directly related to the length of time a prospect has been involved with your organization, especially for consistent givers. So, lifetime giving values tend to favor older donors.
 
Giving per Year in System reduces the effect of length of time in your database by dividing lifetime giving by number of years in your system. For instance, a prospect became a member of your organization 10 years ago and her giving is $10,000. So, her giving is an average of $1,000 per year for her lifetime ($10,000/10 years). You are still measuring lifetime customer value, but removing the effect of age/length of involvement with your organization.
 
Highest Gift/Pledge measures a donor’s single highest gift or pledge. Note that major gifts tend to be multi-year pledges, so it is best to measure pledges for this variable. This is my favorite variable for modeling major gifts prospects.
 
Velocity or Consistency measures a donor’s recent behavior, whether she is escalating her giving or whether she is giving consistently. I use these variables for annual giving studies. Velocity is calculated as the last full year’s giving divided by the average of the previous 3 years giving.
 
Distances help measure the amount of required cultivation for different level gifts. Measure the distance from first to first major gift (major gifts), from entry date to first gift (annual giving), or from lowest gift to highest gift (major gifts or high-end annual giving) – hoping that the lowest gift came first.
 
I hope some of these ideas help you gain new insights into your donors’ behavior. Choosing well is key, and experimenting a lot is better. You can do this.

If you have questions or comments, tweet us @Staupell, email us at marianne@staupell.com or leave a comment below.
0 Comments



Leave a Reply.

    Keep Informed
    Sign up for
    notifications when a
    new post comes out

    Sign Up Now


    Author

    Marianne Pelletier has more than 30 years of experience in fundraising, with the majority in prospect research and prospecting.

    Guest Authors

    Greg Duke helps Raiser’s Edge clients to optimize their database by implementing data clean-up techniques and creating reporting structures, including dashboards and SQL queries.  He also facilitates data imports into Raiser’s Edge and database administration.

    Lauren Schler has more than 15 years of experience in fundraising representing academic, human service, and arts organizations, helping with annual fund and capital campaign initiatives.

    Categories

    All
    Advancement Svcs
    Annual Giving
    Assessment
    Big Data
    Blackbaud
    Dashboards
    Databases
    Data Management
    Data Mining
    Data Prep
    Dependent Variables
    Donor Modeling
    Efficiency
    Engagement
    Giving Variables
    Linear Regression
    Major Gifts
    Participation
    Productivity
    Project Planning
    Prospecting
    Push Technology
    Raiser's Edge
    RE NXT
    Reporting
    Research Pride
    RFM
    Statistics

    Archives

    March 2018
    September 2017
    June 2017
    March 2017
    January 2017
    December 2016
    September 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015

    View my profile on LinkedIn

Capabilities

Analytics
Pipeline Development
Data Management

Company

About Us

Support

Contact Us
© COPYRIGHT 2018 Staupell Analytics Group. ALL RIGHTS RESERVED.
✕