The Ticket Sales report displays the number and value of seats sold, returned, and changed by role for a range of events, roles and sales dates. You can choose whether to display net values (excluding taxes and service charges) or total values (including taxes and service charges).
You can use this report to determine which events have had admissions fully paid or removed over the course of a sales date range. The breakout of price types is useful for daily sales reporting purposes.
Only those event service charges charged against the price chart’s model are included in this report.
For a more detailed report, refer to Ticket Sales by Event.
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 field is enabled for you to enter the time (hh:mm:ss). If you do not enter the time, 00:00:00 is assumed. If you want to the include data from the entire day of the date you select, set the time to 00:00:00. Any value entered into this field will only apply if Date Range is used. Click The calendar dialog is only enabled to allow you to select the hour and minutes. Once you apply the time selection, you should modify the time to reflect the seconds. |
||
Sales To |
If you are entering a date range, this is the date to which data will be included in the report. This field is enabled for you to enter the time (hh:mm:ss). If you do not enter the time, 00:00:00 is assumed. If you want to the include data from the entire day of the date you select, set the time to 23:59:59. Any value entered into this field will only apply if Date Range is used. Click The calendar dialog is only enabled to allow you to select the hour and minutes. Once you apply the time selection, you should modify the time to reflect the seconds. |
||
Report Output By |
Groups the report data by: •Performance (Event) •Performance Short Description (Event Code) •Price Type •Price Type Group •Series •User Name •User Role Group •User Role Name
|
||
Report On |
Enables you to report on: •All Admissions •Bundle Admissions Only •Single Admissions Only |
||
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 service charges) and total values (including taxes and totals). When selecting this option, the report includes separate columns for taxes and service charges. •Net Sold: Displays net values only (excluding taxes and service charges). |
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 |
If you are entering a date range, this is the event date from which data will be included in the report. Only data relating to events on or after this date will be included in the report. This date is inclusive. Any value entered into this field will only apply if the Event Range date format is used. Click |
||
Events To |
If you are entering a date range, this is the event date to which data will be included in the report. Only data relating to events on or before this date will be included in the report. This date is inclusive. Any value entered into this field will only apply if Event Range date format is used. Click |
||
User Name |
Filters by the selected users. Click This is the user who last updated the order. |
||
User Role |
Filters by the selected user role(s). This is the user used to create the order. |
||
User Role Group |
Filters by the selected user role group(s). 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 contract(s). 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 Charge Types |
Enables you to further expand the pricing breakdown by adding columns based on the selected charge types: •Commission •Service Charge •Tax
|
||
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. |
||
Promo Code |
Filters the report based on a promotion. Click |
Output
Only those event service 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 service 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. If a price was overwritten without changing the price type, you will only see a price change, not a count. This is because there was no change to the price type, only to the value. |
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 the line item is of the total. For example, the percentage of sold tickets that are 'Adult'. |
