Media
Media investments and media groupings for all media-related impressions and campaigns.
All the advertising you do for your business is most likely aiding your sales. In this dataset, Alviss AI needs to know how much you have invested into which media vehicle. In this case, a vehicle can be a media group, a publisher, or basically whatever taxonomy makes sense for your business.
If some of your ads target all products and services and not a specific one, you can again write all in the Product columns for that entry.
The 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.
- Media (string): The type of media for the investment, such as Display, Facebook, Google, and so on.
- Campaign (string): The name of the campaign it corresponds to, if no specific campaign use a generic catch all key, ex.
all. - Metric (string, enum): The type of measurement the entry is, needs to be one of
Impression,Investment,GRP,Reach,Clicks,Leads,Gross. - Value (float): The value of the measurement made in the media in the local currency, with the decimal separator represented using a ‘.’ (period).
Note
An Investment must always be provided in the Metric column for all country, region, grouping, date, product, media, campaign combinations.
Note
For a given country, region, grouping, product, media, campaign a measurement Investment is required and one optional Impression, GRP, Reach, Clicks, Leads, Gross can be given. This metric must be the same for all dates.
The data can be uploaded in both wide and long format, depending on your needs.
Long format:¶
| Country | Region | Grouping | Date | Product | Media | Campaign | Metric | Value |
|---|---|---|---|---|---|---|---|---|
| SWE | all | all | 2018-01-07 | Brand | Display | Campaign A | Impression | 107204 |
| SWE | all | all | 2018-01-07 | Brand | Display | Campaign A | Investment | 7204 |
| SWE | all | all | 2018-01-07 | Brand | Campaign B | Clicks | 2342 | |
| SWE | all | all | 2018-01-07 | Brand | Campaign B | Investment | 187 | |
| SWE | all | all | 2018-01-07 | Life | TV | Campaign B | Investment | 11710 |
Wide format¶
| Country | SWE | SWE | SWE | SWE | SWE |
|---|---|---|---|---|---|
| Region | all | all | all | all | all |
| Product | Brand | Brand | Brand | Brand | Life |
| Media | Display | Display | TV | ||
| Grouping | all | all | all | all | all |
| Campaign | Campaign A | Campaign A | Campaign B | Campaign B | Campaign A |
| Metric | Impression | Investment | Clicks | Investment | Investment |
| 2018-01-08 | 107204 | 7204 | 2342 | 187 | 11710 |
| 2018-01-15 | 0 | 0 | 2134 | 170 | 10670 |
| 2018-01-22 | 0 | 0 | 2097 | 167 | 10485 |
| 2018-01-29 | 0 | 0 | 2324 | 185 | 11620 |
| 2018-02-05 | 0 | 0 | 2758 | 220 | 13790 |
| 2018-02-12 | 0 | 0 | 2751 | 220 | 13755 |
| 2018-02-19 | 0 | 0 | 2495 | 199 | 12475 |