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
TenantGroupACME Internal Use
Account
AccountCategoryNameIf 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.
AccountNameIf the ticket is associated with an organization then this will hold the organization's name
Transaction
AmountThe total amount of the ticket cost without any discounts
DiscountedAmountThe total amount of the ticket cost after discounts
SaleChannel

The sale channel in which the ticket was sold.

Values:

  • Collaborator
  • Customer Rep
  • InsideSalesIndividual
  • Kiosk
  • Online
  • Pos
  • Reseller
  • Salesforce
UserLoginThe name or email of the user that sold the ticket to the visitor
Event
EventGLCodeReturns Event GL Code field data for the event associated with the ticket.
EventNameThe name of the event associated with the ticket. 
EventStartTimeThe start time of the event associated with the ticket. 
TicketTypeThe type of ticket, as defined in the price list for the event associated with the ticket.  (e.g. Adult, Senior, Child, Student, etc.)
Order
OrderCreationDateThe 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

OrderNumberThe unique order number associated with the ticket. 
Visitor
CardImportIdMembership card import ID
ContactFirstNameFirst name of the person who purchased the ticket
ContactLastNameLast name of the person who purchased the ticket
EmailEmail address of the person who purchased  the ticket
ExternalCustomerIdMembership-related customer ID
MembershipAttributeCategoryno longer used
MembershipIdUnique id of the membership of the person who purchased the ticket
MembershipOrgNameIf the membership is an organization membership then this will be the name of the organization
PhoneNumberPhone number of the person who purchased the ticket
ZipCodeZip code of the person who purchased the ticket 
Ticket
CheckedInTicket check in flag True / False
CheckedInCountQuantity of tickets checked in
CheckInDateTicket check in date
ConversionStatusTickets converted to memberships flag True / False
ItemTypeType of item purchased/issued.
Values:
  • Event
  • Inventory (add-on)
  • Donation
  • Membership
MembershipExternalIdMembership externally generated ID 
MembershipLevelIdMembership level ID
MembershipLevelNameMembership Level (Program) Name
MembershipNumberMembership ID number
MembershipOfferingIdMembership offering ID
MembershipOfferingNameMembership Offering Name
MembershipPrimaryFirstNameFirst name of the primary cardholder of a membership
MembershipPrimaryLastNameLast name of the primary cardholder of a membership
TicketExternalSystemTickets originating from an external system
TicketNotesTicket notes
TicketPrintedTicket printed status flag True / False
TicketQuantityQuantity of tickets
TicketSerialNumberTicket unique ID
TicketStatusTicket validation return
EventTemplateCustomFields
EventTemplateCustomField1Custom field assigned to the event template.
EventTemplateCustomField2Custom field assigned to the event template.
EventTemplateCustomField3Custom field assigned to the event template.
EventTemplateCustomField4Custom field assigned to the event template.
EventTemplateCustomField5Custom field assigned to the event template.
EventCustomFields
EventCustomField1Custom field assigned to the event.
EventCustomField2Custom field assigned to the event.
EventCustomField3Custom field assigned to the event.
EventCustomField4Custom field assigned to the event.
EventCustomField5Custom field assigned to the event.