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 answer is whether it was correct or incorrect, how many points were earned, what time it was received, which question, and what answer was selected. You can also export your Trivia Game's rankings and final results, and participant input lead capture data.
All exports are saved to a comma-separated values (.CSV) spreadsheet file format for later analysis and archival.
Export Player Answers from Trivia Game
|On the light blue Activity tab on the Experience Dashboard, click on the pink export button as displayed to the right to export a CSV file spreadsheet containing a question-by-question, answer-by-answer export of every single answer from your players.
If you need to audit a Trivia Game or want to review 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
This tab lets you view and export your Trivia Game's participant activity for your records.
Upon exporting, a CSV file spreadsheet will be created that you can open in Microsoft Excel or Google Sheets called CrowdActivityExport_timestamp.csv.
Crowd Activity table for a Trivia Game
Export Trivia Game Rankings & Results
On the yellow Rankings tab on the Experience Dashboard, click on the pink Export Player Rankings button to 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 Trivia Game. It also includes some additional data for each player, such as Total Questions Answered, Total Questions Correct, etc.
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 Sheets.
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 Trivia Game. Average and total scores, number of correct answers, and more breakdowns are included.
Upon exporting, a CSV file will be created that you can open in Microsoft Excel or Google Sheets called TeamRankingsExport_timestamp.csv.
The Show Multi-Game Rankings? switch 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 Microsoft Excel or Google Sheets called MultiGamePlayerRankingsExport_timestamp.csv.
Export Question Rankings
The Question Rankings tab can be used to export Per-Question Rankings. Simply click into the Question tab, and click the Export Question Rankings button. This will give you rankings data from each question. Average and total scores, number of correct answers, and more breakdowns are included.
Upon exporting, a CSV file will be created that you can open in Microsoft Excel or Google Sheets called QuestionRankingsExport_timestamp.csv.
Export Crowd Lead Capture Data
Lastly, on the purple Leads tab and under the Participants heading, click on the pink export button to export every participant and any entered lead capture fields from the fields enabled on this tab as a CSV file spreadsheet.
If you've enabled any Custom Lead Capture Fields, (Seminar Plan and higher only) any custom lead data will also be exported. 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 Crowd Lead Data export exists because the previous Player Rankings and Crowd Activity exports will not include all of the lead capture fields.
Upon exporting, a CSV file will be created that you can open in Microsoft Excel or Google Sheets called CrowdDataCaptureExport_timestamp.csv.
Participant & Lead Capture table for a Trivia Game
Export and Save Results Before You Reset Your Trivia Game
After exporting your Trivia Game data and saving the exported CSV files, feel free to reset your Trivia Games and clear out any participant responses. You may then re-run your Trivia 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 Trivia Games.
Exporting Other Experience Types
Please see the following articles for exporting other Experiences and data to a Spreadsheet: