v2 Update to Files in Your Tatari S3 Bucket

We’re excited to announce our v2 update to files in your Tatari S3 bucket. Data in all S3 files is now easier to ingest into your internal tools. See what’s new in the latest version below. 

All v2 reports live in new folders and can be accessed today.

Previous folder:

acme/streaming_spend_and_impression/acme_streaming_spend_and_impression_2020-05-01-2020-06-01.csv.gz

New (v2) folder:

acme/streaming_spend_and_impression/v2/acme_streaming_spend_and_impression_2020-05-01-2020-06-01.csv.gz

Data can be backfilled upon request. 

Linear spot-level data

• The spot_ids are now obfuscated and in a new format
• The airdate column name has changed to spot_datetime and now includes the time 
• We removed the $ symbol from spend values and rounded them to two decimal places
• Lift is now formatted to three decimal places 

Linear spend and impressions data 

• We added spot_id as a column, which is a unique ID of each spot aired and allows you to link to data in other files 
• In the lift column, previously the values would show "0" if there was negative lift and now they will show actual negative lift values 
• We removed the $ symbol from spend values and rounded them to two decimal places
• We updated the names of various columns: 
  • • DatetimeUTC => spot_datetime
    • Creative => creative_name
    • CreativeCode => creative_code
    • Network => network
    • Program => program
    • Spend => spend
    • Impressions => impressions
    • Lift => lift
    • isDeadzoned => is_deadzoned
    • spot_id (new column)

Streaming spend and impressions data 

• For empty values, you’ll find an empty string instead of “n/a”. This will allow for external applications to more easily parse this as null. (Note: In an excel CSV file, it will appear blank but when ingesting the data the value will be "")
• We removed the $ symbol from all spend values and rounded them to two decimal places in the following columns:
  • • measured_spend
    • booked_cpm
    • effective_spend
    • effective_cpm
• All creatives have been broken down into a single line item and the creative_codes column has been renamed to creative_code (the “s” has been removed)
• The campaigns_ids are now obfuscated and in a new format

Streaming user attribution data (for websites) 

• The campaign_ids are now obfuscated and in a new format

Streaming user attribution data (for apps)

• The campaigns_ids are now obfuscated and in a new format
• We changed the names of the following columns:
  • • impression_dt => impression_datetime
    • event_dt => event_datetime 

We’ll be deprecating the previous (v1) version in the future and will let you know in advance. In the meantime, we encourage you to begin using the v2 files. 

Already have access to Tatari S3 buckets? You can find v2 files today.

Not set up with a Tatari S3 bucket yet? Follow the instructions in your dashboard AWS Data Sharing page:

• Log in to your dashboard
• Click the menu in the upper right-hand corner
• Navigate to "Setup" 
• Click "AWS Data Sharing”

Updated September 16, 2020