28. Campaigns<yymmdd>.[TABLE | UPDATE].csv

Variable

Data type

Comment

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 https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831056991

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