An event can consist of several ticket types and attendees, therefore they are more complex than some other exports you might do. This article should help explain it further.
Events gadget
To find out information on a supporter’s ticket purchase, you can use the Lookup Supporter tool. The transaction will appear in the Transaction History gadget (remember to check your gadget’s settings to ensure you are seeing the appropriate campaign types) but you will get more detail if you use the Events gadget.
There are two types you can view in this gadget: ECS which is the most common and shows the total purchase price, including additional donations, that the supporter paid. The other type is ECC which is for free tickets or ones paid by cash or cheque.
The gadget will display the following:
Ticket information
This shows the number of tickets bought of each type, in its own row, along with any discounts or additional donations. The total price is displayed at the bottom.
Associated attendees
This will show you the names of any attendees for that purchase, with their name, email and ticket type. You can also click the “View” button to view more information and mark them as attended.
Transaction information
This shows you the details of the actual card purchase, with the gateway’s transaction ID, event log ID, date, amount, gateway name and expiry date of the card used.
Events data export
You can also use the export tool to export all event data as a csv file by clicking on the events tab in the filter list.
Click on “All Event Pages” if you want to export information on all event transactions, otherwise search and add the specific event. If you do this you can add further filters:
You can accept the defaults if you want to export as much information as possible on the event, otherwise you can export just certain ticket types, or discounts. You can also limit the types of rows that are exported in the Transaction format which we’ll explain below.
Note that a Hybrid format export will only show you the date the purchase was made, so if you want to export more meaningful export you should use the Transaction format.
Transaction export – rows
This format will potentially export several types of rows, denoted by the three letter code under the Campaign Type column:
- A single ECS row which details the entire purchase
- An ETK (Event Ticket) row per ticket type
- An ETA (Event Attendee) row per attendee
For example, if a supporter bought four tickets, one “standing” and three “seated”, then there would be one ECS row, two ETK rows, but four ETA rows.
Transaction export – columns
There are several columns of useful data in this export, which differ for each campaign type. We’ll detail some of them here:
ECS columns
- Campaign ID – the page name
- Campaign status – “success” if the payment went through
- Campaign Data 4 – the total paid, including any additional donations
- Campaign Data 20 – the additional donation if any
ETK columns
- Campaign ID – the ticket type name
- Campaign Data 2 – the page name
- Campaign Data 4 – the grand total paid for tickets of this type
- Campaign Data 6 – the number of tickets bought of this type
- Campaign Data 8 – discount code
- Campaign Data 10 – the ticket type ID number
ETA columns
- Campaign ID – the ticket type name for this attendee
- Campaign Data 2 – the page name
- Campaign Data 4 – the ticket type ID number
- Campaign Data 6 – the attendee’s first name
- Campaign Data 7 – the attendee’s last name
- Campaign Data 8 – the attendee’s email address