The Trade Desk
The Trade Desk is an advertising service that provides users with a multifaceted approach to advertising automation.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step The Trade Desk setup guide to connect The Trade Desk with your destination using Fivetran connectors.
Schema information
This schema applies to all The Trade Desk connections.
Sync overview
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).
The Trade Desk connector relies on the REPORT_SCHEDULE and REPORT_EXECUTION tables to fetch new report schedules and executions during each sync. We recommend that you include these tables in your connection's sync at all times.
Rollback sync
A rollback sync is a sync that automatically runs once a day. The rollback window for our The Trade Desk connector is one day.
Supported report types
We support the My Reports type of The Trade Desk reports. We don't support the Hourly Performance Feeds or Raw Event Data Stream (REDS) types of reports.
Data blocking
We support data blocking for reports created in your The Trade Desk account as well as the following tables:
ADVERTISER_ASSOCIATED_BID_LISTADVERTISER_CANDIDATE_PROFILEADVERTISER_DEFAULT_BID_LISTBID_LISTBID_LIST_DIMENSIONCAMPAIGNCAMPAIGN_ASSOCIATED_BID_LISTCAMPAIGN_CONVERSION_REPORTING_COLUMNCAMPAIGN_DEFAULT_BID_LISTCAMPAIGN_FLIGHTPARTNER_ASSOCIATED_BID_LISTREPORT_EXECUTIONREPORT_SCHEDULEREPORT_TEMPLATE_HEADER
Syncing empty tables and columns
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.