| Column | Column|Required | Values | Checks | | ----------------|:-: | :------: | -------------------------------------------------------------------- | ---------------------------------------------------- | | Additional Pixels|A| No | Event tag names
`IAS_BLOCKING`
`IAS_MONITORING`
| - Event tags should already be present in DCM
| |Site Name|B|Yes|Site name| - Site name should match exactly in DCM| |DCM Placement ID|C|Yes|Placement ID| - DCM placement ID must exist in the specified Campaign on DCM| |Placement Name|D|Yes|Placement name| - The Placement ID and Placement Name combination must be unique in Traffic Doc
- Dimension must be present in Placement names for Display
- Placement name should match in DCM| |Dimensions|E|Yes|Any image dimensions
`0x0` for video and audio
`1x1` for trackers| - For Display Ads, the dimension should match in Placement name and in Creative name| |Video length|F|No|Length of the video in seconds|| |Vast or Vpaid|G|No||| |AD Name|H|Yes|Ad name| - Values like `native ttd` or `n/a` are not accepted
- When the action is `update`, Ad name must match on DCM under the specified Campaign
- When the action is `pause` or `update`, the Ad should not be part of other Placements not mentioned in the sheet
- An Ad can have only one action in Traffic Doc, even if the same Ad is being used in multiple placements.| |Multi Ad Mapping|I|No|Multi Ad Alias| - Both Ad name and Multi Ad Mapping columns cannot be blank.
- Multi Ad Mapping column contains the Alias.
- Alias can be anything there is no restrictions.
- If Ad name is present in the Multi Ad sheet and no Alias in the Multi Ad Mapping column in the Trafficking sheet it will not be considered| |Trafficking Notes|J|No|| |Action|K|Yes|`New`
`Pause`
`Update`
`Active, NA`
`Inactive, NA`
|| |Creative File Name|L|Yes|Can only contain `A-Za-z0-9.=-\_`| - Creative file names should not have file extensions. In case of HTML assets, `_html.zip` should not be part of the Creative file name
- For Display Creatives, dimensions must be present in the Creative File Name
- The actual dimension of the image file must match the dimensions mentioned in the sheet
- File size for Display Creatives (image and HTML) must be less than `10MB`
- Video Creatives must be one of: `mp4,avi,mov,mp4,m4v,mpeg,mpg,webm,wmv`
- Audio Creatives must be in one of : `mp3,oga,ogg,ogv`
- Video and Audio creatives can have multiple assets to be uploaded and the assets should be seperated by `\|`(pipe)
- In case video/audio creatives have multiple assets, the first asset name will also be considered to be the creative name.
- HTML Creative must have a main asset and a backup asset.
- Creative must be present for all Ads, except `Tracker Ads` and `Studio Creatives`
- All Creatives under one Placement should have the same asset types
- In case where one Ad has multiple Creatives, action cannot be `Pause` for all the Creatives in Multi-Ad or Multi Creative sheet

| |Studio Creative? (Y/N)|M|No|`Y` or `N`|When Studio Creative is `y/yes`, the mentioned Creative name must exist in DCM| |Rotation %|N|Yes|`even`
`click-through rate`
`clicks`
`click-through conversions`
`view-through conversions`
`click-through conversions / view-through conversions`
`video completions`
`see multi tab`
numbers
percentages|Currently, the custom rotation optimizations feature is turned off. This can be enabled if needed. Once enabled, custom rotation names will also be accepted provided they are already created in DCM| |Start Date|O|Yes|Date|Date should match exactly with the Placement start date/Placement Group start date and Ad start date| |End Date|P|Yes|Date|Date should match exactly with the Placement end date/Placement Group end date and Ad end date| |Click through URL|Q|Yes|URL|URL should be a valid URL with valid UTM parameters. Unfortunately, there's no way we can validate a UTM parameter to be valid.|

Guide