IdeaScale Community Data Export

Path: Community Settings >> Reports >> Export Data >> IdeaScale Community Data Export

Administrators can export the community's data for ideas, stages, tags, comments, event etc using this export alone instead of exporting each data exports.

NOTE: 1. Date range cannot be more than a month.
2. If any of the tabs/sheets doesn't have data in it, 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.

Date Filters

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. Date range of more than a month cannot be selected.

Time Range

Alternative to 'Date filters' is the 'Time Range' option using which administrators can from one out of the following available ranges:

Last week
Last two weeks
Last three weeks
Last month

Select Your Timezone

Timezone can be selected for the export data timestamp from this option.

Choose Your Campaign

Administrator 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 (mechanism) etc of each member n the community.
Member Report - Shows all the member details.
Community Events - Shows type of actions performed in community along with who and when it was performed.
Comment Votes - Shows details about the votes on 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:

Inbound (status)
Pending Review
Pending (those which are in pending approval)
Ideate
Team Build
Refine
Estimate
ReviewScale
Fund
Assessment
Archive
Recycle Bin
Off-Topic
Pairwise Idea Detail
Pairwise Member Detail
Assessment Results

Fields on each Exported Excel sheet:

Audit log
Member report
Member report campaign
Community events
Comment votes
Idea votes
Idea details
Comments
Moderator tags
Tags
Stages
Pairwise idea detail
Pairwise member detail
Assessment results

Sheet 1 - Audit Log

Date/Time
IP
Type
Mechanism
Source Name
User ID
Source Email
Via Identity Type
Target Name
Target Email
Event Type

Sheet 2 - Member Report

Member ID
Email Address
Name
Registered Date
Source
Status
Ideas
Votes
Comments
Member Profile Language
Points
What type of member are you?

Sheet 3 - Member Report Campaign

Each campaign will have a separate tab with the below information

Member ID
Email Address
Name
Registered
Source
Status
Ideas
Votes
Comments
Member Profile Language

Sheet 4 - Community Events

Event ID
Timestamp
Member ID
Action Name
Action Direction
Idea ID
Comment ID

Sheet 5 - Comment Votes

Up/Down
Voter ID
Voter Name
Email Address
Idea ID
Comment ID
Idea
Comment Summary
URL
Timestamp

Sheet 6 - Idea Votes

Up/Down
Voter ID
Voter Name
Email Address
Idea ID
Idea Number
Idea
URL
Timestamp
Voter IP

Sheet 7 - Idea Details

Creation Date/Time
Idea ID
Idea Number
Author ID
Stage
Author
Author Email
Campaign
Campaign Group
Total Votes
Vote Up
Vote Down
Comments
Title
Details
Tags
URL
Attachments
Owner
Contributors
Latitude
Longitude
Idea Event
Modification Date/Time
Any custom questions will have separate column

Sheet 8 - Comments

Date
Idea ID
Comment ID
Member ID
Idea Number
Author
Author Email
Comment
Attachements

Sheet 9 - Moderator Tags

Idea ID
Idea Number
Idea Title

Sheet 10 - Tags

Idea ID
Idea Number
Idea Title
Any tags you have in community will have 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.

Stage Name
Stage Type
Idea ID
Idea Number
Idea Title
Idea Description
Idea Custom fields (each custom field will be listed in separate column)
Idea Campaign
Tags
Contributors
Up Votes
Down Votes
Up votes Down votes (Net votes)
Number of Comments
Attachments
Idea Submitter
Idea Owner
Team members

Sheet 12 - Pairwise Idea Detail

Idea ID
Idea Title
Idea Description
Idea Submitter
Submitter Email
Submitter ID
Batch
Idea Campaign
Total Rating
Members Assessed (count only)

Sheet 13 - Pairwise Member Detail

Email
Member ID
Name
Assessment Time Stamp
Batch
Campaign
Winning Idea ID
Winning Idea Title

Sheet 14 - Assessment Results

Idea ID
Idea Title
Idea Description
Idea Submitter
Member ID
Stage Name
Idea Campaign
Assessment Rating
Assessment Question
Assessing Member ID
Assessing Member
Email
Date

Output format

Community data can be exported in Microsoft Excel sheet (.xls) format.