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

IDTypeNameDescriptionReport
advertiserTEXTAdvertiser nameThe name of the advertiser.Advertiser
advertiser_attribution_click_lookback_window_in_secondsTEXTAdvertiser Attribution Click Lookback Window In SecondsAdvertiser Attribution Click Lookback Window In SecondsAdvertiser
advertiser_attribution_impression_lookback_window_in_secondsTEXTAdvertiser Attribution Impression Lookback Window In SecondsAdvertiser Attribution Impression Lookback Window In SecondsAdvertiser
advertiser_availabilityTEXTAvailability of advertiserAvailability state of the Advertiser.Advertiser
advertiser_click_dedup_window_in_secondsTEXTAdvertiser Click Dedup Window In SecondsAdvertiser Click Dedup Window In SecondsAdvertiser
advertiser_conversion_dedup_window_in_secondsTEXTAdvertiser Conversion Dedup Window In SecondsAdvertiser Conversion Dedup Window In SecondsAdvertiser
advertiser_currency_codeTEXTAdvertiser Currency CodeAdvertiser Currency CodeAdvertiser
advertiser_default_right_media_offer_type_idTEXTAdvertiser Default Right Media Offer Type IdAdvertiser Default Right Media Offer Type IdAdvertiser
advertiser_descriptionTEXTDescription of advertiserAn optional description of the advertiser.Advertiser
advertiser_domainTEXTDomain of advertiserThe domain address for the Advertiser.Advertiser
advertiser_idTEXTAdvertiser IDThe platform ID of the advertiser.Advertiser
advertiser_ignore_referral_url_in_conversionTEXTAdvertiser Ignore Referral Url In ConversionAdvertiser Ignore Referral Url In ConversionAdvertiser
advertiser_industry_category_idTEXTAdvertiser Industry Category IdAdvertiser Industry Category IdAdvertiser
advertiser_industry_category_mapping_category_idTEXTAdvertiser Industry Category Mapping Category IdAdvertiser Industry Category Mapping Category IdAdvertiser
advertiser_industry_category_mapping_category_taxonomy_idTEXTAdvertiser Industry Category Mapping Category Taxonomy IdAdvertiser Industry Category Mapping Category Taxonomy IdAdvertiser
advertiser_industry_category_mapping_external_idTEXTAdvertiser Industry Category Mapping External IdAdvertiser Industry Category Mapping External IdAdvertiser
advertiser_industry_category_taxonomy_idTEXTAdvertiser Industry Category Taxonomy IdAdvertiser Industry Category Taxonomy IdAdvertiser
advertiser_is_ballot_measureTEXTAdvertiser Is Ballot MeasureAdvertiser Is Ballot MeasureAdvertiser
advertiser_is_candidate_electionTEXTAdvertiser Is Candidate ElectionAdvertiser Is Candidate ElectionAdvertiser
advertiser_keywordsTEXTKeywords of advertiserKeywords that classify the Advertiser.Advertiser
TEXTLogo of advertiserThe URL for the Advertiser's logo or brand image.Advertiser
advertiser_vetting_statusTEXTVetting status of advertiserVetting status of the advertiser.Advertiser
campaignTEXTCampaignThe Campaign NameCampaign
campaign_auto_allocator_enabledTEXTCampaign Auto Allocator EnabledCampaign Auto Allocator EnabledCampaign
campaign_auto_prioritization_enabledTEXTCampaign Auto Prioritization EnabledCampaign Auto Prioritization EnabledCampaign
campaign_availabilityTEXTCampaign AvailabilityCampaign AvailabilityCampaign
campaign_budgetNUMERICBudget of campaignThe maximum amount the Campaign may spend.Campaign
campaign_budget_currency_codeTEXTCampaign Budget Currency CodeCampaign Budget Currency CodeCampaign
campaign_budget_impressionsNUMERICBudget for impressions of campaignThe maximum amount of impressions the Campaign should buy.Campaign
campaign_campaign_flight_idTEXTCampaign Campaign Flight IdCampaign Campaign Flight IdCampaign Metrics
campaign_campaign_typeTEXTCampaign Campaign TypeCampaign Campaign TypeCampaign
campaign_created_at_utcTIMESTAMPCampaign Created At UTCCampaign Created At UTCCampaign
campaign_creation_timeTIMESTAMPCreation time of campaignThe time in UTC the Campaign was created.Campaign
campaign_ctv_targeting_and_attributionTEXTCampaign Ctv Targeting And AttributionCampaign Ctv Targeting And AttributionCampaign
campaign_custom_cp_aclick_weightTEXTCampaign Custom Cp Aclick WeightCampaign Custom Cp Aclick WeightCampaign
campaign_custom_cp_atypeTEXTCampaign Custom Cp AtypeCampaign Custom Cp AtypeCampaign
campaign_custom_cp_aviewthrough_weightTEXTCampaign Custom Cp Aviewthrough WeightCampaign Custom Cp Aviewthrough WeightCampaign
campaign_custom_cpa_click_weightNUMERICCustom CPA click weightWeight to assign to click through pixels when calculating Custom CPA.Campaign
campaign_custom_ro_as_typeTEXTCampaign Custom Ro As TypeCampaign Custom Ro As TypeCampaign
campaign_custom_viewthroug_weightNUMERICCustom CPA viewthroug weightWeight to assign to view pixels when calculating Custom CPA.Campaign
campaign_daily_budgetNUMERICDaily budget udget of campaignThe maximum amount that the campaign should spend per day, if possible.Campaign
campaign_daily_budget_impressionsNUMERICBudget for impressions of compaig dailyThe total number of impressions the Campaign should buy in a single day, if able.Campaign
campaign_descriptionTEXTCampaign descriptionAn optional description of the Campaign.Campaign
campaign_end_dateDATEEnd date of campaignThe date and time (in UTC) that the Campaign should stop spending if it has not yet exhausted its budget.Campaign
campaign_frequency_settings_frequency_capTEXTCampaign Frequency Settings Frequency CapCampaign Frequency Settings Frequency CapCampaign
campaign_frequency_settings_frequency_period_in_minutesNUMERICCampaign Frequency Settings Frequency Period In MinutesCampaign Frequency Settings Frequency Period In MinutesCampaign
campaign_frequency_settings_lifetime_frequency_capTEXTCampaign Frequency Settings Lifetime Frequency CapCampaign Frequency Settings Lifetime Frequency CapCampaign
campaign_goal_info_cp_min_advertiser_currency_amountNUMERICCampaign Goal Info Cp Min Advertiser Currency AmountCampaign Goal Info Cp Min Advertiser Currency AmountCampaign Metrics
campaign_goal_info_cp_min_advertiser_currency_currency_codeTEXTCampaign Goal Info Cp Min Advertiser Currency Currency CodeCampaign Goal Info Cp Min Advertiser Currency Currency CodeCampaign Metrics
campaign_goal_info_impressionsNUMERICCampaign Goal Info ImpressionsCampaign Goal Info ImpressionsCampaign Metrics
campaign_goal_info_last_calculated_atTIMESTAMPCampaign Goal Info Last Calculated AtCampaign Goal Info Last Calculated AtCampaign Metrics
campaign_idTEXTCampaign IDThe ID of the Campaign.Campaign
campaign_is_ballot_measureTEXTCampaign Is Ballot MeasureCampaign Is Ballot MeasureCampaign
campaign_last_updated_at_utcTIMESTAMPCampaign Last Updated At UTCCampaign Last Updated At UTCCampaign
campaign_minimum_ad_group_spend_in_advertiser_currencyNUMERICCampaign Minimum Ad Group Spend In Advertiser CurrencyCampaign Minimum Ad Group Spend In Advertiser CurrencyCampaign
campaign_objectiveTEXTObjectiv of campaign.The campaign objective.Campaign
campaign_pacing_advertiser_currencyTEXTCampaign Pacing Advertiser CurrencyCampaign Pacing Advertiser CurrencyCampaign Metrics
campaign_pacing_current_spend_in_advertiser_currencyNUMERICCampaign Pacing Current Spend In Advertiser CurrencyCampaign Pacing Current Spend In Advertiser CurrencyCampaign Metrics
campaign_pacing_flight_budget_in_advertiser_currencyNUMERICCampaign Pacing Flight Budget In Advertiser CurrencyCampaign Pacing Flight Budget In Advertiser CurrencyCampaign Metrics
campaign_pacing_last_calculated_atTIMESTAMPCampaign Pacing Last Calculated AtCampaign Pacing Last Calculated AtCampaign Metrics
campaign_pacing_modeTEXTCampaign Pacing ModeCampaign Pacing ModeCampaign
campaign_pacing_projected_spend_in_advertiser_currencyNUMERICCampaign Pacing Projected Spend In Advertiser CurrencyCampaign Pacing Projected Spend In Advertiser CurrencyCampaign Metrics
campaign_partner_cost_percentage_feeNUMERICCampaign Partner Cost Percentage FeeCampaign Partner Cost Percentage FeeCampaign
campaign_partner_cp_cfee_amountNUMERICCampaign Partner Cp Cfee AmountCampaign Partner Cp Cfee AmountCampaign
campaign_partner_cp_cfee_currency_codeTEXTCampaign Partner Cp Cfee Currency CodeCampaign Partner Cp Cfee Currency CodeCampaign
campaign_partner_cp_mfee_amountNUMERICCampaign Partner Cp Mfee AmountCampaign Partner Cp Mfee AmountCampaign
campaign_partner_cp_mfee_currency_codeTEXTCampaign Partner Cp Mfee Currency CodeCampaign Partner Cp Mfee Currency CodeCampaign
campaign_primary_channelTEXTPrimary channel of campaign.The campaign primary channel.Campaign
campaign_primary_goal_cp_cin_advertiser_currency_amountNUMERICCampaign Primary Goal Cp Cin Advertiser Currency AmountCampaign Primary Goal Cp Cin Advertiser Currency AmountCampaign
campaign_primary_goal_cp_cin_advertiser_currency_currency_codeTEXTCampaign Primary Goal Cp Cin Advertiser Currency Currency CodeCampaign Primary Goal Cp Cin Advertiser Currency Currency CodeCampaign
campaign_purchase_order_numberTEXTPurchase 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_percentPERCENTCampaign Secondary Goal Ct Rin PercentCampaign Secondary Goal Ct Rin PercentCampaign
campaign_start_dateDATEStart date of campaignThe date and time (in UTC) that the Campaign should start spending.Campaign
campaign_time_zoneTEXTCampaign Time ZoneCampaign Time ZoneCampaign
campaign_typeTEXTType of campaign.The type of the Campaign, options are currently either Standard (default) or ProgrammaticGuaranteed.Campaign
campaign_update_timeTIMESTAMPLast update time of campagin.The time in UTC the Campaign was last updated.Campaign
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe DateGeneral
media_typeTEXTPrimary channel of campaign. (alias for campaign_primary_channel)The campaign primary channel.Campaign
partner_idTEXTPartner IDThe ID of the partner who owns this advertiser.General
partner_id_integerNUMERICPartner Id IntegerThe id integer of the partner who owns this advertiser.General
partner_nameTEXTPartner NameThe name of the partner who owns this advertiser.General
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date