Visits
Provide Visits data in Alviss AI for traffic metrics like website store visits to model consumer engagement funnel efficiency impacts on conversions sales KPIs.
Visits data tracks traffic metrics, such as website visits, store footfall, or other forms of consumer engagement that indicate interest or exposure to your business. This includes sessions from various channels like direct access, paid search, or email campaigns, helping to understand how traffic correlates with conversions and sales.
Monitoring visits is key to analyzing consumer behavior and funnel efficiency. Alviss AI uses this data to model how traffic scales with outcomes like revenue, quantifying the impact of marketing channels on demand. For example, it can reveal how organic search visits drive in-store purchases, supporting optimizations for acquisition strategies. Sourced from analytics tools (e.g., Google Analytics for web, sensors/counters for physical stores), this data enhances attributions, simulations, predictions, and response curves by linking upstream engagement to downstream results.
Data Requirements
The Visits 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 visit 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).
- Channel (string, required): The traffic source or channel (e.g., "BrandedPaidSearch", "Direct", "Display", "Email", "GenericPaidSearch", "OrganicSearch").
- Visits (float, required): The number of visits (e.g., 11339). Can be fractional for weighted or averaged data; handle missing values with blanks or zeros—Alviss AI will flag inconsistencies during upload.
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 channel per date, etc.).
| Country | Region | Grouping | Date | Channel | Visits |
|---|---|---|---|---|---|
| SWE | all | all | 2018-01-07 | BrandedPaidSearch | 11339 |
| SWE | all | all | 2018-01-07 | Direct | 104596 |
| SWE | all | all | 2018-01-07 | Display | 1108 |
| SWE | all | all | 2018-01-07 | 10130 | |
| SWE | all | all | 2018-01-07 | GenericPaidSearch | 7518 |
| SWE | all | all | 2018-01-07 | OrganicSearch | 88386 |
- Wide Format (Useful for spreadsheets): Columns represent different channels, with rows as dates. The first few rows define fixed attributes (e.g., Country, Region).
| Country | SWE | SWE | SWE | SWE | SWE |
|---|---|---|---|---|---|
| Region | all | all | all | all | all |
| Channel | BrandedPaidSearch | Direct | Display | GenericPaidSearch | |
| Grouping | all | all | all | all | all |
| 2018-01-08 | 11339 | 104596 | 1108 | 10130 | 7518 |
| 2018-01-15 | 12064 | 101443 | 651 | 8426 | 9849 |
| 2018-01-22 | 14984 | 148089 | 703 | 8705 | 13072 |
| 2018-01-29 | 14540 | 146961 | 648 | 9620 | 11480 |
| 2018-02-05 | 14967 | 157759 | 719 | 7912 | 10887 |
| 2018-02-12 | 15789 | 158599 | 839 | 6949 | 12334 |
Best Practices
- Consistency: Ensure dates align with your project's periodicity (e.g., daily visits if the project is set to daily 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.
- Channel Tracking: Use clear, consistent channel names to enable segmentation. Align with media or sales channels for cross-analysis.
For uploading instructions, see Upload Data. If you encounter issues, contact support or refer to the API for programmatic uploads.
Sales
Provide Sales data in Alviss AI as core dataset for outcomes like revenue volume with units sold price per unit optional profit.
Weather
Provide Weather data in Alviss AI for meteorological indicators like precipitation wind temperature snow humidity sunshine to model environmental impacts on demand KPIs.