Amazon Ads

Explore the interactive ERD

Table & Field Reference

sb_campaign_report

Column	Type	Keys
`report_date`	LocalDate	PK
`campaign_id`	String	PKFK
`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	PKFK
`category_id`	String	PKFK
`acos_`
`ctr_`
`impressions_`
`roas_`

sb_campaign_bid_adjustments_by_placement

Column	Type	Keys
`placement`	String	PK
`campaign_id`	String	PKFK
`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	PKFK

product_ad_serving_status_detail

Column	Type	Keys
`name`	String	PK
`product_ad_id`	String	PKFK
`help_url`	String
`message`	String

sb_placement_report

Column	Type	Keys
`placement`	String	PK
`report_date`	LocalDate	PK
`campaign_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`value`	String

sd_product_ad_report

Column	Type	Keys
`date`	LocalDate	PK
`ad_id`	String	PKFK
`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	PKFK
`value`	String

sb_target_report

Column	Type	Keys
`report_date`	LocalDate	PK
`target_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK
`rule_id`	String	PKFK

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	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK

campaign_serving_status_detail

Column	Type	Keys
`name`	String	PK
`campaign_id`	String	PKFK
`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	PKFK
`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	PKFK
`eta_for_moderation`	String

campaign_placement_report

Column	Type	Keys
`date`	LocalDate	PK
`placement`	String	PK
`campaign_id`	Long	PKFK
`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	PKFK
`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	PKFK
`campaign_id`	String	PKFK
`targeting_id`	String	PKFK
`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	PKFK
`help_url`	String
`message`	String

search_term_targeting_report

Column	Type	Keys
`date`	LocalDate	PK
`search_term`	String	PK
`ad_group_id`	Long	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK
`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	PKFK
`campaign_id`	String	PKFK
`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	PKFK
`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	PKFK

sd_budget_usage_history

Column	Type	Keys
`usage_updated_timestamp`	Instant	PK
`campaign_id`	String	PKFK
`budget`	Double
`budget_usage_percent`	Double

budget_rule_campaign

Column	Type	Keys
`campaign_id`	Long	PKFK
`rule_id`	String	PKFK

sb_campaign_bid_adjustments_by_shopper_segment

Column	Type	Keys
`shopper_segment`	String	PK
`campaign_id`	String	PKFK
`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	PKFK
`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	PKFK
`suggested_bid`	Double

sb_creative_custom_image

Column	Type	Keys
`asset_id`	String	PK
`_fivetran_id`	String	PKFK
`url`	String
`crop_`

campaign_level_report

Column	Type	Keys
`date`	LocalDate	PK
`campaign_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`ad_id`	Long	PKFK
`campaign_id`	Long	PKFK
`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	PKFK
`suggested_bid`	Double

sd_budget_rule_history

Column	Type	Keys
`id`	String	PK
`last_updated_date`	Instant	PK
`campaign_id`	String	PKFK
`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	PKFK
`campaign_id`	String	PKFK
`targeting_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK
`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	PKFK
`id`	String

sb_ad_group_report

Column	Type	Keys
`report_date`	LocalDate	PK
`ad_group_id`	Long	PKFK
`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	PKFK
`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	PKFK

sd_bid_recommendation

Column	Type	Keys
`asin`	String	PK
`target_id`	String	PKFK
`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	PKFK

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	PKFK
`id`	String	FK
`name`	String

sb_negative_product_target_resolved_expression

Column	Type	Keys
`type`	String	PK
`target_id`	String	PKFK
`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	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK

purchased_product_keyword_report

Column	Type	Keys
`date`	LocalDate	PK
`purchased_asin`	String	PK
`ad_group_id`	Long	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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