How to query event donors that converted to regular donors?
Hello Everyone! I queried our event donors in FY19 and would like to find those that have donated to a non-event appeal since then. Because there is a significant number, I'd like to refine the query to isolate those donors without having to do so in Excel. Does anyone have any suggestions? Thank you!
Tagged:
0
Comments
-
Okay, first thoughts here... Find a report that can help you isolate those donors for gifts since the event(s) and attach the query, and have it create an output query when you run it.
So, for example, a gift detail and summary report could be one of the ones you might use to find your donors that meet your secondary criteria. Attach the query to the report in tab 1, apply your filters in that tab (like only have given to non-event appeals or funds since then) and when you run the report, the output query will contain your new set of refined records.
Another option that's coming to mind is to use merged queries. You've already got your event donors built. You'd then build a second query of all donors who meet your 2nd set of criteria. Then use the AND merge operator to find those donors in both groups.3 -
Thank you Heather! I haven't done much with merged queries, however, it seems like the best approach since I'm half way there. No time like the present to learn how. Wish me luck!1
-
I agree with the recommendations of Heather MacKenzie and just to add another option that is like a merge. You could attach your query of event donors in the query options (Tools-->Query Options-->Record processing tab) and then in the main query criteria area write the query for donors to non-event appeals/funds since FY19. It acts the same way as a merge using the AND operator.
6 -
Thanks Dan! This is helpful. This is an area I have yet to explore - setting query options. It sounds straight forward enough.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 400 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®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 34 PowerUp Challenges
- 3 (Open) 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
- 790 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)