28. Campaigns<yymmdd>.[TABLE | UPDATE].csv
Variable | Data type | Comment | |
---|---|---|---|
1 | CodCampaign | Integer | Links to CampaignCode in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2752283116 |
2 | Description | String |
|
3 | AlternativeDescription | String |
|
4 | CodSector | Integer | Links to CodLevel1 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831581264 |
5 | CodGroup | Integer | Links to CodLevel2 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831351895 |
6 | CodProduct | Integer | Links to CodLevel3 in |
7 | CodBrand | Integer | Links to CodLevel1 in |
8 | CodModel | Integer | Links to CodLevel2 in |
9 | CodSubmodel | Integer | Identifies combination of advertiser code and model code |
10 | CodHolding | Integer | Links to CodLevel1 in |
11 | CodAdvertiser | Integer | Links to CodLevel2 in |
12 | CodAgency |
| Not in use |
13 | CodOnlineBrands | Integer | Links to CodLevel1 in |
14 | StartingDate | Date | yyyymmdd |
15 | _LoadOp_ | Integer | Only for UPDATE: 1 = add, 2 = delete, 3 = modify |