blog post

How to connect Apple App Store to Catchr ?

Johan Chemin
March 19, 2024
| Lastest update
August 28, 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.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on

Build dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data

Connect your App Store Connect data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
No items found.
No items found.
Need a clearer view of your marketing data?
No items found.
No items found.
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