All Crowdpurr Premium Plans allow you to export and save every single player answer-response received from your participants. The information included with each recorded entry is what square the player marked off, how many points were earned, and what time it was received. You can also export your Bingo Game's rankings and results. Lastly, you can export your participants' input lead capture data.
All exports are saved to a comma-separated values (CSV) spreadsheet file format for later analysis and archival.
Export Player Responses from a Bingo Game
On the blue Activity tab on the Experience Dashboard, click on the Export Crowd Activity button. This is a square-by-square, bingo-by-bingo export of every single marked square and bingo from your players. So if you need to audit a Bingo Game or want to review all the squares marked or Bingos obtained, you can review this export. It includes the specifically marked square, the player who marked it, the points awarded, the time they marked the square, etc. This tab lets you view and export your Bingo Game's participant activity for your records.
Upon exporting, a CSV file spreadsheet will be created that you can open in MS Excel or Google Docs called CrowdActivityExport_timestamp.csv.
Crowd Activity table on the Activity tab
Export Bingo Game Rankings & Results
On the Rankings tab on the Experience Dashboard, you can click on the Export Player Rankings button. This will export all of the player rankings to a CSV file spreadsheet. This lets you archive how your players performed, ranked, and who the ultimate winners were for your Bingo Game.
Upon exporting, a CSV file called PlayersRankingsExport_timestamp.csv will be created and downloaded. You can then open the spreadsheet in Microsoft Excel or Google Docs.
Player Rankings chart on the Rankings tab
Export Team & Multi-Game Rankings & Results
The Team Rankings tab can be used to export team rankings if you're using Advanced Team Mode. Simply click into the Team Rankings tab, and click the Export Team Rankings button. This will give you data from each of the teams in your Bingo Game.
Upon exporting, a CSV file will be created that you can open in MS Excel or Google Docs called TeamRankingsExport_timestamp.csv.
The Show Multi-Game Rankings? toggle can be used to view and export the total scores across every Trivia Game included in the Multi-Game Rankings. Click on the switch to toggle it, then click on the Export Multi-Game Player Rankings button to download the rankings.
Upon exporting, a CSV file will be created that you can open in MS Excel or Google Docs called MultiGamePlayerRankingsExport_timestamp.csv.
Advanced Team Rankings chart on the Rankings tab
Export Crowd Lead Capture Data
Lastly, 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 (Seminar Plan and higher only) 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 databases, etc.
The above Player Rankings and Crowd Activity exports will not include all the lead capture fields like this one does, which is why this export exists.
Upon exporting, a CSV file will be created that you can open in MS Excel or Google Docs called CrowdDataCaptureExport_timestamp.csv.
Participants table under the Leads tab
You may be wondering how you can link players between exports. For example, if you're looking at the Player Rankings export and want to know the phone number of the player who won first place. Each export has a unique Player ID (or Team ID for team modes) associated with each player that you can use 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 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 Bingo Game
After exporting your Bingo Game data and saving the exported CSV files, you can feel free to reset your Bingo Games and clear out any participant responses. You may then re-run your Bingo Game for 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 Bingo Games.
As long as you don't manually remove your Experiences, Crowdpurr will retain all of your experiences and crowd responses indefinitely. Some users prefer to leave the Crowd Responses in their Experiences and choose to never export their data. Your data is always saved even after downgrading. You can always clone any 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.
Exporting Other Experience Types
Please see the following articles for exporting other Experiences as a spreadsheet:
Comments
0 comments
Please sign in to leave a comment.