Media

Media data captures investments in advertising and campaigns, including groupings by product, media type, campaign, and metrics like impressions or clicks. This encompasses all promotional activities, such as digital ads, TV spots, or social media campaigns, broken down by taxonomy relevant to your business (e.g., media groups, publishers, or channels).

All advertising contributes to sales and KPIs, so providing detailed investment data allows Alviss AI to model media effectiveness accurately. For campaigns targeting all products/services, use "all" in the Product field. Sourced from ad platforms (e.g., Google Ads, Facebook), agency reports, or internal trackers, this data enables quantification of ROI, channel performance, and campaign impacts in attributions, simulations, predictions, and optimizations. For example, it can reveal how display ad investments drive conversions, supporting budget allocation decisions.

Data Requirements

The Media 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 media investment occurred.
• 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 date of the media activity in ISO 8601 format (YYYY-MM-DD).
• Product (string, required): The name or identifier of the product/service targeted (e.g., "Brand", "Life"); use "all" for broad campaigns.
• Media (string, required): The media type or channel (e.g., "Display", "Facebook", "Google", "TV").
• Campaign (string, required): The campaign name (e.g., "Campaign A"); use a generic like "all" if not campaign-specific.
• Metric (string, required, enum): The measurement type; must be one of: "Impression", "Investment", "GRP", "Reach", "Clicks", "Leads", "Gross".
• Value (float, required): The metric value (e.g., investment in local currency like 7204, or impressions like 107204). Use a period (.) as the decimal separator.

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 combination).

• Wide Format (Useful for spreadsheets): Columns represent combinations of Metric, with rows as dates. The first few rows define fixed attributes (e.g., Country, Region, Product).

Best Practices

• Consistency: Ensure dates align with your project's periodicity (e.g., daily data 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. Always include "Investment" for every combination to enable ROI calculations. 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.
• Taxonomy and Grouping: Define Media, Campaign, and Product consistently to reflect your business structure. This aids in filtering and aggregation during analysis.

For uploading instructions, see Upload Data. If you encounter issues, contact support or refer to the API for programmatic uploads.