Skip to main content

Exporting Bingo Game Scores, Rankings & Data to a Spreadsheet

Learn how to export scores from a bingo game, rankings, and other Experience data 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 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 the pink export button to download a square-by-square, bingo-by-bingo export of every single marked square and bingo from your players.

Pink export button example

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 following information:

  • The specifically marked square

  • The player who marked it

  • The points awarded

  • The timestamp of the marked square

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 Microsoft Excel or Google Sheets called CrowdActivityExport_timestamp.csv.

Crowd Activity table on the Activity tab

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 Sheets.

Player Rankings for a Bingo Game

Player Rankings for a Bingo Game

Export Team & Multi-Game Rankings & Results

The Team Rankings tab allows you to export team rankings if you're using Advanced Team Mode. Finally, click into the Team Rankings tab, and click the Export Team Rankings button. This will give you data for every team 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 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.

Advanced Team Rankings for a Bingo Game

Advanced Team Rankings for a Bingo Game

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 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 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 your participants' emails and phone numbers if you have these lead capture 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.

What if you never export your data? How long is data saved? 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.

Did this answer your question?