Report Delivery Requirements
Report Requirements
Please review each section closely:
If you are unable to meet these requirements, Rockerbox will not be able to support your files.
File Format Requirements
To send files to Rockerbox, we require the following:
-
Send in .csv, .tsv, or .xlsx format.
-
The file extension must be lowercase in the file name.
-
Standardize the file name.
- All files need a unique indicator in the report name such as a date or ID.
- Do not include spaces in the file name.
- Do not include special characters in the file name.
- If you include a date in the filename, send it in ISO 8601 format.
- If your file failed on initial delivery and you are sending a replacement file, add _v2 to the replacement file name.
Acceptable File Name Example
- YYYY-MM-DD_yourbrandname_tv_postlog.csv
File Contents Requirements
-
Do not password protect your files.
-
The data format — in particular, column names cannot change over time.
-
Remove all newlines in the header. The first row of the file must be the column names.
-
Only use alphanumeric characters in column header names.
-
Do not use the same column header name more than once.
-
Do not include a summary or "totals" row in the file.
-
Remove all blank rows at the bottom of the dataset. This is a common issue in Excel if you clear data in rows without deleting the rows themselves.
-
A Date field is included for all line items, and the Date format is standardized. Dates should be in ISO-8601 format (YYYY-MM-DD) in UTC if possible.
-
Do not include more than 1 tab in the file.
-
Any line items with no spend should be indicated as $0. Do not include special characters such as $-, N/A, etc.
-
Do not include any values in scientific notation. To resolve this, follow the steps here.
Spend Currency
Rockerbox defaults all spend ingestion to USD. If you send a different currency, then you need to either:
- add a Currency column to the report, indicating the ISO 4217 currency code
- work with your Rockerbox contact to update the report setting to a fixed currency, in which case the report currency cannot change moving forward
Timezones
If you are passing timezones dynamically, then it needs to meet one of two requirements:
- Include it as part of the timestamp according to ISO 8601 standards
- Include the timezone as a separate column according to IANA standards
File Delivery Requirements
See here for delivery methods that Rockerbox supports.
-
For email endpoints, files must be sent as an email attachment rather than a link.
-
For email endpoints, files must be sent as a new email with the endpoint being the only recipient.
-
Do not send the same day of spend more than once. For example, if you are sending a daily file, only include the previous day of data. Do not send a historical file every day.
Historical Data Correction
Rockerbox cannot currently process corrections to historical data. If you or your partners send us data that needs to be corrected, contact your Rockerbox account manager. We cannot guarantee that we can correct the information.
.zip and .gz files
You can also send .zip or .gz files; however, if you do so, then the file must meet the following requirements:
- 1 file per .zip file
- the zip filename is "filename.csv.zip" (or "filename.tsv.zip", "filename.xlsx.zip")
- the decompressed filename is "filename.csv"
- the file and the .zip file must have the same name
- the extension must be sent in all lower-case
Similar requirements if the compressed file were instead a .gz file, except replace .zip with .gz.
TV postlog report syntax
A sample tv postlog report can be found here.
| Field Name | Field Description |
|---|---|
| timestamp | YYYY-MM-DD HH24:mm:ss Indicate timezone as a separate column or must be static timezone for all files. If it's a static timezone, then you must communicate to Rockerbox the timezone so that we can set it up. |
| network | Example: PBS, NBC |
| inventory | TV program an ad aired on. Examples: Seinfeld, M.A.S.H. |
| media_outlet_type | Example: Cable - National, Satellite |
| feed_type | Live, Dual |
| isci | Uniquely identifies the commercial |
| ad_name | Name corresponding to the ISCI |
| tape_length | Duration of the ad, most commonly 15 or 30 |
| dma_id | The Nielsen DMA code. Required if the spot airs in a specific region. |
| prelog | 1 = prelog 0 = postlog If a given date has at least one postlog, then only postlogs will be used for that date. Any prelogs for that date will be ignored. |
| spend | Spend associated with a specific ad airing. Required if you want TV spend ingested |
Dual Feed
If you are running any Dual feed spots, list the spot once in the Eastern timezone, and make sure the feed_type is set to dual. Rockerbox will automatically assume multiple airings based on the spot information.
Direct mail mailer report syntax
A sample direct mail postlog report can be found here.
OTT Log File report syntax
A sample OTT postlog report can be found here
Batch Spend report syntax
For more information—including the list of required columns, review Spend: Batch.
A sample batch spend report can be found here
Updated over 1 year ago