Apple App Store

Explore the interactive ERD

Table & Field Reference

app_store_review

Column	Type	Keys
`id`	String	PK
`app_id`	Long	PKFK
`body`	String
`created_date`	Instant
`rating`	Int
`reviewer_nickname`	String
`territory`	String
`title`	String

app_store_app_version_review

Column	Type	Keys
`app_version_id`	String	PKFK
`review_id`	String	PKFK

app_store_pre_order_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`campaign`	String
`device`	String
`page_title`	String
`page_type`	String
`platform_version`	String
`pre_order_canceled`	Int
`pre_order_end_date`	LocalDate
`pre_order_placed`	Int
`pre_order_start_date`	LocalDate
`source_info`	String
`source_type`	String
`territory`	String

sales_subscription_event_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`_fivetran_index`	Int
`app_apple_id`	Long
`app_name`	String
`cancellation_reason`	String
`client`	String
`consecutive_paid_periods`	Int
`country`	String
`days_before_canceling`	Int
`days_canceled`	Int
`device`	String
`event`	String
`event_date`	LocalDate
`marketing_opt_in`	String
`marketing_opt_in_duration`	String
`original_start_date`	LocalDate
`paid_service_days_recovered`	Int
`preserved_pricing`	String
`previous_subscription_apple_id`	Long
`previous_subscription_name`	String
`proceeds_reason`	String
`promotional_offer_id`	String
`promotional_offer_name`	String
`quantity`	Int
`requested_report_date`	LocalDate
`standard_subscription_duration`	String
`state`	String
`subscription_apple_id`	Long
`subscription_group_id`	Long
`subscription_name`	String
`subscription_offer_duration`	String
`subscription_offer_type`	String

app_store_purchase_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`campaign`	String
`content_apple_identifier`	String
`content_name`	String
`device`	String
`page_title`	String
`page_type`	String
`paying_users`	Int
`payment_method`	String
`platform_version`	String
`pre_order`	String
`proceeds_in_usd`	Double
`purchase_type`	String
`purchases`	Int
`sales_in_usd`	Double
`source_info`	String
`source_type`	String
`territory`	String

app_session_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`app_version`	String
`campaign`	String
`device`	String
`page_title`	String
`page_type`	String
`platform_version`	String
`sessions`	Int
`source_info`	String
`source_type`	String
`territory`	String
`total_session_duration`	Int
`unique_devices`	Int

financial

Column	Type	Keys
`_fivetran_id`	String	PK
`country_code`	String	PK
`vendor_number`	Int	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`artist_show_developer_author`	String
`country_of_sale`	String
`customer_currency`	String
`customer_price`	Double
`end_date`	LocalDate
`extended_partner_share`	Double
`filename`	String
`grid`	String
`isan_other_identifier`	String
`isrc_isbn`	String
`label_studio_network_developer_publisher`	String
`partner_share`	Double
`partner_share_currency`	String
`pre_order_flag`	String
`product_type_identifier`	String
`promo_code`	String
`quantity`	Int
`requested_report_date`	LocalDate
`sale_or_return`	String
`start_date`	LocalDate
`title`	String
`upc`	String
`vendor_identifier`	String

app_store_discovery_and_engagement_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`counts`	Int
`device`	String
`engagement_type`	String
`event`	String
`page_type`	String
`platform_version`	String
`source_type`	String
`territory`	String
`unique_counts`	Int

app_store_download_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_version`	String
`counts`	Int
`device`	String
`download_type`	String
`page_type`	String
`platform_version`	String
`pre_order`	String
`source_type`	String
`territory`	String

app_store_in_app_purchase

Column	Type	Keys
`id`	String	PK
`app_id`	Long	PKFK
`content_hosting`	Boolean
`family_sharable`	Boolean
`in_app_purchase_type`	String
`name`	String
`product_id`	String
`review_note`	String
`state`	String

app_store_installation_and_deletion_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`app_version`	String
`campaign`	String
`counts`	Int
`device`	String
`download_type`	String
`event`	String
`page_title`	String
`page_type`	String
`platform_version`	String
`source_info`	String
`source_type`	String
`territory`	String
`unique_devices`	Int

sales_summary_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`begin_date`	LocalDate
`category`	String
`client`	String
`cmb`	String
`country_code`	String
`currency_of_proceeds`	String
`customer_currency`	String
`customer_price`	Double
`developer`	String
`developer_proceeds`	Double
`device`	String
`end_date`	LocalDate
`order_type`	String
`parent_identifier`	String
`period`	String
`preserved_pricing`	String
`proceeds_reason`	String
`product_type_identifier`	String
`promo_code`	String
`provider`	String
`provider_country`	String
`requested_report_date`	LocalDate
`sku`	String
`subscription`	String
`supported_platforms`	String
`title`	String
`units`	Double
`version`	String

sales_subscription_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`_fivetran_index`	Int
`active_free_trial_introductory_offer_subscriptions`	Int
`active_pay_as_you_go_introductory_offer_subscriptions`	Int
`active_pay_up_front_introductory_offer_subscriptions`	Int
`active_standard_price_subscriptions`	Int
`app_apple_id`	Long
`app_name`	String
`billing_retry`	Int
`client`	String
`country`	String
`customer_currency`	String
`customer_price`	Double
`date`	LocalDate
`developer_proceeds`	Double
`device`	String
`free_trial_offer_code_subscriptions`	Int
`free_trial_promotional_offer_subscriptions`	Int
`free_trial_win_back_offers`	Int
`grace_period`	Int
`marketing_opt_ins`	Int
`pay_as_you_go_offer_code_subscriptions`	Int
`pay_as_you_go_promotional_offer_subscriptions`	Int
`pay_as_you_go_win_back_offers`	Int
`pay_up_front_offer_code_subscriptions`	Int
`pay_up_front_promotional_offer_subscriptions`	Int
`pay_up_front_win_back_offers`	Int
`preserved_pricing`	String
`proceeds_currency`	String
`proceeds_reason`	String
`promotional_offer_id`	String
`requested_report_date`	LocalDate
`standard_subscription_duration`	String
`state`	String
`subscribers`	Int
`subscription_apple_id`	Long
`subscription_group_id`	Long
`subscription_name`	String
`subscription_offer_name`	String

app_crash_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_version`	String
`crashes`	Int
`device`	String
`platform_version`	String
`unique_devices`	Int

app_store_app

Column	Type	Keys
`id`	Long	PK
`content_rights_declaration`	String
`name`	String
`primary_locale`	String
`subscription_status_url`	String
`subscription_status_url_for_sandbox`	String
`subscription_status_url_version`	String
`subscription_status_url_version_for_sandbox`	String
`was_made_for_kids`	Boolean

app_session_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`app_version`	String
`device`	String
`page_type`	String
`platform_version`	String
`sessions`	Int
`source_type`	String
`territory`	String
`total_session_duration`	Int
`unique_devices`	Int

app_store_retention_messaging

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`counts`	Int
`current_group_subscription`	String
`current_subscription`	String
`current_subscription_group_identifier`	Long
`current_subscription_identifier`	Long
`device`	String
`event`	String
`message_selection_type`	String
`page`	String
`platform_version`	String
`retention_message_type`	String
`save_type`	String
`territory`	String

financial_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`country_code`	String	PK
`vendor_number`	Int	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`country_of_sale`	String
`customer_currency`	String
`customer_price`	Double
`developer_name`	String
`end_date`	LocalDate
`extended_partner_share`	Double
`filename`	String
`order_type`	String
`partner_share`	Double
`partner_share_currency`	String
`product_type_identifier`	String
`promo_code`	String
`quantity`	Int
`region`	String
`requested_report_date`	LocalDate
`sale_or_return`	String
`settlement_date`	LocalDate
`sku`	String
`start_date`	LocalDate
`title`	String
`transaction_date`	LocalDate

sales_subscription_offer_code_redemption

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`app_apple_id`	Long	PKFK
`_fivetran_index`	Int
`app_name`	String
`date`	LocalDate
`offer_code`	String
`offer_reference_name`	String
`redemptions`	Int
`requested_report_date`	LocalDate
`subscription_apple_id`	Long
`subscription_name`	String
`territory`	String

sales_first_annual_detailed

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_name`	String
`channel`	String
`first_annual_installs`	Int
`install_type`	String
`os_version`	String
`requested_report_date`	LocalDate
`territory`	String
`total_installs`	Int

sales_win_back_eligibility

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`app_apple_id`	Long	PKFK
`_fivetran_index`	Int
`app_name`	String
`churned_subscription_count`	Int
`has_previously_redeemed_win_back_offer`	String
`paid_subscription_tenure`	Int
`requested_report_date`	LocalDate
`standard_subscription_duration`	String
`subscription_apple_id`	Long
`subscription_group_id`	Long
`subscription_name`	String
`territory`	String
`time_since_last_subscribed`	Int
`time_since_last_win_back_offer`	Int

sales_pre_order_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`canceled`	Double
`category`	String
`client`	String
`country_code`	String
`cumulative_canceled`	Double
`cumulative_ordered`	Double
`developer`	String
`device`	String
`end_date`	LocalDate
`ordered`	Double
`pre_order_end_date`	LocalDate
`pre_order_start_date`	LocalDate
`provider`	String
`provider_country`	String
`requested_report_date`	LocalDate
`sku`	String
`start_date`	LocalDate
`supported_platforms`	String
`title`	String

app_store_purchase_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`content_apple_identifier`	String
`content_name`	String
`device`	String
`page_type`	String
`paying_users`	Int
`payment_method`	String
`platform_version`	String
`pre_order`	String
`proceeds_in_usd`	Double
`purchase_type`	String
`purchases`	Int
`sales_in_usd`	Double
`source_type`	String
`territory`	String

app_store_installation_and_deletion_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_download_date`	LocalDate
`app_version`	String
`counts`	Int
`device`	String
`download_type`	String
`event`	String
`page_type`	String
`platform_version`	String
`source_type`	String
`territory`	String
`unique_devices`	Int

app_store_app_version

Column	Type	Keys
`id`	String	PK
`app_id`	Long	FK
`app_store_state`	String
`app_version_state`	String
`copyright`	String
`created_date`	Instant
`downloadable`	Boolean
`earliest_release_date`	Instant
`platform`	String
`release_type`	String
`review_type`	String
`uses_idfa`	String
`version_string`	String

sales_subscriber_detailed

Column	Type	Keys
`_fivetran_id`	String	PK
`vendor_number`	Int	PK
`_fivetran_index`	Int
`app_apple_id`	Long
`app_name`	String
`client`	String
`country`	String
`customer_currency`	String
`customer_price`	Double
`developer_proceeds`	Double
`device`	String
`event_date`	LocalDate
`introductory_price_type`	String
`marketing_opt_in_duration`	String
`preserved_pricing`	String
`proceeds_currency`	String
`proceeds_reason`	String
`promotional_offer_id`	String
`purchase_date`	LocalDate
`refund`	String
`requested_report_date`	LocalDate
`standard_subscription_duration`	String
`subscriber_id`	Long
`subscriber_id_reset`	String
`subscription_apple_id`	Long
`subscription_group_id`	Long
`subscription_name`	String
`subscription_offer_duration`	String
`subscription_offer_name`	String
`units`	Int

app_store_discovery_and_engagement_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`campaign`	String
`counts`	Int
`device`	String
`engagement_type`	String
`event`	String
`page_title`	String
`page_type`	String
`platform_version`	String
`source_info`	String
`source_type`	String
`territory`	String
`unique_counts`	Int

app_store_browser_choice_screen_engagement_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`counts`	Int
`device`	String
`event`	String
`platform_version`	String
`territory`	String
`unique_devices`	Int

app_store_download_detailed_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`app_version`	String
`campaign`	String
`counts`	Int
`device`	String
`download_type`	String
`page_title`	String
`page_type`	String
`platform_version`	String
`pre_order`	String
`source_info`	String
`source_type`	String
`territory`	String

app_store_browser_choice_screen_selection_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`build`	String
`device`	String
`direct_selection_rate`	Double
`existing_install_rate`	Double
`informed_selection_rate`	Double
`new_install_rate`	Double
`platform`	String
`product_page_conversion_rate`	Double
`release_type`	String
`selection_rate`	Double
`territory`	String

app_store_pre_order_standard_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`app_id`	Long	PKFK
`_fivetran_index`	Int
`device`	String
`page_type`	String
`platform_version`	String
`pre_order_canceled`	Int
`pre_order_end_date`	LocalDate
`pre_order_placed`	Int
`pre_order_start_date`	LocalDate
`source_type`	String
`territory`	String