Competitor Distribution

Data about competitor distribution, like number of stores, sales agents, offices, etc.

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).
• Competitor (string): The name of the competitor the data relates to.
• 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	Competitor	Channel	Value
SWE	all	all	2018-01-08	Health	Competitor1	Agents	90
SWE	all	all	2018-01-08	Life	Competitor1	Agents	90
SWE	all	all	2018-01-08	Pc	Competitor1	Agents	90
SWE	all	all	2018-01-15	Health	Competitor1	Agents	90
SWE	all	all	2018-01-15	Life	Competitor1	Agents	90
SWE	all	all	2018-01-15	Pc	Competitor1	Agents	90
SWE	all	all	2018-01-22	Health	Competitor1	Agents	90
SWE	all	all	2018-01-22	Life	Competitor1	Agents	90
SWE	all	all	2018-01-22	Pc	Competitor1	Agents	90
Wide format:

Country	SWE	SWE	SWE
Region	all	all	all
Product	Health	Life	Pc
Channel	Agents	Agents	Agents
Grouping	all	all	all
Competitor	Competitor1	Competitor1	Competitor1
2018-01-08	90	90	90
2018-01-15	90	90	90
2018-01-22	90	90	90
2018-01-29	90	90	90
2018-02-05	90	90	90