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 |
| DiscountedAmount | The total amount of the ticket cost after discounts |
| 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. |
| 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 |
| 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. |