# Apple App Store schema ERD

Table and field reference for the Fivetran Apple App Store connector.

## Table & Field Reference

### app_store_review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| app_id | Long | PK, FK |
| 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 | PK, FK |
| review_id | String | PK, FK |

### app_store_pre_order_detailed_daily

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| app_id | Long | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| 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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 | PK, FK |
| _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 |  |

## Relationships

- app_store_review(app_id) → app_store_app(id)
- app_store_app_version_review(app_version_id) → app_store_app_version(id)
- app_store_app_version_review(review_id) → app_store_review(id)
- app_store_pre_order_detailed_daily(app_id) → app_store_app(id)
- app_store_purchase_detailed_daily(app_id) → app_store_app(id)
- app_session_detailed_daily(app_id) → app_store_app(id)
- financial(app_id) → app_store_app(id)
- app_store_discovery_and_engagement_standard_daily(app_id) → app_store_app(id)
- app_store_download_standard_daily(app_id) → app_store_app(id)
- app_store_in_app_purchase(app_id) → app_store_app(id)
- app_store_installation_and_deletion_detailed_daily(app_id) → app_store_app(id)
- sales_summary_daily(app_id) → app_store_app(id)
- app_crash_daily(app_id) → app_store_app(id)
- app_session_standard_daily(app_id) → app_store_app(id)
- app_store_retention_messaging(app_id) → app_store_app(id)
- financial_detail(app_id) → app_store_app(id)
- sales_subscription_offer_code_redemption(app_apple_id) → app_store_app(id)
- sales_first_annual_detailed(app_id) → app_store_app(id)
- sales_win_back_eligibility(app_apple_id) → app_store_app(id)
- sales_pre_order_summary(app_id) → app_store_app(id)
- app_store_purchase_standard_daily(app_id) → app_store_app(id)
- app_store_installation_and_deletion_standard_daily(app_id) → app_store_app(id)
- app_store_app_version(app_id) → app_store_app(id)
- app_store_discovery_and_engagement_detailed_daily(app_id) → app_store_app(id)
- app_store_browser_choice_screen_engagement_report(app_id) → app_store_app(id)
- app_store_download_detailed_daily(app_id) → app_store_app(id)
- app_store_browser_choice_screen_selection_report(app_id) → app_store_app(id)
- app_store_pre_order_standard_daily(app_id) → app_store_app(id)