blog post

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

Florian Cabirol
January 31, 2024
Import your App Store Connect Application metrics to Google Sheets : How-to, metrics and more...

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

This detailed guide is designed to help marketing professionals effectively connect their App Store Connect account to Google Sheets, allowing for the simplification of data analysis and reporting. By the end of this tutorial, you'll be equipped with the knowledge to visualize your app's performance data directly in Google Sheets, enabling easier access to insights and more informed decision-making.

How to connect your App Store Connect account to Google Sheets

Add a source on Catchr

Begin by navigating to the Catchr homepage. From there, select 'Source' from the left-hand menu, followed by 'Add a Source' situated at the upper right-hand corner. Choose 'App Store Connect' as the platform you wish to link. Follow the on-screen prompts to authenticate and establish a connection between Catchr and App Store Connect.

Adding a Source on Catchr

Create a New Query

Initiate the process by opening a Google Sheets document and selecting the "Catchr" option from the toolbar. Proceed by clicking on "New Query" to formulate a new query that will facilitate the transfer of your App Store Connect data.

Select Your Data Source

In the query interface, select 'App Store Connect' as your preferred data source. Should your account not be listed, it can be easily added by clicking the "+" icon.

Selecting Your Data Source

Select Your Account(s)

Continue to the 'Select account(s)' tab and select the App Store Connect account(s) from which you intend to import data.

Selecting Your Accounts

Choose Metrics and Dimensions

Advance to the "Metrics" and "Dimensions" segments to pick specific data points for your query. Here are examples of metrics and dimensions from App Store Connect that you might find useful:

Metrics:

  • App Name: Obtain the name of the app.
  • Review Rating: Acquire the review rating.
  • Summary Sales units: Summarized number of units sold, accounting for refunds.
Choosing Metrics

Dimensions:

  • Country: The country from which the app was accessed or purchased.
  • Device: The type of device used for the purchase or app download (e.g., iPhone, iPad).
  • Review Territory: The territory from which a review was submitted.

Select metrics and dimensions that will serve your analysis and reporting objectives best.

Choosing Dimensions

Set Date Range

After identifying the metrics and dimensions, proceed to the "Date Range" tab. Catchr.io provides predefined date ranges like "Last month" and "This year," along with the option to choose custom start and end dates for your data.

Setting the Date Range

Apply Filters

To refine your data, apply filters in the "Filters" tab. Input the desired criteria across the following fields:

  • Field: The parameter name (e.g., country)
  • Operator: The equation operator (e.g., equals)
  • Value: The specified parameter value (e.g., United States)

For instance, to exclusively view data for app interactions originating from the United States, establish a filter with Field = Country, Operator = Equals, and Value = United States.

Applying Filters

Schedule & Customize Data Refreshness

To conclude, navigate to the "Options" tab to set up scheduled automatic updates for your data. Here, you can enable features such as "Appends rows," which incorporates new rows at the end of your data range, and "Combine rows," which refreshes all rows within that span.

Scheduling Data Refresh

With the tutorial's completion, you possess the comprehensive know-how to align your App Store Connect data with Google Sheets, fostering an environment for enhanced data analysis and reporting.

Example of Google sheets you can create to use with the App Store Connect source

Integrating App Store Connect with Google Sheets opens new vistas for visualizing and analyzing your app's performance data in transformative ways. Here are examples of Google Sheets you can construct:

App Performance Dashboard: Create a comprehensive dashboard featuring metrics like review ratings, total sales units, and active subscriptions. Such a setup aids in instant performance evaluation and trend spotting, helping you make informed decisions swiftly.

User Feedback Analysis: Aggregating review data such as ratings, titles, and content into a sheet makes it manageable to perform sentiment analysis or identify common points of feedback, enabling a targeted approach to app improvements.

Sales and Revenue Reporting: By pulling detailed sales metrics and dimensions into Google Sheets, you can form nuanced reports that detail your app’s financial health, tracking sales trends, revenue from different territories, and performance of various app versions or platforms.

Ultimately, the versatility of Google Sheets, combined with the detailed metrics and dimensions available through App Store Connect, provides a powerful toolkit for app developers and marketers aiming to elevate their app’s success and operational efficiency.

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

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