Bookwhen reports include a lot of valuable data, but understanding what each column means helps you get the most out of your exports. This article explains the most common fields found in the CSV downloads for Customer, Booking, and Attendance reports.
This article covers:
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.
💬 Any questions or feedback? There are two ways to get in touch:
For a quicker response, please contact us via live chat on our homepage or your account.
Or send us an email.
Thank you! 🕺