You are here:
The Trade Desk (My Reports) Custom API Connector
The Trade Desk (TTD) is a Demand-Side Platform that allows ad buyer teams to manage data-driven digital advertising campaigns across various advertising formats, including display, video, and social, on a multitude of devices. The TTD Custom API connector allows you to retrieve a custom set of Measurements and Dimensions from the API into Marketing Cloud Intelligence Data Pipelines. It enables you to pull data from any of the TTD (My Reports) reports. While the standard TTD (My Reports) API connector is preset to be automatically mapped to the Data Model, the Custom connector requires manual setup.
- Channel: Display, Search
- Data Stream Type: Ads, Conversion Tag, Generic
- Data Lagging: 1 Day
Prerequisites
To connect to The TradeDesk My Reports API, you need a valid username, password and Partner ID, that has access to the My Reports reporting system. To enable API for your user, contact your TTD representative and request API access for your Partner and third party API access to My Reports.
Details
- You only need to define the Extended Properties, when pulling a non-standard report.
- After you’ve defined the TTD (My Reports) Custom API Connector and click Save, you’ll be redirected to the Mapping screen so you can map the Data Stream. The mapping process is the same as every other TotalConnect Data Stream. Click here to learn more about Mapping. After you finish mapping the relevant fields and save, data is retrieved for the period defined in the Initial Data Fetch section of the connector.
General Setup
After you’ve entered your credentials, define the information you want to pull data for:
- Report Templates - Select The Trade Desk report you want to retrieve data for.
- Advertiser - Select the advertisers you want to retrieve data for. Leave the Advertisers field empty if you want to pull data for all advertisers.
Extended Properties
- Data Stream Type - Select one of the available Data Stream Types you want to map your data
to. You can only select one type of Data Stream Type in any given The Trade Desk Custom API
Data Stream. You can map into the following Data Stream Types:
- Ads
- Conversion Tag
- Generic
- Report Dimensions - Insert the Dimensions you want to retrieve, separated by a comma, exactly as they appear in the TTD platform. This field is mandatory.
- Report Measurements - Insert the Measurements you want to retrieve, separated by a comma, exactly as they appear in the TTD platform. This field is only mandatory when mapping to the Ads Data Stream Type. If any other Data Stream Type is selected, this field is ignored.
- Report Conversion - Insert the Conversion Tags you want to retrieve, separated by a comma.
When inserting the Conversion Tags name, only include the tag name, without the tag number.
It’s important to insert ‘Conversion Tag Name’ into the Report Dimensions text box when
retrieving Report Conversions.
This field is only mandatory when mapping to the Conversion Tag Data Stream Type. If any other Data Stream Type is selected, this field is ignored.
How to QA Your Data
- Create the desired report in the Trade Desk My Reports platform for the required date range:
- In the Trade Desk platform, go to REPORTS > My Reports
- Select the report you want to create. You can select any of the Standard or Custom reports within your account.
- Next, process the relevant Data Stream in Marketing Cloud Intelligence Data Pipelines for the same date range.
- Create a Report/Pivot Table within Intelligence Data Pipelines containing the exact same Dimensions and Measurements for the same report and date range.
- Compare the data in Marketing Cloud Intelligence Data Pipelines to the Basic Performance Stats. If you selected a Location Breakdown, compare the data in Intelligence Data Pipelines to the Geo Insights reports.
