Apple App Store & Catchr: How to connect your data

How to connect Apple App Store to Catchr ?

To connect your Apple App Store account to Catchr, you will need 4 IDs. We will see here how to find these IDs, how to create your Catchr Source for your Apple Apps and how to start with our destination (Looker studio, Google Sheets, PowerBI, Tabelau etc.).

The 4 IDs to find are your issuer ID, vendor ID, Key ID, and Key Secret.

How do you find your Issuer and vendor ID and your Ket secret and ID?

First, open a quick note where you will be able to paste these IDs.

Finding your issuer ID:

The issuer ID is available in the API section of your account.
Follow this link: https://appstoreconnect.apple.com/access/api. Your issuer ID should be visible here, and you can copy it using the shortcut.
The Issuer ID will differ for each Developer Account you are a part of.
If the issuer ID is absent, contact your Team agent and ask him to activate the feature.

Paste it on your note.

Finding your Vendor ID:

Your vendor ID is a unique ID representing a payment account in Apple's System. You need the admin permissions on the account to access it.

You can view your vendor number at any time through App Store Connect.

1. From the homepage, click Payments and Financial Reports.
2. Your Vendor Number appears under your Legal Entity Name in the top left corner.

Paste it on your note.

Finding your Key ID and Secret ID:

Finally, you must create a new App Store Key to connect to Catchr:

• Go to the API section of your App Store Account. Click on the blue + sign to create a new key.
• Make sure to give us the adequate level of access (Admin: highest level, all report are accessible, Sales and Report will access the Trends...)
• Click Generate. You can access your Key ID and Key Secret on the next page.

For the secret key: click on "Download the API Key" and open the file. You Secret Key will look like this:

-----BEGIN PRIVATE KEY-----
AAAAAAAAAAAAAAAAAAAAAAAAAAAA
BBBBBBBBBBBBBBBBBBBBBBBBBBBB
CCCCCCCCCCCCCCCCCCCCCCCCCCCC
-----END PRIVATE KEY-----

You need to copy only the next and remove the space before copying it !

Here's the final version :

AAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCC

‍

‍

You can create a new Apple App Store Source on Catchr with all the IDs.

How to create your Catchr Apple App Store Source ?

Follow this link to access our data source creation page. Select Apple App Store, choose a name and click "Connect your account".

A pop-up will open asking for the IDs found at the previous step.

‍

Starting with Looker Studio and Apple App Store:

Once your Apps are visible on your Catchr Source, you can go to our connector in Looker Studio and create a new data source linked to your App(s).

First, go through the authorization steps, then select your account and clickConnectto create your new App Store data source:

In the next screen, you'll find the available field list. Click on Create report and start analyzing your App results with Looker Studio!

Starting with Google Sheets and Apple App Store:

You can install our Google Sheets add-on and import data to Google Sheets automatically!

Open a new Google sheets, click on Extension -> Catchr - Data Connector -> Launch:

You now have access to our Add-on. Click on Add new to start creating a new query:

Follow this link to find a complete tutorial on how to use our Google Sheets Add-on for your Apple App Store Apps.

‍