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 |