Filter constituent list giving by amount?
What would be the best report to be able to filter and see a list of constituents based on their annual giving. Example 2022 givers with an annual giving total of 12k+
Comments
-
@Michelle Stone On a Constituent List, you can filter on Total Giving, and specify gift dates and amounts.
0 -
@Marie Stark Ok, yes, we got that far but were then wondering how to filter with in those results. If we have last year total giving only showing, how do we then say within this time frame, we want anything over 12K for just that year? or will what you are saying report on that? I was assuming it was still giving me a lifetime total
0 -
@Michelle Stone If you are working in RE Database View, the criteria to use would be Summary for Gift (Total Amount of Gifts) then choose the gift types you want and I would include soft credits, to pick up those who give thru a Donor Advised Fund or a company and gift range and any other filters you may want. Once you have that, use an export and attach the query and then you bring over the info you would like to see, Name, Address, Total Giving for 2022 (make sure to set that up in the export as well) or anything else you want to see. Just do not use Query to export the information, use the actual RE Export.
0 -
@Michelle Stone You could gift amounts to the filter, and also have a column for lifetime giving.
0 -
@Joe Moretti I can run it in RE but was hoping to find something for my fundraisers who are using NXT only. A quick easy report for them to see the annual amount for the filtered date range.
0 -
@Marie Stark ok, yes this is helpful. Still looking for a way to display the annual amount possibly in NXT
0 -
@Michelle Stone Unfortunately in RE NXT, you will not be able to show the particular total you want to see, only the Total Giving for all time. This is the issue with RE NXT, reporting is very limited compared to Database View.
2 -
@Michelle Stone Just a word of caution, too, that you may want to consider how NXT is handling soft credits, especially with regard to matching gift funds, so your lifetime giving totals are the same in database view vs NXT. Not to open another can of worms, but that “lifetime giving” box can have all sorts of surprises…
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 402 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 656 Blackbaud Grantmaking™
- 577 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 941 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 240 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 796 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)