Upload playout logs

The Playout Uploader is a manual resource that will require you to independently source and upload your logs directly into the platform. The Playout Uploader is used for 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 good tool if you need 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.

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 activate this feature.

Upload logs

1. In Attribute, click the icon in the left menu and then the Upload button in the upper right corner. The Upload Type screen opens. 

1. Under Playout Data, click Select File. CSV UTF-8 format is required.

   By nature, all rows in a CSV file will be processed. If you are attempting to filter a CSV using Excel or another spreadsheet program, you'll need to export the rows you want to process into a new, clean CSV file and upload that file.

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.

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 fate formats:

    • YYYY-MM-DD

    • M/D/YY

    • M-D-YY

    • M/D/YYYY

    • M-D-YYYY

  • Supported time formats:

    • 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, 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 optional. (See Optional Fields section below.)

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 and 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. Utilize the Notification Center to view the most recent status of your processing file.

• Complete without errors
  • Files with this status have completed successfully and are represented with a green checkmark.
  • This will upload completely new Advertiser spot data, and can also accept ‘additive’ data to ensure it’s included in your reports.
    • Once this is completed, you can set up your Advertiser Campaign by following these steps:
      • Create a new advertiser
      • Create a campaign 

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

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

The following optional fields are supported if you wish to track this additional data or if 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 vs. 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

• Playout data ingest methods
• Playout log uploader file requirements
• Reconnected Advertiser: Why is my weblift/Ad Visits low?

• Enable the uploader
• Upload logs
• Data schema requirements
• File statuses and icon descriptions
• View upload errors
• Optional fields