# Amazon Ads schema ERD

Table and field reference for the Fivetran Amazon Ads connector.

## Table & Field Reference

### sb_campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| report_date | LocalDate | PK |
| campaign_id | String | PK, FK |
| applicable_budget_rule_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| top_of_search_impression_share | Double |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### sb_benchmark_brand_and_category

| Column | Type | Keys |
| --- | --- | --- |
| end_time | LocalDate | PK |
| start_time | LocalDate | PK |
| brand | String | PK, FK |
| category_id | String | PK, FK |
| acos_** |  |  |
| ctr_** |  |  |
| impressions_** |  |  |
| roas_** |  |  |

### sb_campaign_bid_adjustments_by_placement

| Column | Type | Keys |
| --- | --- | --- |
| placement | String | PK |
| campaign_id | String | PK, FK |
| percentage | Int |  |

### sd_brand_safety_history

| Column | Type | Keys |
| --- | --- | --- |
| domain_id | String | PK |
| last_modified | Instant | PK |
| created_at | Instant |  |
| name | String |  |
| state | String |  |
| type | String |  |

### sb_store

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| brand_entity_id | String | FK |
| store_name | String |  |
| store_status | String |  |

### negative_keyword_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| keyword_text | String |  |
| match_type | String |  |
| native_language_keyword | String |  |
| native_language_locale | String |  |
| serving_status | String |  |
| state | String |  |

### sb_budget_rule_recurrence_day

| Column | Type | Keys |
| --- | --- | --- |
| day_of_week | String | PK |
| rule_id | String | PK, FK |

### product_ad_serving_status_detail

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| product_ad_id | String | PK, FK |
| help_url | String |  |
| message | String |  |

### sb_placement_report

| Column | Type | Keys |
| --- | --- | --- |
| placement | String | PK |
| report_date | LocalDate | PK |
| campaign_id | String | PK, FK |
| applicable_budget_rule_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### sb_budget_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| seven_days_end_date | LocalDate | PK |
| seven_days_start_date | LocalDate | PK |
| campaign_id | String | PK, FK |
| seven_days_estimated_missed_clicks_lower | Int |  |
| seven_days_estimated_missed_clicks_upper | Int |  |
| seven_days_estimated_missed_impressions_lower | Int |  |
| seven_days_estimated_missed_impressions_upper | Int |  |
| seven_days_estimated_missed_sales_lower | Double |  |
| seven_days_estimated_missed_sales_upper | Double |  |
| seven_days_percent_time_in_budget | Double |  |
| suggested_budget | Double |  |

### ad_group_theme_based_bid_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Long | FK |
| campaign_id | Long | FK |
| profile_id | Long | FK |
| estimated_impression_lower | Int |  |
| estimated_impression_upper | Int |  |
| targeting_type | String |  |
| theme | String |  |

### sb_ad_sub_page

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| url | String | PK |
| _fivetran_id | String | PK, FK |
| page_title | String |  |

### sd_negative_targeting_expression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| target_id | String | FK |
| type | String |  |
| value | Json |  |

### asin_bid_analysis

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| profile_id | Long | FK |
| asin | String |  |
| bid | Double |  |
| estimated_impression_avg | Int |  |
| estimated_impression_lower | Int |  |
| estimated_impression_upper | Int |  |
| placement | String |  |
| strategy | String |  |
| targeting_type | String |  |
| theme | String |  |
| type_of_bid | String |  |

### sb_negative_product_target_expression

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| target_id | String | PK, FK |
| value | String |  |

### sd_product_ad_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_id | String | PK, FK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| add_to_cart | Int |  |
| add_to_cart_clicks | Int |  |
| add_to_cart_rate | Double |  |
| add_to_cart_views | Int |  |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| bid_optimization | String |  |
| branded_search_rate | Double |  |
| branded_searches | Int |  |
| branded_searches_clicks | Int |  |
| branded_searches_views | Int |  |
| campaign_budget_currency_code | String |  |
| clicks | Int |  |
| cost | Double |  |
| cumulative_reach | Int |  |
| detail_page_views | Int |  |
| detail_page_views_clicks | Int |  |
| e_cpadd_to_cart | Double |  |
| e_cpbrand_search | Double |  |
| impressions | Int |  |
| impressions_frequency_average | Double |  |
| impressions_views | Int |  |
| lead_form_opens | Int |  |
| leads | Int |  |
| link_outs | Int |  |
| new_to_brand_detail_page_view_clicks | Int |  |
| new_to_brand_detail_page_view_rate | Double |  |
| new_to_brand_detail_page_view_views | Int |  |
| new_to_brand_detail_page_views | Int |  |
| new_to_brand_ecpdetail_page_view | Double |  |
| new_to_brand_purchases | Int |  |
| new_to_brand_purchases_clicks | Int |  |
| new_to_brand_sales | Double |  |
| new_to_brand_sales_clicks | Double |  |
| new_to_brand_units_sold | Int |  |
| new_to_brand_units_sold_clicks | Int |  |
| purchases | Int |  |
| purchases_clicks | Int |  |
| purchases_promoted_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales | Double |  |
| sales_clicks | Double |  |
| sales_promoted_clicks | Double |  |
| units_sold | Int |  |
| units_sold_clicks | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| view_click_through_rate | Double |  |
| viewability_rate | Double |  |

### sb_product_target_resolved_expression

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| target_id | String | PK, FK |
| value | String |  |

### sb_target_report

| Column | Type | Keys |
| --- | --- | --- |
| report_date | LocalDate | PK |
| target_id | String | PK, FK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| targeting_expression | String |  |
| targeting_text | String |  |
| targeting_type | String |  |
| top_of_search_impression_share | Double |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### sb_campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | String | PK |
| campaign_id | String | PK, FK |
| value | String |  |

### campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| name | String | PK |
| value | String |  |

### asin_suggested_keyword

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asin | String |  |
| keyword_text | String |  |
| rec_id | String |  |
| search_term_impression_rank | Double |  |
| search_term_impression_share | Double |  |
| translation | String |  |
| user_selected_keyword | Boolean |  |

### sd_creative

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| creative_type | String |  |
| properties_** |  |  |

### sb_budget_usage_history

| Column | Type | Keys |
| --- | --- | --- |
| usage_updated_timestamp | Instant | PK |
| campaign_id | String | PK, FK |
| budget | Double |  |
| budget_usage_percent | Double |  |

### sd_targeting_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| creation_date | Instant |  |
| expression_type | String |  |
| serving_status | String |  |
| state | String |  |

### campaign_negative_keyword_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| keyword_text | String |  |
| match_type | String |  |
| serving_status | String |  |
| state | String |  |

### sd_brand_safety_status_history

| Column | Type | Keys |
| --- | --- | --- |
| request_id | String | PK |
| domain_id | String | FK |
| details | String |  |
| status | String |  |

### sb_search_term_report

| Column | Type | Keys |
| --- | --- | --- |
| query_term | String | PK |
| report_date | LocalDate | PK |
| keyword_id | String | PK, FK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| attributed_conversions_14_d | Int |  |
| attributed_sales_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| impressions | Int |  |
| search_term_impression_rank | Int |  |
| search_term_impression_share | Double |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### purchased_product_targeting_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| purchased_asin | String | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| add_to_list | Int |  |
| advertised_asin | String |  |
| advertised_sku | String |  |
| campaign_budget_currency_code | String |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| match_type | String |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_other_sku_14_d | Int |  |
| purchases_other_sku_1_d | Int |  |
| purchases_other_sku_30_d | Int |  |
| purchases_other_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_14_d | Double |  |
| sales_other_sku_1_d | Double |  |
| sales_other_sku_30_d | Double |  |
| sales_other_sku_7_d | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_14_d | Int |  |
| units_sold_other_sku_1_d | Int |  |
| units_sold_other_sku_30_d | Int |  |
| units_sold_other_sku_7_d | Int |  |

### sb_budget_rule_campaign

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

### negative_targeting_clause_history

| Column | Type | Keys |
| --- | --- | --- |
| last_updated_date | Instant | PK |
| target_id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| expression_type | String |  |
| serving_status | String |  |
| state | String |  |

### targeting_keyword_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| acos_clicks_14_d | Double |  |
| acos_clicks_7_d | Double |  |
| ad_keyword_status | String |  |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Int |  |
| keyword_bid | Double |  |
| keyword_type | String |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| match_type | String |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| roas_clicks_14_d | Double |  |
| roas_clicks_7_d | Double |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_7_d | Long |  |
| targeting | String |  |
| top_of_search_impression_share | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_ad_landing_page_asin

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| ad_id | String | PK, FK |

### campaign_serving_status_detail

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| campaign_id | String | PK, FK |
| help_url | String |  |
| message | String |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| country_code | String |  |
| currency_code | String |  |
| daily_budget | Long |  |
| timezone | String |  |
| account_** |  |  |

### sb_keyword_recommendation_url

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| url | String | PK |
| match_type | String |  |
| search_term_impression_rank | Double |  |
| search_term_impression_share | Double |  |
| translation | String |  |
| type | String |  |
| url_type | String |  |
| value | String |  |

### sb_campaign_bid_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| bid_adjustment_predicate | String | PK |
| campaign_draft_id | String | PK, FK |
| bid_adjustment_percent | Double |  |

### sd_product_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| ad_name | String |  |
| asin | String |  |
| creation_date | Instant |  |
| landing_page_type | String |  |
| landing_page_url | String |  |
| serving_status | String |  |
| sku | String |  |
| state | String |  |

### sd_creative_moderation

| Column | Type | Keys |
| --- | --- | --- |
| moderation_status | String | PK |
| creative_id | String | PK, FK |
| eta_for_moderation | String |  |

### campaign_placement_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| placement | String | PK |
| campaign_id | Long | PK, FK |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_bidding_strategy | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Long |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| spend | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_targeting_recommendation_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| asin | String |  |
| estimated_reach | String |  |
| is_targetable | String |  |
| name | String |  |
| path | String |  |
| supply_source | String |  |
| translated_name | String |  |
| translated_path | String |  |

### sb_keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| bid | Double |  |
| keyword_text | String |  |
| match_type | String |  |
| native_language_keyword | String |  |
| state | String |  |

### sd_target_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | String | PK, FK |
| campaign_id | String | PK, FK |
| targeting_id | String | PK, FK |
| ad_keyword_status | String |  |
| add_to_cart | Int |  |
| add_to_cart_clicks | Int |  |
| add_to_cart_rate | Double |  |
| add_to_cart_views | Int |  |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| branded_search_rate | Double |  |
| branded_searches | Int |  |
| branded_searches_clicks | Int |  |
| branded_searches_views | Int |  |
| campaign_budget_currency_code | String |  |
| clicks | Int |  |
| cost | Double |  |
| detail_page_views | Int |  |
| detail_page_views_clicks | Int |  |
| e_cpadd_to_cart | Double |  |
| e_cpbrand_search | Double |  |
| impressions | Int |  |
| impressions_views | Int |  |
| lead_form_opens | Int |  |
| leads | Int |  |
| link_outs | Int |  |
| new_to_brand_detail_page_view_clicks | Int |  |
| new_to_brand_detail_page_view_rate | Double |  |
| new_to_brand_detail_page_view_views | Int |  |
| new_to_brand_detail_page_views | Int |  |
| new_to_brand_ecpdetail_page_view | Double |  |
| new_to_brand_purchases | Int |  |
| new_to_brand_purchases_clicks | Int |  |
| new_to_brand_sales | Double |  |
| new_to_brand_sales_clicks | Double |  |
| new_to_brand_units_sold | Int |  |
| new_to_brand_units_sold_clicks | Int |  |
| purchases | Int |  |
| purchases_clicks | Int |  |
| purchases_promoted_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales | Double |  |
| sales_clicks | Double |  |
| sales_promoted_clicks | Double |  |
| targeting_expression | String |  |
| targeting_text | String |  |
| units_sold | Int |  |
| units_sold_clicks | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| view_click_through_rate | Double |  |
| viewability_rate | Double |  |

### keyword_serving_status_detail

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| keyword_id | String | PK, FK |
| help_url | String |  |
| message | String |  |

### search_term_targeting_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| search_term | String | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| acos_clicks_14_d | Double |  |
| acos_clicks_7_d | Double |  |
| ad_keyword_status | String |  |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Int |  |
| keyword_bid | Double |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| roas_clicks_14_d | Double |  |
| roas_clicks_7_d | Double |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_7_d | Long |  |
| targeting | String |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_keyword_report

| Column | Type | Keys |
| --- | --- | --- |
| report_date | LocalDate | PK |
| keyword_id | String | PK, FK |
| ad_group_id | String | FK |
| applicable_budget_rule_id | String | FK |
| campaign_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| search_term_impression_rank | Int |  |
| search_term_impression_share | Double |  |
| top_of_search_impression_share | Double |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### sd_purchased_products_reports

| Column | Type | Keys |
| --- | --- | --- |
| asin_brand_halo | String | PK |
| date | LocalDate | PK |
| promoted_asin | String | PK |
| promoted_sku | String | PK |
| ad_group_id | String | PK, FK |
| campaign_id | String | PK, FK |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| campaign_budget_currency_code | String |  |
| conversions_brand_halo | Int |  |
| conversions_brand_halo_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales_brand_halo | Double |  |
| sales_brand_halo_clicks | Double |  |
| units_sold_brand_halo | Int |  |
| units_sold_brand_halo_clicks | Int |  |

### sd_targeting_expression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| target_id | String | FK |
| type | String |  |
| value | Json |  |

### sd_campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| campaign_id | String | PK, FK |
| add_to_cart | Int |  |
| add_to_cart_clicks | Int |  |
| add_to_cart_rate | Double |  |
| add_to_cart_views | Int |  |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| branded_search_rate | Double |  |
| branded_searches | Int |  |
| branded_searches_clicks | Int |  |
| branded_searches_views | Int |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| clicks | Int |  |
| cost | Double |  |
| cost_type | String |  |
| cumulative_reach | Int |  |
| detail_page_views | Int |  |
| detail_page_views_clicks | Int |  |
| e_cpadd_to_cart | Double |  |
| e_cpbrand_search | Double |  |
| impressions | Int |  |
| impressions_frequency_average | Double |  |
| impressions_views | Int |  |
| lead_form_opens | Int |  |
| leads | Int |  |
| link_outs | Int |  |
| new_to_brand_detail_page_view_clicks | Int |  |
| new_to_brand_detail_page_view_rate | Double |  |
| new_to_brand_detail_page_view_views | Int |  |
| new_to_brand_detail_page_views | Int |  |
| new_to_brand_ecpdetail_page_view | Double |  |
| new_to_brand_purchases | Int |  |
| new_to_brand_purchases_clicks | Int |  |
| new_to_brand_sales | Double |  |
| new_to_brand_sales_clicks | Double |  |
| new_to_brand_units_sold | Int |  |
| new_to_brand_units_sold_clicks | Int |  |
| purchases | Int |  |
| purchases_clicks | Int |  |
| purchases_promoted_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales | Double |  |
| sales_clicks | Double |  |
| sales_promoted_clicks | Double |  |
| units_sold | Int |  |
| units_sold_clicks | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| view_click_through_rate | Double |  |
| viewability_rate | Double |  |

### product_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| asin | String |  |
| creation_date | Instant |  |
| custom_text | String |  |
| serving_status | String |  |
| sku | String |  |
| state | String |  |

### sb_keyword_recommendation_asin

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| id | String | PK |
| match_type | String |  |
| search_term_impression_rank | Double |  |
| search_term_impression_share | Double |  |
| translation | String |  |
| type | String |  |
| value | String |  |

### sb_creative_video_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | String | PK, FK |

### sd_budget_usage_history

| Column | Type | Keys |
| --- | --- | --- |
| usage_updated_timestamp | Instant | PK |
| campaign_id | String | PK, FK |
| budget | Double |  |
| budget_usage_percent | Double |  |

### budget_rule_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| rule_id | String | PK, FK |

### sb_campaign_bid_adjustments_by_shopper_segment

| Column | Type | Keys |
| --- | --- | --- |
| shopper_segment | String | PK |
| campaign_id | String | PK, FK |
| percentage | Int |  |

### targeting_clause_history

| Column | Type | Keys |
| --- | --- | --- |
| last_updated_date | Instant | PK |
| target_id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| bid | Double |  |
| creation_date | Instant |  |
| expression_type | String |  |
| serving_status | String |  |
| state | String |  |

### sb_product_target_expression

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| target_id | String | PK, FK |
| value | String |  |

### sb_campaign_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_format | String |  |
| bid_multiplier | Int |  |
| bid_optimization | Boolean |  |
| bid_optimization_strategy | String |  |
| budget | Double |  |
| budget_type | String |  |
| end_date | LocalDate |  |
| landing_page_page_type | String |  |
| landing_page_url | String |  |
| name | String |  |
| portfolio_id | String |  |
| start_date | LocalDate |  |
| tags | Json |  |

### sb_campaign_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_update_date | Instant | PK |
| brand_entity_id | String | FK |
| portfolio_id | String | FK |
| profile_id | Long | FK |
| bid_optimization | Boolean |  |
| bid_optimization_strategy | String |  |
| budget | Double |  |
| budget_type | String |  |
| cost_type | String |  |
| creation_date | Instant |  |
| end_date | LocalDate |  |
| goal | String |  |
| is_multi_ad_groups_enabled | Boolean |  |
| name | String |  |
| outcome | String |  |
| product_location | String |  |
| serving_status | String |  |
| start_date | LocalDate |  |
| state | String |  |
| rule_based_budget_** |  |  |

### sb_targeting_recommendation_product

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| recommended_target_asin | String |  |

### ad_group_bid_recommendation_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| parent_id | String | PK, FK |
| suggested_bid | Double |  |

### sb_creative_custom_image

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | String | PK |
| _fivetran_id | String | PK, FK |
| url | String |  |
| crop_** |  |  |

### campaign_level_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| campaign_id | Long | PK, FK |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_applicable_budget_rule_id | String |  |
| campaign_applicable_budget_rule_name | String |  |
| campaign_bidding_strategy | String |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| campaign_rule_based_budget_amount | Double |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Long |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| spend | Double |  |
| top_of_search_impression_share | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_product_targeting_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| asin_count_range_max | Int |  |
| asin_count_range_min | Int |  |
| estimated_reach_max | Int |  |
| estimated_reach_min | Int |  |
| is_targetable | Boolean |  |
| name | String |  |
| parent_category_refinement_id | String |  |
| supply_source | String |  |
| translated_name | String |  |

### portfolio_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| last_updated_date | Instant | PK |
| profile_id | Long | FK |
| creation_date | Instant |  |
| in_budget | Boolean |  |
| name | String |  |
| serving_status | String |  |
| state | String |  |
| budget_** |  |  |

### budget_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| budget_increase_by_type | String |  |
| budget_increase_by_value | Double |  |
| created_date | Instant |  |
| date_range_type_duration_end_date | LocalDate |  |
| date_range_type_duration_start_date | LocalDate |  |
| event_type_duration_end_date | LocalDate |  |
| event_type_duration_event_id | String |  |
| event_type_duration_event_name | String |  |
| event_type_duration_start_date | LocalDate |  |
| last_updated_date | Instant |  |
| name | String |  |
| performance_measure_comparison_operator | String |  |
| performance_measure_metric_name | String |  |
| performance_measure_threshold | Double |  |
| recurrence_type | String |  |
| state | String |  |
| status | String |  |
| type | String |  |

### sd_ad_group_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | String | PK, FK |
| campaign_id | String | FK |
| add_to_cart | Int |  |
| add_to_cart_clicks | Int |  |
| add_to_cart_rate | Double |  |
| add_to_cart_views | Int |  |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| bid_optimization | String |  |
| branded_search_rate | Double |  |
| branded_searches | Int |  |
| branded_searches_clicks | Int |  |
| branded_searches_views | Int |  |
| campaign_budget_currency_code | String |  |
| clicks | Int |  |
| cost | Double |  |
| cumulative_reach | Int |  |
| detail_page_views | Int |  |
| detail_page_views_clicks | Int |  |
| e_cpadd_to_cart | Double |  |
| e_cpbrand_search | Double |  |
| impressions | Int |  |
| impressions_frequency_average | Double |  |
| impressions_views | Int |  |
| lead_form_opens | Int |  |
| leads | Int |  |
| link_outs | Int |  |
| new_to_brand_detail_page_view_clicks | Int |  |
| new_to_brand_detail_page_view_rate | Double |  |
| new_to_brand_detail_page_view_views | Int |  |
| new_to_brand_detail_page_views | Int |  |
| new_to_brand_ecpdetail_page_view | Double |  |
| new_to_brand_purchases | Int |  |
| new_to_brand_purchases_clicks | Int |  |
| new_to_brand_sales | Double |  |
| new_to_brand_sales_clicks | Double |  |
| new_to_brand_units_sold | Int |  |
| new_to_brand_units_sold_clicks | Int |  |
| purchases | Int |  |
| purchases_clicks | Int |  |
| purchases_promoted_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales | Double |  |
| sales_clicks | Double |  |
| sales_promoted_clicks | Double |  |
| units_sold | Int |  |
| units_sold_clicks | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| view_click_through_rate | Double |  |
| viewability_rate | Double |  |

### ad_group_level_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | Long | PK, FK |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_bidding_strategy | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Long |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| spend | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### advertised_product_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| acos_clicks_14_d | Double |  |
| acos_clicks_7_d | Double |  |
| add_to_list | Int |  |
| advertised_asin | String |  |
| advertised_sku | String |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Int |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| roas_clicks_14_d | Double |  |
| roas_clicks_7_d | Double |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_7_d | Long |  |
| spend | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### asin_bid_recommendation_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| parent_id | String | PK, FK |
| suggested_bid | Double |  |

### sd_budget_rule_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| campaign_id | String | PK, FK |
| created_date | Instant |  |
| rule_state | String |  |
| rule_status | String |  |
| rule_detail_** |  |  |

### sd_matched_target_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| matched_target_asin | String | PK |
| ad_group_id | String | PK, FK |
| campaign_id | String | PK, FK |
| targeting_id | String | PK, FK |
| add_to_cart | Int |  |
| add_to_cart_clicks | Int |  |
| add_to_cart_rate | Double |  |
| add_to_cart_views | Int |  |
| add_to_list | Int |  |
| add_to_list_from_clicks | Int |  |
| add_to_list_from_views | Int |  |
| branded_search_rate | Double |  |
| branded_searches | Int |  |
| branded_searches_clicks | Int |  |
| branded_searches_views | Int |  |
| campaign_budget_currency_code | String |  |
| clicks | Int |  |
| cost | Double |  |
| detail_page_views | Int |  |
| detail_page_views_clicks | Int |  |
| e_cpadd_to_cart | Double |  |
| e_cpbrand_search | Double |  |
| impressions | Int |  |
| impressions_views | Int |  |
| lead_form_opens | Int |  |
| leads | Int |  |
| link_outs | Int |  |
| new_to_brand_purchases | Int |  |
| new_to_brand_purchases_clicks | Int |  |
| new_to_brand_sales | Double |  |
| new_to_brand_sales_clicks | Double |  |
| new_to_brand_units_sold | Int |  |
| new_to_brand_units_sold_clicks | Int |  |
| purchases | Int |  |
| purchases_clicks | Int |  |
| purchases_promoted_clicks | Int |  |
| qualified_borrows | Int |  |
| qualified_borrows_from_clicks | Int |  |
| qualified_borrows_from_views | Int |  |
| royalty_qualified_borrows | Int |  |
| royalty_qualified_borrows_from_clicks | Int |  |
| royalty_qualified_borrows_from_views | Int |  |
| sales | Double |  |
| sales_clicks | Double |  |
| sales_promoted_clicks | Double |  |
| targeting_expression | String |  |
| targeting_text | String |  |
| units_sold | Int |  |
| units_sold_clicks | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| view_click_through_rate | Double |  |
| viewability_rate | Double |  |

### campaign_placement_bidding

| Column | Type | Keys |
| --- | --- | --- |
| placement | String | PK |
| campaign_id | String | PK, FK |
| percentage | Int |  |

### sb_negative_keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| keyword_text | String |  |
| match_type | String |  |
| state | String |  |

### sd_negative_targeting_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| creation_date | Instant |  |
| expression_type | String |  |
| serving_status | String |  |
| state | String |  |

### sb_ad_group_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_update_date | Instant | PK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| name | String |  |
| serving_status | String |  |
| state | String |  |

### sb_brand

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| brand_entity_id | String |  |
| brand_id | String |  |
| brand_registry_name | String |  |

### sd_campaign_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| portfolio_id | String | FK |
| profile_id | Long | FK |
| budget | Double |  |
| budget_type | String |  |
| cost_type | String |  |
| creation_date | Instant |  |
| end_date | LocalDate |  |
| name | String |  |
| serving_status | String |  |
| start_date | LocalDate |  |
| state | String |  |
| tactic | String |  |

### sd_targeting_resolved_expression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| target_id | String | FK |
| type | String |  |
| value | Json |  |

### sd_targeting_recommendation_product

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| target_asin | String | PK |
| rank | Long |  |

### sb_campaign_draft_subpage

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| campaign_draft_id | String | PK, FK |
| page_title | String |  |
| url | String |  |

### sd_targeting_recommendation_audience

| Column | Type | Keys |
| --- | --- | --- |
| audience | String | PK |
| target_asin | String | PK |
| category | String |  |
| name | String |  |
| rank | Long |  |

### search_term_ad_keyword_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| search_term | String | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| acos_clicks_14_d | Double |  |
| acos_clicks_7_d | Double |  |
| ad_keyword_status | String |  |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Int |  |
| keyword_bid | Double |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| roas_clicks_14_d | Double |  |
| roas_clicks_7_d | Double |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_7_d | Long |  |
| targeting | String |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_negative_product_target

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| bid | Double |  |
| state | String |  |

### ad_group_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| default_bid | Double |  |
| name | String |  |
| serving_status | String |  |
| state | String |  |

### campaign_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| portfolio_id | String | FK |
| profile_id | Long | FK |
| bidding_strategy | String |  |
| budget | Double |  |
| budget_type | String |  |
| creation_date | Instant |  |
| effective_budget | Double |  |
| end_date | LocalDate |  |
| name | String |  |
| serving_status | String |  |
| start_date | LocalDate |  |
| state | String |  |
| targeting_type | String |  |

### sb_budget_rule_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| campaign_id | String | PK, FK |
| end_date | LocalDate |  |
| event_name | String |  |
| start_date | LocalDate |  |
| suggested_budget_increase_percent | Int |  |

### asin_theme_based_bid_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| profile_id | Long | FK |
| asin | String |  |
| estimated_impression_lower | Int |  |
| estimated_impression_upper | Int |  |
| strategy | String |  |
| targeting_type | String |  |
| theme | String |  |

### sb_campaign_draft_video_media

| Column | Type | Keys |
| --- | --- | --- |
| campaign_draft_id | String | PK, FK |
| id | String |  |

### sb_ad_group_report

| Column | Type | Keys |
| --- | --- | --- |
| report_date | LocalDate | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

### sb_store_page_info

| Column | Type | Keys |
| --- | --- | --- |
| store_page_id | String | PK |
| store_id | String | PK, FK |
| store_page_name | String |  |
| store_page_status | String |  |
| store_page_url | String |  |

### sb_creative_original_video_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | String | PK, FK |

### sd_bid_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| target_id | String | PK, FK |
| bid_optimization | String |  |
| cost_type | String |  |
| range_lower | Double |  |
| range_upper | Double |  |
| recommended | Double |  |

### sd_negative_targeting_resolved_expression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| target_id | String | FK |
| type | String |  |
| value | Json |  |

### sb_purchased_product

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| attribution_type | String |  |
| campaign_budget_currency_code | String |  |
| new_to_brand_purchases_14_d | Int |  |
| new_to_brand_purchases_percentage_14_d | Double |  |
| new_to_brand_sales_14_d | Double |  |
| new_to_brand_sales_percentage_14_d | Double |  |
| new_to_brand_units_sold_14_d | Int |  |
| new_to_brand_units_sold_percentage_14_d | Double |  |
| orders_14_d | Int |  |
| product_category | String |  |
| product_name | String |  |
| purchased_asin | String |  |
| sales_14_d | Double |  |
| units_sold_14_d | Int |  |

### sd_targeting_recommendation_category

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK |
| tactic | String | PK |
| target_asin | String | PK |
| name | String |  |
| rank | Long |  |
| targetable_asin_count_range_lower | Long |  |
| targetable_asin_count_range_upper | Long |  |
| translated_name | String |  |

### budget_rule_recurrence_day

| Column | Type | Keys |
| --- | --- | --- |
| day_of_week | String | PK |
| rule_id | String | PK, FK |

### ad_group_bid_analysis

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Long | FK |
| campaign_id | Long | FK |
| profile_id | Long | FK |
| bid | Double |  |
| estimated_impression_avg | Int |  |
| estimated_impression_lower | Int |  |
| estimated_impression_upper | Int |  |
| placement | String |  |
| targeting_type | String |  |
| theme | String |  |
| type_of_bid | String |  |

### sb_targeting_recommendation_brand_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | String | PK, FK |
| id | String | FK |
| name | String |  |

### sb_negative_product_target_resolved_expression

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| target_id | String | PK, FK |
| value | String |  |

### sb_product_target

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| bid | Double |  |
| state | String |  |

### targeting_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| acos_clicks_14_d | Double |  |
| acos_clicks_7_d | Double |  |
| ad_keyword_status | String |  |
| add_to_list | Int |  |
| attributed_sales_same_sku_14_d | Double |  |
| attributed_sales_same_sku_1_d | Double |  |
| attributed_sales_same_sku_30_d | Double |  |
| attributed_sales_same_sku_7_d | Double |  |
| campaign_budget_amount | Double |  |
| campaign_budget_currency_code | String |  |
| campaign_budget_type | String |  |
| click_through_rate | Double |  |
| clicks | Int |  |
| cost | Double |  |
| cost_per_click | Double |  |
| impressions | Int |  |
| keyword_bid | Double |  |
| keyword_type | String |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| match_type | String |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_same_sku_14_d | Int |  |
| purchases_same_sku_1_d | Int |  |
| purchases_same_sku_30_d | Int |  |
| purchases_same_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| roas_clicks_14_d | Double |  |
| roas_clicks_7_d | Double |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_7_d | Long |  |
| targeting | String |  |
| top_of_search_impression_share | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_7_d | Int |  |
| units_sold_same_sku_14_d | Int |  |
| units_sold_same_sku_1_d | Int |  |
| units_sold_same_sku_30_d | Int |  |
| units_sold_same_sku_7_d | Int |  |

### sb_budget_rule_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| budget_increase_by_type | String |  |
| budget_increase_by_value | Double |  |
| created_date | Instant |  |
| date_range_type_duration_end_date | LocalDate |  |
| date_range_type_duration_start_date | LocalDate |  |
| event_type_rule_duration_end_date | LocalDate |  |
| event_type_rule_duration_event_id | String |  |
| event_type_rule_duration_event_name | String |  |
| event_type_rule_duration_start_date | LocalDate |  |
| performance_measure_condition_comparison_operator | String |  |
| performance_measure_condition_metric_name | String |  |
| performance_measure_condition_threshold | Double |  |
| recurrence_type | String |  |
| rule_state | String |  |
| rule_status | String |  |
| rule_type | String |  |

### sb_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| last_update_date | Instant | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| creation_date | Instant |  |
| id | String |  |
| landing_page_page_type | String |  |
| landing_page_url | String |  |
| name | String |  |
| serving_status | String |  |
| state | String |  |

### sb_creative_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_id | String | FK |
| brand_logo_asset_id | String |  |
| brand_logo_crop_height | Int |  |
| brand_logo_crop_left | Int |  |
| brand_logo_crop_top | Int |  |
| brand_logo_crop_width | Int |  |
| brand_logo_url | String |  |
| brand_name | String |  |
| consent_to_translate | Boolean |  |
| creation_time | Instant |  |
| creative_status | String |  |
| creative_type | String |  |
| creative_version | String |  |
| custom_image_asset_id | String |  |
| custom_image_crop_height | Int |  |
| custom_image_crop_left | Int |  |
| custom_image_crop_top | Int |  |
| custom_image_crop_width | Int |  |
| custom_image_url | String |  |
| headline | String |  |
| landing_page_type | String |  |
| landing_page_value | String |  |
| last_update_time | Instant |  |
| type | String |  |

### sb_creative_asin

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | String | PK, FK |

### purchased_product_keyword_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| purchased_asin | String | PK |
| ad_group_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| keyword_id | Long | PK, FK |
| add_to_list | Int |  |
| advertised_asin | String |  |
| advertised_sku | String |  |
| campaign_budget_currency_code | String |  |
| kindle_edition_normalized_pages_read_14_d | Int |  |
| kindle_edition_normalized_pages_royalties_14_d | Double |  |
| match_type | String |  |
| purchases_14_d | Int |  |
| purchases_1_d | Int |  |
| purchases_30_d | Int |  |
| purchases_7_d | Int |  |
| purchases_other_sku_14_d | Int |  |
| purchases_other_sku_1_d | Int |  |
| purchases_other_sku_30_d | Int |  |
| purchases_other_sku_7_d | Int |  |
| qualified_borrows | Int |  |
| royalty_qualified_borrows | Int |  |
| sales_14_d | Double |  |
| sales_1_d | Double |  |
| sales_30_d | Double |  |
| sales_7_d | Double |  |
| sales_other_sku_14_d | Double |  |
| sales_other_sku_1_d | Double |  |
| sales_other_sku_30_d | Double |  |
| sales_other_sku_7_d | Double |  |
| units_sold_clicks_14_d | Int |  |
| units_sold_clicks_1_d | Int |  |
| units_sold_clicks_30_d | Int |  |
| units_sold_clicks_7_d | Int |  |
| units_sold_other_sku_14_d | Int |  |
| units_sold_other_sku_1_d | Int |  |
| units_sold_other_sku_30_d | Int |  |
| units_sold_other_sku_7_d | Int |  |

### sb_store_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| brand_entity_id | String | FK |
| height | Int |  |
| media_type | String |  |
| name | String |  |
| url | String |  |
| width | Int |  |

### ad_group_serving_status_detail

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| ad_group_id | String | PK, FK |
| help_url | String |  |
| message | String |  |

### keyword_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| bid | Double |  |
| creation_date | Instant |  |
| keyword_text | String |  |
| match_type | String |  |
| native_language_keyword | String |  |
| native_language_locale | String |  |
| serving_status | String |  |
| state | String |  |

### ad_group_suggested_keyword

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Long | FK |
| campaign_id | Long | FK |
| keyword_text | String |  |
| rec_id | String |  |
| search_term_impression_rank | Double |  |
| search_term_impression_share | Double |  |
| translation | String |  |
| user_selected_keyword | Boolean |  |

### sb_campaign_draft_creative_asin

| Column | Type | Keys |
| --- | --- | --- |
| campaign_draft_id | String | PK, FK |
| asin | String |  |

### sd_ad_group_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_updated_date | Instant | PK |
| campaign_id | String | FK |
| bid_optimization | String |  |
| creation_date | Instant |  |
| creative_type | String |  |
| default_bid | Double |  |
| name | String |  |
| serving_status | String |  |
| state | String |  |
| tactic | String |  |

### sb_ad_report

| Column | Type | Keys |
| --- | --- | --- |
| report_date | LocalDate | PK |
| _fivetran_id | String | PK, FK |
| ad_group_id | String | FK |
| ad_id | String | FK |
| applicable_budget_rule_id | String | FK |
| campaign_id | String | FK |
| attributed_branded_searches_14_d | Int |  |
| attributed_conversions_14_d | Int |  |
| attributed_conversions_14_d_same_sku | Int |  |
| attributed_detail_page_views_clicks_14_d | Int |  |
| attributed_order_rate_new_to_brand_14_d | Double |  |
| attributed_orders_new_to_brand_14_d | Int |  |
| attributed_orders_new_to_brand_percentage_14_d | Double |  |
| attributed_sales_14_d | Double |  |
| attributed_sales_14_d_same_sku | Double |  |
| attributed_sales_new_to_brand_14_d | Double |  |
| attributed_sales_new_to_brand_percentage_14_d | Double |  |
| attributed_units_ordered_new_to_brand_14_d | Int |  |
| attributed_units_ordered_new_to_brand_percentage_14_d | Double |  |
| clicks | Int |  |
| cost | Double |  |
| currency | String |  |
| dpv_14_d | Int |  |
| impressions | Int |  |
| units_sold_14_d | Int |  |
| vctr | Double |  |
| video_5_second_view_rate | Double |  |
| video_5_second_views | Int |  |
| video_complete_views | Int |  |
| video_first_quartile_views | Int |  |
| video_midpoint_views | Int |  |
| video_third_quartile_views | Int |  |
| video_unmutes | Int |  |
| viewable_impressions | Int |  |
| vtr | Double |  |

## Relationships

- sb_campaign_report(campaign_id) → sb_campaign_history(last_update_date)
- sb_campaign_report(applicable_budget_rule_id) → sb_budget_rule_history(last_updated_date)
- sb_benchmark_brand_and_category(brand) → sb_brand(_fivetran_id)
- sb_benchmark_brand_and_category(category_id) → sb_product_targeting_category(id)
- sb_campaign_bid_adjustments_by_placement(campaign_id) → sb_campaign_history(last_update_date)
- sb_store(brand_entity_id) → sb_brand(_fivetran_id)
- negative_keyword_history(campaign_id) → campaign_history(last_updated_date)
- negative_keyword_history(ad_group_id) → ad_group_history(last_updated_date)
- sb_budget_rule_recurrence_day(rule_id) → sb_budget_rule_history(last_updated_date)
- product_ad_serving_status_detail(product_ad_id) → product_ad_history(last_updated_date)
- sb_placement_report(campaign_id) → sb_campaign_history(last_update_date)
- sb_placement_report(applicable_budget_rule_id) → sb_budget_rule_history(last_updated_date)
- sb_budget_recommendation(campaign_id) → sb_campaign_history(last_update_date)
- ad_group_theme_based_bid_recommendation(profile_id) → profile(id)
- ad_group_theme_based_bid_recommendation(ad_group_id) → ad_group_history(id)
- ad_group_theme_based_bid_recommendation(campaign_id) → campaign_history(id)
- sb_ad_sub_page(_fivetran_id) → sb_creative_history(_fivetran_id)
- sd_negative_targeting_expression(target_id) → sd_negative_targeting_history(last_updated_date)
- asin_bid_analysis(profile_id) → profile(id)
- sb_negative_product_target_expression(target_id) → sb_product_target(id)
- sd_product_ad_report(ad_id) → sd_product_ad_history(last_updated_date)
- sd_product_ad_report(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_product_ad_report(campaign_id) → sd_campaign_history(last_updated_date)
- sb_product_target_resolved_expression(target_id) → sb_product_target(id)
- sb_target_report(target_id) → sb_product_target(id)
- sb_target_report(ad_group_id) → ad_group_history(last_updated_date)
- sb_target_report(campaign_id) → sb_campaign_history(last_update_date)
- sb_campaign_tag(campaign_id) → sb_campaign_history(last_update_date)
- sd_creative(ad_group_id) → sd_ad_group_history(last_updated_date)
- sb_budget_usage_history(campaign_id) → sb_campaign_history(last_update_date)
- sd_targeting_history(ad_group_id) → sd_ad_group_history(last_updated_date)
- campaign_negative_keyword_history(campaign_id) → campaign_history(last_updated_date)
- sd_brand_safety_status_history(domain_id) → sd_brand_safety_history(domain_id)
- sb_search_term_report(keyword_id) → sb_keyword(id)
- sb_search_term_report(ad_group_id) → ad_group_history(last_updated_date)
- sb_search_term_report(campaign_id) → sb_campaign_history(last_update_date)
- purchased_product_targeting_report(campaign_id) → campaign_history(last_updated_date)
- purchased_product_targeting_report(ad_group_id) → ad_group_history(last_updated_date)
- purchased_product_targeting_report(keyword_id) → keyword_history(last_updated_date)
- sb_budget_rule_campaign(rule_id) → sb_budget_rule_history(last_updated_date)
- sb_budget_rule_campaign(campaign_id) → sb_campaign_history(last_update_date)
- negative_targeting_clause_history(campaign_id) → campaign_history(last_updated_date)
- negative_targeting_clause_history(ad_group_id) → ad_group_history(last_updated_date)
- targeting_keyword_report(campaign_id) → campaign_history(last_updated_date)
- targeting_keyword_report(ad_group_id) → ad_group_history(last_updated_date)
- targeting_keyword_report(keyword_id) → keyword_history(last_updated_date)
- sb_ad_landing_page_asin(ad_id) → sb_ad_history(last_update_date)
- campaign_serving_status_detail(campaign_id) → campaign_history(last_updated_date)
- sb_campaign_bid_adjustment(campaign_draft_id) → sb_campaign_draft(id)
- sd_product_ad_history(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_product_ad_history(campaign_id) → sd_campaign_history(last_updated_date)
- sd_creative_moderation(creative_id) → sd_creative(id)
- campaign_placement_report(campaign_id) → campaign_history(last_updated_date)
- sb_targeting_recommendation_category(id) → sb_product_targeting_category(id)
- sb_keyword(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_keyword(campaign_id) → sb_campaign_history(last_update_date)
- sd_target_report(targeting_id) → sd_targeting_history(last_updated_date)
- sd_target_report(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_target_report(campaign_id) → sd_campaign_history(last_updated_date)
- keyword_serving_status_detail(keyword_id) → keyword_history(last_updated_date)
- search_term_targeting_report(campaign_id) → campaign_history(last_updated_date)
- search_term_targeting_report(ad_group_id) → ad_group_history(last_updated_date)
- search_term_targeting_report(keyword_id) → keyword_history(last_updated_date)
- sb_keyword_report(keyword_id) → sb_keyword(id)
- sb_keyword_report(campaign_id) → sb_campaign_history(last_update_date)
- sb_keyword_report(ad_group_id) → ad_group_history(last_updated_date)
- sb_keyword_report(applicable_budget_rule_id) → sb_budget_rule_history(last_updated_date)
- sd_purchased_products_reports(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_purchased_products_reports(campaign_id) → sd_campaign_history(last_updated_date)
- sd_targeting_expression(target_id) → sd_targeting_history(last_updated_date)
- sd_campaign_report(campaign_id) → sd_campaign_history(last_updated_date)
- product_ad_history(campaign_id) → campaign_history(last_updated_date)
- product_ad_history(ad_group_id) → ad_group_history(last_updated_date)
- sb_creative_video_asset(_fivetran_id) → sb_creative_history(_fivetran_id)
- sd_budget_usage_history(campaign_id) → sd_campaign_history(last_updated_date)
- budget_rule_campaign(rule_id) → budget_rule(id)
- budget_rule_campaign(campaign_id) → campaign_history(last_updated_date)
- sb_campaign_bid_adjustments_by_shopper_segment(campaign_id) → sb_campaign_history(last_update_date)
- targeting_clause_history(campaign_id) → campaign_history(last_updated_date)
- targeting_clause_history(ad_group_id) → ad_group_history(last_updated_date)
- sb_product_target_expression(target_id) → sb_product_target(id)
- sb_campaign_history(brand_entity_id) → sb_brand(_fivetran_id)
- sb_campaign_history(profile_id) → profile(id)
- sb_campaign_history(portfolio_id) → portfolio_history(last_updated_date)
- ad_group_bid_recommendation_value(parent_id) → ad_group_theme_based_bid_recommendation(_fivetran_id)
- sb_creative_custom_image(_fivetran_id) → sb_creative_history(_fivetran_id)
- campaign_level_report(campaign_id) → campaign_history(last_updated_date)
- portfolio_history(profile_id) → profile(id)
- sd_ad_group_report(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_ad_group_report(campaign_id) → sd_campaign_history(last_updated_date)
- ad_group_level_report(ad_group_id) → ad_group_history(last_updated_date)
- advertised_product_report(campaign_id) → campaign_history(last_updated_date)
- advertised_product_report(ad_group_id) → ad_group_history(last_updated_date)
- advertised_product_report(ad_id) → product_ad_history(last_updated_date)
- asin_bid_recommendation_value(parent_id) → asin_theme_based_bid_recommendation(_fivetran_id)
- sd_budget_rule_history(campaign_id) → sd_campaign_history(last_updated_date)
- sd_matched_target_report(targeting_id) → sd_targeting_history(last_updated_date)
- sd_matched_target_report(ad_group_id) → sd_ad_group_history(last_updated_date)
- sd_matched_target_report(campaign_id) → sd_campaign_history(last_updated_date)
- campaign_placement_bidding(campaign_id) → campaign_history(last_updated_date)
- sb_negative_keyword(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_negative_keyword(campaign_id) → sb_campaign_history(last_update_date)
- sd_negative_targeting_history(ad_group_id) → sd_ad_group_history(last_updated_date)
- sb_ad_group_history(campaign_id) → sb_campaign_history(last_update_date)
- sd_campaign_history(profile_id) → profile(id)
- sd_campaign_history(portfolio_id) → portfolio_history(last_updated_date)
- sd_targeting_resolved_expression(target_id) → sd_targeting_history(last_updated_date)
- sb_campaign_draft_subpage(campaign_draft_id) → sb_campaign_draft(id)
- search_term_ad_keyword_report(campaign_id) → campaign_history(last_updated_date)
- search_term_ad_keyword_report(ad_group_id) → ad_group_history(last_updated_date)
- search_term_ad_keyword_report(keyword_id) → keyword_history(last_updated_date)
- sb_negative_product_target(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_negative_product_target(campaign_id) → sb_campaign_history(last_update_date)
- ad_group_history(campaign_id) → campaign_history(last_updated_date)
- campaign_history(portfolio_id) → portfolio_history(last_updated_date)
- campaign_history(profile_id) → profile(id)
- sb_budget_rule_recommendation(campaign_id) → sb_campaign_history(last_update_date)
- asin_theme_based_bid_recommendation(profile_id) → profile(id)
- sb_campaign_draft_video_media(campaign_draft_id) → sb_campaign_draft(id)
- sb_ad_group_report(ad_group_id) → ad_group_history(last_updated_date)
- sb_ad_group_report(campaign_id) → sb_campaign_history(last_update_date)
- sb_store_page_info(store_id) → sb_store(id)
- sb_creative_original_video_asset(_fivetran_id) → sb_creative_history(_fivetran_id)
- sd_bid_recommendation(target_id) → sd_targeting_history(last_updated_date)
- sd_negative_targeting_resolved_expression(target_id) → sd_negative_targeting_history(last_updated_date)
- sb_purchased_product(campaign_id) → sb_campaign_history(last_update_date)
- sb_purchased_product(ad_group_id) → sb_ad_group_history(last_update_date)
- budget_rule_recurrence_day(rule_id) → budget_rule(id)
- ad_group_bid_analysis(profile_id) → profile(id)
- ad_group_bid_analysis(ad_group_id) → ad_group_history(id)
- ad_group_bid_analysis(campaign_id) → campaign_history(id)
- sb_targeting_recommendation_brand_category(category_id) → sb_product_targeting_category(id)
- sb_targeting_recommendation_brand_category(id) → sb_brand(_fivetran_id)
- sb_negative_product_target_resolved_expression(target_id) → sb_product_target(id)
- sb_product_target(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_product_target(campaign_id) → sb_campaign_history(last_update_date)
- targeting_report(campaign_id) → campaign_history(last_updated_date)
- targeting_report(ad_group_id) → ad_group_history(last_updated_date)
- targeting_report(keyword_id) → keyword_history(last_updated_date)
- sb_ad_history(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_ad_history(campaign_id) → sb_campaign_history(last_update_date)
- sb_creative_history(ad_id) → sb_ad_history(last_update_date)
- sb_creative_asin(_fivetran_id) → sb_creative_history(_fivetran_id)
- purchased_product_keyword_report(campaign_id) → campaign_history(last_updated_date)
- purchased_product_keyword_report(ad_group_id) → ad_group_history(last_updated_date)
- purchased_product_keyword_report(keyword_id) → keyword_history(last_updated_date)
- sb_store_asset(brand_entity_id) → sb_brand(_fivetran_id)
- ad_group_serving_status_detail(ad_group_id) → ad_group_history(last_updated_date)
- keyword_history(campaign_id) → campaign_history(last_updated_date)
- keyword_history(ad_group_id) → ad_group_history(last_updated_date)
- ad_group_suggested_keyword(ad_group_id) → ad_group_history(last_updated_date)
- ad_group_suggested_keyword(campaign_id) → campaign_history(last_updated_date)
- sb_campaign_draft_creative_asin(campaign_draft_id) → sb_campaign_draft(id)
- sd_ad_group_history(campaign_id) → sd_campaign_history(last_updated_date)
- sb_ad_report(ad_id) → sb_ad_history(last_update_date)
- sb_ad_report(applicable_budget_rule_id) → sb_budget_rule_history(last_updated_date)
- sb_ad_report(_fivetran_id) → sb_ad_history(last_update_date)
- sb_ad_report(ad_group_id) → sb_ad_group_history(last_update_date)
- sb_ad_report(campaign_id) → sb_campaign_history(last_update_date)