How to export Last Event Attended?
Hi, I am having difficulties exporting a group of constituents with the Last Event attended. Is it possible to do? Thank you in advance.
Comments
-
@Lena Payne
Not in the way that you can for something like last gift date. I have a workaround but it is a bit convoluted.I have a participant export and on the General tab I uncheck the “Have not attended” box under the “Include participants who” area. The fields I export include the constituent id as well as event information, including the date. Attached to that export I have a participant query which for me is simply Constituent ID is not blank so I don't get any guests who are not constituents.
Then in Power BI (you could do this in Excel or PowerQuery) where I use this data I am able to identify the max date per the constituent ID and only keep those listings where the max date is equal to the event date to get a final last event attended date. Not the most straightforward, but it works for our needs.
4 -
@Dan Snyder thank you so much, I made some changes as I only needed ‘last event attended’ for a certain group of people, and it worked! Thank you for taking the time to share.
1
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) 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
- 778 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)
