None as of 10/06/2023
Refresh Time (CST)
Alli Data Library
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.
Create a report in My Reports app.
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 the Datawarehouse
Fields (ie. Dimensions) and Metrics that will be included in the report
Report filter (ie, the advertisers, campaigns, adgroups that should be included in the report)
File format (use CSV when possible)
Recurrence schedule (ie. How often the report should run)
Generated schedule name
After filling in the Datasource Settings panel and clicking Next, the Advertiser Name selection menu will populate in the Additional Configuration Needed panel.
Select any advertiser that appears within the report you created in step 1 above.
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.