The Ticket Sales by Performance report displays sales, returns, and price changes for a range of performances, 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. For more information, refer to Ticket Sales.
Only those performance 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.
Ticket Sales by Performance Report Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Venue |
Enables you to filter the report by one or more venue selections.
To select more than one venue, hold CTRL or SHIFT while making your selections. |
Series |
Specifies one or more series to include in the report.
Enter the series name and press ENTER or click to search for the series. For more information, refer to The Find Series Dialog Box. |
Performance Code |
Enables you to filter the report by a specific performance.
Enter the performance code or click to search for the performance. For more information, refer to The Find Performances Dialog Box. |
Sales Date Format |
Specifies the date to use for the report:
-
Date Range
-
Previous 7 Days - This does not include today.
-
Today
-
Yesterday
This is the date that the item on the order was sold, modified or deleted.
|
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.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
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.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
Report Output By |
Enables you to group the reporting data by:
-
Performance
-
Performance Short Description
-
Series
|
Report On |
Enables you to report on:
-
All Admissions
-
Bundle Admissions Only
-
Single Admissions Only
|
Group Price Types By |
Enables you to group 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 |
Enables you to group the report data by:
-
User Role
-
User Role Group
|
Advanced Section
The following criteria is available in the advanced section:
Criteria |
Description |
Performance Date Format |
Enables you to filter the report by:
-
Advanced Sales: Filters for allocated tickets for performances that occur after today’s date.
-
Past Sales: Filters for allocated tickets for performances that have occurred on or before today’s date.
-
Performance Range: Filters for performances occurring between the date range entered in the 'Performance From' and 'Performance To' fields.
|
Performances From |
Enables you to filter for those performances that occur on or after the date entered.
Any value entered into this field will only apply if the Performance Range date format is used.
The application will ignore your entry if you do not enter a value for 'Performances To' date.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
Performances To |
Enables you to filter for those performances that occur on or before the date entered.
Any value entered into this field will only apply if Performance Range date format is used.
The application will ignore your entry if you do not enter a value for 'Performances From' date.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
User Role |
Enables you to filter by the selected user roles.
This is the user who last updated the order. |
User Role Group |
Enables you to filter by the selected user role groups.
This is the user who last updated the order. |
Only Show Performances Without a Producer |
Enables you to filter the report so that only performances that do not have a producer are displayed. |
Producer |
Enables you to filter by the selected producers.
The report will return data related to the current producer of the performance(s).
To select more than one producer, hold CTRL or SHIFT while making your selections. |
Report on Opens or Holds |
Enables you to filter 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 |
Enables you to 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 |
Enables you to filter the report by the selected hold types.
To select more than one hold type, hold CTRL or SHIFT while making your selections. |
Display Options |
Enables you to choose the depth of the report that you would like to create:
|
Ticket Sales by Performance Report Output
The following image illustrates a sample report.
Ticket Sales by Performance Results (Output By Performance, Grouped by Price Type)
Only those performance 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. |