Competitor Brand
Information about your competitors brand, like awareness, liking, penetration, consideration, etc.
The competitor band 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 where the brand metrics were collected.
- Region (string): The region within the country where the brand metrics were collected. 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 brand data based on additional criteria, such as product categories or sales territories.
- Date (date): The date when the brand metrics were collected, in the format of YYYY-MM-DD (ISO 8601).
- Competitor (string): The name of the competitor the data relates to.
- Brand (string): The name or identifier of the brand associated with the metric.
- Metric (string): The type of metric being reported, such as Unaided Awareness, Aided Awareness, Consideration, and so on.
- Value (float): The value associated with the metric reported, such as the percentage of respondents who are aware of the brand or who consider it favorably.
The data can be uploaded in both wide and long format, depending on your needs.
Long format:
| Country | Region | Grouping | Date | Competitor | Brand | Metric | Value |
|---|---|---|---|---|---|---|---|
| SWE | all | all | 2018-01-08 | Competitor1 | AwesomeInsurance | Unaided Awareness | 87.65397476360124 |
| SWE | all | all | 2018-01-08 | Competitor1 | CoolInsurance | Unaided Awareness | 35.860897908707926 |
| SWE | all | all | 2018-01-08 | Competitor1 | AwesomeInsurance | Aided Awareness | 95.80406667004866 |
| SWE | all | all | 2018-01-08 | Competitor1 | CoolInsurance | Aided Awareness | 46.7856756466731 |
| SWE | all | all | 2018-01-08 | Competitor1 | AwesomeInsurance | Consideration | 59.883367317492954 |
| SWE | all | all | 2018-01-08 | Competitor1 | BestInsurance | Consideration | 17.325031539537704 |
| SWE | all | all | 2018-01-08 | Competitor1 | CoolInsurance | Consideration | 27.449598901467187 |
Wide format:
| Country | SWE | SWE | SWE | SWE | SWE | SWE |
|---|---|---|---|---|---|---|
| Region | all | all | all | all | all | all |
| Brand | AwesomeInsurance | CoolInsurance | AwesomeInsurance | CoolInsurance | AwesomeInsurance | BestInsurance |
| Metric | Unaided Awareness | Unaided Awareness | Aided Awareness | Aided Awareness | Consideration | Consideration |
| Grouping | all | all | all | all | all | all |
| Competitor | Competitor1 | Competitor1 | Competitor1 | Competitor1 | Competitor1 | Competitor1 |
| 2018-01-08 | 87.6539747636012 | 35.8608979087079 | 95.8040666700487 | 46.7856756466731 | 59.883367317493 | 17.3250315395377 |
| 2018-01-15 | 92.6168025720957 | 56.7633898031061 | 2.65673292377081 | 96.7171028219704 | 88.5898314242487 | 84.2775120211196 |
| 2018-01-22 | 63.5991809805342 | 53.402872105366 | 96.9545473085919 | 54.7469630755428 | 44.2074333356145 | 56.7240464275083 |
| 2018-01-29 | 56.3267856324564 | 65.3824826953493 | 62.39091267603 | 60.9973615338258 | 21.4336959074193 | 57.3351223750182 |
| 2018-02-05 | 64.6931773096164 | 61.1832960347049 | 70.0994435959415 | 66.9064895385894 | 59.5134005595969 | 89.184757233672 |