FundSvcs Community

Expand all | Collapse all

Annual Fund Target Ask Amounts/Yield Analysis

  • 1.  Annual Fund Target Ask Amounts/Yield Analysis

    Posted 08-25-2021 01:57 PM

    We're looking to implement new procedures for entering annual fund target ask amounts (fixed number, no ranges) in our database (we're using Raiser's Edge/NXT).  Our ultimate goal is to look back and report the yield (%) and who came in above, at, or below ask.  Last year, we utilized the RE prospect module and loaded a proposal record to every prospect (household).  This proved to be an extremely complicated method to manage as all gift entry required proposal linking, not to mention that we had over 10,000 annual fund proposals in our database for last FY alone.  Every 'prospect' in our database gets a specific target amount, with the lowest amount at $25.

    Does anyone have a similar method for calculating 'yield' based on target ask amounts?  Where do you enter your ask amounts in your database?  Any tips?  Any and all information would be greatly appreciated!

    Many thanks,

    Tony Mercadal
    Director of Advancement Services
    Ransom Everglades School

  • 2.  RE: Annual Fund Target Ask Amounts/Yield Analysis

    Posted 08-25-2021 09:30 PM
    Hi Tony,

    Proposals in RE are really much more suitable for major gift management. I guess the big question in terms of how to set this up is whether it is important that the target amount be visible from the constituent's record or not. If so, you're probably going to wind up using an attribute for this. And if you do, you might prefer to name the ask levels, rather than set a number, so that you can tweak the numbers of the years without having to re-do all the attributes. You would translate back into numbers in your reporting.

    Since you're probably assigning target numbers in some computational fashion, using some formula that takes into account previous data, the 'ask amount' isn't really a granular characteristic of a person. It's a prediction of how much, on average, you're going to get from a segment of the donor pool. So why assign a number to each person? Why not just set asks by donor segments, rather than individually? 

    I guess the other thing I'm not fully understanding is that presumably, your 'ask' is determined by something like the average donation amount for a donor of this type, right? If so, the yield % is simply a year-over-year comparison of total giving. There's nothing wrong with that, but why take such a complicated approach to getting there?  

    There's lots more I'm happy to discuss on this topic offline, if you'd like to reach out directly.

    Isaac Shalev
    Data Strategy Expert
    Sage70, Inc.
    (917) 859-0151

    Schedule a 30-minute consultation now: