New Vs. Old API Table Mapping

Fivetran has two versions of the Apple App Store connector. The latest version, released in November 2024, queries data from the Apple App Store Connect API. To directly compare the two connector schemas, see the links below:

Additionally, to better understand the differences between the two connectors' schema, and migrate from the previous version of the connector to the new one, see the Analytics Tables Mapping section.

Analytics tables mapping

The following report tables are combinations of App Store Connect API and previous schema tables.

Specific tables from the previous schema are not supported by the new schema.

APP_STORE_DISCOVERY_AND_ENGAGEMENT_DETAILED_DAILY

Tables from previous schema	Supported by new schema
APP_STORE_TERRITORY_SOURCE_TYPE_REPORT
APP_STORE_TERRITORY_APP_REFERRER_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_WEB_REFERRER_REPORT
APP_STORE_PLATFORM_VERSION_CAMPAIGN_REPORT
APP_STORE_PLATFORM_VERSION_SOURCE_TYPE_REPORT
APP_STORE_PLATFORM_VERSION_SOURCE_TYPE_REPORT
APP_STORE_PLATFORM_VERSION_SOURCE_TYPE_REPORT

See App Store Discovery and Engagement documentation for more details.

APP_STORE_DOWNLOAD_DETAILED_DAILY

Tables from previous schema	Supported by new schema
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

See App Store Downloads documentation for more details.

APP_CRASH_DAILY

Tables from previous schema	Supported by new schema
CRASHES_PLATFORM_VERSION_DEVICE_REPORT
CRASHES_APP_VERSION_DEVICE_REPORT

See App Crashes documentation for more details.

APP_SESSION_DETAILED_DAILY AND APP_STORE_INSTALLATION_AND_DELETION_DETAILED_DAILY

Tables from previous schema	Supported by new schema
USAGE_APP_VERSION_SOURCE_TYPE_REPORT
USAGE_APP_VERSION_WEB_REFERRER_REPORT
USAGE_APP_VERSION_WEB_REFERRER_REPORT
USAGE_APP_VERSION_APP_REFERRER_REPORT
USAGE_APP_VERSION_CAMPAIGN_REPORT
USAGE_APP_REFERRER_DEVICE_REPORT
USAGE_CAMPAIGN_DEVICE_REPORT
USAGE_PLATFORM_VERSION_CAMPAIGN_REPORT
USAGE_PLATFORM_VERSION_APP_REFERRER_REPORT
USAGE_PLATFORM_VERSION_WEB_REFERRER_REPORT
USAGE_PLATFORM_VERSION_SOURCE_TYPE_REPORT
USAGE_SOURCE_TYPE_DEVICE_REPORT
USAGE_TERRITORY_SOURCE_TYPE_REPORT
USAGE_TERRITORY_CAMPAIGN_REPORT
USAGE_TERRITORY_APP_REFERRER_REPORT
USAGE_TERRITORY_WEB_REFERRER_REPORT
USAGE_TERRITORY_WEB_REFERRER_REPORT
USAGE_TERRITORY_DEVICE_REPORT
USAGE_WEB_REFERRER_DEVICE_REPORT

See App Store Installations and Deletions and App Sessions documentation for more details.

APP_STORE_PURCHASE_DETAILED_DAILY

Tables from previous schema	Supported by new schema
SALES_PURCHASABLE_ITEM_APP_REFERRER_REPORT
SALES_PURCHASABLE_ITEM_WEB_REFERRER_REPORT
SALES_PURCHASABLE_ITEM_CAMPAIGN_REPORT
SALES_PURCHASABLE_ITEM_SOURCE_TYPE_REPORT

See App Store Purchases documentation for more details.

Reports unavailable in the latest schema

Tables from previous schema	Supported by new schema
RETENTION_BY_DEVICE_REPOR	Report is not available
RETENTION_BY_CAMPAIGN_REPORT	Report is not available
RETENTION_BY_APP_REFERRER_REPORT	Report is not available
RETENTION_BY_WEB_REFERRER_REPORT	Report is not available
RETENTION_BY_SOURCE_TYPE_REPORT	Report is not available
RETENTION_BY_TERRITORY_REPORT	Report is not available

The schema of the tables above is the same for standard reports.