How to manually upload your sales data using the export and import feature?

You can add and adjust sales data using the import and export feature provided by the application. This feature is available on Lookout and Wave, allowing you to use it from either location. It was designed to simplify the task of uploading sales data for dozens or even hundreds of events at once.

To add or adjust your existing sales data, begin by applying the necessary filters to narrow down the specific events you want to adjust.

 

Then, click the ‘Export sales data’ button   to export the sales data for events based on filters you applied. The filtered event’s will be exported to an Excel file. Please use 'exported-data' Excel file to add number of tickets sold and revenue for each event. Save this file.

 

Use this button to import adjusted sales data in the application. Chose the Excel file with exported data and upload it.

 

After processing, your adjustments will be reflected in the Sales Trend graph, Ticket Category, and Sales Overview graph on Lookout.

 

In the Sales Overview graph, the adjustments will be displayed as a dotted line on the date the changes were made. By hovering over the 'i' icon next to the dotted line, you can view detailed information about which tickets or revenue were adjusted and by how much.

To understand how the distribution of sales data works when you upload sales date using the export and import feature, and how the data is distributed over time, please see an examples below.

User added 120 regular tickets sold from 14th January to 14th May, using the Import/Export tool. The tickets will be spread randomly over this period by the tool. On the 16th of May the user changes the tickets from 120 to 132. Those 12 tickets difference will be spread  randomly over the period from 14th May - 16th May.

 


 

As tickets are spread randomly over the period the evaluation is possible but not as exact as the upload via file through Lookout (how to get there: click on the event - three dots on the top right - update sales - upload via file). Through this file you can provide us with the daily number of tickets sold and the daily revenue which leads to more accurate results in the evaluation. You can find detailed information on how to do that here: How to upload sales data in bulk?