Option #2: Run the Sales Report or Sales by Price Type report. These use transaction date instead of event date for reporting.
Option #3: Create the following query. Note: This solution covers how to report on scheduled programs and their attendance. To report on the attendance of daily admission programs, please use the Daily Admission Report. The Daily Admission report includes admission ticket counts for all sales methods.
Start your query:
- Go to Analysis > Information Library
- Click Add a new ad-hoc query
- Select the source view of Sales Order.
- To report on a specific program event: In the left column, expand Sales Order Item, then expand Sales Order Item Ticket and select Program Event. From the middle column, drag Program Event Record into Include records where. Set Equal to your program event.
- OR If you would like to include all program events happening in a specific date range: In the left column, expand Sales Order Item, then expand Sales Order Item Ticket and select Program Event. From the middle column,drag Start date to Include records where. Set this equal to your date parameters.
- Exclude refunds from the query for accurate ticket count
Add fields to Results Fields to Display:
- For the name of the program: In the left column, expand Sales Order Item, expand Sales Order Item Ticket and select Program. From the middle, drag Name to Results fields to display.
- For program category: In the left column, expand Sales Order Item, expand Sales Order Item Ticket and select Program. From the middle, drag Category into Results fields to display.
- For the date of the event: In the left column, expand Sales Order Item, expand Sales Order Item Ticket and select Program Events. From the middle, drag Start Date into Results fields to display.
- For the name of the program event: In the left column, expand Sales Order Item, expand Sales Order Item Ticket and select Program Events. From the middle, drag Name into Results fields to display.
- To see information about the source of the transaction (online, daily sales, advance sales, group sales): In the left column, select Sales Order. From the middle column, drag Sales method type into Results fields to display.
- To add the number of tickets sold: in the left column, select Sales Order Item. From the middle column, drag Quantity to Results fields to display.
- To add the dollar amount of those items sold: In the left column, select Sales Order Item. From the middle, drag Net Amount to Results fields to display.
- Note: Net Amount field will display how much was paid for the item (cost minus any discounts).
- To add the number of tickets refunded: In the left column, expand Sales Order Item and select Refunded item. From the middle, drag Quantity to Results fields to display.
- To add the dollar amount of those items refunded: In the left column, expand Sales Order Item and select Refunded item. From the middle, drag Total to Results fields to display.
- In order for the refund fields to calculate properly: Within Results Fields to Display, select your preferred node. Click the Sigma sign and check the box to SUM.
- To add Price Type: In the left column, expand Sales Order Item, then select Sales Order Item Ticket. From the middle column, drag Price Type Code to Results fields to display.
Your final query will look similar to this one:
TIP: Use the pencil icon to edit the name of the field headers in your results.
Using Excel to open the .csv, you may use features such as Autosum, Pivot Tables, and OData to report on the data in different ways, please visit Microsoft Support for further assistance with Excel.
