You can manage Ticket data coding in two ways: in-app via the UI for quick adjustments or an Excel file for bulk coding. Both methods are accessible via the Event Table.
👁️🗨️Identifying Events with uncoded values
When navigating through the Event table, you will see red flags 🚩next to some Event titles. This indicates uncoded ticket data for the event.
To remove these flags, please ensure that the Transaction Type and Ticket Price Type fields have been coded or confirmed.
🔶Using the UI interface
To code in the app, select the event and click 'Code tickets for X events' at the bottom of the page. A pop-up window will appear for data coding.
At the top of the window, you'll see a ticket graphic containing values from your raw data.
This is showing the Ticket group that you are currently coding data for.
Below the ticket, you will be able to see the number of tickets contained with the group and their value.
At the bottom of the window are drop down boxes containing the currently coded values. You can click on these and select from the available options to change them.
Once you’ve updated a ticket group, you can queue the changes using the “Queue Changes” button, then move through other groups using the “Next” and “Previous” buttons. When all edits are complete, click “Submit Changes” to save your work.
🔶Using the Excel File
If you find it more convenient to work in Excel, you also have the option to generate a downloadable coding file. This can be helpful for coding events with large volumes of ticket groups or for coding entire seasons at once.
Choose events from the Events table or Season view, then click “Download Ticket Coding File.” A pre-populated spreadsheet will be created, which can be edited offline and uploaded via the 'Manage Data Coding' portal.