App Store Connect & Power BI: How to integrate your data and template

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.

Create the request to transfer App Store Connect data to PowerBI

• Within Catchr, select 'API' from the navigation menu on the left.

• Set your export preference to "PowerBI" as the format.

• In the "Source" tab, pick App Store Connect as the platform for data extraction.

• Choose one or more accounts from which you wish to extract data.

• For your data request, pick the desired metrics and dimensions—multiple choices are allowed.

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.

• Apply filters if needed to refine the data request—multiple filters are permitted.

• Optionally, add specific platform options to your data request.

• Upon preparation completion, a URL will materialize at the top bar. To preview the outcome, simply click "Preview" on the top right.

• After a brief interim, you’ll be able to inspect the data preview.

• Once satisfied with the data preview, copy the URL as it's necessary for the next steps in 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".

• In 'basics' mode, paste the URL you copied earlier from Catchr.

• 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.

‍