What Field Data Is Updated By The TicketReturn Connection?

Once the TicketReturn connection is enabled, specific fields in your account will be updated with data from TicketReturn on a nightly basis. The TicketReturn connection first checks to see if a field exists. If the field exists, then it is updated. If a field does not exist, it is created.

Field Name Updated/Created By TicketReturn In Your Account Data Added To The Field By TicketReturn
email The email address of a contact. The Email Address is mandatory.
firstname The first name of the contact.
lastname The last name of the contact.
sponsorid The Sponsor ID for all event information on the contact.
sponsoridother List of other Sponsor IDs that the contact has also purchased. For lists, each item should only be listed once, each item is separated by a space, and each item is enclosed in [square braces].
ticketpackages List of ticket packages that the contact has purchased. For lists, each item should only be listed once, each item is separated by a space, and each item is enclosed in [square braces]. The fields is blank if the contact has not purchased any ticket packages, only individual tickets.
Individualtickets Total number of tickets the contact has purchased that were not a part of a package.
tickettotalnumber Total number of tickets the contact has purchased (including both package and individual tickets). For contacts with multiple ticket packages, the field value is the sum of the number of tickets in all packages and individual tickets.
percentticketsused Percentage of all tickets purchased that could have been used, which have been used. For contacts with multiple ticket packages, the field value is the sum of the number of used tickets in all packages and individual tickets, divided by the Total Tickets from the tickettotalnumber.
percenteventsattended Percentage of events purchased by the contact that they could have been attended, which they did attend.
lasteventpurch The name of the last event for which the contact had purchased a ticket.
lasteventdatepurch The date of the last event for which the contact had purchased a ticket.
lasteventtimepurch The time of the last event for which the contact had purchased a ticket to.
lasteventpurchattended Flag indicating if the contact's ticket to the last event was used. To determine if a contact with multiple ticket packages and individual tickets attended an event, any single used ticket is represented as a "Yes" in the lasteventpurchattended field.
lasteventattended The name of the last event for which the contact has a used ticket.
lasteventdateattended The date of the last event for which the contact has a used ticket.
lasteventtimeattended The time of the last event for which the contact has a used ticket.
nextevent The next event name.
nexteventdate The date of the next event.
nexteventtime The time of the next event.
nexteventhasticket Flag indicating if the contact has a ticket to the next event. To determine if a contact with multiple ticket packages and individual tickets has tickets to an event, any single purchased ticket is counted as a "Yes" in the nexteventhasticket field.
nexteventpurch The name of the next event for which the contact has a ticket.
nexteventdatepurch The date of the next event for which the contact has a ticket.
nexteventtimepurch The time of the next event for which the contact has a ticket.
Warning: Fields that already exist that have the same name as those fields used by the TicketReturn connection will be overwritten with the data from TicketReturn.
Note: If you delete a field used by the connection, it will be re-created and populated with data during the nightly data refresh.