In this article will we show you how to better understand your Dashboard data once it has been exported to a CSV file.
If you want to know how to use your Dashboard, you can consult the dedicated article here.
To export the CSV file, click on the Export button above your dashboard and a popup will appear once the download is complete.
The CSV file content will be filtered according to the following settings :
Training Mode Toggle
Period Picker
Time Slot Picker
Stores Picker
Timeframe picker
Once downloaded, you will be able to see the information showcased as below.
Here is a description of each row of CSV file :
Each row represents the sales of the store by date, depending on the selecting information in the timeframe picker you will see:
If you are only consulting an hour from a specific day, the date column will be the start of that hour
If you selected one day, the date is the start of that day
If you are looking at an entire week, the date will be the start of the week
If you are consulting a month, the date is the start of the month
Columns description :
In this table you will find the different columns included in the CSV file as well as a description of the data they include :
Date | Start date of the period of the timeframe as selected on a Timeframe picker |
Store | Store of the sales |
Store ID | Store ID of the sales |
Number of Clients | Sum of the nb of clients of the orders in the scope of the export |
Average Sales incl Tax | Sales incl Tax / Number of Clients. If Number of Clients = 0 then Average Sales incl Tax = Sales incl Tax |
Average Sales excl Tax | Sales excl Tax / Number of Clients. If Number of Clients = 0 then Average Sales excl Tax = Sales excl Tax |
Sales incl Tax | Total sales with the tax amount |
Sales excl Tax | Total sales without the tax amount |