Gain insights about member activity and participation during a specific time period. The Member Participation export includes the following data based on the date range selected:
- Total login count
- Total comments posted
- Total surveys completed
- Total member posts submitted
- Total files uploaded
- Total points earned
This export type includes only members. Moderator and client users are not included.
Create a Member Participation Export
- Select Exports from the left navigation.
- Select Request Export.
- Select Member Participation as the export type.
Export Setup
Export Name—Enter a name for the export. Exported files are named in the format Type_Created_ExportName—for example, Survey_092123_ProductFeedback.
Export Filters
Date Range (optional)—Enable a date filter to export content for a specific period.
Banners
By default, the Members tab of the export includes User ID, User Role, Username, Email, Status, and Activation status. Enable the options below to add additional account, profile, or survey columns to the Members tab.
Include User Account Fields—Exports all required account fields, such as name, gender, and age.
Group Membership—Select up to 10 groups to include in the export. Type the group name and select it from the list.
P2 Engine—Select one or more profile points to include in the export. Type the profile point question name and select it from the list.
- Include All P2 Points Marked for Export—Select this option to include all profile points flagged for export.
- Export reference text—Exports the reference text associated with the profile point response.
- Export message text—Exports the message text associated with the profile point response.
Participation Logs
By default, the export includes total counts for overall community activity and a breakdown per individual member. Enable the options below to add detail.
Activities—A detailed list of all actions taken by each member in activities during the selected period. Actions include comments and file uploads. Each action includes a participation date.
Surveys—A detailed list of all surveys completed by each member during the selected period, including the participation date.
Member Forums—A detailed list of all actions taken by each member in Member Forums during the selected period. Actions include member posts, comments, and file uploads. Each action includes a participation date.
Points Earned—A detailed list of all points earned by each member during the selected period. Details include the activity name, the action taken, the participation date, and the points earned for that action.
Submit Export Request
Click the Request Export button when you're ready to submit for processing. When the export is ready, a notification appears in the bell icon at the top of the screen. You can download the file from the notification without leaving your current page.
You can also go to the Exports page and use the Actions dropdown to download. Two versions are available:
- Download—All data included in the export, including personally identifiable information (PII) such as name and email.
- Download Masked—PII is masked and will not display in the file.
The status column shows Requested while the export processes. Once it is ready to download, the status changes to Completed.