id 🔑

last_updated_date 🔑

portfolio_id ➤ PORTFOLIO_HISTORY.id

bidding_strategy

budget

effective_budget

budget_type

creation_date

end_date

name

profile_id

serving_status

start_date

state

targeting_type

CAMPAIGN_HISTORY ⇱

id 🔑

last_update_date 🔑

campaign_id ➤ CAMPAIGN_HISTORY.id

creation_date

default_bid

name

serving_status

state

AD_GROUP_HISTORY ⇱

id 🔑

last_updated_date 🔑

ad_group_id ➤ AD_GROUP_HISTORY

campaign_id ➤ CAMPAIGN_HISTORY

bid

creation_date

keyword_text

match_type

native_language_keyword

native_language_locale

serving_status

state

KEYWORD_HISTORY ⇱

id 🔑

last_updated_date 🔑

campaign_id ➤ CAMPAIGN_HISTORY

ad_group_id ➤ AD_GROUP_HISTORY

creation_date

keyword_text

match_type

native_language_keyword

native_language_locale

serving_status

state

NEGATIVE_KEYWORD_HISTORY ⇱

name 🔑

keyword_id 🔑 ➤ KEYWORD_HISTORY

help_url

message

CAMPAIGN_NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL ⇱

_fivetran_id 🔑

campaign_id ➤ CAMPAIGN_HISTORY.id

ad_group_id ➤ AD_GROUP_HISTORY.id

keyword_text

match_type

state

AD_GROUP_SUGGESTED_KEYWORD ⇱

_fivetran_id 🔑

asin

keyword_text

match_type

ASIN_SUGGESTED_KEYWORD ⇱

ad_id 🔑

last_updated_date 🔑

ad_group_id ➤ AD_GROUP_HISTORY.id

campaign_id ➤ CAMPAIGN_HISTORY.id

asin

creation_date

custom_text

sku

serving_status

state

PRODUCT_AD_HISTORY ⇱

name 🔑

product_ad_id 🔑 ➤ PRODUCT_AD_HISTORY

help_url

message

PRODUCT_AD_SERVING_STATUS_DETAIL ⇱

target_id 🔑

last_updated_date 🔑

ad_group_id ➤ AD_GROUP_HISTORY

campaign_id ➤ CAMPAIGN_HISTORY

bid

creation_date

expression_type

serving_status

state

TARGETING_CLAUSE_HISTORY ⇱

_fivetran_id 🔑

target_id ➤ TARGETING_CLAUSE_HISTORY

type

value

TARGETING_EXPRESSION ⇱

_fivetran_id 🔑

target_id ➤ TARGETING_CLAUSE_HISTORY

type

value

TARGETING_RESOLVED_EXPRESSION ⇱

target_id 🔑

last_updated_date 🔑

ad_group_id ➤ AD_GROUP_HISTORY

campaign_id ➤ CAMPAIGN_HISTORY

creation_date

expression_type

serving_status

state

NEGATIVE_TARGETING_CLAUSE_HISTORY ⇱

id 🔑

budget_increase_by_type

budget_increase_by_value

created_date

date_range_type_duration_end_date

date_range_type_duration_start_date

event_type_rule_duration_end_date

event_type_rule_duration_event_id

event_type_rule_duration_event_name

event_type_rule_duration_start_date

last_updated_date

name

preformance_measure_comparison_operator

preformance_measure_metric_name

preformance_measure_treshold

recurrence_type

state

status

type

BUDGET_RULE ⇱

campaign_id 🔑➤ CAMPAIGN_HISTORY.id

rule_id 🔑 ➤ BUDGET_RULE.rule_id

BUDGET_RULE_CAMPAIGN ⇱

day_of_week 🔑

rule_id 🔑 ➤ BUDGET_RULE.rule_id

BUDGET_RULE_RECURRENCE_DAY ⇱

_fivetran_id 🔑

target_id ➤ NEGATIVE_TARGETING_CLAUSE_HISTORY

type

value

NEGATIVE_TARGETING_EXPRESSION ⇱

_fivetran_id 🔑

target_id ➤ NEGATIVE_TARGETING_CLAUSE_HISTORY

type

value

NEGATIVE_TARGETING_RESOLVED_EXPRESSION ⇱

id 🔑

last_update_date 🔑

profile_id ➤ PROFILE

budget_amount

budget_currency_code

budget_end_date

budget_policy

budget_start_date

creation_date

in_budget

name

serving_status

state

PORTFOLIO_HISTORY ⇱

date 🔑

campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id

_metrics

CAMPAIGN_LEVEL_REPORT ⇱

date 🔑

placement 🔑

_metrics

CAMPAIGN_PLACEMENT_REPORT ⇱

date 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id

campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id

keyword_id 🔑 ➤ KEYWORD_HISTORY.id

_metrics

TARGETING_KEYWORD_REPORT ⇱

date 🔑�search_term

ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id

campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id

keyword_id 🔑 ➤ KEYWORD_HISTORY.id

_metrics

SEARCH_TERM_AD_KEYWORD_REPORT ⇱

date 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id

_metrics

AD_GROUP_LEVEL_REPORT ⇱

date 🔑

ad_id 🔑 ➤ PRODUCT_AD_HISTORY

ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id

campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id

_metrics

ADVERTISED_PRODUCT_REPORT ⇱

date 🔑

purchased_asin 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY.id

campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id

keyword_id 🔑 ➤ KEYWORD_HISTORY.id

_metrics

PURCHASED_PRODUCT_KEYWORD_REPORT ⇱

date 🔑�search_term

ad_group_id 🔑 ➤ AD_GROUP_HISTORY

campaign_id 🔑 ➤ CAMPAIGN_HISTORY

_metrics

SEARCH_TERM_TARGETING_REPORT ⇱

date 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY

campaign_id 🔑 ➤ CAMPAIGN_HISTORY�keyword_id 🔑 ➤ TARGETING_EXPRESSION.target_id

_metrics

TARGETING_REPORT ⇱

date 🔑

purchased_asin 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY

campaign_id 🔑 ➤ CAMPAIGN_HISTORY

keyword_id 🔑 ➤ KEYWORD_HISTORY.id

_metrics

PURCHASED_PRODUCT_TARGETING_REPORT ⇱

name 🔑

campaign_id 🔑 ➤ CAMPAIGN_HISTORY

help_url

message

CAMPAIGN_SERVING_STATUS_DETAIL ⇱

placement 🔑

campaign_id 🔑 ➤ CAMPAIGN_HISTORY

percentage

CAMPAIGN_PLACEMENT_BIDDING ⇱

name 🔑

campaign_id 🔑 ➤ CAMPAIGN_HISTORY

value

CAMPAIGN_TAG ⇱

name 🔑

ad_group_id 🔑 ➤ AD_GROUP_HISTORY

help_url

message

AD_GROUP_SERVING_STATUS_DETAIL ⇱

name 🔑

keyword_id 🔑 ➤ KEYWORD_HISTORY

help_url

message

KEYWORD_SERVING_STATUS_DETAIL ⇱

name 🔑

keyword_id 🔑 ➤ KEYWORD_HISTORY

help_url

message

NEGATIVE_KEYWORD_SERVING_STATUS_DETAIL ⇱

id 🔑

last_updated_date 🔑

campaign_id ➤ CAMPAIGN_HISTORY

creation_date

keyword_text

match_type

serving_status

state

CAMPAIGN_NEGATIVE_KEYWORD_HISTORY ⇱

name 🔑

target_id 🔑 ➤ TARGETING_CLAUSE_HISTORY

help_url

level

TARGETING_SERVING_STATUS_DETAIL ⇱

name 🔑

target_id 🔑 ➤ TARGETING_CLAUSE_HISTORY

help_url

level

NEGATIVE_TARGETING_SERVING_STATUS_DETAIL ⇱

id 🔑

account_id

account_marketplace_string_id

account_name

account_sub_type

account_type

account_valid_payment_method

currency_code

country_code

daily_budget

timezone

PROFILE ⇱

_fivetran_id 🔑

profile_id ➤ PROFILE

asin

estimated_impression_lower

estimated_impression_upper

strategy

targeting_type

theme

ASIN_THEME_BASED_BID_RECOMMENDATION ⇱

parent_id 🔑➤ ASIN_THEME_BASED_BID_RECOMMENDATION

index 🔑

suggested_bid

ASIN_BID_RECOMMENDATION_VALUE ⇱

_fivetran_id 🔑

profile_id ➤ PROFILE

asin ➤ AD_GROUP_HISTORY

bid

estimated_impression_avg

estimated_impression_lower

estimated_impression_upper

placement

strategy

targeting_type

theme

type_of_bid

ASIN_BID_ANALYSIS ⇱

_fivetran_id 🔑

ad_group_id ➤ AD_GROUP_HISTORY

campaign_id ➤ CAMPAIGN_HISTORY

profile_id ➤ PROFILE

estimated_impression_lower

estimated_impression_upper

targeting_type

theme

AD_GROUP_THEME_BASED_BID_RECOMMENDATION ⇱

parent_id 🔑 ➤ AD_GROUP_THEME_BASED_BID_RECOMMENDATION

index 🔑

suggested_bid

AD_GROUP_BID_RECOMMENDATION_VALUE ⇱

_fivetran_id 🔑

ad_group_id ➤ AD_GROUP_HISTORY

campaign_id ➤ CAMPAIGN_HISTORY

profile_id ➤ PROFILE

bid

estimated_impression_avg

estimated_impression_lower

estimated_impression_upper

placement

targeting_type

theme

type_of_bid

AD_GROUP_BID_ANALYSIS ⇱

id 🔑

last_updated_date 🔑

portfolio_id ➤ PORTFOLIO_HISTORY

profile_id ➤ PROFILE

budget

budget_type

cost_type

creation_date

delivery_profile

end_date

name

serving_status

start_date

state

tactic

SD_CAMPAIGN_HISTORY ⇱

id 🔑

last_updated_date 🔑

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

bid_optimization

creation_date

creative_type

default_bid

name

serving_status

state

tactic

SD_AD_GROUP_HISTORY ⇱

id 🔑

last_updated_date 🔑

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

ad_name

asin

creation_date

landing_page_type

landing_page_url

serving_status

sku

state

SD_PRODUCT_AD_HISTORY ⇱

id 🔑

last_updated_date 🔑

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

bid

creation_date

expression_type

serving_status

state

SD_TARGETING_HISTORY ⇱

id 🔑

last_updated_date 🔑

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

creation_date

expression_type

serving_status

state

​

SD_NEGATIVE_TARGETING_HISTORY ⇱

_fivetran_id 🔑

target_id ➤ SD_NEGATIVE_TARGETING_HISTORY.id

value

type

SD_NEGATIVE_TARGETING_RESOLVED_EXPRESSION ⇱

domain_id 🔑

last_modified 🔑

created_at

name

state

type

SD_BRAND_SAFETY_HISTORY ⇱

request_id 🔑

domain_id ➤ SD_BRAND_SAFETY_HISTORY

details

status

SD_BRAND_SAFETY_STATUS_HISTORY ⇱

id 🔑

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

creative_type

properties_*

SD_CREATIVE ⇱

moderation_status 🔑

creative_id 🔑 ➤ SD_CREATIVE.id

eta_for_moderation

SD_CREATIVE_MODERATION ⇱

report_date 🔑

tactic 🔑

campaign_id 🔑➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_CAMPAIGN_REPORT_V_2 ⇱

report_date 🔑

tactic 🔑

ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_AD_GROUP_REPORT_V_2 ⇱

report_date 🔑

tactic 🔑

ad_id 🔑 ➤ SD_PRODUCT_AD_HISTORY.id

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_PRODUCT_AD_REPORT_V_2 ⇱

report_date 🔑

tactic 🔑

target_id 🔑 ➤ SD_TARGETING_HISTORY.id

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_TARGET_REPORT_V_2 ⇱

_fivetran_id 🔑

report_date 🔑

tactic 🔑

asin

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_ASIN_REPORT_V_2 ⇱

report_date 🔑

tactic 🔑

target_id 🔑 ➤ SD_TARGETING_HISTORY.id

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_MATCHED_TARGET_REPORT_V_2 ⇱

asin 🔑

target_asin 🔑

rank

SD_TARGETING_RECOMMENDATION_PRODUCT ⇱

category 🔑

target_asin 🔑

tactic 🔑

name

rank

targetable_asin_count_range_lower

targetable_asin_count_range_upper

translated_name

SD_TARGETING_RECOMMENDATION_CATEGORY ⇱

audience 🔑

target_asin 🔑

category

name

rank

SD_TARGETING_RECOMMENDATION_AUDIENCE ⇱

asin 🔑

target_id 🔑 ➤ SD_TARGETING_HISTORY.id

bid_optimization

cost_type

range_lower

range_upper

recommended

SD_BID_RECOMMENDATION ⇱

_fivetran_id 🔑

target_id ➤ SD_NEGATIVE_TARGETING_HISTORY.id

value

type

SD_NEGATIVE_TARGETING_EXPRESSION ⇱

id 🔑

last_updated_date 🔑

campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id

created_date

rule_state

rule_status

rule_detail_*

SD_BUDGET_RULE_HISTORY ⇱

usage_updated_timestamp 🔑

campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id

budget

budget_usage_percent

SD_BUDGET_USAGE_HISTORY ⇱

_fivetran_id 🔑

target_id ➤ SD_TARGETING_HISTORY.id

value

type

SD_TARGETING_EXPRESSION ⇱

_fivetran_id 🔑

target_id ➤ SD_TARGETING_HISTORY.id

value

type

SD_TARGETING_RESOLVED_EXPRESSION ⇱

date 🔑

campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id

_metrics

SD_CAMPAIGN_REPORT ⇱

date 🔑

ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤SD_CAMPAIGN_HISTORY.id

_metrics

SD_AD_GROUP_REPORT ⇱

date 🔑

ad_id 🔑 ➤ SD_AD_GROUP_HISTORY.id

ad_group_id ➤ SD_AD_GROUP_HISTORY.id

campaign_id ➤SD_CAMPAIGN_HISTORY.id

_metrics

SD_PRODUCT_AD_REPORT ⇱

date 🔑

ad_group_id 🔑

asin_brand_halo 🔑

campaign_id 🔑 ➤ SD_CAMPAIGN_HISTORY.id

promoted_asin 🔑

promoted_sku 🔑

_metrics

SD_PURCHASED_PRODUCTS_REPORTS ⇱

date 🔑

ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id

campaign_id 🔑 ➤SD_CAMPAIGN_HISTORY.id

targeting_id 🔑 ➤SD_TARGETING_HISTORY.id

_metrics

SD_TARGET_REPORT ⇱

date 🔑

ad_group_id 🔑 ➤ SD_AD_GROUP_HISTORY.id

campaign_id 🔑 ➤SD_CAMPAIGN_HISTORY.id

matched_target_asin

targeting_id 🔑 ➤SD_TARGETING_HISTORY.id

_metrics

SD_MATCHED_TARGET_REPORT ⇱

id 🔑

last_updated_date 🔑

brand_entity_id ➤ SB_BRAND

portfolio_id ➤ PORTFOLIO_HISTORY

profile_id ➤ PROFILE

bid_optimization

bid_optimization_strategy

budget

budget_type

creation_date

end_date

goal

is_multi_ad_groups_enabled

name

product_location

rule_based_budget_applicable_rule_id

rule_based_budget_applicable_rule_name

rule_based_budget_is_processing

rule_based_budget_value

start_date

state

SB_CAMPAIGN_HISTORY ⇱

shopper_segment 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

percentage

SB_CAMPAIGN_BID_ADJUSTMENTS_BY_SHOPPER_SEGMENT ⇱

placement 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

percentage

SB_CAMPAIGN_BID_ADJUSTMENTS_BY_PLACEMENT ⇱

tag_name 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

value

SB_CAMPAIGN_TAG ⇱

id 🔑

last_update_date 🔑

campaign_id ➤ SB_CAMPAIGN_HISTORY

creation_date

name

serving_status

state

SB_AD_GROUP_HISTORY ⇱

seven_days_start_date 🔑

seven_days_end_date 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY.id

seven_days_estimated_clicks_lower

seven_days_estimated_clicks_upper

seven_days_estimated_impressions_lower

seven_days_estimated_impressions_upper

seven_days_estimated_missed_sales_lower

seven_days_estimated_missed_sales_upper

seven_days_percent_time_in_budget

suggested_budget

SB_BUDGET_RECOMMENDATION_HISTORY ⇱

_fivetran_id 🔑

last_update_date 🔑

campaign_id ➤ SB_CAMPAIGN_HISTORY

ad_group_id

creation_date

id

landing_page_page_type

landing_page_url

name

serving_status

state

SB_AD_HISTORY ⇱

asin 🔑

ad_id 🔑➤ SB_AD_HISTORY

SB_AD_LANDING_PAGE_ASIN ⇱

_fivetran_id 🔑

ad_id ➤ SB_AD_HISTORY

brand_logo_asset_id

brand_logo_crop_height

brand_logo_crop_left

brand_logo_crop_top

brand_logo_crop_width

brand_logo_url

brand_name

creation_time

creative_type

creative_version

creative_status

custom_image_asset_id

custom_image_crop_height

custom_image_crop_left

custom_image_crop_top

custom_image_crop_width

custom_image_url

headline

last_update_time

landing_page_type

landing_page_value

SB_CREATIVE_HISTORY ⇱

asset_id 🔑

_fivetran_id 🔑➤ SB_CREATIVE_HISTORY

crop_height

crop_left

crop_top

crop_width

url

SB_CREATIVE_CUSTOM_IMAGE ⇱

asin 🔑

_fivetran_id 🔑➤ SB_CREATIVE_HISTORY

SB_CREATIVE_ASIN ⇱

asin 🔑

url 🔑

_fivetran_id 🔑➤ SB_CREATIVE_HISTORY

page_title

SB_CREATIVE_SUB_PAGE ⇱

id 🔑

_fivetran_id 🔑➤ SB_CREATIVE_HISTORY

SB_CREATIVE_ORIGINAL_VIDEO_ASSET ⇱

id 🔑

last_updated_date 🔑

budget_increase_by_type

budget_increase_by_value

created_date

date_range_type_duration_end_date

date_range_type_duration_start_date

event_type_rule_duration_end_date

event_type_rule_duration_event_id

event_type_rule_duration_event_name

event_type_rule_duration_start_date

name

preformance_measure_comparison_operator

preformance_measure_metric_name

preformance_measure_treshold

recurrence_type

status

type

SB_BUDGET_RULE_HISTORY ⇱

day_of_week 🔑

rule_id 🔑 ➤ SB_BUDGET_RULE_HISTORY

SB_BUDGET_RULE_RECURRENCE_DAY ⇱

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

rule_id 🔑 ➤ SB_BUDGET_RULE_HISTORY

SB_BUDGET_RULE_CAMPAIGN ⇱

usage_updated_timestamp 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

budget

budget_usage_percent

SB_BUDGET_USAGE_HISTORY ⇱

id 🔑

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

keyword_text

match_type

native_language_keyword

state

SB_KEYWORD ⇱

id 🔑

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

keyword_text

match_type

state

SB_NEGATIVE_KEYWORD ⇱

entity_id 🔑

brand_entity_id

store_name

SB_STORE ⇱

id 🔑

entity_id 🔑➤ SB_STORE.entity_id

name

url

SB_STORE_PAGE_INFO ⇱

_fivetran_id 🔑

id

entity_id

registry_name

SB_BRAND ⇱

_fivetran_id 🔑

date 🔑

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

attribution_type

campaign_budget_currency_code

product_category

product_name

purchased_asin

_metrics

SB_PURCHASED_PRODUCT_REPORT ⇱ ⇱

id 🔑

_fivetran_id 🔑➤ SB_CREATIVE_HISTORY

SB_CREATIVE_VIDEO_ASSET ⇱

event_id 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

end_date

event_name

start_date

suggested_budget_increase_percent

SB_BUDGET_RULE_RECOMMENDATION ⇱

id 🔑

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

bid

state

SB_PRODUCT_TARGET ⇱

id 🔑

asin_count_range_max

asin_count_range_min

estimated_reach_max

estimated_reach_min

is_targetable

name

parent_category_refinement_id

supply_source

translated_name

SB_PRODUCT_TARGETING_CATEGORY ⇱

id 🔑

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

bid

state

SB_NEGATIVE_PRODUCT_TARGET ⇱

asin 🔑

recommended_target_asin

SB_TARGETING_RECOMMENDATION_PRODUCT ⇱

asin 🔑

id 🔑➤ SB_PRODUCT_TARGETING_CATEGORY�estimated_reach

is_targetable

name

path

supply_source

translated_name

translated_path

SB_TARGETING_RECOMMENDATION_CATEGORY ⇱

brand_id 🔑➤ SB_BRAND

category_id 🔑➤ SB_PRODUCT_TARGETING_CATEGORY�brand_name

SB_TARGETING_RECOMMENDATION_BRAND_CATEGORY ⇱

asin 🔑

id 🔑

match_type

search_term_impression_rank

search_term_impression_share

translation

type

value

SB_KEYWORD_RECOMMENDATION_ASIN ⇱

id 🔑

url 🔑

match_type

search_term_impression_rank

search_term_impression_share

translation

type

url_type

value

SB_KEYWORD_RECOMMENDATION_URL ⇱

brand_name 🔑 ➤ SB_BRAND

category_id 🔑 ➤ SB_PRODUCT_TARGETING_CATEGORY

start_date 🔑

end_date 🔑

acos_median

acos_top_25_pct

acos_value

acos_bottom_25_pct

ctr_median

ctr_top_25_pct

ctr_value

ctr_bottom_25_pct

impressions_median

impressions_top_25_pct

impressions_value

impressions_bottom_25_pct

roas_median

roas_top_25_pct

roas_value

roas_bottom_25_pct

SB_BENCHMARK_BRAND_AND_CATEGORY_REPORT ⇱

id 🔑

brand_entity_id 🔑➤ SB_BRAND.entity_id

height

media_type

name

url

width

SB_STORE_ASSET ⇱

type 🔑

target_id 🔑 ➤ SB_PRODUCT_TARGET

value

SB_PRODUCT_TARGET_EXPRESSION ⇱

target_id 🔑 ➤ SB_PRODUCT_TARGET

type 🔑

value

SB_PRODUCT_TARGET_RESOLVED_EXPRESSION ⇱

report_date 🔑

campaign_id 🔑 ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_CAMPAIGN_REPORT ⇱ ⇱ ⇱

report_date 🔑

placement 🔑

campaign_id 🔑➤ SB_CAMPAIGN_HISTORY

_metrics

SB_PLACEMENT_REPORT ⇱ ⇱ ⇱

report_date 🔑

ad_group_id 🔑 ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_AD_GROUP_REPORT ⇱ ⇱ ⇱

report_date 🔑

target_id 🔑 ➤ SB_PRODUCT_TARGET

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_TARGET_REPORT ⇱ ⇱ ⇱

report_date 🔑

keyword_id 🔑 ➤ SB_KEYWORD

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_KEYWORD_REPORT ⇱ ⇱ ⇱

report_date 🔑

query_term 🔑

keyword_id 🔑➤ SB_KEYWORD

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_SEARCH_TERM_REPORT ⇱ ⇱ ⇱

report_date 🔑

_fivetran_id 🔑➤ SB_AD_HISTORY

ad_id ➤ SB_AD_HISTORY

ad_group_id ➤ SB_AD_GROUP_HISTORY

campaign_id ➤ SB_CAMPAIGN_HISTORY

_metrics

SB_AD_REPORT ⇱ ⇱ ⇱

type 🔑

target_id 🔑 ➤ SB_PRODUCT_TARGET

value

SB_NEGATIVE_PRODUCT_TARGET_EXPRESSION ⇱

target_id 🔑 ➤ SB_PRODUCT_TARGET

type 🔑

value

SB_NEGATIVE_PRODUCT_TARGET_RESOLVED_EXPRESSION ⇱