Hello!
We're trying to gather a list of people who have been consistent donors to our organization over the past 5 years (Fiscal Year 18-22). We're not looking at how much they've given (it could be $10/year), what funds they've given to, or how many unique times they've given each year. It's about the consistency of giving every single year. Ultimately, our goal is to recognize these committed donors in the annual report, on a donor board in the Museum, etc. Once we get the 5 year report to work in Analytics, we want to pull it for 10, 20, etc. years too.
This is currently what I tried to set up for my colleague and not sure what's the best way to go about it. Any help is appreciated!
Thanks,
Amanda
Good idea! I just made this in my sandbox dash based on your idea. I'm filtering to any individuals and households who has a current membership and then counting the number of unique fiscal years of their contributions. I also have a filter so it's only grabbing 5+ year donors.
I'm wondering if it would make sense to make each year's amount a Value, then filter each and all of those values to ' > 0'. This would ensure that each person displayed would need to have all of those years' worth of giving in place. This gets a bit layer-intensive, but that should work.You also could do this with bucketing to create a super-formula:If (last year's giving) > 0 AND (2 years ago giving) > 0 [etc. etc.], [total giving] , NULL
Then set up rows for constituent, play with things from there.
I think I mis-read your post - I thought you were looking to only have people who had given each year for the past X years. Apologies!
Thank you! I think this is exactly what I was looking for.
No worries. Thank you though!
Ah yes, Nathaniel is right, this isn't going to give you consecutive years necessarily. Just the total number of years that they donated. Although it's also only giving you current members so it's likely that the years that they donated were recent.
Hi Amanda,
If you filter the widget to only FY 22 Contributors, that ensures they've given in the most recent FY you wish to count. Then removing the Campaign Fiscal Year from Categories, add a value for Years Consecutive Giving from FY 22... which in my case I used Campaign Fiscal Current Year Offset = -1.
So everyone in the widget has at least 1 consecutive year of giving in FY -1. Then if a constituent has no giving in FY -2, then they really are just a 1 consecutive year donor. If they have giving in FY -2 and none in FY -3, then they are a 2 consecutive year donor, etc.
CASE WHEN ISNULL(([Total Contribution Count],[Campaign Fiscal Current Year Offset = -2])) THEN 1WHEN ISNULL(([Total Contribution Count],[Campaign Fiscal Current Year Offset = -3])) THEN 2WHEN ISNULL(([Total Contribution Count],[Campaign Fiscal Current Year Offset = -4])) THEN 3WHEN ISNULL(([Total Contribution Count],[Campaign Fiscal Current Year Offset = -5])) THEN 4ELSE MAX(5) END
ConsecutiveYearsGiving.dash
Also filtered out $0 contributions and customer ID 0.
Despite my searching prior to posting this reply, I failed to find this post from 2 years ago, until now.
https://community.tessituranetwork.com/topical_groups/zoos-aquariums-tug/f/discussions/26853/consecutive-years-of-giving-membership/75033#75033
Thank you very much!