Skip to main content
waffle.svg
Domo Knowledge Base

The Trade Desk Connector

Version 10

 

Intro

The Trade Desk is an online demand-side platform that provides buying tools for digital media buyers. Use Domo's The Trade Desk connector to generate reports about ads, audiences, campaigns, and the like. To learn more about The Trade Desk's API, visit their page (https://api.thetradedesk.com/v3/doc).

You connect to your The Trade Desk account in the Data Center. This topic discusses the fields and menus that are specific to the The Trade Desk connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

This connector is useful for pulling data about ads and campaigns filtered by one or more advertisers. Users seem to find the "HD Reports" report especially useful.

Primary Company Roles

Marketing roles

Average Implementation Time

Less than an hour

Ease of Use (on a 1-to-10 scale with 1 being easiest)

3

Best Practices

  • It is best to select All Advertisers in the Advertiser Type menu instead of choosing to manually select advertisers. This way, as you add/remove advertisers, the DataSet will dynamically grab those advertisers when it runs in the future. That way you don't have to go back and edit your DataSet after you make changes.
  • Most of the reports for this connector are easy to configure. The only report that gets more complicated is the "HD Report." There are different types of HD reports, and not all advertisers have the same reports generated each day. So depending on which advertiser you select, you will see different HD report types loaded into the checkbox selector, which means that selected advertiser has those HD reports ready to query. However if you select more than one advertiser, or all advertisers, each of the advertisers may not share the same HD reports, so we simply display all of the existing report types. You then choose one, and we return any and all of that report types that the selected advertisers have.

Prerequisites

To connect to your The Trade Desk account and create a DataSet, you must have the following:

  • The username and password for your The Trade Desk account

  • Your The Trade Desk partner ID

If you do not know any of these credentials, please reach out to your The Trade Desk account representative.

Connecting to Your The Trade Desk Account

This section enumerates the options in the Credentials and Details panes in the Trade Desk Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your The Trade Desk account. The following table describes what is needed for each field:  

Field

Description

Username Enter your The Trade Desk username.
Password Enter your The Trade Desk password.
Environment Select whether you are using a production or sandbox environment.
Partner ID Enter your The Trade Desk partner ID.

Once you have entered valid The Trade Desk credentials, you can use the same account any time you go to create a new The Trade Desk DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the The Trade Desk report you want to run. The following reports are available:

Ad Formats supported Retrieves ad formats supported by The Trade Desk.
Ad Groups by Advertiser Returns ad groups for all or selected advertisers.
Ad Groups with a campaign Retrieves ad groups for selected campaigns.
Ad Technologies Retrieves all available Ad Technologies.
Advertisers Retrieves a list of all advertisers for the authenticated user account.
Audiences owned by an Advertiser Retrieves audiences for all or selected advertisers.
Campaigns belonging to an Advertiser Retrieves campaigns for all or selected advertisers.
Creatives belonging to an Advertiser Retrieves creatives for all or selected advertisers.
Data Groups owned by an Advertiser Retrieves Data Groups for all or selected advertisers.
First Party Data by Advertiser Retrieves First Party data for all or selected advertisers.
Geo Segments available to an Advertiser Retrieves available Geo Groups for all or selected advertisers.
HD Report

Retrieves High Definition Reports that match the supplied advertiser(s), report date, and scope.

Important: This report returns server errors if the Most Recent option is not selected for Report Date and the DataSet updates before the Trade Desk generates the current day's report.
Right Media Offer Types Retrieves all the Right Media Offer types.
Site Lists Summaries belonging to an Advertiser Retrieves summaries of the Site Lists that belong to all or selected advertisers.
Summaries IP Targeting List for an Advertiser Retrieves summaries of the IP Targeting Lists that belong to all of selected advertisers.
Supply Vendors Retrieves a list of supply vendors available to the authenticated user.
Third Party Data by Advertiser Retrieves third-party data that can be queried by all of selected advertisers.
App Event Tracking for an Advertiser Retrieve a list of AppEventTrackers set up for a particular advertiser, along with some basic activity statistics.
Advertiser Type Select whether you want your report to retrieve data for all advertisers or only those you select.
Advertiser Select all of the advertisers you want to retrieve data for.
Campaign Select the campaign you want to retrieve data for.
Report Date

Select an option for configuring the report date for the HD Report report type. You can choose to pull the most recent data (recommended) or today's data. Or you can choose to bring in data for a certain number of days back or for a specified date.

Important: This report returns server errors if the Most Recent option is not selected for Report Date and the DataSet updates before the Trade Desk generates the current day's report.
Scope Select the scope for the report, either Advertiser or Partner.
Number of Days Back Enter the number of past days you want to pull information for.
Specific Date Select the date you want to retrieve information for.
Delimiting Character Select the delimiting character used in your file. If your delimiter is not listed, select 'Other'.
Specify your Delimiter Enter the character to be used to delimit your character separated values (CSV) text.
Quote Character Select the desired quote character for parsing CSV files. If your quote character is not listed, select 'Other'. (A double quote is the CSV standard.)
Custom Quote Character Enter the desired CSV quote character.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Troubleshooting

If you run into issues, try going into the Accounts page in Domo and making sure the account you linked is still validated. If not, revalidate it.