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

8

CodModel

Integer

Links to CodLevel2 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831351909

9

CodSubmodel

Integer

Identifies combination of advertiser code and model code

10

CodHolding

Integer

Links to CodLevel1 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831351902

11

CodAdvertiser

Integer

Links to CodLevel2 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831614026

12

CodAgency

 

Not in use

13

CodOnlineBrands

Integer

Links to CodLevel1 in https://kantarmedia.atlassian.net/wiki/spaces/TVOVEXT/pages/2831089772

14

StartingDate

Date

yyyymmdd

15

_LoadOp_

Integer

Only for UPDATE: 1 = add, 2 = delete, 3 = modify