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

  1. Date filters
  2. Time range
  3. Select your timezone
  4. Choose tabs to be included in your export
  5. Choose stage type to be included in your export
  6. Fields on each exported excel sheet
  7. Output format

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 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:

  1. Audit log
  2. Member report
  3. Member report campaign
  4. Community events
  5. Comment votes
  6. Idea votes
  7. Idea details
  8. Comments
  9. Moderator tags
  10. Tags
  11. Stages
  12. Pairwise idea detail
  13. Pairwise member detail
  14. 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.

Did this answer your question?