✨ Please note: Discounts are available on the Lite plan or above.
The attendance report helps you track discount code usage and assess its impact, including which codes are popular, their value, and who is using them. Understanding how your discount codes are used is key to managing your bookings effectively and attracting customers, helping you make informed decisions for your business.
This article covers:
Generating the report
To generate the attendance report, open the Bookings tab on your account, then:
Filter your search to suit your reporting needs. For example, use the Start date and End date fields to select the date range you'd like to report on, or use the Entries field to select the specific entries.
Select Search to generate the results, then Export attendances (CSV) from the Options drop-down menu:
This will download the spreadsheet, allowing you to open it in your preferred spreadsheet software (such as Excel, Google Sheets, etc.)
You can then begin to organise your data, removing any unnecessary rows and columns and ensuring you keep the Discount code column.
Extracting data from the report
As an admin, you may have specific needs when it comes to discount code reporting:
Frequency of usage
Questions:
How many times is each discount code used?
How to check:
Find the Discount code column.
Use the Filter tool to organise the codes. For example, in Google Sheets, you can right-click the header and select Create a filter:
You can then select/deselect the necessary codes:
Once selected, you can then review how many codes were used:
Alternatively, you can sort alphabetically or by a condition you set. Learn more about filtering your spreadsheet on Google Sheets and Excel.
Value of each code
Questions:
What is the monetary value for each discount code?
Are we offering too much in discounts?
How to check:
Locate the Ticket face value, Ticket discount, and Ticket current value columns:
Compare the ticket discount amounts to the ticket face value to review if you're offering too much.
Customer usage
Questions:
Which customers are using these codes?
Is one individual consistently using them?
How to check:
Find the Booker email and Attendee customer name columns:
Review the columns to find which customers are using discount codes.
Use the Filter tool or the Find feature (Ctrl+F) to search for specific customers. Filtering alphabetically will also help you find repeat customers.
Should there be a cap on usage?
If one person is using the codes frequently, consider whether you need to set a usage limit. For example, in your discount settings, you can check the Restrict to single use per booker email address setting:
Or add a limitation on how many times the code can be used overall under How many times can the code be used?:
💬 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! 🕺