Path: Profile Dropdown >> Reports & Analysis >> Export data >> IdeaScale Community Data Export
Administrators can export the community's data for ideas, stages, tags, comments, events, etc using this export alone instead of exporting each data export.
1. Date range cannot be more than a month.
2. If any of the tabs/sheets don't have data in them, that sheet will not be available in the excel file.
3. If there is no data available for the selected date range, a single blank sheet will appear in the export.
Expanding the Date Filters link will provide administrators the option to select a Start Date and End Date in order to define the date range for data to be exported. The date range of more than a month cannot be selected.
Alternative to Date filters is the Time Range option using which administrators can from one out of the following available ranges:
Last two weeks
Last three weeks
Select Your Timezone
Timezone can be selected for the export data timestamp from this option.
Choose Your Campaign
Administrators can choose to export data from all campaigns, active campaigns only, or a particular campaign.
Choose Tabs To Be Included In Your Export
Administrators can choose between the tabs they want to export. Following are the tabs they can choose from:
Audit Log - This shows login success/failure, user IP address, way of login (a mechanism), etc of each member n the community.
Member Report - Shows all the member details.
Community Events - Shows the type of actions performed in the community along with who and when it was performed.
Comment Votes - Shows details about the votes on the comment.
Idea Votes - Shows details about the votes on idea.
Idea Details - Shows all the details about the ideas.
Comments - Shows all comments in the community.
Moderator Tags - Shows moderator tags assigned to ideas.
Tags - Shows tags assigned to ideas.
Choose Stage type To Be Included In Your Export
Administrators can also choose between the stage types they want to export. Following are the stage types they can choose from:
Pending (those which are in pending approval)
Pairwise Idea Detail
Pairwise Member Detail
Fields on each Exported Excel sheet
Member report campaign (separate sheet for each campaign)
Stages (Separate sheet for each stage)
Sheet 1 - Audit Log
Via Identity Type
Sheet 2 - Member Report
Member Profile Language
What type of member are you?
Sheet 3 - Member Report Campaign
Each campaign will have a separate tab with the below information
Member Profile Language
Sheet 4 - Community Events
Sheet 5 - Comment Votes
Sheet 6 - Idea Votes
Sheet 7 - Idea Details
Any custom questions will have a separate column
Sheet 8 - Comments
Sheet 9 - Moderator Tags
Sheet 10 - Tags
Any tags you have in the community will have a separate column
Sheet 11 - Stages
Each stage within each workflow will have a separate tab with the below information. This will include 'Inbound', 'Pending', 'Pending review' and 'Off-topic' as well.
Idea Custom fields (each custom field will be listed in a separate column)
Upvotes Downvotes (Net votes)
Number of Comments
Sheet 12 - Assessment Results
Assessing Member ID
Community data can be exported in Microsoft Excel sheet (.xls) format.