Customer Experience

Investments and efforts to improve customer experience. The focus is on investments, such the models can be used to estimate the ROI of the efforts. If you want to include CX metrics, such as NPS or VOC, the Brand file is more suitable.

The competitor media 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 media investment occurred.
• Region (string): The region within the country where the media investment 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 media investment data based on additional criteria, such as product categories or sales territories.
• Date (date): The date of the media investment, in the format of YYYY-MM-DD (ISO 8601).
• Product (string): The name or identifier of the product associated with the media investment.
• Channel (string): The type of activity for the investment, such as IT, Human, etc.
• Investment (float): The amount of investment made in the media in the local currency, with the decimal separator represented using a ‘.’ (period).

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

Long format:

Country	Region	Grouping	Date	Product	Channel	Investment
SWE	all	all	2018-01-08	Brand	IT	107204
SWE	all	all	2018-01-08	Pc	Human	0
SWE	all	all	2018-01-08	Brand	IT	0
SWE	all	all	2018-01-08	Pc	Human	0
SWE	all	all	2018-01-08	Brand	IT	2342
SWE	all	all	2018-01-08	Life	IT	253
SWE	all	all	2018-01-08	Pc	Human	6332

Wide format:

Country	SWE	SWE	SWE	SWE	SWE	SWE	SWE
Region	all	all	all	all	all	all	all
Product	Brand	Pc	Brand	Pc	Brand	Life	Pc
Channel	IT	IT	Human	Human	Non Human	Non Human	Non Human
Grouping	all	all	all	all	all	all	all
2018-01-08	107204	0	0	0	2342	253	6332
2018-01-15	0	0	0	0	2134	295	14874
2018-01-22	0	0	0	0	2097	327	11880
2018-01-29	0	0	0	0	2324	359	10565