How does your Organization handle Giving Societies/levels?

Options
We are migrating to NXT in 2 weeks. In our current RE7, we have A LOOOOT of customization that helps us determine who are in our different giving society levels.  We have been told that our customizations will not be an option once we move to NXT.  


I have been made aware of "Donor Categories" which I think MAY help us, but I am unsure if it will be able to get granular where we need to.

I wanted to ask this lovely community the basics:  
  • With as much detail as you care to provide, how does your organization handle giving societies?
    • Attributes?
    • Constituent Codes?
    • Membership module?
  • Do you run these daily? Monthly? Quarterly? Annually?
    • how do you manage this?
      • queries? 
      • dashboards?
      • reports?
  • How do you calculate those with recurring gifts (whose 12 month payment might qualify them even though the full receipt hasn't't been realized? if this makes sense)?
  • Do you take into consideration those with "step-up pledges?"
    • how do you pull these folks into a giving society, if necessary?
I know it's a lot, so thank you or indulging me.  We're getting close to migration with no answer in sight!

Comments

  • We currently track our giving societies with Constituent Attributes.  The date field is the date they "entered" that society.


    That works well for all but the "annual giving" society because after 10 years that means 10 different attributes for us and it's getting a little ugly.


    We also just moved to RE NXT and we're thinking about using Membership (we never had it before) for giving society info going forward.
  • We use notes.  The type is the name of the society with YY (i.e. Reynolds19), the description is used if there is a specific monetary value associated with the society range.  So, in this example, the note type would be Reynolds19 and the description "Friend" (without the quotes).  We have 5 levels of giving in the societies.  I run the queries and add/update the notes on a daily basis so my manager can run her reports without having to ask me if all the coding is up to date. 
  • Karen Stuhlfeier
    Karen Stuhlfeier Community All-Star
    Tenth Anniversary 1,000 Likes 500 Comments Photogenic
    We use attributes - which translate to custom fields in NXT, but we mostly just rely on the gift dates and amounts. We use those in our queries to determine things like annual report listings. There's too much room for error if you rely on having to remember to put that information someplace. The gift dates and amounts are the facts.


    You're not losing RE - you're just gaining NXT - a web view of your current database. I kind of think that the way Blackbaud uses the term "migrate" isn't very accurate. It makes it sound like you're moving your database - which you're not.


     
  • Karen Stuhlfeier:

    We use attributes - which translate to custom fields in NXT, but we mostly just rely on the gift dates and amounts. We use those in our queries to determine things like annual report listings. There's too much room for error if you rely on having to remember to put that information someplace. The gift dates and amounts are the facts.


    You're not losing RE - you're just gaining NXT - a web view of your current database. I kind of think that the way Blackbaud uses the term "migrate" isn't very accurate. It makes it sound like you're moving your database - which you're not.


     

    Thanks Karen Stuhlfeier‍ .  I'm thinking I wasn't very clear.  We have custom coding set up on the back end (in the current API) that does not exist in the NXT API.  Therefore, we are unaware of any other way to query and export those that fill our VERY SPECIFIC criteria.
    • If your organization uses queries, is there a way, for instance, to query on those who have a recurring gift that equals $1,000 a year?  We have custom coding that does that math for us.
    • Is there a way to query those with multi-year step  up pledges, where the summary of those step-up pledges equals $1,000? 
    • Is there a way to pull Pledge Installment summaries for a certain year that should equal $1,000
    And, ultimately, does someone (or multiple people) in your organization manually run these, check them, and update records accordingly? and how often?
  • In other organizations I've often run this based upon straight giving amounts because then there isn't a need to update an attribute or anything like that.  When I joined this organization they used attributes but I dislike that mostly because attributes only have one date available so you either have to be consistent throughout all your attributes with the date being either the start or end date otherwise it gets confusing if it's strictly based upon the particular attribute.  I've been trying to use the membership module now because it's set up to handle beginning and end dates, reporting can be done on both historical and current active "memberships" etc.  The only problem is you do need to update it every time someone gives a gift that meets the level or a gift that raises them to the next level.  Unfortunately there's no current way to have this happen automatically.  Perhaps that's something that NXT will provide in the future as it's intended to be much more intuitive and allow for more "automatic" coding (like tags).  As a matter of fact I might just go make this suggestion (or vote if it already exists) to hopefully be ahead of the game. 


    As for pledges, we don't include pledges in a giving level, strictly cash in.  This is partially because of things like multi-year pledges.  If someone pledges $20,000 to be paid over 4 years we don't count them at the $20,000 level every year but at the $5,000 level.  This tends to keep it on an even basis as well as to take into account someone who either doesn't make a payment on time or overpays a particular payment.  And for recurring gifts we just know that a recurring gift of $83.33 is a $1,000 donor over the course of an entire year.  We had to figure this out so we could make this an option on our donor pages and give people the option of becoming a $1,000 donor by making a recurring gift of that amount.  And as opposed to a pledge we mark someone at the $1,000 level no matter when their donation comes in throughout the year (our fiscal and calendar are the same).  We know this is going to be taken out automatically so they really will be giving $1,000 over the course of the year (unless they cancel) as opposed to someone we expect to give but may not.
  • We have a President's club that has 5 different levels starting at $1,000 and going up to $25K. It historically had been managed in Attributes but it was allot of work to keep it accurate. We now extract out all RE Data that we report on nightly into a separate DB. We have nightly processes that calculate who has qualified every year. The positive is it is very easy for us to report on and we don't need to update/manage any data in RE. The con is it is outside of RE, but that is not an issue for our team.


    We have a separate reporting environment in QlikSense outside of RE. All staff retrieve their reporting data from there.

    Cheers,

    David
  • Just a thought I have had NXT for a year now and while they may be correct in the you won't be able to see on the web view, you can continue entering and reporting just as you have been on the database side. You might want to continue until you see how your team adjusts to NXT and find they don't need to be able to see in the web view as long as you still provide.
  • In RE, we use Attributes for each Giving Society (including a year), and we run a report weekly to add people, though many get added when the gift is added. We added the year as part of the attribute (so their record could show Kellan17, Kellan 18, Protected Resources Circle 19, etc) as this helps us 1) when a donor calls you can quickly see what Giving Society they are in, and 2) most importantly, we can easily report by Giving Society Attribute for each year they were in it without having to figure out which gifts to count for certain years (there might have been anomalies —count gala, don't count it, etc).

    For Sustainers and how we handle Giving Circles: we add their specific Attribute GIving Society year immediately when their monthly gift amount X 12 will add up to that gift Society's minimum. Thus, even if they join in Aug 2018 and won't reach the full amount in the 2018 Calendar Year, they are given the benefit of the doubt and treated at that level.  To catch fall-outs, in January, we run a query to look for people who are no longer Sustainers and did not make the minimum amt for each Giving Society (we count one time and sustainer gifts) and we delete their Attribute for the previous year if they didn't meet the $ minimum.
  • Dale Anania:

    In RE, we use Attributes for each Giving Society (including a year), and we run a report weekly to add people, though many get added when the gift is added. We added the year as part of the attribute (so their record could show Kellan17, Kellan 18, Protected Resources Circle 19, etc) as this helps us 1) when a donor calls you can quickly see what Giving Society they are in, and 2) most importantly, we can easily report by Giving Society Attribute for each year they were in it without having to figure out which gifts to count for certain years (there might have been anomalies —count gala, don't count it, etc).

    For Sustainers and how we handle Giving Circles: we add their specific Attribute GIving Society year immediately when their monthly gift amount X 12 will add up to that gift Society's minimum. Thus, even if they join in Aug 2018 and won't reach the full amount in the 2018 Calendar Year, they are given the benefit of the doubt and treated at that level.  To catch fall-outs, in January, we run a query to look for people who are no longer Sustainers and did not make the minimum amt for each Giving Society (we count one time and sustainer gifts) and we delete their Attribute for the previous year if they didn't meet the $ minimum.

    Thanks Dale Anania‍ !  I can only mark 1 response as best answer, but this one tied with 1st for me!  Thank you for all the information you provided :)


    Thanks everyone!!

  • Anyone on this thread start using the Membership tab area to track giving clubs? I'm looking for some insight on how others handle the re-upping. thanks!

Categories