How does your Organization handle Giving Societies/levels?
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 manage this?
- 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?
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.0 -
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.0
-
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.
3 -
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
1 -
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.2 -
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,
David1 -
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.2
-
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.4 -
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!!
0 -
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!0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 3 Blackbaud Staff Discussions
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board