Skip to content

Sales

The most important file, and actually the only one required, is the Sales data file. It contains the number of units sold and the price the consumer paid for them. An example of such a file can be found in Table 1.

File format

The Sales Data file should contain the following column headers:

  • Country (string): A three-letter country code as specified in the ISO 3166 standard, indicating the country in which the sales occurred.
  • Region (string): The region within the country where the sales occurred. The format for the region may vary depending on the specific region being represented, but it should adhere to the ISO 3166 standard.
  • Grouping (string): An optional field for grouping the sales data based on additional criteria, such as sales channels or product categories.
  • Date (date): The first date of the period of the sales transaction, in the format of YYYY-MM-DD (ISO 8601).
  • Product (string): The name or identifier of the product that was sold.
  • UnitsSold (integer): The number of units of the product that were sold during the transaction period.
  • PricePerUnit (float): The price per unit of the product in the local currency, with the decimal separator represented using a ‘.’ (period).
  • ProfitPerUnit (float, Optional): The profit made on the unit sold. This column is optional.

The data can be uploaded in both wide and long format, depending on your needs.

Long format:

Country Region Grouping Date Product UnitsSold PricePerUnit ProfitPerUnit
SWE all all 2018-01-07 Health 292.00 362.9658 120.0
SWE all all 2018-01-07 Life 1489.00 1990.8113 550.0
SWE all all 2018-01-07 Pc 30212.33 546.3061 220.0
SWE all all 2018-01-14 Health 275.00 391.5818 120.0
SWE all all 2018-01-14 Life 1359.00 5241.0199 550.0
SWE all all 2018-01-14 Pc 27306.00 478.0982 220.0

Wide format:

Country SWE SWE SWE SWE SWE SWE
Region all all all all all all
Product Health Life Pc Health Life Pc
Grouping all all all all all all
Metric UnitsSold UnitsSold UnitsSold PricePerUnit PricePerUnit PricePerUnit
2018-01-08 292 1489 30212.33333 362.9657534 1990.811283 546.3061282
2018-01-15 275 1359 27306 391.5818182 5241.019868 478.0982202
2018-01-22 359 1431 25467 285.7465181 2303.684836 417.5839321
2018-01-29 411 1481 22027 306.7177616 4008.871708 345.5292141
2018-02-05 533 2382 50881 361.6679174 2419.802687 348.0693776