Events
This captures all kinds of events which extends over a given period of time. Could be events like Force Majeure or other extraordinary events.
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.
- StartDate (date): The date when the event started, in the format of YYYY-MM-DD (ISO 8601).
- EndDate (date): The date when the event ended, in the format of YYYY-MM-DD (ISO 8601).
- Event (string): The name or identifier of the event, the same event can be used on multiple rows.
The data can be uploaded in both wide and long format, depending on your needs.
Long format:
| Country | Region | Grouping | StartDate | EndDate | Event |
|---|---|---|---|---|---|
| SWE | all | all | 2018-01-08 | 2018-01-10 | Website down |
| UKR | all | all | 2019-10-21 | 2019-10-24 | Strike |
| Wide format: |
| Country | SWE | UKR | SWE | UKR |
|---|---|---|---|---|
| Region | all | all | all | all |
| Event | Website down | Strike | Website down | Strike |
| Grouping | all | all | all | all |
| Metric | StartDate | StartDate | EndDate | EndDate |
| 2018-01-08 | 2019-10-21 | 2018-01-10 | 2019-10-24 |