Connect Your The Trade Desk Performance with All Your Data
Drive Meaningful Insights from The Trade Desk
The Trade Desk is the fastest growing demand-side platform — offering agencies and advertisers best-in-class technology to manage digital campaigns.
Automatically pull data from The Trade Desk, which can then be grouped with data from other marketing platforms and automatically fed into your Data Warehouse, BI solution or visualization tool.
With just a few clicks, connect your The Trade Desk account to any data warehouse of your choice and watch your data load in real-time. Experience a hassle-free, zero-maintenance data load.
What data can I get from The Trade Desk?
Available endpoints and fields are available from The Trade Desk through Launchpad.
The Trade Desk
Grains
Audience
Recency Group
Recency Group End (in minutes)
Recency Group Start (in minutes)
Grains
Ad Group
Ad Group Fill Type
Advertiser
Advertiser Currency Code
Campaign
Frequency
Is Managed By TTD
Language
Market Type
Partner Currency Code
Partner Name
Metrics
Audience Impressions
Average Bid CPM (Partner Currency)
Average Bid CPM (Adv Currency)
Average Bid CPM (Partner Currency)
Average Bid CPM (Adv Currency)
Bids
Impressions
Total Bid Amount (Partner Currency)
Total Bid Amount (Adv Currency)
Unique IDs
Win Rate
Metrics
Advertiser CPC (Adv Currency)
Advertiser CPC (Partner Currency)
Clicks
CTR
Hypothetical Advertiser CPC (Partner Currency)
Hypothetical Advertiser CPC (Adv Currency)
Hypothetical Partner CPC (Partner Currency)
Hypothetical Partner CPC (Adv Currency)
Partner CPC (Partner Currency)
Partner CPC (Adv Currency)
Metrics
Companion Clicks
Companion Impressions
Grains
Conversion City
Conversion Country
Conversion Device Type
Conversion ID
Conversion Metro Code
Conversion Metro Name
Conversion Monetary Value
Conversion Monetary Value Currency
Conversion Order ID
Conversion Referrer URL
Conversion Region
Conversion TD 01
Conversion TD 02
Conversion TD 03
Conversion TD 04
Conversion TD 05
Conversion TD 06
Conversion TD 07
Conversion TD 08
Conversion TD 09
Conversion TD 10
Conversion TDID
Conversion Time
Conversion Time (UTC)
Conversion Tracking Tag ID
Conversion Tracking Tag Name
Metrics
All Last Click + View Conversion Rate
All Last Click + View Conversion Revenue
All Last Click + View Conversions
All Last Click + View CPA (Adv Currency)
All Last Click + View CPA (Partner Currency)
Custom CPA (Partner Currency)
Custom CPA (Adv Currency)
Normalized All Last Click + View Conversion Rate
Total Custom CPA Conversion Rate
Total Custom CPA Conversions
Total Return on Ad Spend (ROAS)
Conversion metrics
% of Conversion Touches With Last Click or View Credit
Click Conversion
Click Conversions Rate
Click Conversions Revenue
Click Conversions CPA (Partner Currency)
Click Conversions CPA (Adv Currency)
Conversion Touch
Conversion Touch Revenue
Conversion Touches per Impression
Hypothetical Click Conversions CPA (Partner Currency)
Hypothetical Click Conversions CPA (Adv Currency)
Hypothetical Total Click + View Conversions CPA (Partner Currency)
Hypothetical Total Click + View Conversions CPA (Adv Currency)
Total Click + View Conversion Rate
Total Click + View Conversion Revenue
Total Click + View Conversions
Total Click + View Conversions CPA (Partner Currency)
Total Click + View Conversions CPA (Adv Currency)
View-through Conversion
View-through Conversion Revenue
Metrics
Advertiser Cost (Adv Currency)
Advertiser Cost (Partner Currency)
Advertiser CPM (Adv Currency)
Advertiser CPM (Partner Currency)
Fee Features Cost (Partner Currency)
Fee Features Cost (Adv Currency)
Hypothetical Advertiser Cost (Partner Currency)
Hypothetical Advertiser Cost (Adv Currency)
Hypothetical Advertiser CPM (Partner Currency)
Hypothetical Advertiser CPM (Adv Currency)
Hypothetical Partner Cost (Partner Currency)
Hypothetical Partner Cost (Adv Currency)
Hypothetical Partner CPM (Partner Currency)
Hypothetical Partner CPM (Adv Currency)
Media Cost (Partner Currency)
Media Cost (Adv Currency)
Media CPM (Partner Currency)
Media CPM (Adv Currency)
Non-USD Currency Cost (Partner Currency)
Non-USD Currency Cost (Adv Currency)
Normalized Advertiser CPM (Partner Currency)
Normalized Advertiser CPM (Adv Currency)
Normalized Media CPM (Partner Currency)
Normalized Media CPM (Adv Currency)
Normalized Partner CPM (Partner Currency)
Normalized Partner CPM (Adv Currency)
Partner Cost (Partner Currency)
Partner Cost (Adv Currency)
Partner CPM (Partner Currency)
Partner CPM (Adv Currency)
TTD Cost (Partner Currency)
TTD Cost (Adv Currency)
Grains
Ad Format
Ad Server Creative Placement ID
Ad Server Name
Creative
Grains
1st Party Data ID
3rd Party Data Brand
3rd Party Data Brand ID
3rd Party Data Full Path
3rd Party Data ID
Data Element
Data Type Name
Tracking Tag ID
Tracking Tag ID (Household)
Tracking Tag Name
Tracking Tag Name (Household)
Metrics
Charged Data Element Cost (Partner Currency)
Charged Data Element Cost (Adv Currency)
Charged Data Impressions
Data Cost (Partner Currency)
Data Cost (Adv Currency)
Not-Charged Data Element Cost (Partner Currency)
Not-Charged Data Element Cost (Adv Currency)
Not-Charged Data Impressions
Grains
Ad Environment
Browser
Carrier ID
Carrier Name
Device Make
Device Model
Device Type
Operating System
Operating System Family
Grains
Event Ad Format
Event Ad Group ID
Event Ad Group Name
Event App Name
Event Audience ID
Event Audience Name
Event Browser
Event Campaign ID
Event Campaign Name
Event Carrier ID
Event Carrier Name
Event City
Event Country
Event Creative ID
Event Creative Name
Event Cross Device Attribution Model
Event Device Make
Event Device Model
Event Device Type
Event Factual Proximity Design ID
Event Factual Proximity Design Name
Event Factual Proximity Targeting Code ID
Event Factual Proximity Targeting Code Name
Event Inventory Contract ID
Event Inventory Contract Name
Event Keyword
Event Keyword ID
Event Matched Category Hierarchy
Event Matched Category ID
Event Matched Category Name
Event Matched Fold Position
Event Matched Language Code
Event Matched Site
Event Matched Site List ID
Event Matched Site List Name
Event Matched Site Strategy Line ID
Event Metro Code
Event Metro Name
Event Native Context Type
Event Native Context Type ID
Event Native Placement Type
Event Native Placement Type ID
Event OS
Event OS Family
Event Recency Bucket End (in minutes)
Event Recency Bucket Name
Event Recency Bucket Start (in minutes)
Event Region
Event Rendering Context
Event Report Hour (UTC)
Event Site
Event Supply Vendor
Event Temperature Bucket End (in Celsius)
Event Temperature Bucket Name
Event Temperature Bucket Start (in Celsius)
Event Time
Event Time (UTC)
Event Type
Event Type ID
Event User Day of Week
Event User Hour of Day
Event User Hour of Week
Grains
Ad Group Base Bid CPM (Adv Currency)
Ad Group Budget (Adv Currency)
Ad Group Budget in Impressions
Ad Group Campaign Flight ID
Ad Group Daily Cap (Adv Currency)
Ad Group Daily Cap in Impressions
Ad Group Daily Target (Adv Currency)
Ad Group Daily Target in Impressions
Ad Group Flight Budget (Adv Currency)
Ad Group Flight Budget in Impressions
Ad Group Flight Daily Target (Adv Currency)
Ad Group Flight Daily Target in Impressions
Ad Server Campaign ID
Ad Server Campaign Name
Ad Server Creative Variant
Ad Server Placement ID
Ad Server Placement Name
Ad Server Site ID
Ad Server Site Name
Additional Fee Card ID
Additional Fee Description
Additional Fee ID
Additional Fee Target ID
Additional Fee Target Type
Additional Fee Target Type ID
Additional Fee Type
Additional Fee Value
Advanced Grain
Advanced Grain Type
Campaign Flight Budget (Adv Currency)
Campaign Flight Budget in Impressions
Campaign Flight Daily Target (Adv Currency)
Campaign Flight Daily Target in Impressions
Campaign Flight End Date (UTC Exclusive)
Campaign Flight ID
Campaign Flight Start Date Inclusive -> End Date Exclusive (UTC)
Campaign Flight Start Date (UTC Inclusive)
Counting Method ID
Cross Device Attribution Model
Cross Device Attribution Model ID
Demographic Key
Fee Type
First Display Click Ad Environment
First Display Click Ad Format
First Display Click Ad Group ID
First Display Click Ad Group Name
First Display Click Browser
First Display Click Campaign ID
First Display Click Campaign Name
First Display Click Creative ID
First Display Click Creative Name
First Display Click Device Type
First Display Click OS
First Display Click OS Family
First Display Click Time
First Display Click Time (UTC)
First Impression Ad Environment
First Impression Ad Format
First Impression Ad Group ID
First Impression Ad Group Name
First Impression Browser
First Impression Campaign ID
First Impression Campaign Name
First Impression Creative ID
First Impression Creative Name
First Impression Device Type
First Impression OS
First Impression OS Family
First Impression Time
First Impression Time (UTC)
First Non-Display Click Ad Environment
First Non-Display Click Browser
First Non-Display Click Campaign ID
First Non-Display Click Campaign Name
First Non-Display Click Device Type
First Non-Display Click Keyword
First Non-Display Click Keyword ID
First Non-Display Click OS
First Non-Display Click OS Family
First Non-Display Click Time
First Non-Display Click Time (UTC)
Internet Connection Type
Last Display Click Ad Environment
Last Display Click Ad Format
Last Display Click Ad Group ID
Last Display Click Ad Group Name
Last Display Click Browser
Last Display Click Campaign ID
Last Display Click Campaign Name
Last Display Click Creative ID
Last Display Click Creative Name
Last Display Click Device Type
Last Display Click OS
Last Display Click OS Family
Last Display Click Time
Last Display Click Time (UTC)
Last Impression Ad Environment
Last Impression Ad Format
Last Impression Ad Group ID
Last Impression Ad Group Name
Last Impression Browser
Last Impression Campaign ID
Last Impression Campaign Name
Last Impression Country
Last Impression Creative ID
Last Impression Creative Name
Last Impression Device Type
Last Impression Fcap
Last Impression Frequency
Last Impression Metro Name
Last Impression OS
Last Impression OS Family
Last Impression Region
Last Impression Site
Last Impression Time
Last Impression Time (UTC)
Last Non-Display Click Ad Environment
Last Non-Display Click Browser
Last Non-Display Click Campaign ID
Last Non-Display Click Campaign Name
Last Non-Display Click Device Type
Last Non-Display Click Keyword
Last Non-Display Click Keyword ID
Last Non-Display Click OS
Last Non-Display Click OS Family
Last Non-Display Click Time
Last Non-Display Click Time (UTC)
Media Type
Miaozhen Demographic Name
Miaozhen Monitoring Product
Miaozhen Reporting Market
Monetary Value Currency
Normalized Referrer URL
Order ID
Potential Spend Advertiser Currency Code
Report Date
Supply Vendor Publisher ID
TD1
TD10
TD2
TD3
TD4
TD5
TD6
TD7
TD8
TD9
TDID
Third-Party Ad Server ID
Third-Party Ad Server Name
Tracking Tag Type
TTD Seller Id
Zip
Metrics
Ad Server Last Click Count
Ad Server Last View Count
Additional Fee Cost (Adv Currency)
Additional Fee Cost (Partner Currency)
Additional Fee Cost Component (Adv Currency)
Additional Fee Cost Component (Partner Currency)
Data Cost Component (Partner Currency)
Data Cost Component (Adv Currency)
Display Click Count
Fee Amount (Partner Currency)
Fee Amount (Adv Currency)
Fee Features Cost Component (Partner Currency)
Fee Features Cost Component (Adv Currency)
Frequency per Household
Frequency per Person
Frequency per Unique ID
Hit Count
Hypothetical All Last Click + View CPA (Partner Currency)
Hypothetical All Last Click + View CPA (Adv Currency)
Impression Count
Media Cost Component (Partner Currency)
Media Cost Component (Adv Currency)
Miaozhen On Target Click Percent
Miaozhen On Target Clicks
Miaozhen On Target Impression Percent
Miaozhen On Target Impressions
Miaozhen On Target Unique Click Percent
Miaozhen On Target Unique Clicks
Miaozhen On Target Unique Impression Percent
Miaozhen On Target Unique Impressions
Miaozhen Total Clicks
Miaozhen Total Impressions
Miaozhen Total Unique Clicks
Miaozhen Total Unique Impressions
Monetary Value
Non-Display Click Count
On-Target Impressions
On-Target Percent
Potential Impressions
Potential Spend (Adv Currency)
Predictive Clearing Savings (Partner Currency)
Predictive Clearing Savings (Adv Currency)
Revenue
TTD Margin (Partner Currency)
TTD Margin (Adv Currency)
Unique Households
Unique Persons
Unique Users
White Ops SIVT Bids Avoided
Grains
Ad Group ID
Ad Group Integer ID
Advertiser ID
Advertiser Integer ID
Audience ID
Campaign ID
Campaign Integer ID
Campaign PO
Creative ID
Creative Integer ID
Inventory Contract ID
IO Contract Number
Matched Site List ID
Partner ID
Partner Integer ID
Grains
Ads.txt Seller Type
App
Category Hierarchy
Category ID
Category Name
Content Duration (in Minutes)
Deal ID
Fold
Fold Bid Factor
Genre
Inventory Contract
Inventory Contract Billing
Inventory Contract Created By
Inventory Contract Created On Date (UTC)
Inventory Contract Currency Code
Inventory Contract End Date (UTC)
Inventory Contract Is Archived
Inventory Contract Owner
Inventory Contract Start Date (UTC)
Inventory Contract Type
Livestream
Matched Fold Position
Seller Domain
Seller Name
Site
Site List Name
Site/Category Bid Factor
Supply Vendor
Supply Vendor Integer ID
Whitelist Site
Grains
City
Country
Factual Proximity Design Name
Factual Proximity Targeting Code
Metro
Metro Code
Region
Region Level One
Metrics
Margin (Partner Currency)
Margin (Adv Currency)
Profit (Partner Currency)
Profit (Adv Currency)
Grains
Native Context Type
Native Placement Type
Grains
Creative Duration (in seconds)
Video Playback Type
Metrics
eCPCV (Partner Currency)
eCPCV (Adv Currency)
Hypothetical eCPCV (Partner Currency)
Hypothetical eCPCV (Adv Currency)
In-banner Player Impressions
Large Player Impressions
Medium Player Impressions
Player 25% Complete
Player 50% Complete
Player 75% Complete
Player Close
Player Collapse
Player Completed Views
Player Completion Rate
Player Engaged Views
Player Errors
Player Expansion
Player Full Screen
Player Invitation Accept
Player Mute
Player Pause
Player Playing Event
Player Resume
Player Rewind
Player Skip
Player Starts
Player Total Playing Seconds
Player Unmute
Player Views
Small Player Impressions
Total Seconds in View
Video In-view Event
Grains
Date
Month
Month of Year
Month of Year (UTC)
Month (UTC)
Report Hour
Report Hour (UTC)
Timezone
User Day of Week
User Hour of Day
User Hour of Week
Year
Year (UTC)
Metrics
Advertiser Viewable CPM (vCPM) (Adv Currency)
Advertiser Viewable CPM (vCPM) (Partner Currency)
DoubleVerify Display Impression Served Delivery Activity
DoubleVerify IAB Video Viewable (1st Quartile)
DoubleVerify IAB Video Viewable (1st Quartile) Rate
DoubleVerify IAB Video Viewable (2nd Quartile)
DoubleVerify IAB Video Viewable (2nd Quartile) Rate
DoubleVerify IAB Video Viewable (3rd Quartile)
DoubleVerify IAB Video Viewable (3rd Quartile) Rate
DoubleVerify IAB Video Viewable (4th Quartile)
DoubleVerify IAB Video Viewable (4th Quartile) Rate
DoubleVerify IAB Viewable (at 10 Seconds)
DoubleVerify IAB Viewable (at 10 Seconds) Rate
DoubleVerify IAB Viewable (at 15 Seconds)
DoubleVerify IAB Viewable (at 15 Seconds) Rate
DoubleVerify IAB Viewable (at 5 Seconds)
DoubleVerify IAB Viewable (at 5 Seconds) Rate
DoubleVerify Video Impression Served Delivery Activity
Hypothetical Advertiser Viewable CPM (vCPM) (Partner Currency)
Hypothetical Advertiser Viewable CPM (vCPM) (Adv Currency)
Hypothetical Partner Viewable CPM (vCPM) (Partner Currency)
Hypothetical Partner Viewable CPM (vCPM) (Adv Currency)
IAS Display Fully In View (0 Seconds)
IAS Display Fully In View (0 Seconds) Rate
IAS Display Fully In View (1 Second)
IAS Display Fully In View (1 Second) Rate
IAS Display Fully In View (15 Seconds)
IAS Display Fully In View (15 Seconds) Rate
IAS Display Fully In View (5 Seconds)
IAS Display Fully In View (5 Seconds) Rate
IAS Display In View (1 Second)
IAS Display In View (1 Second) Rate
IAS Display In View (15 Seconds)
IAS Display In View (15 Seconds) Rate
IAS Display In View (5 Seconds)
IAS Display In View (5 Seconds) Rate
IAS High Risk Impression Count
IAS High Risk Impression Rate
IAS Low Risk Impression Count
IAS Low Risk Impression Rate
IAS Moderate Risk Impression Count
IAS Moderate Risk Impression Rate
IAS Non GIVT Impression Count
IAS Suspicious Activity
IAS Suspicious Activity Rate
IAS Total Impression Count
IAS Very High Risk Impression Count
IAS Very High Risk Impression Rate
IAS Video 25% Complete
IAS Video 25% Completed Rate
IAS Video 50% Complete
IAS Video 50% Completed Rate
IAS Video 75% Complete
IAS Video 75% Completed Rate
IAS Video Completed Views
IAS Video Completed Views Rate
IAS Video Muted
IAS Video Viewable 25% Complete
IAS Video Viewable 25% Completed Rate
IAS Video Viewable 50% Complete
IAS Video Viewable 50% Completed Rate
IAS Video Viewable 75% Complete
IAS Video Viewable 75% Completed Rate
IAS Video Viewable Completed Views
IAS Video Viewable Completed Views Rate
MOAT Display In View Time (10 Seconds)
MOAT Display In View Time (10 Seconds) Rate
MOAT Display In View Time (15 Seconds)
MOAT Display In View Time (15 Seconds) Rate
MOAT Display In View Time (30 Seconds)
MOAT Display In View Time (30 Seconds) Rate
MOAT Display In View Time (5 Seconds)
MOAT Display In View Time (5 Seconds) Rate
MOAT Display On Screen
MOAT Display On Screen Rate
MOAT Display Universal Interaction
MOAT Display Universal Interaction Rate
MOAT Display Universal Interaction Time (10 Seconds)
MOAT Display Universal Interaction Time (15 Seconds)
MOAT Display Universal Interaction Time (30 Seconds)
MOAT Display Universal Interaction Time (5 Seconds)
MOAT Video Audible and Visible on Complete
MOAT Video Audible and Visible on Complete Rate
MOAT Video In View Time (3 Seconds)
MOAT Video In View Time (5 Seconds)
MOAT Video Visible on Complete
MOAT Video Visible on Complete Rate
Partner Viewable CPM (vCPM) (Partner Currency)
Partner Viewable CPM (vCPM) (Adv Currency)
Sampled In-view Rate
Sampled Tracked Impressions
Sampled Viewed Impressions
Grains
Temperature Bucket End (in Celsius)
Temperature Bucket Name
Temperature Bucket Start (in Celsius)
Weather Condition