Community Export Member Data

Community Administrators can get quick information on members 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.

Role Permissions

1. Community Administrator: Configures and downloads Member Data exports for the community.

Export Settings

The following settings are available when configuring a Member Data export:

1. Export Format: Member data can be exported in either of the following formats:
   1. Microsoft Excel sheet (.xls) format.
   2. CSV format.
2. Include Groups in Export: Switch this setting on to include the groups a member belongs to in the exported data.
3. Filter by Date Range: Leave this switch disabled to export all data from the beginning up to the current date. Enable the switch and specify a start date and an end date to export data for a specific time period instead.
4. Timezone: Select a preferred timezone for viewing the exported data, rather than defaulting to the community's timezone.

Excel Sheet Fields

The exported Excel sheet contains a community-level summary along with separate sheets for the member breakdown per campaign.

Community-Level Fields

The community-level sheet contains the following fields:

1. Member ID: The unique identifier assigned to the member.
2. Email Address: The member's registered email address. See Exceptions below for identity-hidden members.
3. Username: The member's username.
4. Name: The member's display name. See Exceptions below for identity-hidden members.
5. Member Since: The date the member joined the community.
6. Last Successful Login Date and Time: The date and time of the member's most recent successful login.
7. Source: How the member's account originated — Admin (added by the workspace or community owner), Upload (invited by an administrator), or Web (registered directly through the community website).
8. Status: The member's current standing in the community, in Member status/Member Email status format — Member, Invited, Yet to Join, or Banned combined with a status such as verified or sent (for example, member/verified or member/sent).
9. Ideas: The number of ideas submitted by the member.
10. Votes: The number of votes cast by the member.
11. Comments: The number of comments made by the member.
12. TOS Accepted: Whether the member has accepted the Terms of Service — Yes or No.
13. TOS Accepted Date: The date the Terms of Service were accepted.
14. Group Based Moderation: The member's group-based moderation standing.
15. Groups: The groups the member belongs to. Included only when Include Groups in Export is enabled.
16. Member Profile Questions: The member's responses to community profile questions.

Campaign-Level Fields

Each campaign-specific sheet contains the following fields:

1. Member ID: The unique identifier assigned to the member.
2. Email Address: The member's registered email address. See Exceptions below for identity-hidden members.
3. Username: The member's username.
4. Name: The member's display name. See Exceptions below for identity-hidden members.
5. Member Since: The date the member joined the community.
6. Last Successful Login Date and Time: The date and time of the member's most recent successful login.
7. Source: How the member's account originated — Upload (invited by an administrator) or Web (registered directly through the community website).
8. Status: The member's current standing, in Member status/Member Email status format.
9. Ideas: The number of ideas submitted by the member within the campaign.
10. Votes: The number of votes cast by the member within the campaign.
11. Comments: The number of comments made by the member within the campaign.
12. TOS Accepted: Whether the member has accepted the Terms of Service — Yes or No.
13. TOS Accepted Date: The date the Terms of Service were accepted.

Exceptions

1. Hide My Identity Enabled: If the community setting Hide My Identity is enabled and a member has chosen to keep their identity hidden, that member's Name appears in the export as "Community Member," and their Email Address is hidden.

Frequently Asked Questions

What is the difference between the community-level sheet and the campaign-level sheets in the export?

The community-level sheet summarizes a member's activity and details across the entire community, while each campaign-level sheet breaks that same member's activity down individually per campaign.

Why does a member's Source show as Admin, Upload, or Web?

Source reflects how the member's account originated: Admin means the member is the workspace or community owner, Upload means an administrator invited the member into the community, and Web means the member registered directly through the community website. Note: campaign-level sheets do not include Admin as a Source value.

Can groups be excluded from the export?

Yes. Groups only appear on the community-level sheet when Include Groups in Export is switched on. Leaving the switch off excludes group data from the export.

Related Articles

• Help Article for Export Data 
• Help Article for Erase Community Data