Exporting Poll Results & Data to a Spreadsheet

All Crowdpurr Premium Plans allow you to export and save every single vote and response your Poll receives from your participants. Included with each recorded vote is what time it was received, which question, and which answer was selected. Additionally, you can export your participants' input lead capture data.

All exports are saved to a comma-separated values (CSV) file spreadsheet for later analysis and archival.

Export Crowd Poll Votes

On the Activity tab on the Experience Dashboard, you can click on the pink Export Crowd Activity button, which will export every vote from every single user onto a CSV file spreadsheet. You can perfectly archive every vote your participants respond with, which question was voted on, which answer was chosen, and the time of the vote. This tab lets you view and export your Poll's participant activity for your records.

This is a vote-by-vote export of every single response from your crowd. So if you need to audit your Poll or dig deeper into the actual votes that make up a given result for a Poll question, you can use this export for your analysis. Upon exporting, a CSV file will be created that you can open in Microsoft Excel or Google Sheets called CrowdActivityExport_timestamp.csv.

Crowd Activity table under the Activity tab

Export Crowd Lead Capture Data

On the Leads tab under the Participants heading you can click on the Export Crowd Lead Data button. This will export every participant and any entered lead capture fields from the fields enabled on this tab to a CSV file spreadsheet. This is a great way to archive your participants and capture their lead capture fields such as email, phone number, name, age, etc. You can then use this data for further analysis, marketing, contact lists, adding contact data to your own databases, etc.

The previous Crowd Activity export does not include all the lead capture fields as this export, so that is why this export exists. Upon exporting, a CSV file will be created that you can open in Microsoft Excel or Google Sheets called CrowdDataCaptureExport_timestamp.csv.

Participants table under the Leads tab

How do I track players between the various types of data exports in Crowdpurr?

You may be wondering how you would link players between exports. For example, let's say you're looking at a Poll's Crowd Activity export and want to know the Phone Number of a certain participant who voted on a given question. Each export has a unique Player ID (or Team ID for team modes) associated with each player. So you can use this unique Player ID to look up players between export files.

Additionally, the Crowd Activity export will include the email and phone numbers of participants if you have those fields enabled. These are unique fields so you could also simply just use these to look up players between export files. However, if you didn't collect an email or phone number (or didn't set them to be required), then you would simply use the Player ID field.

Export and Save Results Before You Reset Your Poll

After exporting your Poll data and saving the CSV file spreadsheets, you can feel free to reset your Polls and clear out any participant responses. You may then re-run your Poll on a new crowd as many times as you'd like using this method. You will still have your saved data exports to refer to for a historical record of your Polls.

 

What If You Never Export Your Data? How Long Is Data Saved?

Crowdpurr will retain all of your Experiences and crowd responses indefinitely. Some users prefer to leave their crowd responses within their Experiences and choose to never export their data. You can always clone an Experience up to your plan's Experience Limit. This will create a copy of the Experience that you can then reset and use versus reusing the original Experience. The choice is yours. Your data is always saved even after downgrading.

Exporting Other Experience Types

Please see the following articles for exporting other Experience data to a spreadsheet:

• Exporting Social Wall Posts & Images
• Exporting Trivia Game Scores, Rankings & Data to a Spreadsheet
• Exporting Bingo Game Scores, Rankings & Data to a Spreadsheet