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 can be included in the file.
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 encoded mandatory.
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 of 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".