# The Trade Desk schema ERD

Table and field reference for the Fivetran The Trade Desk connector.

## 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 | PK, FK |
| partner_id | String | PK, FK |
| is_default_for_dimension | Boolean |  |
| is_enabled | Boolean |  |

### advertiser_default_bid_list

| Column | Type | Keys |
| --- | --- | --- |
| advertiser_id | String | PK, FK |
| bid_list_id | String | PK, FK |

### campaign_default_bid_list

| Column | Type | Keys |
| --- | --- | --- |
| bid_list_id | String | PK, FK |
| campaign_id | String | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| partner_name | String |  |

### category_mapping

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| category_id | Long | PK, FK |
| 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 | PK, FK |
| bid_list_id | String | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| campaign_id | String | PK, FK |
| 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 |  |

## Relationships

- partner_associated_bid_list(bid_list_id) → bid_list(id)
- partner_associated_bid_list(partner_id) → partner(id)
- advertiser_default_bid_list(bid_list_id) → bid_list(id)
- advertiser_default_bid_list(advertiser_id) → advertiser(id)
- campaign_default_bid_list(bid_list_id) → bid_list(id)
- campaign_default_bid_list(campaign_id) → campaign(id)
- campaign(advertiser_id) → advertiser(id)
- campaign_conversion_reporting_column(campaign_id) → campaign(id)
- ad_group(advertiser_id) → advertiser(id)
- ad_group(campaign_id) → campaign(id)
- advertiser_custom_label(advertiser_id) → advertiser(id)
- category_mapping(category_id) → advertiser_category(id)
- advertiser_associated_bid_list(bid_list_id) → bid_list(id)
- advertiser_associated_bid_list(advertiser_id) → advertiser(id)
- advertiser(partner_id) → partner(id)
- advertiser(category_id) → advertiser_category(id)
- advertiser_keyword(advertiser_id) → advertiser(id)
- report_execution(report_schedule_id) → report_schedule(report_schedule_id)
- advertiser_assigned_brand(advertiser_id) → advertiser(id)
- campaign_flight(campaign_id) → campaign(id)
- advertiser_candidate_profile(advertiser_id) → advertiser(id)
- bid_list_dimension(bid_list_id) → bid_list(id)
- creative(advertiser_id) → advertiser(id)
- campaign_associated_bid_list(bid_list_id) → bid_list(id)
- campaign_associated_bid_list(campaign_id) → campaign(id)