Export Community Data 

The community administrator can export idea, stage, tag, comment, and other community data to an Excel file, based on the specific fields and options selected in the export report.

• Campaign: Community Administrators can choose to export data from all campaigns, active campaigns only, or a particular campaign.
• Filter by Date Range: To export all data from the beginning up to the current date, leave this toggle disabled. To export data for a specific time period, enable the toggle and specify a start date and an end date.
• Time Period: An alternative to Date filters is the Time Period option using which community administrators can select one out of the following available ranges:

  • Last week

  • Last two weeks

  • Last three weeks

  • Last month

• Tabs to be included in your export: Community Administrators can choose between the tabs they want to export. Following are the tabs they can choose from:Member Report, Community Events, Comment Votes, Idea Votes, Idea Details, Comments, Moderator Tags and Tags.
• Stage type to be included in your export: Community Administrators can also choose between the stage types they want to export. The following are the stage types they can choose from: Pending (ideas which are in pending approval), Ideate, Build Team, Refine, Estimate, ReviewScale, Fund, Assessment, Reserve, Recycle Bin, Off-Topic and Assessment Results
• Timezone: You may select your preferred timezone for viewing the exported data, allowing for a more personalized experience instead of adhering to the community's default timezone.

Fields on each Exported Excel sheet

Sheet 1 - Member Report 

• Member ID

• Email Address - Email address of the member

• Name - Display name of the member

• Member Since - Date and time of member registration

• Source - Member source like Web/Upload/Admin

• Status 

• Ideas

• Votes 

• Comments 

• Member Profile Language 

• TOS Accepted
• TOS Accepted Date

• Member Profile Questions

Sheet 2 - Community Events 

• Event ID 

• Timestamp

• Member ID

• Action Name

• Action Direction 

• Idea ID

• Comment ID 

Sheet 3 - Idea Votes 

• Up/Down

• Voter ID

• Voter Name 

• Email Address

• Idea ID

• Idea Number

• Idea Title

• Stage ID
• Stage Name

• URL

• Timestamp 

• Voter IP

Sheet 4 - 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 

• Description

• Tags

• Labels

• URL

• Attachments

• Owner

• Contributors 

• Latitude 

• Longitude 

• Idea Event

• Modification Date/Time

• Private
• Annotations
• Details

• Any custom questions will have a separate column 

Sheet 5 - Comments

• Date 

• Idea ID

• Comment ID

• Member ID

• Idea Number 

• Author

• Author Email

• Comment 

• Attachments 

Sheet 6 - Moderator Tags

• Idea ID

• Idea Number

• Idea Title 

• Separate column for each Moderator tag

Sheet 7 - Tags

• Idea ID

• Idea Number

• Idea Title 

• Any tags you have in the community will have a separate column 

Sheet 8 - Stages

Each stage within each workflow will have a separate tab with the below information. This will include 'Pending', 'Pending review' and 'Off-topic' as well.

• Stage Name

• Stage Type

• Idea ID

• Idea Number

• Title

• Description

• Details

• Idea Custom fields (each custom field will be listed in a separate column)

• Idea Campaign

• Tags

• Labels

• Contributors

• Up Votes

• Down Votes

• Upvotes Downvotes (Net votes)

• Number of Comments

• Attachments

• Idea Submitter

• Idea Submitter Email Address

• Idea Owner

• Idea Owner Email Address

• Stage specific columns

Sheet 12 - 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