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 :


Column

Description

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