Positions | Variable | Comment | Length |
---|---|---|---|
1-10 | Campaign code | 10 | |
11-70 | Description | 60 | |
71-130 | Alternative description | 60 | |
131-140 | Sector code | Links to sectores table 34. Sectores<yymmdd>.[ new | rec | tab ] | 10 |
141-150 | Group code | Links to grupos tableto 29. Grupos<yymmdd>.[ new | rec | tab ] | 10 |
151-160 | Product code | Links to productos tableto 33. Productos<yymmdd>.[ new | rec | tab ] | 10 |
161-170 | Brand code | Links to brands tableto 27. Brands<yymmdd>.[ new | rec | tab ] | 10 |
171-180 | Model code | Links to models tableto 31. Models<yymmdd>.[ new | rec | tab ] | 10 |
181-190 | Not in use | 10 | |
191-200 | Holding code | Links to matriz table30. Matriz<yymmdd>.[ new | rec | tab ] | 10 |
201-210 | Advertiser code | Links to advertisers table25. Advertisers<yymmdd>.[ new | rec | tab ] | 10 |
211-220 | Not in use | 10 | |
221-230 | OnlineBrand code | Links to online brand table32. OnlineBrand<yymmdd>.[ new | rec | tab ] | 10 |
231-240 | Start date | Number of days since 1900.01.01 | 10 |
241-241 | Action | Only for .REC-files: 1 = add, 2 = delete, 3 = modify | 1 |
Note: Until 2019.03.08 the name of this file was Campanyas<yymmdd>.[ new | rec | tab ]