The Ticket Sales by Event report displays sales, returns, and price changes for a range of events, roles and sales dates. You can choose whether to display net values (excluding taxes and charges) and/or total values (including taxes and charges). Similar to the Ticket Sales report, this report provides additional details on sales.
Only those event charges charged against the price chart’s model are included in this report.
If your organization uses multiple roles within departments, you can run this report to get a sense as to which departments are processing orders. You can also use this report to detail sales activity for all departments. Executives could also use this report to determine which roles in the organization are active in terms of sales.
Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Venue |
Filters the report by one or more venue selections. Click |
Series |
Filters the report by the 'Series Name' defined on the Event Configuration - Events|Basic page. |
Event Code |
Filters the report by a specific event. Click |
Sales Date Format |
Specifies the date to use for the report: •Date Range •Previous 7 Days (excluding today) •Today •Yesterday |
Sales From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Sales To |
If you are entering a date range, this is the date to which data will be included in the report. This date is inclusive where the end time will be up to 23:59:59 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Report Output By |
Groups the reporting data by: •Performance (Event) •Performance Short Description (Event Name) •Series |
Report On |
Enables you to report on: •All Admissions •Bundle Admissions Only •Single Admissions Only |
Group Price Types By |
Groups the reporting data by: •Price Type •Price Type Group |
Display Values |
Enables you to specify what values to display: •Net Paid •Net Paid and Total Paid •Net Sold and Total Sold: Displays both net values (excluding taxes and charges) and total values (including taxes and totals). When selecting this option, the report includes separate columns for taxes and charges. •Net Sold: Displays net values only (excluding taxes and charges). |
Group User Roles by |
Groups the report data by: •User Role •User Role Group |
Advanced Section
The following criteria is available in the advanced section:
Criteria |
Description |
Event Date Format |
Filters the report by: •Advanced Sales: Filters for allocated tickets for events that occur after today’s date. •Past Sales: Filters for allocated tickets for events that have occurred on or before today’s date. •Event Range: Filters for events occurring between the date range entered in the 'Event From' and 'Event To' fields. |
Events From |
Filters for those events that occur on or after the date entered. Any value entered into this field will only apply if the Event Range date format is used. Your entry will be ignored if you do not enter a value for 'Events To' date. Click |
Events To |
Filters for those events that occur on or before the date entered. Any value entered into this field will only apply if Event Range date format is used. Your entry will be ignored if you do not enter a value for 'Events From' date. Click |
User Role |
Filters by the selected user roles. This is the user who last updated the order. |
User Role Group |
Filters by the selected user role groups. This is the user who last updated the order. |
Only Show Events Without a Contract |
Filters the report so that only events that do not have a contract are displayed. |
Contract |
Filters by the selected contracts. The report will return data related to the event(s) with the selected contract(s). |
Report on Opens or Holds |
Filters the report by: •Open Seats and Holds: ▪If no options are selected from the 'Hold Types' field, open seats and all holds will be returned within the reports results. ▪If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and all holds except the selected holds will be returned within the report's results. ▪If options are selected from the 'Hold Types' field and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and only the selected holds will be returned within the report's results. •Open Seats Only: Regardless of the option selected from the 'Include or Exclude Selected Holds' dropdown, or the options selected from the 'Hold Types' field, only open seats will be returned within the report's results. •Holds Only: ▪If no options are selected from the 'Hold Types' field, all of the holds (and only holds) will be returned within the report's results. ▪If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, all holds except the selected holds will be returned within the report's results. ▪If options are selected from the 'Hold Types' field ▪and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, only the selected holds will be returned within the report's results. |
Include or Exclude Selected Holds |
Choose whether or not to include the holds selected from the 'Hold Type' field in the report's results: •Exclude Selected Holds: Excludes all of the options selected from the 'Hold Type' field from the report's results. •Include Selected Holds: Includes only the options selected from the 'Hold Type' field from the report's results. |
Hold Type |
Filters the report by the selected hold type(s). |
Display Options |
Choose the depth of the report that you would like to create: •Detail •Summary
If you have exchanges enabled, the 'Display Option' will work as follows: •Summary: Exchanges are considered 'Sales' and 'Returns' in the net total. •Detail: Exchange To events are considered sales in the 'Sale' column, and Exchange From events are considered returns in the 'Returns' column •Detail (Report on Exchanges): The 'Sales' column shows the original sales, the 'Sales (Exchanges To)' column shows the Exchange To events, the 'Returns' column shows returns that are not part of an exchange, the 'Returns (Exchanges From)' column shows Exchange From events. |
Output
Only those event charges charged against the price chart’s model are included in this report.
The following table describes the report’s output:
Column |
Description |
Sales |
The total number of tickets sold and the value of those tickets. If you chose to display net and total values, separate columns are included for taxes and charges. |
Price Changes |
Displays a count and total for those tickets that had a price type change (for example, an adult ticket modified to a junior ticket) or a ticket’s price manually overwritten. |
Returns |
Displays a count and total for those tickets that were returned. |
Net Sales |
A sum of Sales, Price Changes, and Returns. |
Net Percentages |
The percentage of the total. For example, the percentage of sold tickets that are adult. |
