The Trade Desk link
The Trade Desk is an advertising service that provides users with a multifaceted approach to advertising automation.
We support the My Reports type of The Trade Desk reports.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | ||
Data blocking | check | Column level, table level, and schema level. |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | check | Reporting tables |
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step The Trade Desk setup guide to connect The Trade Desk with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all The Trade Desk connectors.
To zoom, open the ERD in a new window.Sync overviewlink
The REPORT_SCHEDULE
table contains a list of reports created through The Trade Desk User Interface. The REPORT_EXECUTION
table contains the report_start_date_inclusive
and report_end_date_exclusive
columns. Each report has a report_execution_id
column. You can use the report_execution_id
column in a JOIN query to determine the period when the report was generated (from report_start_date_inclusive
to report_end_date_exclusive
).
Data blockinglink
We support data blocking for reports created in your The Trade Desk account as well as the following tables:
ADVERTISER_ASSOCIATED_BID_LIST
ADVERTISER_CANDIDATE_PROFILE
ADVERTISER_DEFAULT_BID_LIST
BID_LIST
BID_LIST_DIMENSION
CAMPAIGN
CAMPAIGN_ASSOCIATED_BID_LIST
CAMPAIGN_CONVERSION_REPORTING_COLUMN
CAMPAIGN_DEFAULT_BID_LIST
CAMPAIGN_FLIGHT
PARTNER_ASSOCIATED_BID_LIST
REPORT_EXECUTION
REPORT_SCHEDULE
REPORT_TEMPLATE_HEADER
Syncing empty tables and columnslink
The Trade Desk connector doesn't support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the relevant data from the source. If The Trade Desk doesn’t return data for the source table, we don’t create the table in your destination.