Brand
Provide Brand data in Alviss AI for metrics on perception like awareness, liking, and NPS, to quantify impact on sales and KPIs.
Brand data captures metrics about your brand's perception and performance in the market, such as awareness, liking, penetration, consideration, and recommendation. This category also includes customer experience-related tracking (e.g., satisfaction scores or Net Promoter Score).
These metrics are often sourced from third-party providers like YouGov. Alviss AI uses this data to estimate your brand's contribution to overall sales and other KPIs. By incorporating brand tracking, you can quantify how brand strength influences business outcomes.
Data Requirements
The Brand Data file must include the following columns (headers). All columns are required unless marked as optional:
- Country (string, required): A three-letter country code per ISO 3166 standard (e.g., "SWE" for Sweden), indicating where the metrics were collected.
- Region (string, required): The region within the country (e.g., "all" for nationwide or a specific ISO 3166-2 code like "SE-AB" for Stockholm County in Sweden).
- Grouping (string, optional): For additional segmentation, such as product categories, demographics, or sales territories (e.g., "all" if not applicable).
- Date (date, required): The collection date in ISO 8601 format (YYYY-MM-DD).
- Brand (string, required): The brand name or identifier (e.g., "AwesomeInsurance").
- Metric (string, required): The metric type (e.g., "Unaided Awareness", "Aided Awareness", "Consideration", "Likeability", "Penetration", "Recommendation").
- Value (float, required): The metric value (e.g., a percentage like 64.74).
Only the following characters are allowed when enter text values: 0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZåäöüøæÆÄÅÖÜߨ()_+-
Supported Formats
Data can be uploaded in long (tidy) or wide (pivoted) format. Choose based on your data pipeline:
-
Long Format (Recommended for flexibility): Each row represents a single observation (one metric per brand, date, etc.).
Country Region Grouping Date Brand Metric Value SWE all all 2018-01-07 AwesomeInsurance Unaided Awareness 64.74 SWE all all 2018-01-07 CoolInsurance Unaided Awareness 62.17 SWE all all 2018-01-07 AwesomeInsurance Aided Awareness 70.44 SWE all all 2018-01-07 CoolInsurance Aided Awareness 79.77 SWE all all 2018-01-07 AwesomeInsurance Consideration 26.16 SWE all all 2018-01-07 BestInsurance Consideration 30.74 -
Wide Format (Useful for spreadsheets): Columns represent combinations of Brand and Metric, with rows as dates. The first few rows define fixed metadata (e.g., Country, Region, Brand, ..), .
| Country | SWE | SWE | SWE | SWE | SWE | SWE |
|---|---|---|---|---|---|---|
| Region | all | all | all | all | all | all |
| Brand | AwesomeInsurance | CoolInsurance | AwesomeInsurance | CoolInsurance | AwesomeInsurance | CoolInsurance |
| Metric | Unaided Awareness | Unaided Awareness | Aided Awareness | Aided Awareness | Consideration | Consideration |
| Grouping | all | all | all | all | all | all |
| 2018-01-08 | 64.74 | 62.17 | 70.44 | 79.77 | 26.16 | 32.77 |
| 2018-01-15 | 55.33 | 60.97 | 82.22 | 92.25 | 30.77 | 32.08 |
| 2018-01-22 | 62.93 | 55.16 | 89.15 | 77.46 | 26.79 | 27.84 |
| 2018-01-29 | 64.32 | 52.21 | 79.02 | 70.13 | 30.59 | 27.09 |
| 2018-02-05 | 63.7 | 54.71 | 81.49 | 78.1 | 30.3 | 33.25 |
| 2018-02-12 | 52.86 | 61.27 | 71.73 | 73.5 | 30.52 | 30.97 |
| 2018-02-19 | 64.08 | 65.53 | 83.72 | 74.47 | 27.71 | 26.84 |
Best Practices
- Consistency: Ensure dates align with your project's periodicity (e.g., weekly data if the project is set to weekly granularity). Mismatched granularity will cause upload errors.
- Data Quality: Check for outliers, missing values, or inconsistencies before upload. Use the Activities dashboard to visualize and validate post-upload.
- Granularity Alignment: All data in a project must match the chosen periodicity (set during project creation). For details, see Projects.
- Multiple Brands: If tracking competitors, include them with clear identifiers to enable comparative analysis.