When you run your events through OpenSports you can collect custom attendee details by setting up custom questions. This guide will show you how to view and export attendee responses to these custom questions.
How to view attendee custom question responses
You can view individual attendee responses to the custom questions through the event page.
Events
- Locate the activity page, select Check-In
- If the custom question column isn’t visible, select Edit Columns and add the custom question.
- Player responses will appear under the column.
- Locate the activity page, select Check-In
- If the custom question column isn’t visible, select Edit Columns and add the custom question.
Programs/Leagues/Tournaments
Programs: Locate the Program Dashboard > Orders and select Export on the top right. The CSV download will display the player responses.
Leagues & Tournaments: Locate the League/Tournament Dashboard > Players OR Teams and select Export on the top right. The CSV download will display the player responses.
How to export attendee list and custom question responses
Export your list of event attendees and their responses to your custom questions as a .csv file. Each individual attendee is listed on one line of the .csv file.
- Navigate to your event page and click on Manage Users.
- Click Export Attendees in the top right corner. You will be prompted to save a .csv file &emdash; this file can be opened in software such as Microsoft Excel, Google Sheets, Apple Numbers.
- The following columns are included in all attendee list exports:
- Date Created: lists date (in YYYY-MM-DD) and time (in UTC) of each order.
- Order ID: unique identifier for each order. If an order includes an OpenSports user and a guest, the registrations will be shown in two separate rows, but will have the same order ID.
- Purchaser User ID: OpenSports ID of the account that made the order.
- Attendee User ID: OpenSports ID of the attendee. Any guests added to an order will not have an ID in this column. For OpenSports users, the purchaser and attendee user IDs will match.
- Ticket Class: the name of each registration type that you specify when setting up your event.
- Ticket Class Price: lists the price of one registration type. If you set up multiple registration types with different price points, these will be reflected here.
- Is Guest:* will be listed as TRUE if the specific attendee was registered as a guest (rather than with their own OpenSports account).
- Checked In: will be listed as TRUE for all attendees who were checked-in through the OpenSports website or app for the event.
- If you added custom questions to your event for attendees to respond to, their response data will be shown in the spreadsheet report after the default columns listed above.
Questions? Send them our way: support@opensports.net