Community Export Member Data

Community administrators can get quick information on the member registered with the community by downloading member data reports. Additional information on leaderboard points and Community roles (if configured in the community) can be exported along with the Member data report.
 
If the community has the setting Hide my Identity enabled and any member chooses to keep his identity hidden will have their Author's name in the Exports as 'Community Member' and their email address as 'The author's identity' is hidden.

1) Export format: Idea data can be exported in the following formats

• Microsoft Excel sheet (.xls) format

• CSV format

2) Include Groups in Export: The group type can be turned On to include groups of the members in the exported data.

3) Filter by Date Range: To export all data from the beginning up to the current date, leave this toggle disabled. To export data for a specific time period, enable the toggle and specify a start date and an end date.

4) Timezone: You may select your preferred timezone for viewing the exported data, allowing for a more personalized experience instead of adhering to the community's default timezone.

Fields on Ideascale users Excel sheet

• Member ID

• Email address

• Username

• Name

• Member Since

• Last Successful Login Date and Time

• Source: (Admin/Upload/web)

• Status: (Member/Invited/Yet to Join/Banned)

• Ideas (Submitted)

• Votes

• Comments

• TOS Accepted (Yes/No)

• TOS Accepted Date

• Group Based Moderation

• Groups ( If Include Groups In Export Data is enabled)

• Member Profile Questions

Separate sheets with the member breakdown per campaign are also included in the Excel sheet.

Fields on specific Campaign in Excel sheet:

• Member ID

• Email address

• Username

• Name

• Member Since

• Last Successful Login Date and Time

• Source: (Upload/web)

• Status: (Member status/Member Email status)

• Ideas

• Votes

• Comments

• TOS Accepted (Yes/No)

• TOS Accepted Date