Skip to main content
Skip table of contents

The Trade Desk

Overview

Vendor/Partner

TradeDesk

Version

v3

API Documentation

https://api.thetradedesk.com/v3/portal/api/doc/ApiOverview#changes-and-updates

Sunset Date

None as of October 2024
API Activity Log

Channel(s)

Programmatic

Refresh Time (CST)

6am

Default backfill

1 day

Alli Data Library

(tick) (error)

Getting Started

Because of the way The Trade Desk's API functions, the report that we want to pull using the API, must first be created in The Trade Desk's My Reports app at https://desk.thetradedesk.com/MyReports.

  1. Create a report in The Trade Desk’s My Reports app.

  2. Click the +TSV/CSV Report button in the My Reports page and create an New Custom Text Report.

Report Content Selections:

  • Type of report you are pulling into Alli Data.

  • Fields (ie. Dimensions) and Metrics that will be included in the report

  • Report filter (ie, the advertisers, campaigns, ad groups that should be included in the report)

  • Date range

  • File format (use CSV when possible)

  • Recurrence schedule (ie. How often the report should run)

  • Generated schedule name

Datasource Configuration

API Username and API Password

The API username and password for each specific partner can be obtained from your Trade Desk representative and are required for the remaining steps in this guide. These credentials are not necessarily the same that are used to create reports in the My Reports application.

Partner ID

Input the ID for the Trade Desk partner to be pulled into Alli.

Advertiser Name

After filling in the Datasource Settings above and clicking the Next button, the Advertiser Name selection menu will populate in the Additional Configuration Needed panel based on the advertisers included in the report created in My Reports.

Screenshot 2024-03-14 at 10.03.00.png

  1. Select any advertiser that appears within the report you created in step 1 above.

  2. Use the Report Name Filter input box to optionally refine the results that will appear in the My Report Name selection dropdown. Then click the Next button.

As there can be a large number of report results, your report may not appear in the selection menu unless you refine the list using the Report Name Filter input box in this step.

3. After the page reloads, choose your report in the My Report Name selection menu. Reports that were created as .xlsx, will not show up in the results.

🚨 While generating the My Report Name dropdown list, the site may become unresponsive for a period of time. 🚨

The Trade Desk API can be very slow to return a list of reports. For that reason, the configuration page can take some time to load (~1 minute or more ⏳) after selecting an advertiser from the selection dropdown and clicking the Next button.

Define your Data

Unfortunately, since the Trade Desk API does not allow you to create reports on the fly, it is also not aware of the columns (dimensions and metrics) that are included in the report. As a result, you will need to use the manual Dimension/Metric picker to match the report that you created in the Trade Desk's My Report UI.

Select the report's columns as dimensions and metrics using the manual report builder.

You can download your report as a .csv file and drop it on to the Manual picker to auto-generate the report's columns. You should still take a minute to verify the auto-generated schema, as misconfigured dimensions and metrics can cause errors in the data and metric inflation. If you need help, here is a guide.

The timeframe of the data included in the report is set within the My Reports UI, so there is no date picker available.

If you need to backfill data, you should create your report as non-recurring, and include all the date ranges that you need in that one report.

Press Load Data to manually pull the most recently completed report available from the Trade Desk.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.