Bookwhen reports include valuable data, and understanding each column helps you make the most of your exports. This article covers the most common fields in Customer, Booking, and Attendance CSV downloads.
This article explains the meaning of each CSV column so you can interpret and use your exported data effectively.
Customer report
Exports from the Customer list focus on customer details and can include lifetime totals for bookings and attendance.
Key fields
Total bookings: The number of bookings with a Completed status. This includes transferred bookings (since the status doesn’t change when tickets are transferred), but excludes cancelled ones.
Total attendance: The number of times the customer has attended an event. Cancelled or transferred attendances aren’t included.
For example, if someone else books and assigns this person as the attendee, they’ll count as having attended but won’t have a booking.
Total confirmed attendance: The number of times the customer was marked as ‘Yes’ on the attendee register.
💡 Tip
If you filter your Customer list (for example, by ‘Attendance between’ dates), the CSV will only include customers who match the filter. However, the totals in the export (such as bookings or attendance) reflect their full history, not just the filtered timeframe.
Booking report
The booking report from the Bookings tab focuses on individual bookings. It includes customer details, event dates, statuses, and any custom field responses.
Key fields
Event starts / Event ends: Use these columns to confirm which events fall within your reporting period.
Attendance status: Complete means the ticket was booked and hasn’t been transferred.
Attended?: Shows whether the attendee was marked ‘Yes’ on the register.
Attendee CustomerID: A unique ID for each customer. Use this with filters or pivot tables to calculate the number of unique customers.
Details: This shows the optional offline payment note left at checkout.
For example, an admin might add a note here when manually recording a payment.
💡 Ticket transfers note
When a ticket is transferred, the original booking stays the same, only the ticket is updated. The new ticket is added to the booking, but the booking record itself doesn't change.
Attendance report
The attendance report from the Bookings tab provides the most detailed information. It includes ticket prices, statuses, and any custom details entered at booking.
⚠️ Important: If your export includes Checkout or Cancelled statuses (depending on your filters), these may affect totals or calculations in the Status columns.
Key fields
Event Code: A unique ID used in the entry URL and public page filters.
EventID: A unique reference for a booked event. This appears only after the event is booked.
Ticket face value: The original ticket price set in the schedule.
Ticket discount: Any discount applied at checkout.
Ticket current value: The final ticket price after discount. For group tickets, the full price shows on each row.
For example, £10 for 2 people appears as £10 on both rows.
Current attendance value: For group tickets, this divides the total price among attendees.
For example, £5 each.
Status columns
These may differ for the same ticket based on its history:
Ticket status: Shows whether the ticket is complete, cancelled, or transferred.
Attendance status: Shows whether the original attendance was kept.
For example, transferring a ticket cancels the original attendance.
Booking status: Shows if the overall booking remains complete.
For example, the booking may still be complete if one ticket was cancelled or transferred.
💡 Important note: If a customer updates their personal details (such as their address), their customer profile will always show the latest information. However, the Attendance CSV reflects the data as it was at the time of booking.
💬 Need extra help?
For the quickest response, contact us via live chat on our homepage or your account. Buddy, our trusty chatbot, will assist first and pass you to a support team member if needed.
Prefer email? Send us an email instead.
Thank you! 🕺