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 |
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. |