Collecting data from The Trade Desk

This guide explains how to collect data from The Trade Desk. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

  • The Trade Desk can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Prerequisites

Before you start collecting data from The Trade Desk, perform all of the following actions:

  • Contact your The Trade Desk account representative and request a dedicated API user for Adverity. Dedicated API user permissions differ from those of a The Trade Desk UI user. Therefore, API users and UI users of The Trade Desk may have access to different reports. If any expected reports are missing in Adverity, contact The Trade Desk.

Creating a datastream to collect data from The Trade Desk

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from The Trade Desk.

Authorization: Allow Adverity to access The Trade Desk

  1. If you choose Access using your credentials or Access using someone else's credentials, in Set up or edit Advertisers, you or the person granting access must choose one of the following options:

    • Choose Grant access to all Advertisers, including those created in the future to allow Adverity to access all existing Advertisers and all Advertisers created in the future.

    • Choose Select specific Advertisers to which you want to grant access to determine the specific Advertisers that you want Adverity to access. Adverity will not automatically have access to Advertisers created in the future. You will need to grant Adverity access to any Advertisers created in the future.

    If you use your credentials to grant Adverity access to The Trade Desk, all the Advertisers available to you using your credentials will be visible in the Authorizations page to all Adverity users with permission to edit this authorization.

    If someone else uses their credentials to grant Adverity access to The Trade Desk, the same applies to the Advertisers available using their credentials.

    This is important to consider if you do not want all Adverity users with permission to edit the authorization to be able to see the details of the Advertisers. For more information about user permissions, see Managing user permissions.

Configuration: Choose the data you want to collect from The Trade Desk

To choose what data to collect and customize the The Trade Desk datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Report type, select the report type you want to use. The next steps to configure your datastream depend on the option you select.

  2. If you selected the Template report type, follow these steps:

    1. In Template, select the report template you want to use.

    2. In Advertisers, select the advertisers for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.

    3. In Timezone, select the timezone in which the data will be reported.

    4. If your template uses Excel, in Sheet number, enter the number of the sheet for which to collect data. If you do not enter a sheet number, Adverity collects data for all sheets.

  3. If you selected the Custom report type, follow these steps:

    1. Schedule a daily report in the The Trade Desk user interface with the preset Yesterday. Due to The Trade Desk rate limitations, it may take some time for all reports and advertisers to appear in the drop-down menus in Adverity.

    2. In Advertiser, select the advertiser for which to collect data. To collect data on the partner level, leave this field empty.

    3. (Optional) In Report keyword, enter a keyword to filter the list of available reports.

      Adverity periodically updates the list of reports. To use a recently created report that is not shown in the list, enter the report name in Report keyword to update the list with reports that include this keyword.

    4. In Report, select the report that you want to use to collect data.

Run initial fetch: Collect data from The Trade Desk

For the Custom report type, data is retrieved for all reports containing any dates you select when fetching data.

This can lead to data duplication. For example, you have two Custom reports: one report is configured to collect data for September 1 and 2, and the second report is configured to collect data for September 2 and 3. When fetching data, if you choose to fetch data for September 2, both reports will be fetched. As a result, data for September 2 may be duplicated.

What's next?

Troubleshooting The Trade Desk

A report is missing from my scheduled fetch from The Trade Desk

If you schedule a fetch from The Trade Desk before the report is ready in the The Trade Desk UI, Adverity is unable to fetch this data. As a result, a report may be missing from your scheduled fetch.

To resolve this issue, ensure that your fetch is scheduled to be performed several hours after the data you want to fetch is available in the The Trade Desk UI.