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.

Chris Zello

If you aren't a PowerBI user, you could use your export file to get what you want from Excel. What Dan has mentioned is very helpful for creating the file.

With the exported file, I would create a copy of the data onto a new worksheet. Then sort by the SortName and descending StartDate. Then if you go to Data>Remove Duplicates, have it match on ConsID and it will keep only the row with the most recent StartDate. You could use this with a VLOOKUP to pull the info you need into your other file.