Export Idea Data (Comments &Tags)

Path and details about idea data along with comments and tags in a community

Path: Community Topbar >> Apps Icon >> Reporting >> Export Data >> Export Idea Data with 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 a particular idea. This helps them to get a view of tags usage on the idea.

1) Filter Data:

• Date: Community 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 the beginning to the current date will be exported.

2) Campaign: Administrator can select the campaign for which they wish to download the data. Selecting All campaigns will export data including Archived Campaigns.

Fields on Exported Excel sheet

 Sheet 1: Contains Ideas data in detail with the following fields -

• Date/Time

• Idea ID

• Idea Number

• Idea Stage

• Author Name

• Author Email Address

• Campaign

• Campaign Group (If any)

• Total Votes

• Up Votes

• Down Votes

• Idea Title

• Idea Description (body of idea)

• Tags

• Labels

• Idea URL

• Attachment

• Owners

• Comment Count

• Actual Comments

• City (If Include geolocation is enabled)

• Region (If Include geolocation is enabled)

• Country (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)