Report Delivery Requirements

This page describes data and file format requirements for sending Rockerbox data. Please review closely. If you're not able to meet these requirements, contact your Rockerbox account manager.

Report Data Requirements

Only send updates; do not send data that you previously sent. For example, if you send daily files, send just the previous day. If you send weekly files, send the prior week. Do not send a 30-day historical every day.

For initial on-boarding, you can send a historical file if available.

🚧

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.

Report Format Requirements

To send files to Rockerbox, we require the following:

  1. Send in .csv, .tsv, or .xlsx format. You must include the file extension in the filename. Do not capitalize the file extension—they must be lower-case.

📘

.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"
  • as noted above, 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.

  1. Standardize the file name.
  • All files need a unique indicator in the report name. This could be the end date, or an ID.
  • File names need to be alphanumeric. Do not include spaces, but you can include “-” and “_” characters. Do not use any other special characters.
  • 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, append text to the filename to differentiate the two files. For example, if the original file was "filename_2021-01-01.csv", send an update as "filename_2021-01-01_v2.csv".

📘

Acceptable FIlename Example

  • TV Example: YYYY-MM-DD_yourbrandname_tv_postlog.csv
  1. For data transfer, while we prefer S3, we can also setup SFTP or Email if you don’t use Amazon services. Check out our more detailed guide here.

  2. Do not password protect your files.

  3. The data format—in particular, number of columns, column names, and position of columns—cannot change over time.

  4. Remove all newlines in the header. The first row of the file will be the column names, and these column names will not change from file to file. Every other row in the file will contain data.

  5. 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.

  6. Send Date and Time type columns in ISO-8601 format (YYYY-MM-DD HH24:mm:ss) in UTC.

  7. Do not include a summary or total row in the file. For example, if a file has 10 rows with individual campaign Spend columns that add up to $1000, do not also include a Total Spend = $1000 in the file.

  8. For email endpoints, files must be sent as an email attachment rather than a link.

  9. For email endpoints, files must be sent as a new email with the endpoint being the only recipient.

  10. For Excel files, only send one tab. Do not include any additional tabs.

If you are not able to follow these requirements, then we may not be able to support your files. Please contact your Account Manager for more details.

🚧

Email Attachments

If you are sending reports to Rockerbox via Email, then it must be sent as an attachment. You cannot send a link to download a file.

TV postlog report syntax

A sample tv postlog report can be found here.

{
    "required": [
        "timestamp",
        "network",
        "inventory"
        "media_outlet_type",
        "feed_type",
        "ad_name",
        "tape_length"
    ],
    "properties": {
        "timestamp": {
            "type": "string",
            "format": "YYYY-MM-DD HH24:mm:ss"
        },
        "media_outlet_type": {
            "type": "string",
            "description": "Examples: Cable - National, Satellite"
        },
        "network": {
            "type": "string",
            "description": "Examples: PBS, NBC"
        },
        "inventory": {
            "type": "string",
            "description": "TV program an ad aired on. Examples: Seinfeld, M.A.S.H."
        },
        "feed_type": {
            "type": "string",
            "enum": [
                "live",
                "dual"
            ]
        },
        "ad_name": {
            "type": "string"
        },
    "isci": {
            "type": "string"
        },
        "tape_length": {
            "type": "string"
        },
        "spend": {
            "type": "number",
            "format": "float",
            "required": false,
            "description": "spend/cost associated with a specific ad airing. Necessary if you want TV spend ingested"
        }
    }
}

Direct mail mailer report syntax

A sample direct mail postlog report can be found here.

OTT Log File report syntax

A sample direct mail postlog report can be found here

Batch Spend report syntax

A sample batch spend report can be found here


Did this page help you?