Skip to main content

Upload TV Data

See how you can upload TV station and airing data using a CSV file.

Note: Adtriba Core is a legacy feature that we continue to support but no longer sell. The latest version of this feature is available as Funnel Measurement.
If you are already using Funnel Measurement, find more information here. To upgrade, contact us.

Download the template to create and upload your TV data.

File format

The file can include the following columns.

  • AIRING_DATETIME (mandatory)

  • CHANNEL_NAME (mandatory)

  • SPOT_LENGTH (optional)

  • PROGRAM_BEFORE (optional)

  • PROGRAM_AFTER (optional)

  • TANDEM_TYPE (optional)

  • GENRE_BEFORE (optional)

  • GENRE_AFTER (optional)

  • MOTIF (optional)

  • TIMESLOT (optional)

  • SPEND (optional)*

  • REACH (optional)

*mandatory if the TV file will also be used for Adtriba Sphere

File type

The TV Data Uploader accepts only CSV files. UTF-8 encoding is required.

Column delimiter

Use one of these delimiters:

  • ,

  • ;

  • TAB (\t)

Column description

Airing_datetime

Define the timestamp in ISO 8601YYYY-MM-DD hh:mm:ss format, for example 2018-01-31 20:34:20.

Value required: yes

Station

Name of the TV station.

Value required: yes

Spot_length

Length of the TV spot in seconds.

Value required: no. Optional. Leave empty if data is not available.

Program_before

Program shown before the TV spot aired.

Value required: no. Optional. Leave empty if data is not available.

Program_after

Program shown after the TV spot aired.

Value required: no. Optional. Leave empty if data is not available.

Tandem_type

Value required: no. Optional. Leave empty if data is not available.

Genre_before

Genre of the program shown before the TV spot aired.

Value required: no. Optional. Leave empty if data is not available.

Genre_after

Genre of the program shown after the TV spot aired.

Value required: no. Optional. Leave empty if data is not available.

Motif

Variant or motif of the TV spot.

Value required: no. Optional. Leave empty if data is not available.

Timeslot

Timeslot of the TV spot.

Value required: no. Optional. Leave empty if data is not available.

Spend

Spend or budget for the TV spot. Use a dot between the integer and decimal parts of spend values.

Value required: no. Optional. Leave empty if data is not available.

Create the file

Enclose columns with double quotes if the delimiter appears in a column value. Example in the PROGRAM_BEFORE column: "The Good, The Bad and The Ugly".

Did this answer your question?