Automated Access to Streaming 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 costs and how many people saw it.

In the Tatari S3 bucket under streaming_spend_and_impression, 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 04:00 - 05:00 UTC

The daily files contain unreconciled data—or the data that we measure before receiving the final spend costs from the publisher— 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 publisher.

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 Streaming Spend and Impressions Data

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

Example CSV file

Within the file, you’ll find a daily platform breakdown of all the creatives streamed:

Column	Type	Description
date	date	Date when the streaming occurred* (UTC)
platform	string	Where the ad was aired
measured_spend	double	Spend as per original agreement (CPM x impressions/1000)
booked_cpm	double	Cost per 1000 impressions i.e. the amount of spend to secure 1000 impressions; agreed to ahead of time
impressions	integer	How many times the ad was displayed
effective_spend	double	Spend calculated using effective_cpm when reconciled spend data is available. Otherwise, this calculation will utilize booked_cpm to calculate spend
effective_cpm	double	Actual CPM; this comes once we receive the platform invoices and reconcile the streaming spend; it could be adjusted if there are bonus impressions
creative_codes	list of string	A list of all ISICs (unique creative codes) aired on this platform
campaign_id	double	Streaming campaign identifier; this can be used to link data in other files

Get Started

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

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

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

*If the date here shows 4/12/20 for example, then the streaming occurred during that day anytime from 4/12/20 at the 0:00 hour to 4/12/20 at the 23:59 hour eastern time.