blog post

How to connect Apple App Store to Catchr ?

Johan Chemin
April 15, 2024
How to connect Apple App Store to Catchr ?

Quick steps to create a App Store Connect report with Google Sheets:

You can easiliy create a App Store Connect report following this step :

  1. Get informations from the data integration from our App Store Connect connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your App Store Connect data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a App Store Connect report with Looker Studio:

You can easiliy create a App Store Connect report following this step :

  1. Get informations from the data integration from our App Store Connect connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for App Store Connect at the end of the page.

The tutorial

Quick steps to create a App Store Connect report with PowerBI:

You can easiliy create a App Store Connect report following this step :

  1. Get informations from the data integration from our App Store Connect connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for App Store Connect at the end of the page.

The tutorial

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.

Pop-up to link your Apple App Store to Catchr

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:

Create your App Store data source on Looker Studio.

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

Apple App Store data source on 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:

Launch the Catchr Add-On for Google Sheets.

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

Start creating a new request on our Google Sheets Add-on

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

No items found.

In this App Store Connect template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this App Store Connect template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about App Store Connect

How to connect Apple App Store to Catchr ?

Connect your Apple App Store Apps to Catchr and start using your data on Looker Studio, Google Sheets, Tableau, PowerBI, and many more.

Johan Chemin

The 8 Best KPIs to Use for App Store Connect

Tracking KPIs is the best way to dominate the app store. Find out the best App Store Connect KPIs in this read, and buckle up to gain more profit!

Florian Cabirol

Import your App Store Connect Application metrics to Google Sheets : How-to, metrics and more...

Learn to connect your App Store Connect account to Google Sheets effortlessly with our comprehensive guide, designed for marketing professionals. This tutorial will enable you to visualize app performance data directly in Google Sheets, simplifying analysis and reporting, and facilitating more informed decisions. Perfect for those looking to streamline their app's data management and unlock actionable insights.

Florian Cabirol

Explore AppStore Connect KPI for your application in PowerBI : How-to, metrics and templates...

Discover how to effortlessly link App Store Connect with PowerBI via Catchr in this comprehensive tutorial. Learn to transform app performance data into powerful visual insights, aiding in strategic marketing decisions. Start harnessing your app metrics for better analytics and reporting now!

Florian Cabirol