For downloads with less than 750 transactions, the .CSV file will now be downloaded straight to your desktop.
For downloads with more than 750 transactions, the file will be compiled and sent to the email address that you are logged in on as before.
Format: Each item on the new download has its own row, meaning that a transaction with varying e-tickets and products will be separated into multiple rows, whilst still being grouped together on the spreadsheet. This makes it much easier to distinguish different tickets and products in a transaction. The ‘Item Type’ column will allow you to filter tickets from products for reporting purposes. Using the DMN purchase reference number, you are able to confirm which tickets and products are from the same transaction.
Data collection answers have also been removed from the file – these are located within the Attendees List section, as well as on the copy of the purchase confirmation email you can choose to receive when a customer makes a purchase. See our guide on Data Collection here for more information.
Example of how a transaction with varying item types will be grouped together on the spreadsheet:
How to filter between Tickets and Products:
1. Within Excel, select Data located along the tool at the top
2. Locate the Item Type column
3. Click the Dropdown arrow and tick the desired items to filter accordingly within the pop-up
4. Click OK to apply
For more information on downloading Customer Data, see our user guide here.