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 |
|---|---|---|---|---|
| adformat_height | TEXT | Ad Format Height | The height in pixels. | Ad Format |
| adformat_id | TEXT | Ad Format ID | The ID of the Ad Format. | Ad Format |
| adformat_inventory_type | TEXT | Ad Format Inventory Type | An enumeration of the string type with the following values: Unknown, Display, Video, Native, Audio, NativeVideo | Ad Format |
| adformat_is_display_rtb_eligible | BOOLEAN | Ad Format Is Display RTB Eligible | Whether this Ad Format is supported in general display RTB. This must be true for display creatives of this size to serve in RTB Ad Groups. | Ad Format |
| adformat_name | TEXT | Ad Format Name | The name of the Ad Format. | Ad Format |
| adformat_width | TEXT | Ad Format Width | The width in pixels. | Ad Format |
| adgroup_advertiser_id | TEXT | Ad Group Advertiser ID | The platform ID of the advertiser that owns the Ad Group. | Ad Group |
| adgroup_are_future_koa_features_enabled | BOOLEAN | Ad Group Are Future Koa Features Enabled | Get whether future Koa features will be enabled for this Ad Group automatically. | Ad Group |
| adgroup_associated_bid_lists | TEXT | Ad Group Associated Bid Lists | The BidLists that are associated with this Ad Group. | Ad Group |
| adgroup_availability | TEXT | Ad Group Availability | Whether the ad group is active and available for normal operation or archived and hidden from normal view. If not specified, the default value is Available. | Ad Group |
| adgroup_budgeting_version | TEXT | Ad Group Budgeting Version | The budgeting used for the campaign that owns the ad group. This property is only returned if the budgeting version is Kokai. | Ad Group |
| adgroup_campaign_id | TEXT | Ad Group Campaign ID | The ID of the Campaign that owns this Ad Group. | Ad Group |
| adgroup_category_id | TEXT | Ad Group Category ID | The category ID of this Ad Group. | Ad Group |
| adgroup_category_mappings | TEXT | Ad Group Category Mappings | The mappings between the industry category taxonomies (IAB 1.0 and IAB 2.2). | Ad Group |
| adgroup_category_name | TEXT | Ad Group Category Name | The category name of this Ad Group. | Ad Group |
| adgroup_category_taxonomy_id | TEXT | Ad Group Category Taxonomy ID | The category ID of the taxonomy of this Ad Group. | Ad Group |
| adgroup_category_taxonomy_name | TEXT | Ad Group Category Taxonomy Name | The category name of the taxonomy of this Ad Group. | Ad Group |
| adgroup_category_taxonomy_version | TEXT | Ad Group Category Taxonomy Version | The category taxonomy version of this Ad Group. | Ad Group |
| adgroup_channel_id | TEXT | Ad Group Channel ID | The Channel ID for this Ad Group. | Ad Group |
| adgroup_created_at_utc | TIMESTAMP | Ad Group Created At UTC Timestamp | The date and time in UTC the ad group was created. | Ad Group |
| adgroup_current_and_future_additional_fee_cards | TEXT | Ad Group Current And Future Additional Fee Cards | The additional fee card that is currently active and future fee cards for ad group. | Ad Group |
| adgroup_custom_labels | TEXT | Ad Group Custom Labels | Custom Labels assigned to this Ad Group. | Ad Group |
| adgroup_description | TEXT | Ad Group Description | An optional description of the creative. The maximum character length is 512. | Ad Group |
| adgroup_enabled_value_added_providers | TEXT | Ad Group Enabled Value Added Providers | A list of third-party providers enabled to set rates and bill for their services rendered to the client managing this ad group. | Ad Group |
| adgroup_funnel_location | TEXT | Ad Group Funnel Location | The funnel location that identifies the focus or objective of the ad group. For details, see https://partner.thetradedesk.com/v3/portal/api/doc/KokaiAdGroup | Ad Group |
| adgroup_high_fill_base_bid_cpm_amount | NUMERIC | Ad Group High Fill Base Bid CPM Amount | The base bid CPM is automatically set to the floor price of the targeted contract. The value returned is the floor price in the currency of the Advertiser that owns the Ad Group. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_high_fill_base_bid_cpm_currency | TEXT | Ad Group High Fill Base Bid CPM Currency Code | The base bid CPM is automatically set to the floor price of the targeted contract. The value returned is the floor price in the currency of the Advertiser that owns the Ad Group. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_high_fill_budget_ad_group_flights | TEXT | Ad Group High Fill Budget Settings Ad Group Flights | The List of flights associated with this adgroup. | Ad Group |
| adgroup_high_fill_budget_amount | NUMERIC | Ad Group High Fill Budget Settings Amount | The total amount the ad group may spend over its lifetime. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_high_fill_budget_auto_allocator_priority | TEXT | Ad Group High Fill Budget Settings Auto Allocator Priority | The rank or priority that determines the order of which this ad group automatically receives spend from the campaign budget. | Ad Group |
| adgroup_high_fill_budget_currency | TEXT | Ad Group High Fill Budget Settings Currency Code | The total amount the ad group may spend over its lifetime. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_high_fill_budget_daily_budget_amount | NUMERIC | Ad Group High Fill Budget Settings Daily Budget Amount | The total amount the Ad Group should spend in a single day, if able. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_high_fill_budget_daily_budget_currency | TEXT | Ad Group High Fill Budget Settings Daily Budget Currency Code | The total amount the Ad Group should spend in a single day, if able. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_high_fill_budget_daily_budget_impressions | NUMERIC | Ad Group High Fill Budget Settings Daily Budget Impressions | The total number of impressions the Ad Group should serve in a single day, if able. This may only be set if the Ad Group has an impression budget. If you have an impression budget but do not wish to limit the daily impressions of the Ad Group, set this equal to the total Ad Group impression budget. NOTE: If you have pacing enabled, the Ad Group may serve more impressions than this in a given day if it needs to increase the average rate to meet overall pacing goals. In case of ad groups that have flights, this value will be determined based on the values from the AdGroupFlights, and may not be modified. | Ad Group |
| adgroup_high_fill_budget_impressions | NUMERIC | Ad Group High Fill Budget Settings Impressions | The total number of impressions the Ad Group may serve over its lifetime. This may only be set if the Campaign has an impression budget. The sum of the Ad Group impression budgets within a Campaign must not exceed the Campaign's impression budget. NOTE: An impression budget may not be set for an ad group with base bid auto-optimization enabled. If an impression budget is set for such an ad group, an error will be returned with http status 400 (BadRequest). In case of ad groups that have flights, this value will be determined based on the values from the AdGroupFlights, and may not be modified. | Ad Group |
| adgroup_high_fill_budget_max_bid_cpm_amount | NUMERIC | Ad Group High Fill Max Bid CPM Amount | The maximum bid CPM is automatically set to the floor price of the targeted contract. The value returned is the floor price in the currency of the Advertiser that owns the Ad Group. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_high_fill_budget_max_bid_cpm_currency | TEXT | Ad Group High Fill Max Bid CPM Currency Code | The maximum bid CPM is automatically set to the floor price of the targeted contract. The value returned is the floor price in the currency of the Advertiser that owns the Ad Group. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_high_fill_budget_pacing_mode | TEXT | Ad Group High Fill Budget Settings Pacing Mode | The pacing mode specifies how an ad group attempts to spend its budget over time. This parameter is required when an ad group is created and PacingEnabled is not set. When specified, PacingMode overrides the value of PacingEnabled. | Ad Group |
| adgroup_high_fill_creative_ids | TEXT | Ad Group High Fill Creative IDs | The complete list of Creative IDs the Ad Group can serve. If the Ad Group has no associated Creatives, it will not serve! | Ad Group |
| adgroup_high_fill_guaranteed_private_contract_id | TEXT | Ad Group High Fill Guaranteed Private Contract ID | The guaranteed-type Contract driving the High-Fill (a.k.a. Programmatic Guaranteed) Ad Group settings, which can be either a Programmatic Guaranteed Contract or a Publisher Direct Guaranteed Contract. Ad Group Base and Max Bid values are automatically set to the floor price of the Contract at the time of bidding. | Ad Group |
| adgroup_id | TEXT | Ad Group ID | The ID of this Ad Group. | Ad Group |
| adgroup_include_defaults_from_campaign | BOOLEAN | Ad Group Include Defaults From Campaign | The default value is false. If set to true, all default bid lists associated with the campaign are automatically applied this ad group upon its creation. If the same bid list is already applied to the ad group, it will be included only once. The applied lists can be removed, as needed. | Ad Group |
| adgroup_increments | TEXT | Ad Group Increments | A list of frequency CounterIds to increment based on impressions served for this ad group. | Ad Group |
| adgroup_is_enabled | BOOLEAN | Ad Group Is Enabled | Whether the Ad Group is enabled to spend. If this is not specified on create, the Ad Group will be disabled until it is explicitly enabled. | Ad Group |
| adgroup_is_high_fill_rate | BOOLEAN | Ad Group Is High Fill Rate | Whether the Ad Group is a high fill rate Ad Group. A high fill rate ad group allows for a limited set of attributes to be set in RTBAttributes and it may only target a single contract that must be a programmatic guaranteed high fill rate contract. | Ad Group |
| adgroup_marketplace_opt_out | BOOLEAN | Ad Group Is Marketplace Opt Out | When ad group is created in Kokai campaign and campaign Marketplace setting is on, it will be automatically opted into it. This flag allows to opt-out from this behavior. Applicable only on creation. Will not be returned when ad group information is returned. | Ad Group |
| adgroup_name | TEXT | Adgroup Name | The name of this Ad Group. | Ad Group |
| adgroup_new_bid_lists | TEXT | Ad Group New BidLists | The BidLists that will be created and associated with this AdGroup. If one of those bidlist is not valid it will fail the adgroup creation and update and they will need to be retried after correcting the offending bid list. | Ad Group |
| adgroup_new_frequency_configs | TEXT | Ad Group New Frequency Configs | Frequency configurations associated with this ad group. For concepts and details on configuring frequency settings, see https://partner.thetradedesk.com/v3/portal/api/doc/FrequencyConfigurationBasic | Ad Group |
| adgroup_predictive_clearing_enabled | BOOLEAN | Ad Group Is Predictive Clearing Enabled | If set to true, enables Koa to analyze historical clearing prices to find a lower, optimal bid for each impression served in a first-price auction. For details, see https://partner.thetradedesk.com/v3/portal/api/doc/PredictiveClearing . The default value for this property is false. | Ad Group |
| adgroup_rtb_audience_targeting_audience_id | TEXT | Ad Group RTB Attributes Audience Targeting Audience ID | The ID of the Audience to target. | Ad Group |
| adgroup_rtb_audience_targeting_audience_predictor_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Audience Predictor Enabled | Enabling Koa™ Audience Predictor automatically generates a lookalike audience targeting users known to be of high value based on the configured goal for the AdGroup. | Ad Group |
| adgroup_rtb_audience_targeting_audience_retargeting_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Audience Retargeting Enabled | Enabling this optimization will only include users determined to be high value, and will calculate bids for these users based off their scored value. | Ad Group |
| adgroup_rtb_audience_targeting_booster_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Booster Enabled | If set to true, adds more relevant, high-performing data segments that are similar to the advertiser's target audience. In other words, ads will be served only to users who benefit the campaign and are most likely to convert. IMPORTANT: To take advantage of this performance-enhancing functionality, the ad group must have CPA or ROAS goals. | Ad Group |
| adgroup_rtb_audience_targeting_cross_device_vendor_list_for_audience | TEXT | Ad Group RTB Attributes Audience Targeting Cross Device Vendor List For Audience | Cross-device data from your selected provider will be used to extend the reach of your Audience across devices. This provider’s data will also be used for f-capping at the Ad Group and Campaign level. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_country_code | TEXT | Ad Group RTB Attributes Audience Targeting Demographic Settings Country Code | The country (the code) that is being targeted for Nielsen analytics. See nielsen/reportingcountries api for a list of valid country codes. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_data_rate_type | TEXT | Ad Group RTB Attributes Audience Targeting Demographic Settings Data Rate Type | Specifies the DataRateType which is detailed in the TargetDemographicDataRateType enum. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Demographic Settings Enabled | Target specific demographic data that will be used to target segments of your Audience. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_end_age | TEXT | Ad Group RTB Attributes Audience Targeting Demographic Settings End Age | The end age being targeted for Nielsen analytics. The end age is required when Nielsen settings are specified for the first time. If this value is lower than the start age, the API will throw an error. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_gender | TEXT | Ad Group RTB Attributes Audience Targeting Demographic Settings Gender | The gender being targeted for Nielsen analytics. | Ad Group |
| adgroup_rtb_audience_targeting_demographic_settings_start_age | TEXT | Ad Group RTB Attributes Audience Targeting Demographic Settings Start Age | The start age being targeted for Nielsen analytics. The start age is required when Nielsen settings are specified for the first time. If this value is greater than the end age, the API will throw an error. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Excluder Enabled | If set to true, generates a custom audience for the ad group that excludes the less relevant data segments that are different from the advertiser's target audience. In other words, this custom audience excludes users who are less likely to benefit the campaign. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpc_rate_advertiser_amount | NUMERIC | Ad Group RTB Attributes Audience Targeting Excluder Fee CPC Rate In Advertiser Currency Amount | An approximation of the CPC rate in the Advertiser's currency. The actual amount charged will depend on exchange rates, but this serves as a guideline and will be accurate within normal currency fluctuations. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpc_rate_advertiser_currency | TEXT | Ad Group RTB Attributes Audience Targeting Excluder Fee CPC Rate In Advertiser Currency Code | An approximation of the CPC rate in the Advertiser's currency. The actual amount charged will depend on exchange rates, but this serves as a guideline and will be accurate within normal currency fluctuations. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpc_rate_amount | NUMERIC | Ad Group RTB Attributes Audience Targeting Excluder Fee CPC Rate Amount | The CPC rate in the currency the provider charges. At billing time, this will be used to determine the charge in the Advertiser's currency based on applicable exchange rates. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpc_rate_currency | TEXT | Ad Group RTB Attributes Audience Targeting Excluder Fee CPC Rate Currency Code | The CPC rate in the currency the provider charges. At billing time, this will be used to determine the charge in the Advertiser's currency based on applicable exchange rates. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpm_rate_advertiser_amount | NUMERIC | Ad Group RTB Attributes Audience Targeting Excluder Fee CPM Rate In Advertiser Currency Amount | An approximation of the CPM rate in the Advertiser's currency. The actual amount charged will depend on exchange rates, but this serves as a guideline and will be accurate within normal currency fluctuations. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpm_rate_advertiser_currency | TEXT | Ad Group RTB Attributes Audience Targeting Excluder Fee CPM Rate In Advertiser Currency Code | An approximation of the CPM rate in the Advertiser's currency. The actual amount charged will depend on exchange rates, but this serves as a guideline and will be accurate within normal currency fluctuations.. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpm_rate_amount | NUMERIC | Ad Group RTB Attributes Audience Targeting Excluder Fee CPM Rate Amount | The CPM rate in the currency the provider charges. At billing time, this will be used to determine the charge in the Advertiser's currency based on applicable exchange rates. The money amount, specified as a decimal, for example, 1.5 for $1.50. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_cpm_rate_currency | TEXT | Ad Group RTB Attributes Audience Targeting Excluder Fee CPM Rate Currency Code | The CPM rate in the currency the provider charges. At billing time, this will be used to determine the charge in the Advertiser's currency based on applicable exchange rates. The currency of the money value specified in the Amount, for example, 'USD' for $1.50 US dollars. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_percent_of_data_cost_rate | PERCENT | Ad Group RTB Attributes Audience Targeting Excluder Fee Percent Of Data Cost Rate | The Percent of Data Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_audience_targeting_excluder_fee_percent_of_media_cost_rate | PERCENT | Ad Group RTB Attributes Audience Targeting Excluder Fee Percent Of Media Cost Rate | The Percent of Media Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_audience_targeting_first_party_data_ids | TEXT | Ad Group RTB Attributes Audience Targeting Settings First Party Data IDs | A list of First Party Data Ids you would like to add to the audience in addition to the scored users data element. | Ad Group |
| adgroup_rtb_audience_targeting_interest_settings_category_id | TEXT | Ad Group RTB Attributes Audience Targeting Interest Settings Category ID | The ID of the interest category. | Ad Group |
| adgroup_rtb_audience_targeting_interest_settings_category_name | TEXT | Ad Group RTB Attributes Audience Targeting Interest Settings Category Name | The name of the interest category. | Ad Group |
| adgroup_rtb_audience_targeting_interest_settings_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Interest Settings Enabled | Target specific interest data that is most relevant to you. | Ad Group |
| adgroup_rtb_audience_targeting_recency_exclusion_window_in_minutes | TEXT | Ad Group RTB Attributes Audience Targeting Recency Exclusion Window In Minutes | The complement to Recency Adjustments, this is the amount of time to exclude users who are in the Excluded Data Groups of the Audience. | Ad Group |
| adgroup_rtb_audience_targeting_settings_customize_retargeting_audience | BOOLEAN | Ad Group RTB Attributes Audience Targeting Settings Customize Retargeting Audience | Whether to customize the retargeting audience | Ad Group |
| adgroup_rtb_audience_targeting_trackable_users_enabled | BOOLEAN | Ad Group RTB Attributes Audience Targeting Trackable Users Enabled | Enabling this optimization will restrict targeting to only trackable users (Users with a TDID) | Ad Group |
| adgroup_rtb_audience_targeting_use_mc_id_as_primary | BOOLEAN | Ad Group RTB Attributes Audience Targeting Use Mc ID As Primary | Base your primary audience targeting strategy on geo interest segments. | Ad Group |
| adgroup_rtb_basebidcpm_amount | NUMERIC | Ad Group RTB Attributes Base Bid CPM Amount | The base bid CPM to use before applying bid adjustments. | Ad Group |
| adgroup_rtb_basebidcpm_currencycode | TEXT | Ad Group RTB Attributes Base Bid CPM Currency Code | The base bid CPM to use before applying bid adjustments. Currency Code | Ad Group |
| adgroup_rtb_budgetsettings_adgroupflights | TEXT | Ad Group RTB Attributes Ad Group Flights | The List of flights associated with this adgroup. AdGroupFlights that are no longer active should not be modified. | Ad Group |
| adgroup_rtb_budgetsettings_autoallocatorpriority | TEXT | Ad Group RTB Attributes Auto Allocator Priority | The rank or priority that determines the order of which this ad group automatically receives spend from the campaign budget. | Ad Group |
| adgroup_rtb_budgetsettings_budget_amount | NUMERIC | Ad Group RTB Attributes Budget Amount | The total amount the ad group may spend over its lifetime. | Ad Group |
| adgroup_rtb_budgetsettings_budget_currencycode | TEXT | Ad Group RTB Attributes Budget Currency Code | The total amount the ad group may spend over its lifetime. Currency Code | Ad Group |
| adgroup_rtb_budgetsettings_budgetinimpressions | NUMERIC | Ad Group RTB Attributes Budget Impressions | The total number of impressions the Ad Group may serve over its lifetime. | Ad Group |
| adgroup_rtb_budgetsettings_dailybudget_amount | NUMERIC | Ad Group RTB Attributes Daily Budget Amount | The total amount the Ad Group should spend in a single day, if able. | Ad Group |
| adgroup_rtb_budgetsettings_dailybudget_currencycode | TEXT | Ad Group RTB Attributes Daily Budget Currency Code | The total amount the Ad Group should spend in a single day, if able. Currency Code | Ad Group |
| adgroup_rtb_budgetsettings_dailybudgetinimpressions | NUMERIC | Ad Group RTB Attributes Daily Budget Impressions | The total number of impressions the Ad Group should serve in a single day, if able. | Ad Group |
| adgroup_rtb_budgetsettings_pacingmode | TEXT | Ad Group RTB Attributes Pacing Mode | The pacing mode specifies how an ad group attempts to spend its budget over time. | Ad Group |
| adgroup_rtb_comscoresettings_demographicmemberids | TEXT | Ad Group RTB Attributes ComScore Settings Demographic Member IDs | The id(s) of the demographic members within the specified population for which the Comscore key metrics will be captured. | Ad Group |
| adgroup_rtb_comscoresettings_enabled | BOOLEAN | Ad Group RTB Attributes ComScore Settings Enabled | The field that indicates whether Comscore reporting has been enabled for the ad group. | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpcrate_amount | NUMERIC | Ad Group RTB Attributes ComScore Settings Fee CPC Rate Amount | The CPC rate in the currency the provider charges. | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpcrate_currencycode | TEXT | Ad Group RTB Attributes ComScore Settings Fee CPC Rate Currency Code | The CPC rate in the currency the provider charges. Currency Code | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpcrateinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ComScore Settings Fee CPC Rate Advertiser Amount | An approximation of the CPC rate in the Advertiser's currency. | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpcrateinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ComScore Settings Fee CPC Rate Advertiser Currency Code | An approximation of the CPC rate in the Advertiser's currency. Currency Code | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpmrate_amount | NUMERIC | Ad Group RTB Attributes ComScore Settings Fee CPM Rate Amount | The CPM rate in the currency the provider charges. | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpmrate_currencycode | TEXT | Ad Group RTB Attributes ComScore Settings Fee CPM Rate Currency Code | The CPM rate in the currency the provider charges. Currency Code | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpmrateinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ComScore Settings Fee CPM Rate Advertiser Amount | An approximation of the CPM rate in the Advertiser's currency. | Ad Group |
| adgroup_rtb_comscoresettings_fee_cpmrateinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ComScore Settings Fee CPM Rate Advertiser Currency Code | An approximation of the CPM rate in the Advertiser's currency. Currency Code | Ad Group |
| adgroup_rtb_comscoresettings_fee_percentofdatacostrate | PERCENT | Ad Group RTB Attributes ComScore Settings Fee Percent Of Data Cost Rate | The Percent of Data Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_comscoresettings_fee_percentofmediacostrate | PERCENT | Ad Group RTB Attributes ComScore Settings Fee Percent Of Media Cost Rate | The Percent of Media Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_comscoresettings_mobiledemographicmemberids | TEXT | Ad Group RTB Attributes ComScore Settings Mobile Demographic Member IDs | The id(s) of the demographic members within the specified population for which the Comscore key metrics will be captured. | Ad Group |
| adgroup_rtb_comscoresettings_populationid | TEXT | Ad Group RTB Attributes ComScore Settings Population ID | The Population Id (country) for which the Comscore key metrics will be captured. | Ad Group |
| adgroup_rtb_contracttargeting_allowopenmarketbiddingwhentargetingcontracts | BOOLEAN | Ad Group RTB Attributes Contract Targeting Allow Open Market Bidding When Targeting Contracts | When targeting contracts, this property controls whether the ad group will bid exclusively on contracts or bid on both contracts and the open market. | Ad Group |
| adgroup_rtb_contracttargeting_contractfloorpricepercentageincrease | NUMERIC | Ad Group RTB Attributes Contract Targeting Contract Floor Price Percentage Increase | This setting defines a percentage that will be added on top of the contract floor price. | Ad Group |
| adgroup_rtb_contracttargeting_usecontractfloorpriceasbasebid | BOOLEAN | Ad Group RTB Attributes Contract Targeting Use Contract Floor Price As Base Bid | When enabled, we will use the contract floor price instead of the Ad Group's base bid. When a contract floor price can't be found, the Ad Group's base bid will be used. | Ad Group |
| adgroup_rtb_creativeids | TEXT | Ad Group RTB Attributes | The complete list of Creative IDs the Ad Group can serve. If the Ad Group has no associated Creatives, it will not serve! See the Creative API for a complete list of this Advertiser's Creatives. | Ad Group |
| adgroup_rtb_dimensionalbiddingautooptimizationsettings | TEXT | Ad Group RTB Attributes Dimensional Bidding Auto Optimization Settings | Specify AutoOptimization for ad groups. | Ad Group |
| adgroup_rtb_displayviewabilitystandardintegral | TEXT | Ad Group RTB Attributes Display Viewability Standard Integral | Viewability standard used for Integral display viewability targeting. | Ad Group |
| adgroup_rtb_isuseclicksasconversionsenabled | BOOLEAN | Ad Group RTB Attributes Is Use Clicks As Conversions Enabled | Controls whether clicks may be counted as primary conversions when conversion data is sparse for optimizing toward conversion-based goals. | Ad Group |
| adgroup_rtb_isusesecondaryconversionsenabled | BOOLEAN | Ad Group RTB Attributes Is Use Secondary Conversions Enabled | Controls whether secondary conversions may be counted as primary conversions when conversion data is sparse for optimizing toward conversion-based goals. | Ad Group |
| adgroup_rtb_koaoptimizationsettings_isbiddingupenabled | BOOLEAN | Ad Group RTB Attributes Koa Optimization Settings Is Bidding Up Enabled | This property indicates whether bidding up is automatically enabled for this ad group or not. | Ad Group |
| adgroup_rtb_koaoptimizationsettings_isenabled | BOOLEAN | Ad Group RTB Attributes Koa Optimization Settings Is Enabled | This property indicates whether Koa automatically applies optimizations and dynamic exclusions to the ad group. | Ad Group |
| adgroup_rtb_koaoptimizationsettings_optionaldimensions | TEXT | Ad Group RTB Attributes Koa Optimization Settings Optional Dimensions | Optionally enable dimensions for Koa Optimizations. If IsEnabled is set to true, a non-null value is required for this field. If empty, no optional dimensions will be enabled. | Ad Group |
| adgroup_rtb_koaoptimizationsversion | TEXT | Ad Group RTB Attributes Koa Optimizations Version | This read-only property indicates the version of Koa being used to apply automatic optimizations or manual recommendations to the ad group. | Ad Group |
| adgroup_rtb_maxbidcpm_amount | NUMERIC | Ad Group RTB Attributes Max Bid CPM Amount | The maximum the Ad Group will ever bid on a single impression. | Ad Group |
| adgroup_rtb_maxbidcpm_currencycode | TEXT | Ad Group RTB Attributes Max Bid CPM Currency Code | The maximum the Ad Group will ever bid on a single impression. Currency Code | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpcrate_amount | NUMERIC | Ad Group RTB Attributes Nielsen Settings Fee CPC Rate Amount | The CPC rate in the currency the provider charges. | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpcrate_currencycode | TEXT | Ad Group RTB Attributes Nielsen Settings Fee CPC Rate Currency Code | The CPC rate in the currency the provider charges. Currency Code | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpcrateinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes Nielsen Settings Fee CPC Rate Advertiser Amount | An approximation of the CPC rate in the Advertiser's currency. | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpcrateinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes Nielsen Settings Fee CPC Rate Advertiser Currency Code | An approximation of the CPC rate in the Advertiser's currency. Currency Code | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpmrate_amount | NUMERIC | Ad Group RTB Attributes Nielsen Settings Fee CPM Rate Amount | The CPM rate in the currency the provider charges. | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpmrate_currencycode | TEXT | Ad Group RTB Attributes Nielsen Settings Fee CPM Rate Currency Code | The CPM rate in the currency the provider charges. Currency Code | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpmrateinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes Nielsen Settings Fee CPM Rate Advertiser Amount | An approximation of the CPM rate in the Advertiser's currency. | Ad Group |
| adgroup_rtb_nielsensettings_fee_cpmrateinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes Nielsen Settings Fee CPM Rate Advertiser Currency Code | An approximation of the CPM rate in the Advertiser's currency. Currency Code | Ad Group |
| adgroup_rtb_nielsensettings_fee_percentofdatacostrate | PERCENT | Ad Group RTB Attributes Nielsen Settings Fee Percent Of Data Cost Rate | The Percent of Data Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_nielsensettings_fee_percentofmediacostrate | PERCENT | Ad Group RTB Attributes Nielsen Settings Fee Percent Of Media Cost Rate | The Percent of Media Cost rate of the data/feature. | Ad Group |
| adgroup_rtb_nielsensettings_nielsentrackingattributes_countries | TEXT | Ad Group RTB Attributes Nielsen Settings Tracking Countries | The list of countries (the codes) that are being targeted for Nielsen analytics. | Ad Group |
| adgroup_rtb_nielsensettings_nielsentrackingattributes_endage | TEXT | Ad Group RTB Attributes Nielsen Settings Tracking End Age | The end age being targeted for Nielsen analytics. | Ad Group |
| adgroup_rtb_nielsensettings_nielsentrackingattributes_enhancedreportingoption | TEXT | Ad Group RTB Attributes Nielsen Settings Tracking Enhanced Reporting Option | The selected Nielsen reporting option. | Ad Group |
| adgroup_rtb_nielsensettings_nielsentrackingattributes_gender | TEXT | Ad Group RTB Attributes Nielsen Settings Tracking Gender | The gender being targeted for Nielsen analytics. | Ad Group |
| adgroup_rtb_nielsensettings_nielsentrackingattributes_startage | TEXT | Ad Group RTB Attributes Nielsen Settings Start Age | The start age being targeted for Nielsen analytics. | Ad Group |
| adgroup_rtb_qualityallianceviewabilityprofile | TEXT | Ad Group RTB Attributes Quality Alliance Viewability Profile | Viewability profile used for Quality Alliance viewability targeting. | Ad Group |
| adgroup_rtb_roigoal_cpainadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ROI Goal CPA In Advertiser Currency Amount | The Cost Per Acquisition goal (in the Advertiser currency). | Ad Group |
| adgroup_rtb_roigoal_cpainadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ROI Goal CPA In Advertiser Currency Code | The Cost Per Acquisition goal (in the Advertiser currency). Currency Code | Ad Group |
| adgroup_rtb_roigoal_cpcinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ROI Goal CPC In Advertiser Currency Amount | The Cost Per Click goal (in the Advertiser currency). | Ad Group |
| adgroup_rtb_roigoal_cpcinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ROI Goal CPC In Advertiser Currency Code | The Cost Per Click goal (in the Advertiser currency). Currency Code | Ad Group |
| adgroup_rtb_roigoal_cpcvinadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ROI Goal CPCV In Advertiser Currency Amount | Cost Per Completed View goal (in the advertiser currency). | Ad Group |
| adgroup_rtb_roigoal_cpcvinadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ROI Goal CPCV In Advertiser Currency Code | Cost Per Completed View goal (in the advertiser currency). Currency Code | Ad Group |
| adgroup_rtb_roigoal_ctrinpercent | PERCENT | Ad Group RTB Attributes ROI Goal CTR In Percent | The Click Through Rate goal (in percent), for example, 1 = 1% (1 in 100). | Ad Group |
| adgroup_rtb_roigoal_maximizeltvincrementalreach | BOOLEAN | Ad Group RTB Attributes ROI Goal Maximize Ltv Incremental Reach | The goal is to reach as many users as possible beyond those who have already reached on Linear TV. | Ad Group |
| adgroup_rtb_roigoal_maximizereach | BOOLEAN | Ad Group RTB Attributes ROI Goal Maximize Reach | Reach as many unique users as possible in your intended audience. | Ad Group |
| adgroup_rtb_roigoal_miaozhenotpinpercent | PERCENT | Ad Group RTB Attributes ROI Goal Miaozhen OTP In Percent | The Miaozhen On Target Percentage goal (in percent), for example, 1 = 1% (1 in 100). | Ad Group |
| adgroup_rtb_roigoal_nielsenotpinpercent | PERCENT | Ad Group RTB Attributes ROI Goal Nielsen OTP In Percent | The Nielsen On Target Percentage goal (in percent), for example, 1 = 1% (1 in 100). | Ad Group |
| adgroup_rtb_roigoal_returnonadspendpercent | PERCENT | Ad Group RTB Attributes ROI Goal Return On Ad Spend Percent | The Return on Ad Spend goal (in percent of ad spend). | Ad Group |
| adgroup_rtb_roigoal_vcpminadvertisercurrency_amount | NUMERIC | Ad Group RTB Attributes ROI Goal VCPM In Advertiser Currency Amount | The Estimated Viewable Cost Per Mille (thousand) goal (in the Advertiser currency). | Ad Group |
| adgroup_rtb_roigoal_vcpminadvertisercurrency_currencycode | TEXT | Ad Group RTB Attributes ROI Goal VCPM In Advertiser Currency Currency Code | The Estimated Viewable Cost Per Mille (thousand) goal (in the Advertiser currency). Currency Code | Ad Group |
| adgroup_rtb_roigoal_vcrinpercent | PERCENT | Ad Group RTB Attributes ROI Goal VCR In Percent | The Video Completion Rate goal (in percent), for example, 1 = 1% (1 in 100). | Ad Group |
| adgroup_rtb_roigoal_viewabilityinpercent | PERCENT | Ad Group RTB Attributes ROI Goal Viewability In Percent | The Viewability goal (in percent), for example, 1 = 1% (1 in 100). | Ad Group |
| adgroup_rtb_videoviewabilitystandardintegral | TEXT | Ad Group RTB Attributes Video Viewability Standard Integral | Viewability standard used for Integral video viewability targeting. | Ad Group |
| advertiser | TEXT | Advertiser name | The name of the advertiser. | Advertiser |
| advertiser_advertiser_audience_settings_audience_booster_enabled | BOOLEAN | Advertiser Audience Settings Audience Booster Enabled | Add segments resembling your target customer when they will benefit your campaign. When turned on for an ad group, it will add highly relevant segments to your audience when there is confidence they will improve your targeting and boost performance. | Advertiser |
| advertiser_advertiser_audience_settings_audience_excluder_enabled | BOOLEAN | Advertiser Audience Settings Audience Excluder Enabled | Exclude users unlikely to benefit your campaign. When turned on for an ad group, it will remove the least relevant users from your audience without harming your pacing. | Advertiser |
| advertiser_advertiser_name_dsa | TEXT | Advertiser Name DSA | The name of the advertiser to be displayed for campaigns targeting individuals established or located in the European Union (EU). 1. This property is required by the Digital Services Act (DSA) only for the EU. Otherwise, the property is optional and its value is set to null by default. 2. If required and not specified, the AdvertiserName value is used by default. IMPORTANT: It is your responsibility, as required under Tradedesk Master Services Agreement, to ensure any information you provide to Tradedesk is truthful and correct. If you fail to confirm the values, you agree to Tradedesk using the default values. For details or assistance, contact your Tradedesk Account Manager or Technical Account Manager. | 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_category_id | TEXT | Advertiser Category ID | The ID of the industry category for this advertiser. | Advertiser |
| advertiser_category_mappings | TEXT | Advertiser Category Mappings | The mappings between the industry category taxonomies (IAB 1.0 and IAB 2.2). | Advertiser |
| advertiser_category_name | TEXT | Advertiser Category Name | The name of the industry category for this advertiser. | Advertiser |
| advertiser_category_taxonomy_id | TEXT | Advertiser Category Taxonomy ID | The ID of the taxonomy for this advertiser. | Advertiser |
| advertiser_category_taxonomy_name | TEXT | Advertiser Category Taxonomy Name | The name of the taxonomy for this advertiser. | Advertiser |
| advertiser_category_taxonomy_version | TEXT | Advertiser Category Taxonomy Version | The version of the taxonomy for this 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 | (Deprecated) Advertiser Industry Category Id | (Deprecated). Please use 'Advertiser Category ID' instead. | Advertiser |
| advertiser_industry_category_mapping_category_id | TEXT | (Deprecated) Advertiser Industry Category Mapping Category Id | (Deprecated) Use 'Advertiser Category Mappings' instead. | Advertiser |
| advertiser_industry_category_mapping_category_taxonomy_id | TEXT | (Deprecated) Advertiser Industry Category Mapping Category Taxonomy Id | (Deprecated) Use 'Advertiser Category Mappings' instead. | Advertiser |
| advertiser_industry_category_mapping_external_id | TEXT | (Deprecated) Advertiser Industry Category Mapping External Id | (Deprecated) Use 'Advertiser Category Mappings' instead. | Advertiser |
| advertiser_industry_category_taxonomy_id | TEXT | (Deprecated) Advertiser Industry Category Taxonomy Id | (Deprecated) Use 'Advertiser Category Taxonomy ID' instead. | 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_payer_name_dsa | TEXT | Payer Name DSA | The name of the entity paying for this advertiser's campaigns. The Digital Services Act (DSA) requires online platforms to declare the natural or legal person paying for the ad, if different from the advertiser. 1. This property is required by the Digital Services Act (DSA) only for the EU. Otherwise, the property is optional and its value is set to null by default. 2. If required and not specified, the CustomerName value is used by default. IMPORTANT: It is your responsibility, as required under Tradedesk Master Services Agreement, to ensure any information you provide to Tradedesk is truthful and correct. If you fail to confirm the values, you agree to Tradedesk using the default values. For details or assistance, contact your Tradedesk Account Manager or Technical Account Manager. | Advertiser |
| advertiser_vetting_status | TEXT | Vetting status of advertiser | Vetting status of the advertiser. | Advertiser |
| campaign | TEXT | Campaign | The Campaign Name | Campaign |
| campaign_advertiser_id | NUMERIC | Campaign Advertiser ID | The platform ID of the advertiser that owns this Campaign. | 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 |
| creative_advertiser_id | TEXT | Creative Advertiser ID | The platform ID of the advertiser that owns this creative. | Creative |
| creative_availability | TEXT | Creative Availability | Indicates whether the Creative is Available for use or Archived and hidden from views. | Creative |
| creative_createdatutc | TIMESTAMP | Creative Created At UTC Timestamp | The time in UTC the Creative was created. | Creative |
| creative_creativeauditstatuses | TEXT | Creative Audit Statuses | A List of Creative Audit Statuses for the Creative. | Creative |
| creative_creativeid | TEXT | Creative id | The ID of the creative. Ignored on create, when an ID will be assigned and returned by The Trade Desk. | Creative |
| creative_creativename | TEXT | Creative Name | The name of the creative. | Creative |
| creative_creativetype | TEXT | Creative Type (Tradedesk) | The type of the creative. | Creative |
| creative_description | TEXT | Creative Description (Tradedesk) | An optional description of the creative. The maximum character length is 512. | Creative |
| creative_flashattributes_adservercreativeid | TEXT | Creative Flash Attributes Ad Server Creative ID | If the ad tag contains a known ad server URL, this will return the identifier of the creative used by the ad server. | Creative |
| creative_flashattributes_adservername | TEXT | Creative Flash Attributes Ad Server Name | If the ad tag contains a known ad server URL, this will return the name of the ad server. Examples are 'MediaMind' or 'DoubleClick'. | Creative |
| creative_flashattributes_adtechnologyids | TEXT | Creative Flash Attributes Ad Technology IDs | This is a declaration of vendor technologies used for click or impression tracking within this creative. These values will be populated by Google when creatives are approved for serving on their exchange. | Creative |
| creative_flashattributes_clickthroughurl | TEXT | Creative Flash Attributes Clickthrough Url | The URL to invoke when the user clicks the ad. This may include additional click tracking. Typically, the user is redirected to the landing page after this URL is invoked. | Creative |
| creative_flashattributes_flashclicktrackingparametername | TEXT | Creative Flash Attributes Flash Click Tracking Parameter Name | The click tracking parameter used in the flash file. | Creative |
| creative_flashattributes_flashcontent | TEXT | Creative Flash Attributes Flash Content | The contents of the Flash file (.swf) as a base-64 encoded string. | Creative |
| creative_flashattributes_flashurl | TEXT | Creative Flash Attributes Flash Url | The URL where The Trade Desk has stored the Flash file for ad serving. | Creative |
| creative_flashattributes_height | TEXT | Creative Flash Attributes Height | The height of the creative in pixels. | Creative |
| creative_flashattributes_issecurable | BOOLEAN | Creative Flash Attributes Is Securable | If set to true (default value on create), indicates that all the resources that are needed to render and track this creative support access over HTTPS (secure) versions of their URIs. If set to false, no attempts will be made to serve this creative in secure contexts. | Creative |
| creative_flashattributes_landingpageurl | TEXT | Creative Flash Attributes Landing Page Url | The landing page URL is the URL of the page where the user is taken after clicking the ad. | Creative |
| creative_flashattributes_rightmediaoffertypeid | TEXT | Creative Flash Attributes Right Media Offer Type ID | Set the Right Media Offer Type (Right Media's creative category) of this creative. | Creative |
| creative_flashattributes_thirdpartyimpressiontrackingurl | TEXT | Creative Flash Attributes Third Party Impression Tracking Url 1 | A pixel URL used to track impressions with third party ad servers. The maximum character length is 500. | Creative |
| creative_flashattributes_thirdpartyimpressiontrackingurl2 | TEXT | Creative Flash Attributes Third Party Impression Tracking Url 2 | A second pixel URL used to track impressions with third party ad servers. The maximum character length is 500. | Creative |
| creative_flashattributes_thirdpartyimpressiontrackingurl3 | TEXT | Creative Flash Attributes Third Party Impression Tracking Url 3 | A third pixel URL used to track impressions with third party ad servers. The maximum character length is 500. | Creative |
| creative_flashattributes_thirdpartytrackingtags | TEXT | Creative Flash Attributes Third Party Tracking Tags | A list of |