This article will show you how to format and upload your TV data into Adtriba.

Download this template as the first step to create and upload your data by using the TV Data Uploader in the dashboard.

File format

The following columns must be included in the file.

  • AIRING_DATETIME
  • STATION
  • SPOT_LENGTH
  • PROGRAM_BEFORE
  • PROGRAM_AFTER
  • TANDEM_TYPE
  • GENRE_BEFORE
  • GENRE_AFTER
  • MOTIF
  • TIMESLOT
  • SPEND

File type

The TV Data Uploader accepts only CSV files.

Column delimiter

Use one of the three delimiters.

  • ,
  • ;
  • TAB (\t)

Column description

AIRING_DATETIME

The timestamp must be defined in the ISO 8601 YYYY-MM-DD hh:mm:ss format - e.g. 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 - keep it empty if data is not available

PROGRAM_BEFORE

Which program was shown before the TV spot was aired.

Value required: no, optional - keep it empty if data is not available

PROGRAM_AFTER

Which program was shown after the TV spot was aired.

Value required: no, optional - keep it empty if data is not available

TANDEM_TYPE

Value required: no, optional - keep it empty if data is not available

GENRE_BEFORE

The gerne of the program which was shown before the TV spot was aired.

Value required: no, optional - keep it empty if data is not available

GENRE_AFTER

The gerne of the program which was shown after the TV spot was aired.

Value required: no, optional - keep it empty if data is not available

MOTIF

Variant/motif of the TV spot.

Value required: no, optional - keep it empty if data is not available

TIMESLOT

The timeslot the TV spot.

Value required: no, optional - keep it empty if data is not available

SPEND

Spend/budget for the TV spot. Use dots between the integer and decimal numbers of your spend values.

Value required: no, optional - keep it empty if data is not available

Create the file

Ensure to enclose the columns with double quotes if the delimiter is used in one of the columns - e.g. in the PROGRAM_BEFORE column: "The Good, The Bad and The Ugly".

Did this answer your question?