Distribution
Contains information about distribution, like number of stores, sales agents, offices, etc.
In order for Alvíss AI to know about how you sell and distribute your
products or services it needs to have a metric for your distribution.
This could for example be the number of physical stores you have or the
number of sales partners etc. An example of such a file can be found in
Table 2.
The Distribution 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 distribution 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.
- Channel (string): The sales channel name used when selling the product.
- Value (integer): The number of distribution units present during the transaction period.
The data can be uploaded in both wide and long format, depending on your needs.
Long format:
Country | Region | Grouping | Date | Product | Channel | Value |
---|---|---|---|---|---|---|
SWE | all | all | 2018-01-07 | Health | Agents | 90 |
SWE | all | all | 2018-01-07 | Life | Agents | 90 |
SWE | all | all | 2018-01-07 | Pc | Agents | 90 |
SWE | all | all | 2018-01-14 | Health | Agents | 90 |
SWE | all | all | 2018-01-14 | Life | Agents | 90 |
SWE | all | all | 2018-01-14 | Pc | Agents | 90 |
Wide format: |
Country | SWE | SWE | SWE |
---|---|---|---|
Region | all | all | all |
Product | Health | Life | Pc |
Channel | Agents | Agents | Agents |
Grouping | all | all | all |
2018-01-08 | 90 | 90 | 90 |
2018-01-15 | 90 | 90 | 90 |
2018-01-22 | 90 | 90 | 90 |
2018-01-29 | 90 | 90 | 90 |