Ticket Sales Reports

There are a variety of ticket sales reports available in Intellitix Cloud. To learn more about downloading, viewing, and using the reports see below:

Organization Reports

The Organization Reports allow you to view data across multiple events that live in an organization or region at the same time. If you want to only see data from one specific event use the Ticketing Reports.

Downloading Organization Reports

Choose between CSV and PDF then click Generate. Then click the Download button when it appears in the Generating Report box.

Downloading_Organization_Reports_030823.gif

Viewing and Using Organization Reports

Event Audit Report

This report gives a quick overall summary of all events that have tickets on sale, have had tickets on sale in the past 7 days, and have tickets starting their on sale in the next 7 days. If generated at the organizational level it will contain all events within the organization and within the regions underneath the organization. If generated at the region level, it will only show the events for that region.

Each event has a section in the report that contains one line per ticket type and a summary line with all ticket sales and revenue generated up until the time the report was pulled, indicated by ALL TICKETS. The ALL TICKETS line will be the first line for each event on the report. Dates and times appear in UTC.

The Event Audit Report includes:

  • Event Name

  • Region

  • City

  • Venue

  • Event Date (UTC time)

  • Days on sale (total, by ticket type)

  • Days to event (total, by ticket type)

  • Total sellable inventory (total, by ticket type)

  • Tickets sold (total, by ticket type)

  • Remaining tickets (total, by ticket type)

  • Sales ($) excluding discounts and fees (total, by ticket type)

  • Promo code discount ($) (total, by ticket type)

  • Fees (total, by ticket type)

  • Tax (total only)

  • Revenue (total only)

Ticketing Reports

There are 3 Event Reports to choose from.

Consolidated Sales Report - shows order level data for all ticket purchases for the event and time frame chosen.

Ticket Sales Report - shows ticket level data for all tickets purchased for the event and time frame chosen.

Ticket Sales by Type Report - summarizes ticket sales by type for all tickets for the event and time frame chosen.

Downloading Ticketing Reports

These reports require an event to be chosen and date ranges selected from the dropdown before they can be generated. 

Downloading_Ticketing_Reports_030823.gif

 

Viewing and Using Ticketing Reports

Consolidated Sales Report

This report shows each order on its own line and includes the sum of all tickets, discounts, fees, and taxes for the total order as well as the status of the order as a whole. An order will appear on multiple lines each time its status changes, including full or partial refunds made on an order. Report lines are in chronological order based on when the action was taken, with the oldest at the top and the most recent at the bottom.

 

The Consolidated Sales Report includes:

  • Order ID

  • Event Name

  • Date - of order or action, based on the time zone report is generated in.

  • Time - of order or action, based on the time zone report is generated in.

  • Buyer Account - account type at the time of purchase is indicated by the code in front of the ID.

    • Guest - purchased using the widget and does not have an Intellitix account.

    • Act - the email associated with the order is a verified Intellitix account holder.

  • Email

  • Name

  • Phone

  • Quantity - number of tickets in the order or number of tickets affected by the action.

  • Status - will indicate if the line is representing a purchase or an action taken on the order.

Status

Definition

paid

There was a dollar amount associated with the order when it was initially placed and paid for..

paid:free

No money was collected on the initial order because it was for comp or free tickets. 

refunded:partial

Some of the items in an order were refunded, but other items in the order still remain valid.

refund:final

All of the items in an order were refunded and no valid items remain.

canceled:partial

Some of the items in an order were canceled, but some valid items still remain in the order. Canceling returns the invalidated items back to inventory.

canceled

All of the items in an order were canceled and no valid items remain. Canceling returns the invalidated items back to inventory.

 

Note: ticket transfers and ticket invalidations will not appear on the Consolidated Sales Report since they do not affect inventory or sales numbers.

  • Promo code - the promo code used (if one was used), if the code was a comp promo code the code will say COMP: in front of the code.

  • Sales Channel - where the purchase was made, either Sales Widget, Intellitix App, or Mobile Box Office.

  • Order price - the order amount before discounts, fees, or taxes.

  • Discount - the amount the promo code(s) discounted from the base ticket subtotal, amount will be negative when the promo code was used and positive when the ticket is invalidated.

  • Subtotal - the order amount after discounts but before fees and taxes

  • Fees

  • Taxes

  • Gross

To see Ticket Revenue in the Consolidated Sales Report:

Calculate the sum of the Gross column. This will include all taxes and fees associated with the orders.

You can also calculate the sum of just the ticket revenue by summing the Subtotal column.

To see the Total Tickets Sold in the Consolidated Sales Report:

Calculate the sum of the numbers in the Quantity column.

This will only give you overall tickets sold (including comps), and not a breakdown by ticket type. To see sales by ticket type you can use the ticket sales by type report.

To see total Discounts applied via promo codes in the Consolidated Sales Report:

Calculate the sum of the numbers in the Discount column. (The total will be negative.)

To see the total discount by promo code, filter the Promo Code column individually by each code and sum the number in the Discount column.

Ticket Sales Report

This report breaks the orders up by each ticket sold, with one line per ticket within the order along with its associated fees, taxes, and status. For example, an order that includes 1 GA and 1 VIP ticket would appear on two lines, with GA tickets on one and VIP on another. An order with 2 GA tickets would also appear on two lines, showing one line for each GA ticket. A single ticket will appear on multiple lines each time its status changes. Report lines are in chronological order based on when the action was taken, with the oldest at the top and the most recent at the bottom.

The Ticket Sales Report includes:

  • Order ID

  • Ticket ID

  • Event Name

  • Date - of order or action, based on the time zone report is generated in.

  • Time - of order or action, based on the time zone report is generated in.

  • Buyer Account - account type at the time of purchase is indicated by the code in front of the ID.

    • guest - purchased using the widget and does not have an Intellitix account.

    • act - the email associated with the order is a verified Intellitix account holder.

    • transfer - this order was created because of a transfer to an email that does not have an Intellitix account.

  • Email

  • Name (of the original purchaser; blank if transferred)

  • Phone (of the original purchaser; blank if transferred)

  • Ticket Type

  • Status - will indicate if the line is representing a purchase or an action taken on the order.

Status

Definition

valid

The ticket is valid. No additional actions have been taken on it.

valid:transferred

The ticket is valid and has been received as the result of a transfer.

invalid:canceled

The ticket was invalidated because it was canceled in customer service tools. The ticket was returned to inventory but no money was returned.

 

If a promo code was used the codes used will also be adjusted to return the code to inventory.

invalid:invalidated

The ticket was invalidated because it was invalidated in customer service tools. The ticket was not returned to inventory and no money was returned.

invalid:refunded

The ticket was invalidated because it was refunded in customer service tools. The ticket was returned to inventory and the money was refunded.

invalid:transfer-canceled

The ticket was invalidated because it was originally transferred then the transfer was canceled. The ticket was returned to its origin order.

invalid:transferred

The ticket was invalidated because it was transferred to someone else. A new valid ticket was created on a new order in its place.

  • Origin Order - the order that the ticket transfer came from.

  • Origin Ticket - the ticket that was transferred to someone else and therefore invalidated.

  • Promo code - the promo code used (if one was used), if the code was a comp promo code the code will say COMP: in front of the code.

  • Ticket Price - the base price of the ticket before discounts or fees.

  • Discount - the amount the promo code(s) discounted from the base ticket subtotal, amount will be negative when the promo code was used and positive when the ticket is refunded or canceled.

  • Subtotal - the price of the ticket after discounts but before fees.

  • Fees

  • Total Before Tax

To see Sales by Ticket Type in the Ticket Sales Report:

To see Promo Code used by Ticket Type in the Ticket Sales Report:

  • Filter the Promo Code column to include any promo code names and remove any blank rows

  • Filter the Ticket Type column to view the desired ticket type.

  • Then use the count function to count the total number of uses of each promo code.

Ticket Sales by Type Report

This report shows each ticket type, its price, the total quantity sold, and the total comps distributed at that price. Any changes to the ticket name or price will generate a new line with the changes and any sales or comps generated after the change. Report lines are in alphabetical order by the ticket type name.

The Ticket Sales by Type Report includes:

  • Event Name

  • Ticket Type

  • Ticket Price

  • Quantity Sold

  • Comp Quantity

To see Total Tickets by Type in the Ticket Sales by Type Report:

  • Sum the Quantity Sold and Comp Quantity cells for the desired ticket type

  • If price changes have been made, you will need to sum all rows of that type to see all tickets sold

To see the Total Tickets Sold in the Ticket Sales by Type Report:

Sum the Quantity Sold and Comp Quantity columns in their entirety




Was this article helpful?
0 out of 0 found this helpful