How to export Last Event Attended?

Lena Payne

Hi, I am having difficulties exporting a group of constituents with the Last Event attended. Is it possible to do? Thank you in advance.

Dan Snyder

@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.

Lena Payne

@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.