Release Notes

December 2024

We have added the date column to the SALES_SUBSCRIPTION_SUMMARY table.

For all existing connectors, we will perform a free historical re-sync of the SALES_SUBSCRIPTION_SUMMARY table to populate it with data. See the Apple App Store connector's latest ERD for more details.

November 2024

Our Apple App Store connector now uses the App Store Connect API to sync your data.

The connector schema has been updated. To better understand the differences between the two schemas, see our Previous Vs. New API Tables Mapping article. To directly compare the two connector schemas, see the links below:

• App Store Connect API schema - current version
• App Store Connect API schema - previous version

April 2024

We have added new Quickstart packages for the following connectors:

• Apple App Store
• LinkedIn Company Pages
• Pendo
• Pinterest Ads
• Recurly
• SAP ERP on HANA
• ServiceNow
• Twitter Ads

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

Effective January 1, 2024, Apple App Store no longer generates the Magazines & Newspapers report. For connectors created on or before January 1, 2024, we will continue to sync data from the Magazines & Newspapers reports into the SALES_NEWSSTAND_DETAILED table. For more information, see Apple's documentation.

December 2022

Apple renamed the Promotional Offer Name report field to Subscription Offer Name in the new versions of the reports. We have renamed the promotional_offer_name column to subscription_offer_name in the following tables:

• SALES_SUBSCRIBER_DETAILED
• SALES_SUBSCRIPTION_SUMMARY
• SALES_SUBSCRIPTION_EVENT_SUMMARY

We now sync new data into the subscription_offer_name column in the destination tables.

We are gradually rolling out this feature to all existing connectors. Contact our support team if you want to backfill older data from the promotional_offer_name column to the new subscription_offer_name column. You may experience slow sync speeds when you backfill the older data into the column.

We have added four new columns to the SALES_SUBSCRIPTION_SUMMARY table:

• free_trial_offer_code_subscriptions
• pay_up_front_offer_code_subscriptions
• pay_as_you_go_offer_code_subscriptions
• subscribers

For more information, see Apple's Subscriber Report Version 1_3, Subscription Report Version 1_3, and Subscription Event Report Version 1_3 reports.

August 2022

Fivetran has created a dbt Core*-compatible app reporting model that aggregates data from our most popular app platform connectors into a unified table. This pre-built model allows you to compare your app activity by device, country, OS version, traffic source, and subscription levels.

The app reporting model supports the Apple App Store and Google Play connectors.

Learn more in our app reporting model documentation.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have released pre-built, dbt Core*-compatible data models for Apple App Store. Find the models in Fivetran's dbt hub. Learn more about our dbt Core integration in our Transformations for dbt Core documentation.

*dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

March 2022

We have added the following new report tables to sync Downloads metrics:

• 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_TPLATFORM_VERSION_CAMPAIGN_REPORT

The new DOWNLOADS_* tables replace the APP_UNITS_* tables.

We have added support for three new metrics, first_time_downloads, redownloads, and total_downloads.

We will continue to sync the APP_UNITS_* tables for another three months and will discontinue the replaced tables after June 15, 2022. Be sure to update your queries with the new table names before we remove the old tables.

For more information about the new tables and metrics, see our Analytics Tables documentation.

September 2021

We will stop support for single-factor authentication on October 4, 2021. To continue syncing your Apple App Store data, switch to two-factor authentication before October 4, 2021. For instructions to configure two-factor authentication, see our Setup Guide.

We have added a warning alert on your connector dashboard. You must now use two-factor authentication.

January 2021

The Apple App Store connector now requires two-factor authentication for all connectors, including existing connectors. Learn more in our setup instructions.

September 2020

We have renamed our iTunes Connect connector to Apple App Store. This name change applies to the Fivetran dashboard and our documentation.

August 2020

When setting up your Apple App Store connector, you can now choose the accounts you want to sync using Account Sync Mode. Previously, you had to separately specify the Sales and Finance accounts you wanted to sync.

NOTE: This change only applies to new connectors created after August 24, 2020 and does not impact existing connectors.

March 2020

You can now configure your Apple App Store connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

January 2020

When setting up your Apple App Store connector, you can now choose which apps, sales accounts, and finance accounts you'd like to sync. Previously, Fivetran synced all apps, sales accounts, and finance accounts by default.

We have upgraded the following subscription reports to version 1_2:

• SALES_SUBSCRIPTION_SUMMARY
• SALES_SUBSCRIPTION_EVENT_SUMMARY
• SALES_SUBSCRIBER_DETAILED

This version upgrade brings some changes in the fields of the above mentioned tables. Refer to the latest schema information: https://fivetran.com/docs/connectors/applications/itunes-connect#schemainformation

October 2019

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

June 2018

We have renamed the _fivetran_id column to _index in the SALES and FINANCE reports.

We have added App Analytics for Apple App Store. We can now fetch apps, app analytics, and retention data for all of your iTunes apps. For more information, see our Analytics Tables documentation.

April 2018

You can now view the list of your tables that are available for sync in your Fivetran dashboard.

We have added support for logs for the following connectors:

• Braintree
• Apple App Store (formerly iTunes Connect)
• Kantata