Apple App Store

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.

IMPORTANT: This is an outdated version of our Apple App Store connector. The documentation is relevant to connections created before October 25, 2024. See API table mapping to better understand how the schema differs between the current and the previous version of the connector.

Features

Setup guide

Follow our step-by-step Apple App Store setup guide 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 and subscription apps.

Sales and trends reports

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 iTunes. iTunes retains reports for only 365 days, so Fivetran fetches data for the last 365 days during the initial sync.

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 Apple App Store App Analytics for details.

Initial import fetches data from Apr 01, 2015 UTC and each incremental sync fetches four days' worth of data. App Analytics data may be delayed up to 72 hours. Refer to the Analytics tables section for details.

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

APP_STORE_TERRITORY_SOURCE_TYPE_REPORT

APP_STORE_TERRITORY_WEB_REFERRER_REPORT

APP_STORE_TERRITORY_CAMPAIGN_REPORT

APP_STORE_SOURCE_TYPE_DEVICE_REPORT

APP_STORE_APP_REFERRER_DEVICE_REPORT

APP_STORE_WEB_REFERRER_DEVICE_REPORT

APP_STORE_CAMPAIGN_DEVICE_REPORT

APP_STORE_PLATFORM_VERSION_SOURCE_TYPE_REPORT

APP_STORE_PLATFORM_VERSION_APP_REFERRER_REPORT

APP_STORE_PLATFORM_VERSION_WEB_REFERRER_REPORT

APP_STORE_PLATFORM_VERSION_CAMPAIGN_REPORT

DOWNLOADS_TERRITORY_SOURCE_TYPE_REPORT

DOWNLOADS_TERRITORY_APP_REFERRER_REPORT

DOWNLOADS_TERRITORY_WEB_REFERRER_REPORT

DOWNLOADS_TERRITORY_CAMPAIGN_REPORT

DOWNLOADS_SOURCE_TYPE_DEVICE_REPORT

DOWNLOADS_APP_REFERRER_DEVICE_REPORT

DOWNLOADS_WEB_REFERRER_DEVICE_REPORT

DOWNLOADS_CAMPAIGN_DEVICE_REPORT

DOWNLOADS_PLATFORM_VERSION_SOURCE_TYPE_REPORT

DOWNLOADS_PLATFORM_VERSION_APP_REFERRER_REPORT

DOWNLOADS_PLATFORM_VERSION_WEB_REFERRER_REPORT

DOWNLOADS_PLATFORM_VERSION_CAMPAIGN_REPORT

SALES_PURCHASABLE_ITEM_SOURCE_TYPE_REPORT

SALES_PURCHASABLE_ITEM_APP_REFERRER_REPORT

SALES_PURCHASABLE_ITEM_WEB_REFERRER_REPORT

SALES_PURCHASABLE_ITEM_CAMPAIGN_REPORT

CRASHES_PLATFORM_VERSION_DEVICE_REPORT

CRASHES_APP_VERSION_DEVICE_REPORT

USAGE_APP_VERSION_SOURCE_TYPE_REPORT

USAGE_APP_VERSION_WEB_REFERRER_REPORT

USAGE_APP_VERSION_CAMPAIGN_REPORT

USAGE_APP_VERSION_APP_REFERRER_REPORT

USAGE_WEB_REFERRER_DEVICE_REPORT

USAGE_CAMPAIGN_DEVICE_REPORT

USAGE_SOURCE_TYPE_DEVICE_REPORT

USAGE_TERRITORY_SOURCE_TYPE_REPORT

USAGE_TERRITORY_CAMPAIGN_REPORT

USAGE_TERRITORY_APP_REFERRER_REPORT

USAGE_TERRITORY_WEB_REFFEER_REPORT

USAGE_PLATFORM_VERSION_SOURCE_TYPE_REPORT

USAGE_PLATFORM_VERSION_APP_REFERRER_REPORT

USAGE_PLATFORM_VERSION_WEB_REFERRER_REPORT

USAGE_PLATFORM_VERSION_CAMPAIGN_REPORT

USAGE_APP_REFERRER_DEVICE_REPORT

RETENTION_BY_{DIMENSION}_REPORT

NOTE: There would be one retention table for each of the following dimensions: TERRITORY, DEVICE, SOURCE_TYPE, CAMPAIGN, APP_REFERRER, and WEB_REFERRER.