Running Attrition Reports from different perspectives
Options
Hi All
We are looking to run reports that will give us more information on our donors. We have a list of questions I want to answer and they seem like questions that they would be questions that others are asking too. We're wondering how other RE users are getting the answers.
Here are some of our questions
What donors are we losing and when are we losing?
Do parents give when their students are in school or after they graduate? do they continue to give? when do we lose them?
Multi year donors, are they continuing to give or when do we lose them?
Are there dashboards / reports we can know to alert us when we lose people?
I was looking at the reports in RE and I see the variance reports comparing 2 years. I would like to be able to see more years to identify trends and also be able to break down the groups by consitiuent code, giving levels and other perspectives.
It seems to me that others would be asking all the same information in creating their plans.
Any assistance or guidance in the right direction would be greatly appreciated.
Thanks!
We are looking to run reports that will give us more information on our donors. We have a list of questions I want to answer and they seem like questions that they would be questions that others are asking too. We're wondering how other RE users are getting the answers.
Here are some of our questions
What donors are we losing and when are we losing?
Do parents give when their students are in school or after they graduate? do they continue to give? when do we lose them?
Multi year donors, are they continuing to give or when do we lose them?
Are there dashboards / reports we can know to alert us when we lose people?
I was looking at the reports in RE and I see the variance reports comparing 2 years. I would like to be able to see more years to identify trends and also be able to break down the groups by consitiuent code, giving levels and other perspectives.
It seems to me that others would be asking all the same information in creating their plans.
Any assistance or guidance in the right direction would be greatly appreciated.
Thanks!
Tagged:
1
Comments
-
Hi Sherry!
I don't work at a school... so there are parts of this that I don't know how to answer. And, I thought I could share how we're looking for some of our donor trends right now in hopes that some of them translate. We pull 4 reports (staggered throughout the month) each month that focus in on our lapsing donors. All are somewhat canned reports in RE that we've modified the parameters and queries for.- SYBUNT & LYBUNT - We pull both of these for a fairly broad stroke view of donors we've lost. One thing I like to do with these is to mark the 'create a constituent query' box on the general parameters page, then pull other reports to try to figure out if there is any correlation/causation between the people on the list using other reports (maybe the tallies report would help you here?)
- Comparison Report - We pull this to catch the people who are still giving... but who are decreasing their giving. Maybe they gave $500 last year... but this year they're on track to only give $100. We want to talk to them. Re-engage them. See if we can figure out what they need to get back to the expected giving level. Again, you can mark the 'create a constituent query' box to do futher research here.
- Lapsing Donor Reports - This one is less canned... but the goal is to catch donors BEFORE they show up on the LYBUNT report, so I have queries that look for people who gave 9-11 months ago, but who haven't given since. I break them up into 3 groups (90 day lapsing, 60 day lapsing, 30 day lapsing...) and sent it our to our individual giving team. They (try to) give the donors personal calls to re-capture them.
Good luck! And I hope someone with actual school experience speaks up with better tips!
2 -
I have worked at a few schools, including currently. And yes, we all ask these questions.
You can use the SYBUNT and LYBUNT reports to see who has dropped off. If you want to see the trend of when they are dropping you can check the box on the SYBUNT/LYBUNT that opts to output a query. You can then Export that query with as many fields as you like to show you number and level of gifts and their dates, along with other info.
You can utilize the Demographic Report >> Comparisons and Summaries to see giving by Constituency (either constit code or Gift constit code), fund and a myriad of other criteria to choose from.
Depending on the grade level of your school the giving varies. (this is based on experience rather than pulling reports at this point). Current Parents (currently enrolled) are the most consistent givers usually, Parents of Alums will continue to give, but there will be a drop off. Or if you are a high school or lower school, they will drop off for awhile while until child gets through college and then you will get them back, all depends on their capacity as to when and how much, and how many other children they have at your school or other schools. You can use the SYBUNT/LYBUNTs to figure this out also as far as drop off.
The variance reports you refer to are good, and you don't have to use just two years, you can do windows of time, like 3 years and 3 year windows or whatever.
I have always been asked to pull this type of info when working in schools:
What is the percentage of participation for different consitituent groups, utilizing the hierarchy we have established and not, so both way.
What amount of $$ did each constit group contributye
How much $$ went into each Fund.
What population (constit group gave to the main Funds i.e. Annual Fund)
What return was there for each appeal? How many were asked vs. how many returned $$
How many and much was from grants foundation/corporate
How much was from matching gifts.
and then of course giving by $$ level
Also if a high school or college/university, they want to see alumni giving by year
1
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