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.
Features
| Feature Name | Supported | Notes |
|---|
| Capture deletes | | |
| Custom data | | |
| check | Column level and table level |
| check | |
| check | Connector level |
| History | | |
| check | |
| Priority-first sync | | |
| check | Get the models: / ; Get the |
| Private networking | | |
Setup guide
Follow our step-by-step to connect Apple App Store with your destination using Fivetran connectors.
Sync overview
Payments and Financial Reports
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 Trends
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 Analytics
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 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 .
Reviews
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 information
Sales and Finance report schema
Analytics tables
Following tables are combinations of Dimensions and Measures for App Analytics.
APP_STORE_TERRITORY_SOURCE_TYPE_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| source_type 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_TERRITORY_APP_REFERRER_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| app_referrer 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_TERRITORY_WEB_REFERRER_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| web_referrer 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_TERRITORY_CAMPAIGN_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| campaign 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_SOURCE_TYPE_DEVICE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| source_type 🔑 | |
| device 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_APP_REFERRER_DEVICE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| app_referrer 🔑 | |
| device 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_WEB_REFERRER_DEVICE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| web_referrer 🔑 | |
| device 🔑 | |
| first_time_downloads | |
| redownloads | |
| total_downloads | |
| meets_threshold | |
DOWNLOADS_CAMPAIGN_DEVICE_REPORT
| 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_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| purchasable_item 🔑 | |
| source_type 🔑 | |
| sales | |
| in_app_purchases | |
| paying_users | |
| meets_threshold | |
SALES_PURCHASABLE_ITEM_APP_REFERRER_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| purchasable_item 🔑 | |
| app_referrer 🔑 | |
| sales | |
| in_app_purchases | |
| paying_users | |
| meets_threshold | |
SALES_PURCHASABLE_ITEM_WEB_REFERRER_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| purchasable_item 🔑 | |
| web_referrer 🔑 | |
| sales | |
| in_app_purchases | |
| paying_users | |
| meets_threshold | |
SALES_PURCHASABLE_ITEM_CAMPAIGN_REPORT
| 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_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| app_version 🔑 | |
| device 🔑 | |
| crashes | |
| meets_threshold | |
USAGE_APP_VERSION_SOURCE_TYPE_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| 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_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| web_referrer 🔑 | |
| device 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_CAMPAIGN_DEVICE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| campaign 🔑 | |
| device 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_SOURCE_TYPE_DEVICE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| source_type 🔑 | |
| device 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_TERRITORY_SOURCE_TYPE_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| source_type 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_TERRITORY_CAMPAIGN_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| campaign 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_TERRITORY_APP_REFERRER_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| territory 🔑 | |
| app_referrer 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
USAGE_TERRITORY_WEB_REFFEER_REPORT
| 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_REPORT
| COLUMN | REFERENCE |
|---|
| app_id 🔑 | APP |
| date 🔑 | |
| app_referrer 🔑 | |
| device 🔑 | |
| installations | |
| sessions | |
| active_devices | |
| active_devices_last_30_days | |
| meets_threshold | |
RETENTION_BY_{DIMENSION}_REPORT
| 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
Comments
0 comments
Please sign in to leave a comment.