Apple App Store Setup Guide

Follow our setup guide to connect Apple App Store to Fivetran. This setup guide applies to the previous version of the connector and applies to connections set up before October, 2024.

IMPORTANT: Fivetran requires two-factor authentication for Apple App Store. We no longer support single-factor authentication for this connector.

Prerequisites

To connect Apple App Store to Fivetran, you need:

• An Apple account. We strongly recommend that you use a separate Apple account for Fivetran. The account should not have any trusted devices.

  NOTE: At the start of every sync, Fivetran requests a verification code on a Fivetran-managed phone number. If you use an Apple account with trusted devices to configure the connector, you will receive requests on the trusted devices asking for permission to complete the two-factor authentication process at the start of every sync.
  

• Make sure your Apple account has at least the Finance and App Manager roles. You must have:

  • Finance role to sync App Analytics, sales, and finance reports
  • App Manager, Customer Support, or Marketing role to sync app reviews

• A phone number registered as a trusted number with your Fivetran-dedicated Apple account, which can be used for two-factor authentication (2FA) when you need to make changes on your Apple account (for example, to elevate roles).

NOTE: When you add or create an Apple account, it may take up to 48 hours for Apple to process the new account. During this time, some reports cannot be retrieved.

Setup instructions

Choose roles in Apple App Store

1. Log in to the Apple App Store dashboard.

2. Click Users and Access.

3. Select or Add the Apple account to be used for Fivetran.

4. Click Roles.

5. Choose roles for the Fivetran user:

   • Select Finance or Admin to access payments and financial reports, sales and trends, and App Analytics data
   • SelectApp Manager, Customer Support, or Marketing to access app reviews

   We recommend selecting the Finance and App Manager roles for the Fivetran user.

   

   NOTE: If you have the Admin role, you can sync all reports. For more information about user roles, see App Store Connect Help.

Begin Fivetran configuration

1. In the connector setup form, enter the Destination schema name of your choice.

2. Enter your Apple ID.

3. Enter your password.

NOTE: Once you open the setup form, we link a Fivetran-managed phone number to the connector for authentication. You have to wait for 10-20 seconds for the phone number to be displayed in the Phone Number field on the setup form. If the phone number is not displayed after 20 seconds, reload the setup form to generate a new number.

Generate app-specific password

1. Log in to the Apple ID account page.

2. Go to the Security section.

3. In the App-Specific Passwords section, click Generate Password.

4. Enter a password label and click Create.

5. Make a note of your app-specific password. You will need it to configure Fivetran.

Find phone number

1. Return to the connector setup form and enter the app-specific password you generated.

2. Make a note of the Fivetran-managed phone number displayed in the Phone Number field on the setup form. You will need to add this number as a trusted phone number for the Apple ID.

   NOTE: This phone number is unique for each Apple App Store connector you create.

Add phone number

1. In your Apple ID account page, go to the Security section.

2. Click Edit.

3. Click Add a Trusted Phone Number.

4. In the country/region drop-down menu, select +1 (United States).

5. In the phone number field, enter the phone number you found.

6. Select Text message to verify the number with a verification code.

7. Click Continue. A popup displaying the verification code input field will appear.

Get verification code

1. Return to the connector setup form and click Get Verification Code to receive the verification code.

   IMPORTANT: We generate a verification code. You must wait for 10 seconds for the verification code to be available in the connector setup form.

2. Make a note of the verification code. You will need the code to verify the phone number for the Apple ID.

   NOTE: You should ignore the Verification Code field in the setup form displayed when you click Get Verification Code. You use the verification code on your Apple ID account page.

Verify Fivetran-managed phone number

1. Return to your Apple ID account page.

2. Use the verification code you obtained to verify the trusted phone number.

3. Click Verify.

NOTE: The verification is a one-time procedure required to authenticate your connector. You do not need to verify the trusted number for your connector syncs.

Finish Fivetran configuration

1. In the connector setup form, select your app sync mode. You can choose either Sync All Apps or Sync Specific Apps.

2. If you choose Sync Specific Apps, select the apps you'd like to sync.

3. Select your account sync mode. You can choose either Sync All Accounts or Sync Specific Accounts.

4. If you choose Sync Specific Accounts, select the accounts you'd like to sync.

5. Select how many months' worth of reporting data you'd like to include in your initial sync.

6. Click Save & Test. Fivetran will take it from here and sync your Apple App Store data.

   We recommend that you set the connector's sync frequency to eight hours or more because of the Apple App Store's access token constraints. On your connector dashboard, go to the Setup tab and use the Sync Frequency slider to set the sync frequency.

NOTE: If you delete your Apple App Store connector, make sure to remove the registered phone number from your Apple App Store account.

IMPORTANT: Due to the App Store Connect rate limit, it may take a long time to sync analytics metrics.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home