Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Automated Access to Linear Spend and Impressions Data (v1)

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

 

Spend and impressions data allows you to see how much an ad cost, how many people saw it, and how it performed against other spots. 

In the Tatari S3 bucket under linear_spend_and_impressions, you’ll find daily and monthly CSV files. 

The files are generated as follows: 

  • Daily file: Every day from 23:00 - 24:00 UTC
  • Monthly file: The first day of the month from 02:00  - 03:00 UTC 

The daily files contain unreconciled data—or the data that we measure before receiving the final spend costs from the network— from the past 45 days. The monthly file will show reconciled data for the previous month. 

Some examples: 

  • Daily file: If it was created on June 1, 2020, it will contain data from April 17 - June 1, 2020. 
  • Monthly file: Final spend and impressions data for the month of January would be available March 1st. 

All files are inclusive of data on the start date and exclusive of data on the end date.

The daily files allow you to access your unreconciled data until the monthly files are reconciled. The daily files may have missing or sparse data as we wait for actuals from the networks. 

We recommend you replace data in the daily file every day once you receive the new file, and then again once you receive the monthly reconciled file. 

A Look into Linear Spend and Impressions Data

 

Inside of each file you’ll see a daily breakdown of data. 

Screen Shot 2020-06-04 at 9.41.15 AMExample daily CSV file

 

Within the file, you’ll find the following data broken out by spot: 

Column Name

Data Type

Description

DatetimeUTC

datetime

The date and time in which the spot aired (UTC)

Creative

string

Creative name

CreativeCode

string

Creative ISCI (Industry-standard coding identification for commercials)

Network

string

Linear network on which the ad was aired

Program

string

Program name or null

Spend

double

Budget

Impressions

integer

Number of people who potentially saw the ad

Lift

double

Incremental increase in traffic

isDeadzoned

boolean

Whether or not a spot occurs during a deadzone  (read more)

 

Get Started

To access granular spend and impressions data from linear TV in the Tatari S3 bucket, follow the instructions in your dashboard AWS Data Sharing page. 

  1. Log into your dashboard
  2. Click the menu in the upper right-hand corner
  3. Navigate to "Setup"
  4. Then click "AWS Data Sharing" 

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