The Ticket Analytics data set contains data from tickets. Use this data set to analyze visitation. Add-on transactions can also be analyzed in this data set if needed.
Tenant | |
TenantGroup | ACME Internal Use |
Account | |
AccountCategoryName | If the ticket is associated with an organization then this will hold the name of the category that the organization is in. Values are defined in Organizations>Categories. |
AccountName | If the ticket is associated with an organization then this will hold the organization's name |
Transaction | |
Amount | The total amount of the ticket cost without any discounts |
CouponCode | The coupon code applied to the ticket |
CouponName | The coupon name applied to the ticket |
DiscountCode | The discount code for the discount that was applied to the ticket |
DiscountedAmount | The total amount of the ticket cost after discounts |
DiscountId | The unique ID of the discount applied |
DiscountName | The name of the discount applied |
DiscountTag | The discount tag associated with the ticket |
SaleChannel | The sale channel in which the ticket was sold. Values:
|
UserLogin | The name or email of the user that sold the ticket to the visitor |
Event | |
EventGLCode | Returns Event GL Code field data for the event associated with the ticket. |
EventId | The unique ID of the ticket's event. |
EventName | The name of the event associated with the ticket. |
EventStartTime | The start time of the event associated with the ticket. |
TicketType | The type of ticket, as defined in the price list for the event associated with the ticket. (e.g. Adult, Senior, Child, Student, etc.) |
Order | |
OrderCreationDate | The date the order was created, typically the date the ticket was sold. |
OrderId | The unique id associated with this order. Use this to verify the accuracy of the report or to answer questions and fine tune your report |
OrderItemID | Join reports with Transactions that have the corresponding ID for all items purchased (e.g. Adult This will enable you to join reports with Transactions, which has the corresponding ID for all items purchased (e.g. Adult tickets, Senior tickets, Family Membership, etc.). Please note: This field will be populated in Ticket Analytics and Sale reports for all orders going forward. |
OrderNumber | The unique order number associated with the ticket. |
Visitor | |
CardImportId | Membership card import ID |
ContactFirstName | First name of the person who purchased the ticket |
ContactLastName | Last name of the person who purchased the ticket |
Email address of the person who purchased the ticket | |
ExternalCustomerId | Membership-related customer ID |
MembershipAttributeCategory | no longer used |
MembershipId | Unique id of the membership of the person who purchased the ticket |
MembershipOrgName | If the membership is an organization membership then this will be the name of the organization |
PhoneNumber | Phone number of the person who purchased the ticket |
ZipCode | Zip code of the person who purchased the ticket |
Ticket | |
CheckedIn | Ticket check in flag True / False |
CheckedInCount | Quantity of tickets checked in |
CheckInDate | Ticket check in date |
CheckInTerminalId | The terminal ID of the device that checked in the ticket |
ConversionStatus | Tickets converted to memberships flag True / False |
ItemType | Type of item purchased/issued. Values:
|
MembershipExternalId | Membership externally generated ID |
MembershipLevelId | Membership level ID |
MembershipLevelName | Membership Level (Program) Name |
MembershipNumber | Membership ID number |
MembershipOfferingId | Membership offering ID |
MembershipOfferingName | Membership Offering Name |
MembershipPrimaryFirstName | First name of the primary cardholder of a membership |
MembershipPrimaryLastName | Last name of the primary cardholder of a membership |
TicketExternalSystem | Tickets originating from an external system |
TicketNotes | Ticket notes |
TicketPrinted | Ticket printed status flag True / False |
TicketQuantity | Quantity of tickets |
TicketSerialNumber | Ticket unique ID |
TicketStatus | Ticket validation return |
EventTemplateCustomFields | |
EventTemplateCustomField1 | Custom field assigned to the event template. |
EventTemplateCustomField2 | Custom field assigned to the event template. |
EventTemplateCustomField3 | Custom field assigned to the event template. |
EventTemplateCustomField4 | Custom field assigned to the event template. |
EventTemplateCustomField5 | Custom field assigned to the event template. |
EventCustomFields | |
EventCustomField1 | Custom field assigned to the event. |
EventCustomField2 | Custom field assigned to the event. |
EventCustomField3 | Custom field assigned to the event. |
EventCustomField4 | Custom field assigned to the event. |
EventCustomField5 | Custom field assigned to the event. |