Community Settings >> Reports >> Export data >> Export Idea Votes
 
Community Administrator can export the vote data from a community to an Excel sheet or CSV file. Moreover, data can be filtered Campaign wise for specific period of time.

 1) Filter Data with:

  • Date: You can specify start date and the end date to download data for a specific period of time. If this field is left blank, all data from beginning to current date will be exported.
  • Campaign: You can select the campaign for which you wish to download the data. Selecting 'All campaigns' will export data including 'Archived Campaigns'

Fields on exported excel sheet:

 
 Sheet 1:
Contains Idea votes along with following fields

  • Up/Down - Shows if the user has Voted for an idea ( Up Vote) or against it (Down vote).
  • Voter ID - IdeaScale generates a unique identification number for all its members. The Voter Id is same as member's identification number.
  • Voter Name - Shows the voters profile name
  • Email Address - Shows the voters email address.
  • Idea ID - The Idea ID is is used by the system to uniquely identify an idea within the community.
  • Idea Number - is similar to Idea ID in its uniqueness. But unlike Idea IDs, Idea Numbers are consecutive (unless some ideas have been deleted) It's mainly used by members to locate ideas using the search function.
  • Idea - Shows the ideas title.
  • Idea URL - This is the idea URL.
  • Timestamp - Shows the date and the time at which the user voted on the idea.
  • Voter IP address – Voter’s internet network IP address.

 Sheet 2: Contains Comment votes along with following fields

  • Up/Down - Shows if the user has agreed with comment (Up Vote) or disagreed (Down vote).
  • Voter ID - IdeaScale generates a unique identification number for all its members. The Voter Id is same as one’s member identification number.
  • Voter Name - Shows the Voters Profile name
  • Email Address - Shows the voters email address.
  • Idea - Shows the ideas title.
  • Comment Summary - Shows actual comment.
  • Comment URL - This is the comment URL.
  • Timestamp – Shows the date and the time at which the user voted on the comment.
Did this answer your question?