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 |
|---|---|---|---|
| advertiser | TEXT | Advertiser name | The name of the advertiser. |
| advertiser_availability | TEXT | Availability of advertiser | Availability state of the Advertiser. |
| advertiser_description | TEXT | Description of advertiser | An optional description of the advertiser. |
| advertiser_domain | TEXT | Domain of advertiser | The domain address for the Advertiser. |
| advertiser_id | TEXT | Advertiser id | The platform ID of the advertiser. |
| advertiser_keywords | TEXT | Keywords of advertiser | Keywords that classify the Advertiser. |
| advertiser_logo | TEXT | Logo of advertiser | The URL for the Advertiser's logo or brand image. |
| advertiser_vetting_status | TEXT | Vetting status of advertiser | Vetting status of the advertiser. |
| campaign | TEXT | Campaign | The Campaign Name |
| campaign_availability | TEXT | Campaign Availability | Whether the campaign is active and available for normal operation or archived and hidden from normal view. |
| campaign_budget | NUMERIC | Budget of campaign | The maximum amount the Campaign may spend. |
| campaign_budget_impressions | NUMERIC | Budget for impressions of compaign | The maximum amount of impressions the Campaign should buy. |
| campaign_creation_time | TEXT | Creation time of campaign | The time in UTC the Campaign was created. |
| campaign_custom_cpa_click_weight | NUMERIC | Custom CPA click weight | Weight to assign to click through pixels when calculating Custom CPA. |
| campaign_custom_viewthroug_weight | NUMERIC | Custom CPA viewthroug weight | Weight to assign to view pixels when calculating Custom CPA. |
| campaign_daily_budget | NUMERIC | Daily budget udget of campaign | The maximum amount that the campaign should spend per day, if possible. |
| 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_description | TEXT | Campaign description | An optional description of the 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_id | TEXT | Campaign ID | The ID of the Campaign. |
| campaign_objective | TEXT | Objectiv of campaign. | The campaign objective. |
| campaign_primary_channel | TEXT | Primary channel of campaign. | The campaign primary channel. |
| 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_start_date | DATE | Start date of campaign | The date and time (in UTC) that the Campaign should start spending. |
| campaign_type | TEXT | Type of campaign. | The type of the Campaign, options are currently either Standard (default) or ProgrammaticGuaranteed. |
| campaign_update_time | DATE | Last update time of campagin. | The time in UTC the Campaign was last updated. |
| date | DATE | Date | The Date |
| partner_id | TEXT | Partner ID | The ID of the partner who owns this advertiser. |
| today | DATE | Today | Today's date |