Consecutive Years Giving - with gift criteria
Options
Hi all,
We're starting up a new Loyalty Society and I've been asked to work on a list of donors with 5+ years of consecutive giving. We don't care the amount, BUT there are some criteria around the types of gifts that are being included (namely - we want to exclude some of our event purchases, raffles, etc.) Any thoughts on how to accomplish this?
A few other notes:
We're including only cash/pay-cash, not pledges
The way we currently include/exclude is based off appeal package category
We can't just exclude event appeals completely, because there are donations at many. (coded appropriately via the package category)
I don't need to know how much someone gave each year, just that there was at least one qualifying gift
Output needed is constituent name (and ID of course) and total number of consecutive years
I was hoping to find a report where I could query on gifts that meet the criteria, but the CYG reports only allow for constituent queries.
I've also tried just running a constituent query and using the summary field for CYG (with appropriate gift criteria), but it seems off? I may need to dig deeper to see if it's a data entry thing vs a RE thing though. Anyone have suggestions or experience with issues on the CYG field in query?
Thanks!
We're starting up a new Loyalty Society and I've been asked to work on a list of donors with 5+ years of consecutive giving. We don't care the amount, BUT there are some criteria around the types of gifts that are being included (namely - we want to exclude some of our event purchases, raffles, etc.) Any thoughts on how to accomplish this?
A few other notes:
We're including only cash/pay-cash, not pledges
The way we currently include/exclude is based off appeal package category
We can't just exclude event appeals completely, because there are donations at many. (coded appropriately via the package category)
I don't need to know how much someone gave each year, just that there was at least one qualifying gift
Output needed is constituent name (and ID of course) and total number of consecutive years
I was hoping to find a report where I could query on gifts that meet the criteria, but the CYG reports only allow for constituent queries.
I've also tried just running a constituent query and using the summary field for CYG (with appropriate gift criteria), but it seems off? I may need to dig deeper to see if it's a data entry thing vs a RE thing though. Anyone have suggestions or experience with issues on the CYG field in query?
Thanks!
Tagged:
0
Comments
-
Hi Steph, it hurts my head every time I start to think about how you might do this in RE, mostly because you need package categories. Not sure if it would help or be any easier, but I just started working on a report that finds donors that have given X out of Y years. It wasn't designed to find consecutive giving but you might be able to use it anyway. How far back are you going to find your 5+ years of consecutive giving donors?
Here's a Community post about the report that I posted just last week:
https://community.blackbaud.com/forums/viewtopic/159/26060
Josh
0 -
Joshua Bekerman bCRE:
Hi Steph, it hurts my head every time I start to think about how you might do this in RE, mostly because you need package categories. Not sure if it would help or be any easier, but I just started working on a report that finds donors that have given X out of Y years. It wasn't designed to find consecutive giving but you might be able to use it anyway. How far back are you going to find your 5+ years of consecutive giving donors?
Here's a Community post about the report that I posted just last week:
https://community.blackbaud.com/forums/viewtopic/159/26060
Josh
You're telling me. I probably could encourage alternate criteria (my original goal was just to look at receipt value, which would exclude all those gifts anyway...)
We want to know whatever they've given. We have gifts in RE back to 1982 (imported from whatever system they were using then.) We did get everyone to agree that anything prior to 2010 counted toward CYG regardless of gift type.
0 -
Wow, that is complex! I've always disliked working with consecutive year concepts because inevitably a major donor will have some sort of timing exception that will cause one gift to fall such that it is a year "early" or a year "late". Particularly pledge payments.
If this were me, I think I would dump a query of every gift in RE to an MS Access table. Then I would use Access to find all ConstIDs with less than 5 gifts, because they obviously won't be included. And from there just sort thru removing chunks of data/gifts that do not qualify. Then you start looking at timing of Gift Dates and do futher exclusions. Once done, you'll have your list of ConstIDs that currently qualify for your list, which you can tag with a Const Attribute using Global Add or Import (which also allows you to include a date as to when each donor qualified for this status). Now you just need to design an audit query in RE that will find new qualifiers moving forward.
Simplified for reasons of typing this in an online forum, and no easy or quick task to undertake, but for me, this would be the best way to get to the end result without missing anyone.
Do you happen to also use Campaign Categories or Fund Categories? I use them to easily exclude certain types of Gifts, and I would think it would be easier than Package Categories, since it's not buried quite as deep. Love Packages, but sometimes that data is more difficult to use than it's worth.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™
- 1 YourCause® from Blackbaud®
- 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
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 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