blog post

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

Florian Cabirol
November 28, 2023
Explore AppStore Connect KPI for your application in PowerBI : How-to, metrics and templates...

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

In this tutorial, you'll learn the seamless process of linking your App Store Connect metrics to PowerBI through Catchr. By the end of this guide, you'll have the ability to transform raw data into visual insights that drive marketing decisions and strategy.

How to connect your App Store Connect account to PowerBI

Add a source on Catchr

Navigate to the Catchr main page and look for the 'Source' option in the left menu. Click on it, and then proceed to 'Add a Source' which you'll find in the upper right corner. Choose App Store Connect and authenticate your account to forge a connection between Catchr and the platform.

Adding Source on Catchr

Create the request to transfer App Store Connect data to PowerBI

  • Within Catchr, select 'API' from the navigation menu on the left.
API Section on Catchr
  • Set your export preference to "PowerBI" as the format.
Setting PowerBI as Export Format
  • In the "Source" tab, pick App Store Connect as the platform for data extraction.
Selecting App Store Connect as Source
  • Choose one or more accounts from which you wish to extract data.
Account Selection for Data Extraction
  • For your data request, pick the desired metrics and dimensions—multiple choices are allowed.
Selecting Metrics and Dimensions
Continued Metrics and Dimensions Selection

Warning: Should you utilize one of the Catchr templates, ensure to include all dimensions and metrics as listed on the template's dedicated Catchr page. Proper selection will automatically populate the template with your App Store Connect data, ready for further customization.

  • Select the time range for data acquisition from App Store Connect, with options for custom or preset durations.
Selecting Time Range for Data
  • Apply filters if needed to refine the data request—multiple filters are permitted.
Applying Filters to Data Request
  • Optionally, add specific platform options to your data request.
Adding Platform-specific Options
  • Upon preparation completion, a URL will materialize at the top bar. To preview the outcome, simply click "Preview" on the top right.
Previewing Data Request Outcome
  • After a brief interim, you’ll be able to inspect the data preview.
Data Preview
  • Once satisfied with the data preview, copy the URL as it's necessary for the next steps in PowerBI.
Data Request URL for PowerBI

Import the App Store Connect data and KPI to PowerBI

For PowerBI Desktop, initiate a data import using the following instructions:

  • Select "Get Data" then choose "Web".
Get Data from Web in PowerBI Desktop
  • In 'basics' mode, paste the URL you copied earlier from Catchr.
Pasting URL in PowerBI Desktop
  • Confirm your selection by clicking "OK."

PowerBI may take a short while to process and import your data. With the import complete, utilize PowerBI Query to fine-tune the query and configure field types to your preference. Subsequently, dive into creating, publishing, and sharing your insightful dashboards.

In the PowerBI Web App, published datasets are accessible in your browser. To find these, you’ll import from PowerBI desktop and can then select a dataset to fuel your new report creation.

You are now equipped to establish a bridge between App Store Connect and PowerBI. Utilizing these steps, the realm of data-driven marketing decisions is at your fingertips. Import KPIs, analyze trends, and communicate results with compelling visualizations made easier by Catchr and PowerBI.

Example of metrics you can use with the PowerBI Integration for App Store Connect

App Store Connect offers a rich trove of metrics that can be leveraged within PowerBI to create detailed reports and dashboards for app performance tracking. For example, you can monitor app downloads, user engagement, and revenue generated from in-app purchases, subscriptions, or paid apps. Below are examples of how you can use various metrics in PowerBI:

By analyzing App Id and App Name, you can track performance across different apps within App Store Connect.

Temporal metrics like Year, Year Quarter, and Date can help you understand sales trends over time, while Review Rating and Review Content offer insight into customer feedback and satisfaction levels.

Financial metrics such as Summary Sales units, Customer Currency, and Developer Proceeds will give you the financial pulse of your products, informing strategy adjustments for pricing and marketing efforts.

The integration of Subscription metrics unlocks a profound understanding of customer retention and the effectiveness of subscription models.

To view a complete list of available App Store Connect metrics for PowerBI and explore how they can empower your analysis, visit: Catchr's App Store Connect Metrics.

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