The Trade Desk

Explore the interactive ERD

Table & Field Reference

audience_insight_geo

Column	Type	Keys
`audience_id`	String	PK
`geo_segment_id`	String	PK
`avails`	Long
`geo_type`	String
`name`	String
`relevance_score`	Double

dimension_specific_time_and_day_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

partner_associated_bid_list

Column	Type	Keys
`bid_list_id`	String	PKFK
`partner_id`	String	PKFK
`is_default_for_dimension`	Boolean
`is_enabled`	Boolean

advertiser_default_bid_list

Column	Type	Keys
`advertiser_id`	String	PKFK
`bid_list_id`	String	PKFK

campaign_default_bid_list

Column	Type	Keys
`bid_list_id`	String	PKFK
`campaign_id`	String	PKFK

bid_list

Column	Type	Keys
`id`	String	PK
`adjustment_type`	String
`bid_list_type`	String
`is_available_for_library_use`	Boolean
`is_global`	Boolean
`name`	String
`owner`	String
`owner_id`	String
`resolution_type`	String
`source`	String

campaign

Column	Type	Keys
`id`	String	PK
`advertiser_id`	String	FK
`auto_allocator_enabled`	Boolean
`auto_prioritization_enabled`	Boolean
`availability`	String
`budget_in_impressions`	Long
`campaign_name`	String
`campaign_type`	String
`created_at_utc`	LocalDate
`custom_cpaclick_weight`	Double
`custom_cpatype`	String
`custom_cpaviewthrough_weight`	Double
`daily_budget_in_impressions`	Long
`deprecate_household_targeting_and_attribution`	Boolean
`description`	String
`end_date`	LocalDate
`include_defaults_from_advertiser`	Boolean
`is_ballot_measure`	Boolean
`minimum_ad_group_spend_in_advertiser_currency`	Double
`objective`	String
`pacing_mode`	String
`primary_channel`	String
`start_date`	LocalDate
`timezone`	String

audience_insight_os

Column	Type	Keys
`audience_id`	String	PK
`operating_system`	String	PK
`percentage_of_audience`	Double

audience_insight_market_mix

Column	Type	Keys
`audience_id`	String	PK
`market_type`	String	PK
`percentage_of_inventory`	Double

dimension_specific_device_details_report

Column	Type	Keys
`ad_environment`	String	PK
`ad_group_id`	String	PK
`date_utc`	String	PK
`device_type`	String	PK
`lookback_days`	Int	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

campaign_conversion_reporting_column

Column	Type	Keys
`reporting_column_id`	Long	PK
`tracking_tag_id`	String	PK
`campaign_id`	String	PKFK
`cross_device_attribution_model_id`	String
`include_in_custom_cpa`	Boolean
`tracking_tag_name`	String
`weight`	Double

ad_group

Column	Type	Keys
`id`	String	PK
`advertiser_id`	String	FK
`campaign_id`	String	FK
`base_bid_cpmin_advertiser_currency`	Double
`budget_in_impressions`	Long
`budget_spend_priority`	Int
`channel`	String
`created_at`	Instant
`current_flight_allocation_in_advertiser_currency`	Double
`current_flight_allocation_type`	String
`current_flight_daily_target_in_advertiser_currency`	Double
`current_flight_daily_target_in_impressions`	Long
`description`	String
`funnel_location`	String
`industry_category_id`	Long
`industry_category_name`	String
`industry_sub_category_id`	Long
`industry_sub_category_name`	String
`is_archived`	Boolean
`is_enabled`	Boolean
`is_ipresolution_enabled`	Boolean
`is_non_decisioned`	Boolean
`is_programmatic_guaranteed`	Boolean
`is_targeting_default_on_deals`	Boolean
`last_updated`	Instant
`market_type`	String
`max_bid_cpmin_advertiser_currency`	Double
`name`	String
`roi_goal_target`	Double
`roi_goal_type`	String
`status`	String

dimension_specific_language_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`matched_language_code`	String	PK
`publisher_name`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

advertiser_custom_label

Column	Type	Keys
`name`	String	PK
`advertiser_id`	String	PKFK

partner

Column	Type	Keys
`id`	String	PK
`partner_name`	String

category_mapping

Column	Type	Keys
`index`	Int	PK
`category_id`	Long	PKFK
`external_id`	String
`taxonomy_id`	String

audience_insight_device

Column	Type	Keys
`audience_id`	String	PK
`device_type`	String	PK
`percentage_of_audience`	Double

advertiser_associated_bid_list

Column	Type	Keys
`advertiser_id`	String	PKFK
`bid_list_id`	String	PKFK
`is_default_for_dimension`	Boolean
`is_enabled`	Boolean

dimension_specific_creative_report

Column	Type	Keys
`ad_group_id`	String	PK
`creative_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`media_type`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`creative`	String
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

audience_insight_interests

Column	Type	Keys
`audience_id`	String	PK
`interest_name`	String	PK
`relevance_score`	Double

audience_insight_browser

Column	Type	Keys
`audience_id`	String	PK
`browser`	String	PK
`percentage_of_audience`	Double

advertiser

Column	Type	Keys
`id`	String	PK
`category_id`	Long	FK
`partner_id`	String	FK
`advertiser_name`	String
`attribution_click_lookback_window_in_seconds`	Long
`attribution_impression_lookback_window_in_seconds`	Long
`availability`	String
`click_dedup_window_in_seconds`	Long
`conversion_dedup_window_in_seconds`	Long
`currency_code`	String
`default_right_media_offer_type_id`	Long
`description`	String
`domain_address`	String
`ignore_referral_url_in_conversion`	Boolean
`industry_category_id`	Long
`is_audience_booster_enabled`	Boolean
`is_audience_excluder_enabled`	Boolean
`is_ballot_measure`	Boolean
`is_candidate_election`	Boolean
`logo_url`	String
`name_dsa`	String
`payer_name_dsa`	String
`vetting_status`	String

report_template_header

Column	Type	Keys
`report_template_id`	String	PK
`created_by_user_name`	String
`format`	String
`name`	String
`type`	String

advertiser_keyword

Column	Type	Keys
`keyword`	String	PK
`advertiser_id`	String	PKFK

dimension_specific_viewability_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`fold`	String	PK
`lookback_days`	Int	PK
`percentage_of_tracked_impression_viewed`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

hourly_performance_feed

Column	Type	Keys
`ad_format`	String	PK
`ad_group_id`	String	PK
`ad_server_creative_placement_id`	String	PK
`ad_server_name`	String	PK
`advertiser_id`	String	PK
`campaign_id`	String	PK
`creative_id`	String	PK
`date_utc`	String	PK
`media_type`	String	PK
`partner_id`	String	PK
`private_contract_id`	String	PK
`report_hour_utc`	String	PK
`supply_vendor`	String	PK

audience_insight_third_party

Column	Type	Keys
`audience_id`	String	PK
`third_party_data_id`	Long	PK
`brand_name`	String
`relevance_score`	Double
`segment_name`	String
`size`	Long
`third_party_data_brand_id`	String

audience_insight_private_contract

Column	Type	Keys
`audience_id`	String	PK
`private_contract_id`	String	PK
`avails`	Double
`channel_name`	String
`contract_name`	String
`is_first_party`	Boolean
`logo_url`	String
`relevance_score`	Double

report_execution

Column	Type	Keys
`report_execution_id`	Long	PK
`report_schedule_id`	Long	FK
`disabled_reason`	String
`last_state_change_utc`	LocalDate
`report_end_date_exclusive`	LocalDate
`report_execution_state`	String
`report_schedule_name`	String
`report_start_date_inclusive`	LocalDate
`timezone`	String

advertiser_assigned_brand

Column	Type	Keys
`name`	String	PK
`advertiser_id`	String	PKFK
`owner`	String

report_schedule

Column	Type	Keys
`report_schedule_id`	Long	PK
`ad_group_filters`	Json
`advertiser_filters`	Json
`campaign_filters`	Json
`creation_date_utc`	LocalDate
`include_headers`	Boolean
`is_completed`	Boolean
`lookback_days`	Int
`partner_filters`	Json
`report_date_format`	String
`report_date_range`	String
`report_end_date_exclusive`	LocalDate
`report_file_format`	String
`report_frequency`	String
`report_numeric_format`	String
`report_schedule_name`	String
`report_schedule_status`	String
`report_start_date_inclusive`	LocalDate
`report_template_id`	Long
`requested_by_user_name`	String
`schedule_start_date`	LocalDate
`timezone`	String

dimension_specific_contextual_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`matched_category`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

audience_insight_channel_mix

Column	Type	Keys
`audience_id`	String	PK
`device_type`	String	PK
`environment`	String	PK
`media_type`	String	PK
`percentage_of_audience`	Double

campaign_flight

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`budget_in_advertiser_currency`	Double
`budget_in_impressions`	Long
`daily_target_in_advertiser_currency`	Double
`daily_target_in_impressions`	Long
`end_date_exclusive_utc`	LocalDate
`start_date_inclusive_utc`	LocalDate

dimension_specific_geo_report

Column	Type	Keys
`ad_group_id`	String	PK
`country`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`metro`	String	PK
`region`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_group`	String
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

advertiser_candidate_profile

Column	Type	Keys
`political_data_id`	String	PK
`advertiser_id`	String	FK
`audience_description`	String
`candidate_name`	String
`disclaimer_notice`	String
`election_state`	String
`federal_verification_id`	String
`file_location_in_s_3`	String
`geo_description`	String
`paying_entity_address`	String
`paying_entity_email_address`	String
`paying_entity_executive_name`	String
`paying_entity_executive_title`	String
`paying_entity_name`	String
`state_verification_id`	String

dimension_specific_weather_report

Column	Type	Keys
`ad_group_id`	String	PK
`atmospheric_condition`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`source_entity_id`	String	PK
`temperature_bucket_name`	String	PK
`weather_condition`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`temperature_bucket_end_in_celsius`	Double
`temperature_bucket_start_in_celsius`	Double
`total_custom_cpa_conversions`	Double

bid_list_dimension

Column	Type	Keys
`index`	Int	PK
`bid_list_id`	String	PKFK
`dimension`	String

dimension_specific_recency_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`recency_group`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`sort_order`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

creative

Column	Type	Keys
`id`	String	PK
`advertiser_id`	String	FK
`ad_format_height`	Int
`ad_format_id`	String
`ad_format_name`	String
`ad_format_width`	Int
`approved_by`	String
`created_at`	Instant
`description`	String
`flight_end`	Instant
`flight_start`	Instant
`flight_time_zone`	String
`id_integer`	Int
`is_archived`	Boolean
`is_click_tracking_successful`	Boolean
`labels`	String
`last_updated_at`	Instant
`name`	String
`share_link`	String
`tag_type_enum`	String
`third_party_click_tracking_url`	String
`type`	String

audience_insight_apps_sites

Column	Type	Keys
`audience_id`	String	PK
`is_app`	Boolean	PK
`name`	String	PK
`avails`	Double
`channel_name`	String
`relevance_score`	Double

campaign_associated_bid_list

Column	Type	Keys
`bid_list_id`	String	PKFK
`campaign_id`	String	PKFK
`is_default_for_dimension`	Boolean
`is_enabled`	Boolean

advertiser_category

Column	Type	Keys
`id`	Long	PK
`name`	String
`taxonomy_id`	String
`taxonomy_name`	String
`taxonomy_version`	String

dimension_specific_ad_group_report

Column	Type	Keys
`ad_group_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_group`	String
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double

dimension_specific_ad_format_report

Column	Type	Keys
`ad_format`	String	PK
`ad_group_id`	String	PK
`creative_id`	String	PK
`date_utc`	String	PK
`lookback_days`	Int	PK
`media_type`	String	PK
`source_entity_id`	String	PK
`_01_click_conversion`	Long
`_01_click_conversion_revenue`	Double
`_01_conversion_touch`	Long
`_01_conversion_touch_revenue`	Double
`_01_view_through_conversion`	Long
`_01_view_through_conversion_revenue`	Double
`ad_plays`	Double
`advertiser_cost_adv_currency`	Double
`advertiser_id`	String
`bids`	Long
`campaign_id`	String
`clicks`	Long
`creative`	String
`custom_revenue`	Double
`impressions`	Long
`partner_id`	String
`player_completed_views`	Long
`player_starts`	Long
`quality_score`	Double
`quality_score_measured_impressions`	Long
`sampled_tracked_impressions`	Long
`sampled_viewed_impressions`	Long
`source_level`	String
`total_custom_cpa_conversions`	Double