In the top right of the SHOEBOX Online Participants page, you can click the Export CSV button to export a CSV file containing the details of all participants that have taken your test. This will also include data specific to individual tests, such as questionnaire responses, test results, and reference IDs. This data is crucial when following up with customers on both an individual participant level and through broader email campaigns.
If you want to automatically export participant test results to your own data management platform you can use SHOEBOX Online’s API. For more information, see Results Data API.
| Disclaimer: SHOEBOX Online is not a diagnostic hearing test. Therefore, the values presented in the CSV are not threshold values; rather, the values are estimates of hearing levels based on the lowest sound a participant could hear using the headphones and devices they own. |
CSV export terms
In addition to placing participants into broad categories of normal hearing or hearing loss, SHOEBOX offers a more in-depth result view which includes:
- The lowest sound a participant could hear at 1k, 2k, 4k, and 6kHz.
- The lowest speech sound they reported to still understand.
- The most comfortable level for speech.
|
Note: The values 888 and 999 on the CSV export indicate the following:
|
The following table describes each type of data displayed in the CSV export.
| Column heading | Description | |
|---|---|---|
| TEST_DATE |
The data and time the participant completed the test.
|
|
| FIRST_NAME / LAST_NAME | The first and last name of the participant. If no name was entered, the participant will be listed as Anonymous. | |
| The email of the participant. | ||
| PHONE_NUMBER | The phone number of the participant. | |
| UPPER_AGE/LOWER_AGE | These values describe the age range selected by the participant. For example, if a participant selected 70+ for their age, the lower age will be 70 and the upper age will be 100. | |
| COUNTRY | The country of the participant. | |
| POST_ZIP_CODE | The postal or zip code of the participant. | |
| CITY | The city of the participant. | |
| GENDER | The gender of the participant. | |
| LANGUAGE | The language in which the participant selected to take the screening test. | |
| REQUESTED_EMAIL_RESULT | Indicates whether the participant agreed to have the results of their test emailed to them. For more information, see Email Participant Results under Configuring your test. | |
| EMAIL_RESULT_URL | Provides a URL that can be pasted into a browser to view the participant’s result page. | |
| ALLOW_EMAIL_MARKETING_MATERIALS | Indicates whether the participant agreed to subscribe to your organization’s marketing materials. For more information, see Email Marketing Materials under Configuring your test. | |
|
RESULT_CATEGORY_LEFT_EAR / RESULT_CATEGORY_RIGHT_EAR |
The hearing level category for each ear based on the participant’s test results.
|
|
| LEFT_OVERALL_SCORE / RIGHT_OVERALL_SCORE |
The hearing level score for each of the participant’s ears. This score is based on the four factors SHOEBOX Onlineuses to generate a hearing level score. For more information, see SHOEBOX Online: How it works.
|
|
| LEFT_SPEECH, LEFT_SPEECH_MCL / RIGHT_SPEECH, RIGHT_SPEECH_MCL | This is the lowest level and the most comfortable level (MCL) that the participant reported to be able to still understand the rainbow speech passage using the device and headphones they own. | |
| LEFT_1K, 2K, 4k, 6K / RIGHT_1K, 2K, 4K, 6k | SHOEBOX Online is not a diagnostic hearing test. Therefore, the values presented in the CSV are not threshold values; rather, the values are estimates of hearing levels based on the lowest sound a participant could hear using the headphones and devices they own. | |
| QUESTION_1-9 / ANSWER_1-9 | These columns display each question that the participant was asked in the dynamic questionnaire and each answer that the participant provided. | |
| PARTICIPANT_ID | A unique ID associated with the participant’s test that can be used to isolate and investigate their results. | |
| ENCOUNTER_ID | A unique ID associated with the participant’s test that can be used to isolate and investigate their results. | |
| PARTICIPANT_TEST_ID | Each instance of a participant taking the test is tagged with a participant test ID. This ID is provided as a URL parameter when a participant clicks the call-to-action button on the result page. If you accept this parameter on the page linked to the call-to-action button, you will be able to go back in our system and review the participant’s details. | |
| RESULT_UUID | A unique ID associated with the participant’s test that can be used to isolate and investigate their results. | |
| REFERRER_ID (refid) | If a referral source was included in the test URL, it will be displayed in this column. For more information, see Using reference and source IDs. | |
| ACCEPTED_PRIVACY_POLICY | Indicates whether the participant accepted the privacy statement. | |
| ACCEPTED_TO_CONTACT | Indicates whether the participant agreed to be contacted about their screening results via email, phone, or SMS. | |
| HEADSET_TYPE | Indicates whether an in-ear or over-ear headset was used for the screening test. | |
| HEADSET_CONNECTIVITY | Indicates whether a wired or wireless headset was used for the screening test. | |
| CONTACT_CAPTURE_CUSTOM_FIELD_1-3 | These columns display the labels of any custom fields you have added to the screening test. For more information, see Global Contact Information under Configuring your test. | |
| CONTACT_CAPTURE_CUSTOM_FIELD_1-3_VALUE | Indicates the value entered by the participant for any custom fields you have added to the screening test. | |
| PRIVACY_STATEMENT | Indicates whether the default or a custom privacy statement was associated with the screening test. For more information, see Custom Privacy Policy under Configuring your test. | |
| ONSITE_MODE | Indicates whether onsite mode was used for the screening test. For more information, see Onsite mode. | |
| CENTER_ID | Displays the ID for the Center to which the participant belongs. For more information, see Data access groups. |