Path: Workspace Homepage >> Navigation Panel >> Settings >> Data >> Export Data >> Groups
| What is the Export Groups report? |
|---|
| Export Groups is a Workspace-level data export that generates a report containing details on every group within the Workspace, along with each group's member details. |
The Export Groups report displays detailed information on all groups within the Workspace, including group member details.
Role Permissions
- Workspace Administrator: Accesses Settings >> Data >> Export Data >> Groups to generate and download the Export Groups report.
Export Groups Settings
The Export Groups settings screen includes the following fields:
- Select Groups: A list of group names to choose from for inclusion in the exported report.
- Timezone: The timezone in which all exported data appears.
Selecting Export begins processing the report, which becomes available for download once complete.
Fields on Exported Excel sheet
The exported file is an Excel workbook made up of a summary sheet followed by one sheet per group.
Sheet 1: Groups Summary
The first sheet, named Ideascale- Groups, lists every group created within the Workspace with the following details:
- Group Name: The name given to the group.
- Number of Members: The number of members assigned to the group.
- Member Assignment Method: The method by which members are assigned to the group.
- Private: Indicates whether the group is set to private.
Sheet 2 Onwards: Individual Group Sheets
Starting with the second sheet, an individual sheet is generated for each group, containing that group's member details:
- Member ID: The unique identifier for the member.
- Email Address: The email address on file for the member.
- Username: The member's username.
- Name: The member's display name.
- Member Since: The date the member was added.
- Source: The origin through which the member was added to the workspace.
- Status: The member's current status
- Ideas: The number of ideas submitted by the member.
- Votes: The number of votes cast by the member.
- Comments: The number of comments made by the member.
Frequently Asked Questions
Can the Export Groups report be limited to specific groups?
Yes. The Select Groups field lists all group names in the Workspace, and one or more can be chosen for inclusion in the exported report.
What does the Timezone field control?
The Timezone field sets the timezone in which all data in the exported report appears.
What happens after Export is selected?
The report begins processing and becomes available for download once complete.
Where can individual group member details be found in the exported file?
Individual group member details appear starting with the second sheet of the exported Excel workbook, with one sheet generated per group.
Related Articles