Apple App Store link Updated November 16, 2023
Apple App Store (formerly known as iTunes Connect) is a suite of web-based tools created for developers to submit and manage their apps for sale in the App Store or the Mac App Store.
Setup guidelink Follow our step-by-step Apple App Store setup guide to connect Apple App Store with your destination using Fivetran connectors.
Sync overviewlink Payments and Financial Reportslink Payments and Financial reports have data for monthly earnings, amounts owed, and payments made to you. These reports are generated at the start of each month and they are available only for paid Apps or for Apps having subscriptions.
Sales and Trendslink Sales and Trends provides data to see the performance of your apps and in-app purchases
The Sales report provides your daily units, proceeds, and sales with content type, app, subscription and territory The Subscriptions report has sales and activity for your auto-renewable subscriptions Reports are generated daily and imported once they are ready in with iTunes. iTunes retains reports for only 365 days, so Fivetran fetches data for the last 365 days during initial import.
App Analyticslink App Analytics provides data on user engagement, marketing campaigns, and App Store for your iOS and tvOS apps with metrics such as App Store Impressions, Product Page Views, Sales, Sessions, and more. Refer to Apple App Store App Analytics for details.
Initial import fetches data from Apr 01, 2015 UTC and each incremental sync fetches data for last four days. App Analytics data may be delayed up to 72 hours. Refer the Tables for Analytics section for details .
Fetch reviews for your apps. Ratings are fetched with reviews. Ratings without reviews are not fetched (this is a limitation of api calls available from iTunes).
Schema informationlink Sales and Finance report schemalink To zoom, open the ERD in a new window. Analytics tableslink Following tables are combinations of Dimensions and Measures for App Analytics.
APP_STORE_TERRITORY_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 source_type 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_TERRITORY_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 app_referrer 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_TERRITORY_WEB_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 web_referrer 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_TERRITORY_CAMPAIGN_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 campaign 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_SOURCE_TYPE_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 source_type 🔑 device 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_APP_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_referrer 🔑 device 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_WEB_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 web_referrer 🔑 device 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
APP_STORE_CAMPAIGN_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 campaign 🔑 device 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 source_type 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 app_referrer 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 web_referrer 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 campaign 🔑 impressions impressions_unique_device page_views page_views_unique_device meets_threshold
DOWNLOADS_TERRITORY_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 source_type 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_TERRITORY_APP_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 app_referrer 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_TERRITORY_WEB_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 web_referrer 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_TERRITORY_CAMPAIGN_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 campaign 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_SOURCE_TYPE_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 source_type 🔑 device 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_APP_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_referrer 🔑 device 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_WEB_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 web_referrer 🔑 device 🔑 first_time_downloads redownloads total_downloads meets_threshold
DOWNLOADS_CAMPAIGN_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 campaign 🔑 device 🔑 first_time_downloads redownloads total_downloads meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 source_type 🔑 first_time_downloads redownloads total_downloads meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 app_referrer 🔑 first_time_downloads redownloads total_downloads meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 web_referrer 🔑 first_time_downloads redownloads total_downloads meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 campaign 🔑 first_time_downloads redownloads total_downloads meets_threshold
SALES_PURCHASABLE_ITEM_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 purchasable_item 🔑 source_type 🔑 sales in_app_purchases paying_users meets_threshold
SALES_PURCHASABLE_ITEM_APP_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 purchasable_item 🔑 app_referrer 🔑 sales in_app_purchases paying_users meets_threshold
SALES_PURCHASABLE_ITEM_WEB_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 purchasable_item 🔑 web_referrer 🔑 sales in_app_purchases paying_users meets_threshold
SALES_PURCHASABLE_ITEM_CAMPAIGN_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 purchasable_item 🔑 campaign 🔑 sales in_app_purchases paying_users meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 device 🔑 crashes meets_threshold
CRASHES_APP_VERSION_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_version 🔑 device 🔑 crashes meets_threshold
USAGE_APP_VERSION_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_version 🔑 source_type 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_APP_VERSION_WEB_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_version 🔑 web_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_APP_VERSION_CAMPAIGN_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_version 🔑 campaign 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_APP_VERSION_APP_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_version 🔑 app_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_WEB_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 web_referrer 🔑 device 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_CAMPAIGN_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 campaign 🔑 device 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_SOURCE_TYPE_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 source_type 🔑 device 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_TERRITORY_SOURCE_TYPE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 source_type 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_TERRITORY_CAMPAIGN_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 campaign 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_TERRITORY_APP_REFERRER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 app_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_TERRITORY_WEB_REFFEER_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 territory 🔑 web_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 source_type 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 app_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 web_referrer 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
COLUMN REFERENCE app_id 🔑 APP date 🔑 platform_version 🔑 campaign 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
USAGE_APP_REFERRER_DEVICE_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_referrer 🔑 device 🔑 installations sessions active_devices active_devices_last_30_days meets_threshold
RETENTION_BY_{DIMENSION}_REPORTlink COLUMN REFERENCE app_id 🔑 APP date 🔑 app_purchase 🔑 {dimension} 🔑 day 🔑 active_devices meets_threshold
Note:
There would be one retention table for each of the following dimensions: TERRITORY, DEVICE, SOURCE_TYPE, CAMPAIGN, APP_REFERRER and WEB_REFERRER 
