28. Campaigns<yymmdd>.[TABLE | UPDATE].csv
Variable | Data type | Comment | |
---|---|---|---|
1 | CodCampaign | Integer | Links to CampaignCode in 6. SPT<yymmdd>.[DAILY | UPDATE].CSV |
2 | Description | String |
|
3 | AlternativeDescription | String |
|
4 | CodSector | Integer | Links to CodLevel1 in 34. Sectors<yymmdd>.[TABLE | UPDATE].csv |
5 | CodGroup | Integer | Links to CodLevel2 in 29. Groups<yymmdd>.[TABLE | UPDATE].csv |
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 |