Skip to main content

CSV export fields explained

Learn what each column means across your customer, booking and attendance reports

Anni avatar
Written by Anni
Updated this week

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 CustomerBooking, 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:

Thank you! 🕺

Did this answer your question?