The Customer List shows you key statistics on your attendees and all their latest responses from your booking forms. All of this information can be searched, filtered, and ordered to give you customised lists and reports.
Filtering your results
You can filter by:
Attendance date - Search for customers based on when they attended an event.
Booking date - Search for customers based on when they booked an event.
Email status - Gives you options to search by whether an email exists for a customer and whether it's valid.
Child status - Useful for filtering between adult and child attendees. If you have child attendees, make sure your entry is set up for that properly here.
Any field included in your booking forms - This could include fields such as consent to marketing, age, dietary requirements, or anything else you might have asked in your booking forms.
You can add multiple filters to your search. Just select the drop-down menu under Filter by and then select the green Add button.
In this example; Attendance date, Email status, Booked between, and Child status are being used.
Once you've run a search, you can order your results using the following options:
First seen - When the customer was first seen on your account
Total bookings - Total lifetime bookings
Total attendances - Total lifetime attendances
Amount spent - Total lifetime spend on bookings
To order the search, just select the drop-down menu under Ordering and select your choice. Then select Search to reorder your results. You can also order in reverse by ticking the Reverse box.
The results (as shown below) are split into three columns:
Customer name and email (if given). The blue hyperlinked email links through to the customer's profile page
Attendee information. If you haven't asked for information in a booking form or attendee details were skipped during an admin booking, this column will be blank.
Once you've completed a search, you can export the corresponding information in a .csv file or extract the email addresses. To do this, select Options, then Export customers (CSV).
Your .csv export will include all associated stats featured on the customer list, class pass information, and all booking form responses.
Yes/no questions (such as consent to marketing or T&C's) will be represented either as blank (no response), 1 (Yes), or 0 (No).
These .csv exports can easily be imported to Excel, Google Docs, or any other spreadsheet app. Click here to learn how to import your .csv list to Mailchimp.
Useful reports to run
Search for invalid emails to fix and update
Export a list of emails for e-marketing, filtering on whether they consented to marketing. If you haven't already, learn how to add these fields to your booking forms here
Find your most valuable customers
Find your most attended customers
Search for results on any of your booking form questions