How do I see the most recent last participation date for each member?

The member participation data export displays the overall participation history for every member in your community and allows you to see multiple participation events from each member. You can see the most recent LastParticipationDate for each member by removing duplicate members from your Member Participation Data export.

Detailed Steps

Export your Member Participation Data

1. In the Community app, click Metrics.
2. At the top left of the page, click Export Member Participation Data.

Result: The Export Member Participation Data dialog appears.

3. Select a date range to see activity data.
4. Click Export.

See the recent participation date for each member

1. Open the Excel file you exported.
2. Select the LastParticipationDate (Local Time UTC-07:00) column.
3. On the Home tab, click Sort & Filter and then click Sort Newest to Oldest.
4. Select the Email column.
5. Navigate to the Data tab, click Remove Duplicates.

Result: The Remove Duplicates Warning dialog appears.

8. Select Expand the selection if it is not already selected and click Remove Duplicates...
9. Click Unselect All and then select Email in the Columns section.
10. Click OK.

Result: The first occurrence of the email in the list is kept but Excel deletes any duplicates that occur after.

If you want to group members you have identified from sorting by the most recent LastParticipationDate, see How do I filter members based on their last participation?

More Information

Read this WebHelp article to learn more about Export member participation data.