Path: Profile Dropdown >> Reports & Analysis >> Export Data >> Export Idea Data (Comments and Tags)
Export Idea data feature allows community administrators to export idea data along with Comments and Tags. The first sheet in the report focuses on ideas and comments while the second shows the number of time tags used on particular idea. This helps the administrator to get a view on tags usage on the idea.
1) Output format: Idea data can be exported in the following formats
Microsoft Excel sheet (.xls) format
XML (RSS 2.0)
2) Select your Timezone: Administrator can select a specific timezone to get the time within data in the timezone.
3) Filter Data:
Date: Administrator can mention the start date and the end date to download data for a specific period of time. If Hide Data Filter is selected, all idea data from beginning to current date will be exported.
Campaign: Administrator can select the campaign for which they wish to download the data. Selecting All campaigns will export data including Archived Campaigns.
4) Include Geo Location: Enabling this option adds geolocation of the users. Note: This information will be visible only if the user has allowed to share it.
Fields on Exported Excel sheet:
Sheet 1: Contains Ideas data in detail with the following fields -
Date/Time
Idea ID
Idea Number
Idea Status
Author Name
Author Email Address
Campaign
Campaign Group (If any)
Net Votes
Votes Up
Votes Down
Idea Title
Idea Details (body of idea)
Tags
Idea URL
Attachment
Owners
Comment Count
Actual Comments
Latitude (If Include geolocation is enabled)
Longitude (If Include geolocation is enabled)
Sheet 2: Tags data shows statistics of user/predefined tags on idea with the following fields
Idea ID
Idea Number
Idea Title
Tag one
Tag two
Tag three and so on.
Sheet 3: Moderators Tags shows statistics of tags used by moderator on ideas (similar to sheet 2 format)
Sheet 4: Pending Ideas (similar to sheet 1)
Sheet 5: Recycle bin Ideas (similar to sheet 1)
Sheet 6: Off-Topic Ideas (similar to sheet 1)
