Why Use the Playout Uploader?

The Playout Uploader is a great resource for those rare cases where spot logs might not be available automatically or easily accessible in Veritone Attribute. This might include forms of sports play x play coverage, regional custom networks, or promotional inventory that cannot be picked up through keyword search in the platform.

It is also a go-to tool if you are looking to upload specific campaign data directly, including any promotional campaigns where your spots may not be logged in your traffic system under the Advertiser name or Station name as usual.

The Playout Uploader is a manual resource that will require you to independently source and upload your logs directly into the platform.

Important: Use of the Playout Uploader is intended for use of your broadcaster group/network's spots only. Per our license agreements with your organization, we can not include competitive broadcasters’ data.

How Do I Enable the Uploader?

This tool will only be visible to you in the platform once it is configured for your Org. Pending any necessary sales leadership and Research group approvals, your Customer Success Manager will turn this feature on.

How Do I Upload Logs?

Once activated by Veritone, the new tool can be accessed by clicking on the Uploader icon on the left menu panel.

1. Click on the Uploader icon.

2. Click Browse to Upload to add your log data for upload.

Note: CSV format is required.

3. Once the file is uploaded, you will now map the data columns in the uploaded file to Veritone's required fields. To do this, simply select the desired value from the dropdown for each column in your file.

Please note: Be sure to double-check the time zone selected in this step matches the time zone in your logs. This is a requirement for correct log mapping and to ensure there are no duplicate entries.

Data Schema Requirements

  • Advertiser

    • Advertiser or Brand Name

    • Supported Format – Text String

  • Duration

    • Length in second or milliseconds

    • Supported Formats

      • HH:mm:ss

      • mm:ss

      • seconds (:30)

      • HH:mm:ss:SS

      • seconds (50)

      • milliseconds

  • Event Name

    • Description of ad, song, promo, etc

    • Supported Format – Text String

  • Start & Date Time

    • Can be in either one or two columns

    • Event start time and date

    • Supported Date Formats

      • YYYY-MM-DD

      • M/D/YY

      • M-D-YY

      • M/D/YYYY

      • M-D-YYYY

    • Supported Time Format

      • H:mm:ss

      • H:mm:ss AM

      • H:mm:ssAM

      • H:mm:ss PM

      • H:mm:ssPM

      • HH:mm:ss

  • Station

    • Can be in either one or two columns

    • Call letters and band

      • Supported call letter format

        • ABCD

      • Supported bands and format

        • AM, FM, HD1, HD2, TV

      • If in one column, please configure as follows: ABCD-AM (hyphen between call letters and band, with no spaces)

  • You may also configure additional fields as desired, but this is completely optional! (See more details below.)*

4. Once the file is uploaded and you have finished mapping your data fields, you will be redirected to the page shown below, which details the files you’ve added to the platform. Within this list of files, you will see key metrics such as record count and date ranges for the available data. New files will take 5-10 minutes to complete processing.

File Statuses & Icon Descriptions

Each file on this page shows an icon next to it. The definition of the icons are below.

  • Processing

    • Files being processed are indicated by an interactive swirl icon.

      • New files will take 5-10 minutes for the file to complete processing.

  • Complete without Errors

    • Files with this status have completed successfully and are represented with a green checkmark

  • Complete with Errors

    • Files with this status have completed, but have Errors in the file. This is represented by red escalation mark

    • Users can click the icon and go to an Error Report

  • Complete with Duplications

    • Files with this status have completed, but have Duplicate records in the file. This is represented by a yellow exclamation mark

      • Users can click on the icon and see how many records were unique vs. considered duplicates. To keep your data sound, the platform will not accept duplicate records from being uploaded.

How Do I View Upload Errors?

For files that don't match the Veritone required inputs, an error report will be provided. This will detail the type of errors present in the file and display the first 10 examples of that error in the file for reference. An example is shown below.

Optional Fields

In addition to the required fields, we also support the following optional fields should you wish to track this additional data or your post log CSV is better aligned with the below field names.

  • Ad ID

    • Unique Ad Identified or ISCI

  • Advertiser ID

    • Unique advertiser ID

  • Artist Name

    • Artist name (This might be populated by such values as the singer, voiceover artist, or advertiser, etc.)

  • Bonus

    • Bonus placement without charge

  • Event ID

    • Unique identifier for the event (may be same as Event Name or ISCI)

  • Status

    • Lifecycle state (i.e. Reconciled, Invoiced, etc.)

  • Type

    • Event categorization (i.e. Spot v Promotion)

  • Gross Rate

    • Placement gross costs

  • Market

    • Market where the event occurred for mapping to time zone and localized broadcast area

  • Station City

    • Station City (should be same as broadcast Market)

  • Category

    • Advertiser industry or category

Need Additional Help?

Contact [email protected] or reach out via chat for any assistance needed while uploading your files.

Did this answer your question?