How do I filter members based on their last participation?

There is no direct way to filter members based on the Last Participation Date. However, you can export the member participation data to check the date on which the members last participated in an activity. This report will allow you to identify the members who should be included in your member group. You can then flag these members in a profile variable through an import.

Detailed Steps

Export the member participation data

1. Go to Community > Metrics.
2. Click Export Member Participation Data.
3. Select activity data in a certain date range.
4. Click Export.
5. Download and open the file.

Note:

• The application does not generate an overall last participation date for surveys. The LastParticipationDate column from the member participation data export is the date the member participated in the activity listed in ActivityName column only. The value will only be populated if the row has a value for the Survey columns (for example, SurveyInvited, SurveyStarted).
• The member participation report is a raw data file that contains every member's participation history. You can manipulate this file and identify the email addresses of the desired participants based on LastParticipationDate. For more information on how to manipulate this file, see How do I see the most recent last participation date for each member?

Create a profile variable

1. Go to Community > Profile Variables.
2. Click + Profile Variable.
3. Enter a descriptive variable name and a variable value.
   Example:
   Variable Name: Flag_Study_A
   Variable Value: 1
4. Click Save.

Import the flag variable as a profile variable

1. Open a new CSV file.
2. Add the header Email in the first column.
3. Paste all the email addresses in the first column.
4. Add the name of the Profile Variable in the second column (for example, Flag_Study_A).
5. Add the value 1 for each email address.
6. Save the file.
7. Go to Community > Profile Variables.
8. Click Import.
9. Click Choose File.
10. Look for the CSV file that you saved in step 6.
11. Click Upload.

You can now filter the members using the condition Profile Variable Flag_Study_A IS 1.

More Information

Please click the WebHelp links below for more information:

• Export member participation data
• Import members or profile variables
• Create a member group