Fivetran documentation

Search the docs

/

Apple Search Ads

Explore the interactive ERD

Table & Field Reference

locale_device

Column	Type	Keys
`language_code`	String	PK
`name`	String	PK
`product_page_id`	String	PKFK

ad_level_report

Column	Type	Keys
`date`	LocalDate	PK
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`campaign_id`	Long	PKFK
`creative_id`	Long	PKFK
`avg_cpm_amount`	BigDecimal
`avg_cpm_currency`	String
`avg_cpt_amount`	BigDecimal
`avg_cpt_currency`	String
`display_status`	String
`impressions`	Int
`language`	String
`local_spend_amount`	BigDecimal
`local_spend_currency`	String
`tap_install_cpi_amount`	BigDecimal
`tap_install_cpi_currency`	String
`tap_install_rate`	BigDecimal
`tap_installs`	Long
`tap_new_downloads`	Long
`tap_redownloads`	Long
`tap_through_rate`	Float
`taps`	Int
`total_avg_cpi_amount`	BigDecimal
`total_avg_cpi_currency`	String
`total_install_rate`	BigDecimal
`total_installs`	Long
`total_new_downloads`	Long
`total_redownloads`	Long
`view_installs`	Long
`view_new_downloads`	Long
`view_redownloads`	Long

targeting_dimensions_history

Column	Type	Keys
`type`	String	PK
`ad_group_id`	Long	PKFK
`ad_group_modification_time`	Instant	PKFK
`value`	Json

product_page_history

Column	Type	Keys
`id`	String	PK
`modification_time`	Instant	PK
`adam_id`	Long
`creation_time`	Instant
`deep_link`	String
`name`	String
`state`	String

ad_serving_state_reason_history

Column	Type	Keys
`modification_time`	Instant	PK
`reason`	String	PK
`ad_id`	Long	PKFK

organization

Column	Type	Keys
`id`	Long	PK
`currency`	String
`name`	String
`payment_model`	String
`role_names`	Json
`time_zone`	String

impression_share_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`organization_id`	Long	PKFK
`adam_id`	Long
`app_name`	String
`country_or_region`	String
`high_impression_share`	BigDecimal
`low_impression_share`	BigDecimal
`rank`	String
`search_popularity`	Int
`search_term`	String

search_term_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`ad_group_id`	Long	PKFK
`campaign_id`	Long	PKFK
`keyword_id`	Long	FK
`ad_group_deleted`	Boolean
`ad_group_name`	String
`avg_cpm_amount`	BigDecimal
`avg_cpm_currency`	String
`avg_cpt_amount`	BigDecimal
`avg_cpt_currency`	String
`bid_amount_amount`	BigDecimal
`bid_amount_currency`	String
`deleted`	Boolean
`impressions`	Int
`keyword`	String
`keyword_display_status`	String
`local_spend_amount`	BigDecimal
`local_spend_currency`	String
`match_type`	String
`search_term_source`	String
`search_term_text`	String
`tap_install_cpi_amount`	BigDecimal
`tap_install_cpi_currency`	String
`tap_install_rate`	BigDecimal
`tap_installs`	Long
`tap_new_downloads`	Long
`tap_redownloads`	Long
`tap_through_rate`	Float
`taps`	Int
`total_avg_cpi_amount`	BigDecimal
`total_avg_cpi_currency`	String
`total_install_rate`	BigDecimal
`total_installs`	Long
`total_new_downloads`	Long
`total_redownloads`	Long
`view_installs`	Long
`view_new_downloads`	Long
`view_redownloads`	Long

ad_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`ad_group_id`	Long	FK
`campaign_id`	Long	FK
`creative_id`	Long	FK
`org_id`	Long	FK
`creation_time`	Instant
`creative_type`	String
`deleted`	Boolean
`name`	String
`serving_status`	String
`status`	String

creative_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`org_id`	Long	FK
`product_page_id`	String	FK
`adam_id`	Long
`creation_time`	Instant
`language_code`	String
`name`	String
`state`	String
`type`	String

campaign_report

Column	Type	Keys
`date`	LocalDate	PK
`id`	Long	PKFK
`ad_channel_type`	String
`avg_cpm_amount`	BigDecimal
`avg_cpm_currency`	String
`avg_cpt_amount`	BigDecimal
`avg_cpt_currency`	String
`device_class`	String
`impressions`	Int
`local_spend_amount`	BigDecimal
`local_spend_currency`	String
`tap_install_cpi_amount`	BigDecimal
`tap_install_cpi_currency`	String
`tap_install_rate`	BigDecimal
`tap_installs`	Long
`tap_new_downloads`	Long
`tap_redownloads`	Long
`tap_through_rate`	Float
`taps`	Int
`total_avg_cpi_amount`	BigDecimal
`total_avg_cpi_currency`	String
`total_install_rate`	BigDecimal
`total_installs`	Long
`total_new_downloads`	Long
`total_redownloads`	Long
`view_installs`	Long
`view_new_downloads`	Long
`view_redownloads`	Long

country_or_region_history

Column	Type	Keys
`index`	Long	PK
`campaign_id`	Long	PKFK
`campaign_modification_time`	Instant	PKFK
`country_or_region`	String

keyword_report

Column	Type	Keys
`date`	LocalDate	PK
`id`	Long	PKFK
`avg_cpm_amount`	BigDecimal
`avg_cpm_currency`	String
`avg_cpt_amount`	BigDecimal
`avg_cpt_currency`	String
`impressions`	Int
`local_spend_amount`	BigDecimal
`local_spend_currency`	String
`tap_install_cpi_amount`	BigDecimal
`tap_install_cpi_currency`	String
`tap_install_rate`	BigDecimal
`tap_installs`	Long
`tap_new_downloads`	Long
`tap_redownloads`	Long
`tap_through_rate`	Float
`taps`	Int
`total_avg_cpi_amount`	BigDecimal
`total_avg_cpi_currency`	String
`total_install_rate`	BigDecimal
`total_installs`	Long
`total_new_downloads`	Long
`total_redownloads`	Long
`view_installs`	Long
`view_new_downloads`	Long
`view_redownloads`	Long

negative_keyword_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`ad_group_id`	Long	FK
`campaign_id`	Long	FK
`deleted`	Boolean
`match_type`	String
`status`	String
`text`	String

creative_state_reason_history

Column	Type	Keys
`modification_time`	Instant	PK
`reason`	String	PK
`creative_id`	Long	PKFK

keyword_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`ad_group_id`	Long	FK
`campaign_id`	Long	FK
`bid_amount`	BigDecimal
`bid_currency`	String
`creation_time`	Instant
`deleted`	Boolean
`match_type`	String
`status`	String
`text`	String

product_page_locale

Column	Type	Keys
`language_code`	String	PK
`product_page_id`	String	PKFK
`adam_id`	Long
`app_name`	String
`language`	String
`promotional_text`	String
`short_description`	String
`sub_title`	String

ad_group_report

Column	Type	Keys
`date`	LocalDate	PK
`ad_group_id`	Long	PKFK
`avg_cpm_amount`	BigDecimal
`avg_cpm_currency`	String
`avg_cpt_amount`	BigDecimal
`avg_cpt_currency`	String
`device_class`	String
`impressions`	Int
`local_spend_amount`	BigDecimal
`local_spend_currency`	String
`tap_install_cpi_amount`	BigDecimal
`tap_install_cpi_currency`	String
`tap_install_rate`	BigDecimal
`tap_installs`	Long
`tap_new_downloads`	Long
`tap_redownloads`	Long
`tap_through_rate`	Float
`taps`	Int
`total_avg_cpi_amount`	BigDecimal
`total_avg_cpi_currency`	String
`total_install_rate`	BigDecimal
`total_installs`	Long
`total_new_downloads`	Long
`total_redownloads`	Long
`view_installs`	Long
`view_new_downloads`	Long
`view_redownloads`	Long

campaign_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`organization_id`	Long	FK
`ad_channel_type`	String
`adam_id`	Long
`billing_event`	String
`budget_amount`	BigDecimal
`budget_currency`	String
`budget_orders`	Json
`creation_time`	Instant
`daily_budget_amount`	BigDecimal
`daily_budget_currency`	String
`deleted`	Boolean
`display_status`	String
`end_time`	Instant
`name`	String
`payment_model`	String
`serving_state_reasons`	Json
`serving_status`	String
`start_time`	Instant
`status`	String
`supply_sources`	Json
`loc_invoice_detail_`

ad_group_history

Column	Type	Keys
`id`	Long	PK
`modification_time`	Instant	PK
`campaign_id`	Long	FK
`organization_id`	Long	FK
`automated_keywords_opt_in`	Boolean
`cpa_goal_amount`	BigDecimal
`cpa_goal_currency`	String
`default_bid_amount`	BigDecimal
`default_bid_currency`	String
`default_cpc_bid_amount`	BigDecimal
`default_cpc_bid_currency`	String
`deleted`	Boolean
`display_status`	String
`end_time`	Instant
`name`	String
`payment_model`	String
`pricing_model`	String
`serving_state_reasons`	Json
`serving_status`	String
`start_time`	Instant
`status`	String
`storefronts`	Json