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 33. Products<yymmdd>.[TABLE | UPDATE].csv |
| 7 | CodBrand | Integer | Links to CodLevel1 in 27. Brands<yymmdd>.[TABLE | UPDATE].csv |
| 8 | CodModel | Integer | Links to CodLevel2 in 31. Models<yymmdd>.[TABLE | UPDATE].csv |
| 9 | CodSubmodel | Integer | Identifies combination of advertiser code and model code |
| 10 | CodHolding | Integer | Links to CodLevel1 in 30. Holding<yymmdd>.[TABLE | UPDATE].csv |
| 11 | CodAdvertiser | Integer | Links to CodLevel2 in 25. Advertisers<yymmdd>.[TABLE | UPDATE].csv |
| 12 | CodAgency | Not in use | |
| 13 | CodOnlineBrands | Integer | Links to CodLevel1 in 32. OnlineBrand<yymmdd>.TABLE.csv |
| 14 | StartingDate | Date | yyyymmdd |
| 15 | _LoadOp_ | Integer | Only for UPDATE: 1 = add, 2 = delete, 3 = modify |
Page Comparison
Manage space
Manage content
Integrations