Exporting Lead Capture Data to a Spreadsheet

If you have an Experience with a large number of participants and lead capture data, exporting to a spreadsheet is essential in speeding up the process of importing your lead capture data into:

A third-party CRM (Customer Relationship Management)
A marketing service (e.g. email list manager)
A data processing software for analysis (e.g. Microsoft Excel, Google Sheets, Apple Numbers, etc.)

Exporting Lead Capture Data

When your Experience has ended, you can export your participants' lead capture data on the purple Leads tab and under the Participants section.

The Participants table shows 84 participants with various data (not actual data).

Simply click on the pink Export Crowd Lead Data button and all of your participants' input data will be exported to a spreadsheet-compatible comma-separated values (CSV) file called CrowdDataCaptureExport_timestamp.csv. This spreadsheet will list each participant in a row and each enabled lead capture field in the columns of the row.

This is an export of all the enabled lead capture fields from your Experience. So if you enabled Email, Phone Number, Age, Country, etc. these will all be included in the export. This allows you to build a contact list, add contact data to a database, etc.

An example Lead Capture Data export opened in Google Sheets (not actual data).

The Lead Capture Data export is the only data export in Crowdpurr that will include all of the lead capture fields you have collected from your participants. Other types of exports such as Trivia Rankings or Poll Results will include basic fields and a Player ID, but will not include additional fields like Age or Country for example.

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, etc.

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. You can use this to look up players between export files.

Additionally, both the Player Rankings Export and 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.

Exporting Other Experience Data

Articles in this section