Windsor brings all your The Trade Desk data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
The Trade Desk Field Reference
Sample
The The Trade Desk connector fetches TTD data on a advertiser and campaign level.
A sample URL on how to query data:
https://connectors.windsor.ai/tradedesk?=[API_KEY]&date_preset=last_7d&fields=campaign,date,campaign_budget,campaign_budget_impressions,advertiser
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| advertiser | TEXT | Advertiser name | The name of the advertiser. | Advertiser |
| advertiser_attribution_click_lookback_window_in_seconds | TEXT | Advertiser Attribution Click Lookback Window In Seconds | Advertiser Attribution Click Lookback Window In Seconds | Advertiser |
| advertiser_attribution_impression_lookback_window_in_seconds | TEXT | Advertiser Attribution Impression Lookback Window In Seconds | Advertiser Attribution Impression Lookback Window In Seconds | Advertiser |
| advertiser_availability | TEXT | Availability of advertiser | Availability state of the Advertiser. | Advertiser |
| advertiser_click_dedup_window_in_seconds | TEXT | Advertiser Click Dedup Window In Seconds | Advertiser Click Dedup Window In Seconds | Advertiser |
| advertiser_conversion_dedup_window_in_seconds | TEXT | Advertiser Conversion Dedup Window In Seconds | Advertiser Conversion Dedup Window In Seconds | Advertiser |
| advertiser_currency_code | TEXT | Advertiser Currency Code | Advertiser Currency Code | Advertiser |
| advertiser_default_right_media_offer_type_id | TEXT | Advertiser Default Right Media Offer Type Id | Advertiser Default Right Media Offer Type Id | Advertiser |
| advertiser_description | TEXT | Description of advertiser | An optional description of the advertiser. | Advertiser |
| advertiser_domain | TEXT | Domain of advertiser | The domain address for the Advertiser. | Advertiser |
| advertiser_id | TEXT | Advertiser ID | The platform ID of the advertiser. | Advertiser |
| advertiser_ignore_referral_url_in_conversion | TEXT | Advertiser Ignore Referral Url In Conversion | Advertiser Ignore Referral Url In Conversion | Advertiser |
| advertiser_industry_category_id | TEXT | Advertiser Industry Category Id | Advertiser Industry Category Id | Advertiser |
| advertiser_industry_category_mapping_category_id | TEXT | Advertiser Industry Category Mapping Category Id | Advertiser Industry Category Mapping Category Id | Advertiser |
| advertiser_industry_category_mapping_category_taxonomy_id | TEXT | Advertiser Industry Category Mapping Category Taxonomy Id | Advertiser Industry Category Mapping Category Taxonomy Id | Advertiser |
| advertiser_industry_category_mapping_external_id | TEXT | Advertiser Industry Category Mapping External Id | Advertiser Industry Category Mapping External Id | Advertiser |
| advertiser_industry_category_taxonomy_id | TEXT | Advertiser Industry Category Taxonomy Id | Advertiser Industry Category Taxonomy Id | Advertiser |
| advertiser_is_ballot_measure | TEXT | Advertiser Is Ballot Measure | Advertiser Is Ballot Measure | Advertiser |
| advertiser_is_candidate_election | TEXT | Advertiser Is Candidate Election | Advertiser Is Candidate Election | Advertiser |
| advertiser_keywords | TEXT | Keywords of advertiser | Keywords that classify the Advertiser. | Advertiser |
| advertiser_logo | TEXT | Logo of advertiser | The URL for the Advertiser's logo or brand image. | Advertiser |
| advertiser_vetting_status | TEXT | Vetting status of advertiser | Vetting status of the advertiser. | Advertiser |
| campaign | TEXT | Campaign | The Campaign Name | Campaign |
| campaign_auto_allocator_enabled | TEXT | Campaign Auto Allocator Enabled | Campaign Auto Allocator Enabled | Campaign |
| campaign_auto_prioritization_enabled | TEXT | Campaign Auto Prioritization Enabled | Campaign Auto Prioritization Enabled | Campaign |
| campaign_availability | TEXT | Campaign Availability | Campaign Availability | Campaign |
| campaign_budget | NUMERIC | Budget of campaign | The maximum amount the Campaign may spend. | Campaign |
| campaign_budget_currency_code | TEXT | Campaign Budget Currency Code | Campaign Budget Currency Code | Campaign |
| campaign_budget_impressions | NUMERIC | Budget for impressions of campaign | The maximum amount of impressions the Campaign should buy. | Campaign |
| campaign_campaign_flight_id | TEXT | Campaign Campaign Flight Id | Campaign Campaign Flight Id | Campaign Metrics |
| campaign_campaign_type | TEXT | Campaign Campaign Type | Campaign Campaign Type | Campaign |
| campaign_created_at_utc | TIMESTAMP | Campaign Created At UTC | Campaign Created At UTC | Campaign |
| campaign_creation_time | TIMESTAMP | Creation time of campaign | The time in UTC the Campaign was created. | Campaign |
| campaign_ctv_targeting_and_attribution | TEXT | Campaign Ctv Targeting And Attribution | Campaign Ctv Targeting And Attribution | Campaign |
| campaign_custom_cp_aclick_weight | TEXT | Campaign Custom Cp Aclick Weight | Campaign Custom Cp Aclick Weight | Campaign |
| campaign_custom_cp_atype | TEXT | Campaign Custom Cp Atype | Campaign Custom Cp Atype | Campaign |
| campaign_custom_cp_aviewthrough_weight | TEXT | Campaign Custom Cp Aviewthrough Weight | Campaign Custom Cp Aviewthrough Weight | Campaign |
| campaign_custom_cpa_click_weight | NUMERIC | Custom CPA click weight | Weight to assign to click through pixels when calculating Custom CPA. | Campaign |
| campaign_custom_ro_as_type | TEXT | Campaign Custom Ro As Type | Campaign Custom Ro As Type | Campaign |
| campaign_custom_viewthroug_weight | NUMERIC | Custom CPA viewthroug weight | Weight to assign to view pixels when calculating Custom CPA. | Campaign |
| campaign_daily_budget | NUMERIC | Daily budget udget of campaign | The maximum amount that the campaign should spend per day, if possible. | Campaign |
| campaign_daily_budget_impressions | NUMERIC | Budget for impressions of compaig daily | The total number of impressions the Campaign should buy in a single day, if able. | Campaign |
| campaign_description | TEXT | Campaign description | An optional description of the Campaign. | Campaign |
| campaign_end_date | DATE | End date of campaign | The date and time (in UTC) that the Campaign should stop spending if it has not yet exhausted its budget. | Campaign |
| campaign_frequency_settings_frequency_cap | TEXT | Campaign Frequency Settings Frequency Cap | Campaign Frequency Settings Frequency Cap | Campaign |
| campaign_frequency_settings_frequency_period_in_minutes | NUMERIC | Campaign Frequency Settings Frequency Period In Minutes | Campaign Frequency Settings Frequency Period In Minutes | Campaign |
| campaign_frequency_settings_lifetime_frequency_cap | TEXT | Campaign Frequency Settings Lifetime Frequency Cap | Campaign Frequency Settings Lifetime Frequency Cap | Campaign |
| campaign_goal_info_cp_min_advertiser_currency_amount | NUMERIC | Campaign Goal Info Cp Min Advertiser Currency Amount | Campaign Goal Info Cp Min Advertiser Currency Amount | Campaign Metrics |
| campaign_goal_info_cp_min_advertiser_currency_currency_code | TEXT | Campaign Goal Info Cp Min Advertiser Currency Currency Code | Campaign Goal Info Cp Min Advertiser Currency Currency Code | Campaign Metrics |
| campaign_goal_info_impressions | NUMERIC | Campaign Goal Info Impressions | Campaign Goal Info Impressions | Campaign Metrics |
| campaign_goal_info_last_calculated_at | TIMESTAMP | Campaign Goal Info Last Calculated At | Campaign Goal Info Last Calculated At | Campaign Metrics |
| campaign_id | TEXT | Campaign ID | The ID of the Campaign. | Campaign |
| campaign_is_ballot_measure | TEXT | Campaign Is Ballot Measure | Campaign Is Ballot Measure | Campaign |
| campaign_last_updated_at_utc | TIMESTAMP | Campaign Last Updated At UTC | Campaign Last Updated At UTC | Campaign |
| campaign_minimum_ad_group_spend_in_advertiser_currency | NUMERIC | Campaign Minimum Ad Group Spend In Advertiser Currency | Campaign Minimum Ad Group Spend In Advertiser Currency | Campaign |
| campaign_objective | TEXT | Objectiv of campaign. | The campaign objective. | Campaign |
| campaign_pacing_advertiser_currency | TEXT | Campaign Pacing Advertiser Currency | Campaign Pacing Advertiser Currency | Campaign Metrics |
| campaign_pacing_current_spend_in_advertiser_currency | NUMERIC | Campaign Pacing Current Spend In Advertiser Currency | Campaign Pacing Current Spend In Advertiser Currency | Campaign Metrics |
| campaign_pacing_flight_budget_in_advertiser_currency | NUMERIC | Campaign Pacing Flight Budget In Advertiser Currency | Campaign Pacing Flight Budget In Advertiser Currency | Campaign Metrics |
| campaign_pacing_last_calculated_at | TIMESTAMP | Campaign Pacing Last Calculated At | Campaign Pacing Last Calculated At | Campaign Metrics |
| campaign_pacing_mode | TEXT | Campaign Pacing Mode | Campaign Pacing Mode | Campaign |
| campaign_pacing_projected_spend_in_advertiser_currency | NUMERIC | Campaign Pacing Projected Spend In Advertiser Currency | Campaign Pacing Projected Spend In Advertiser Currency | Campaign Metrics |
| campaign_partner_cost_percentage_fee | NUMERIC | Campaign Partner Cost Percentage Fee | Campaign Partner Cost Percentage Fee | Campaign |
| campaign_partner_cp_cfee_amount | NUMERIC | Campaign Partner Cp Cfee Amount | Campaign Partner Cp Cfee Amount | Campaign |
| campaign_partner_cp_cfee_currency_code | TEXT | Campaign Partner Cp Cfee Currency Code | Campaign Partner Cp Cfee Currency Code | Campaign |
| campaign_partner_cp_mfee_amount | NUMERIC | Campaign Partner Cp Mfee Amount | Campaign Partner Cp Mfee Amount | Campaign |
| campaign_partner_cp_mfee_currency_code | TEXT | Campaign Partner Cp Mfee Currency Code | Campaign Partner Cp Mfee Currency Code | Campaign |
| campaign_primary_channel | TEXT | Primary channel of campaign. | The campaign primary channel. | Campaign |
| campaign_primary_goal_cp_cin_advertiser_currency_amount | NUMERIC | Campaign Primary Goal Cp Cin Advertiser Currency Amount | Campaign Primary Goal Cp Cin Advertiser Currency Amount | Campaign |
| campaign_primary_goal_cp_cin_advertiser_currency_currency_code | TEXT | Campaign Primary Goal Cp Cin Advertiser Currency Currency Code | Campaign Primary Goal Cp Cin Advertiser Currency Currency Code | Campaign |
| campaign_purchase_order_number | TEXT | Purchase order number of campaign. | A property that you can use for internal reference. For example, a Purchase Order Number. | Campaign |
| campaign_secondary_goal_ct_rin_percent | PERCENT | Campaign Secondary Goal Ct Rin Percent | Campaign Secondary Goal Ct Rin Percent | Campaign |
| campaign_start_date | DATE | Start date of campaign | The date and time (in UTC) that the Campaign should start spending. | Campaign |
| campaign_time_zone | TEXT | Campaign Time Zone | Campaign Time Zone | Campaign |
| campaign_type | TEXT | Type of campaign. | The type of the Campaign, options are currently either Standard (default) or ProgrammaticGuaranteed. | Campaign |
| campaign_update_time | TIMESTAMP | Last update time of campagin. | The time in UTC the Campaign was last updated. | Campaign |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The Date | General |
| day_of_month | TEXT | Day of month | Day of the month | |
| media_type | TEXT | Primary channel of campaign. (alias for campaign_primary_channel) | The campaign primary channel. | Campaign |
| month | TEXT | Month | Number of the month | |
| partner_id | TEXT | Partner ID | The ID of the partner who owns this advertiser. | General |
| partner_id_integer | NUMERIC | Partner Id Integer | The id integer of the partner who owns this advertiser. | General |
| partner_name | TEXT | Partner Name | The name of the partner who owns this advertiser. | General |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |