Skip to main content

Exporting Poll Results & Data to a Spreadsheet

Learn how to export results and related data from a Crowdpurr Poll as a CSV file spreadsheet.

Ross Newton avatar
Written by Ross Newton
Updated over 6 months ago

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 as a comma-separated values (CSV) file spreadsheet for later analysis and archival.

Export Crowd Poll Votes

On the light blue Activity tab on the Experience Dashboard, you can click on the pink export button as displayed on the right. This will export a CSV file spreadsheet containing a question-by-question, answer-by-answer export of every single answer from your players.

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.

If you need to audit a Poll or want to do a deep dive into all the answers to a given question, you can review this export. It includes the following information:

  • The question answered

  • The selected answer and whether it was correct/incorrect

  • The points awarded

  • The timestamp of when the answer was sent

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

Crowd Activity table under the Activity tab

Export Crowd Lead Capture Data

On the Leads tab under the Participants heading you can click 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 external 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

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 lead capture 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.

Did this answer your question?