Hourly performance feeds

Hourly Performance Feeds is one of several reporting solutions in The Trade Desk platform. This solution provides partners with near real-time bidding activity aggregated on an hourly basis. The Trade Desk collects impression, spend, and bidding data and normalizes it into hourly feeds. These files are stored in The Trade Desk Amazon S3 (Simple Storage Service).

Benefits of hourly performance feeds

Hourly Performance Feeds enables you to do the following:

• Quickly fine-tune your media planning instead of waiting for aggregated daily reports.
• Access and analyze bidding data more frequently than daily.
• Integrate bidding data into other systems where integration is unavailable.
• Build a custom reporting solution with hourly performance data.
• Unify where you view bidding information into another system, like your CRM software.
• Calculate important metrics for comprehensive details about each event in a campaign.

What you need to know

Here's what you need to know about using Hourly Performance Feeds:

• After The Trade Desk collects the data, it may take 2-3 hours after the hour closes for the hourly file to generate before it is uploaded to The Trade Desk Amazon S3 bucket.
• Impression and spend data becomes available quickly, whereas bid information may come in at a slower rate.
• Some partners process more than 150,000 lines each hour.
• Hourly log size totals vary based on bidding volume. The files are approximately 1 KB per line.
• Feeds are retained for 90 days after generation and then removed.

Accessing hourly performance feeds

Before you access the Hourly Performance Feeds files, be sure to have the following:

Access to The Trade Desk Amazon S3.
The secret keys provided by your Account Manager.

Here's what you need to know about accessing Hourly Performance Feeds:

• To access Hourly Performance Feeds, use the AWS API for S3.
• The secret keys are used to generate a signature that you use along with the access key to download log files. For details, see Signing AWS API requests.
• All files are stored in partner-specific folders with The Trade Desk Amazon S3.
• Subfolders in the partner folder are organized by year, month, and day in the .../yyyy/MM/dd format. For example, .../2023/04/23.
• To upload files to a partner-hosted Amazon S3 bucket, the partner must set up the folder and provide write-access for The Trade Desk Amazon S3 user account.

To locate a partner folder in the Amazon S3, enter your partner ID and report version number in the base Amazon S3 URI as shown in the following format:

s3://thetradedesk-useast-partner-datafeed/{PARTNER-ID}/hpf/2

Here's an example of a logs folder base URI on Amazon.

s3://thetradedesk-useast-partner-datafeed/partnerabc/hpf/2

File names and feed columns

Each feed file is tab-delimited and in the TSV file format with the following naming convention:

Hourly Performance Feeds-{REPORT-VERSION}-{PARTNER-ID}-{YYYYMMDD}_{HH}.{STATUS}.tsv

The following table details each parameter in the file name.

Here's an example of a file name:

Hourly Performance Feeds-v2-partnerabc-20200423_19.final.tsv

Here's an example of the full path of a file name:

s3://thetradedesk-useast-partner-datafeed/partnerabc/hpf/2/Hourly Performance Feeds-v2-partnerabc-20200423_19.final.tsv

Hourly performance feeds columns

The following table details each Hourly Performance Feeds column including its data type and format.

NOTE: The schema is not customizable.

FAQs

The following is a list of commonly asked questions about Hourly Performance Feeds.

Where can I get more frequent data than hourly?

The Raw event data stream (REDS) provides log-level bidding data in near real-time.

Where can I get daily reports?

User-defined reports have daily attribution and over 200 grains and metrics.