Automated Access to Linear Spot-Level Data (v1)

The version below is v1. To access the most up-to-date version, click here.

Spot-level data shows you the lift associated with your upper funnel (e.g. unique visitors) and lower funnel conversion metrics (e.g. purchases) from advertising on linear TV.

In the S3 bucket under spot_level_metrics, you’ll find daily and monthly CSV files. New files are generated daily between 23:00 - 24:00 UTC.

The monthly file contains data from the past 28 days. The data is unreconciled as it takes 28 days to mature.

The daily file contains a full days’ worth of data for spots that aired 28 days ago. This data is reconciled.

A Look into Linear Spot-Level Data

Example CSV file

Within the file, you’ll find a breakdown of all the spots:

Column	Type	Description
spot_id	integer	ID of the spot (unique to Tatari)
broadcast_week	date	Broadcast week in which the creative aired; the week starts on Monday at 6 a.m. EST
airdate	date	Date when the spot was aired
creative_name	string	Name of the creative (non-unique)
creative_code	string	ISCI: Industry Standard Coding Identification (unique)
network	string	Where the spot aired
rotation	string	When the spot aired during the day
spend	double	Spend associated with a spot
conversion_metric	string	Which metric is being measured
lift	double	Impact of the spot on a given conversion_metric

Get Started

To access granular spot-level data from linear TV in the Tatari S3 bucket, follow the instructions in your dashboard under your right-hand navigation > Setup> AWS Data Sharing.

If you already have access, learn how to ingest the data automatically.