Real Deal Fundraising
  • Home
  • Blog
  • Subscribe
  • Products
  • About
    • Services
    • Consulting
    • Connect
    • Testimonials

In-Depth: Demystifying Predictive Modeling (Working Dynamically with Projections)

10/12/2016

 
Picture
ast week, I argued that predictive modeling is not as intimidating as it sounds. In fact, you don't need a consultant to build your models and you are the best person to do it. 

You are the best person to build your projections for a couple of reasons: 1) You do/should have the most knowledge about how your program has historically performed and your strategies going forward. 2) You will be the person working with those projections throughout the fundraising year as living documents to guide your path to optimum performance. To work best with the predictive model, you should build it and understand it from the ground up. 

A great report (if you can easily get it) is a projections versus actual report that shows you segment-by-segment, side-by-side, where you thought you would be and where you are currently. But if you can't get a report like this designed, no worries. You can easily have your projections (your predictive model) in one hand and your up-to-date actual results in another. 

You should do a P v. A (Projections versus Actual) analysis at least quarterly but ideally monthly. My recommendation would be to work up to more frequent analysis if you aren't currently doing it, as it can be overwhelming and time-consuming in the beginning. The benefits are abundant, though, as I will articulate.

Here's how this works on the segment level: I'll use phonathon segments as an example, but this could be anything (direct mail, email, leadership giving, etc.) Say you are getting close to finished with the College of Business but it doesn’t look like you are going to reach your total dollars. You can now use your projections to pinpoint where the downturn occurred and proposed pointed solutions. (See charts above.)

You notice that you are very close to finished (completion rate) and therefore you aren't going to have that many more calls in order to make up lost ground. The next thing that pops out to you is that contact rate didn't perform to expectations. This signals one major thing: lack of data integrity. Lastly, the participation rate for this group is much lower than projected. You have isolated the two major issues with the College of Business results thus far. If you never had the projections, your report to the Dean of the College of Business would probably simply be, "I'm sorry but we are going to fall short this year." Or worse, you might feel the need to follow that up with a bunch of speculations and excuses. 

Instead, you are armed with information and can break bad news with prepared data-driven solutions. So, a conversation with the Dean of the College of Business might go like this: “It appears that we may fall about $2,000 short of our goal for your college. This is due in part to our contact rate being lower than expected for the college overall and a slightly lower participation rate than we hoped for in the future donors. So, I would recommend that we send out a 'where are you?' email to try and get updated phone numbers for all of your graduates and we may lower the ask amounts for the future donors to help improve acquisition for this group.”

This works the same way with your higher-ups. You will be able to show which metrics and schools are under-performing and explain the statistics rather than provide anecdotes or excuses.

It works the exact same way if your results are amazing! You are able to report on where and how you beat the goal and therefore where the areas of opportunity are for the future. This perspective can change the course of your career because you will become the most trusted person in your organization. You are informed, realistic, and have solutions and analysis galore! 

Try this with your next project. Let me know how it goes. 
Subscribe

Comments are closed.
    Picture

    Jessica Cloud, CFRE

    I've been called the Tasmanian Devil of fundraising and I'm here to talk shop with you. 

    Subscribe

    Archives

    May 2025
    April 2025
    March 2025
    February 2025
    January 2025
    December 2024
    October 2024
    September 2024
    August 2024
    July 2024
    June 2024
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    September 2017
    August 2017
    May 2017
    April 2017
    March 2017
    February 2017
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016

    Categories

    All
    Advancement Services
    Alumni Relations
    Annual Giving
    Apps
    Asking
    Board Relations
    Books
    Branding
    Budget
    Caller Training
    Career
    Case Building
    CFRE
    Communications
    Contact Rates Series
    Covid19
    Crisis Response
    Dance
    Data Integrity
    Data Research
    Development
    Digital Fundraising
    Direct Mail
    Donor Events
    Donor Relations
    E Books
    E-books
    Email
    Fiscal Year End
    Flash Mob
    Free Resources
    Fundraising
    FUNdraising Friday
    Geekery
    Giving Days
    Giving Societies
    Giving Tuesday
    Graphic Design
    Impact
    In Depth
    In-depth
    Interview
    Irarollovers
    Lobby
    Love Your Career
    Major Gifts
    Management
    Motivation Mondays
    Nonprofit Leadership
    Online
    Phonathon
    Planned Giving
    Productivity
    Public Speaking
    Quizzes
    Recurring Gifts
    Self Care
    Social Media
    Stewardship
    Strategic Planning
    Student Debt
    Team Building
    TED Talks
    Telefund
    Thoughts For Thursday
    Thoughts-for-thursday
    Travel Hacks
    Travel-hacks
    Trip Planning
    Tuesdays Tip
    Tuesdays-tip
    Video
    Work From Home
    Young Alumni

    RSS Feed

What Folks Are Saying

 Jessica has been a wonderful colleague and mentor over the years.  In the beginning of my annual giving career, I found her expertise, experience and willingness to help, invaluable.  Her advice and custom phonathon spreadsheets had a direct impact on our phonathon’s success and my ultimate promotion.  As I progress in my career, I continue to value her insight and professionalism." 

​- Ross Imbler, Director of Annual Giving, Lewis and Clark Law School
 Ross Imbler

Contact Us

Photos from ZERGE_VIOLATOR, FindYourSearch, Teddy Mafia, slightly everything, COD Newsroom, Howdy, I'm H. Michael Karshis, smoorenburg, derrickbrutel, Matthew Paul Argall, TP studio, craiglea123, wuestenigel, davidmulder61, baranco1, Editor B
  • Home
  • Blog
  • Subscribe
  • Products
  • About
    • Services
    • Consulting
    • Connect
    • Testimonials