Connectors
Apple App Store
Connect Apple App Store to Google Sheets or Looker Studio
Two Minute Reports' Apple App Store connector lets you pull your app's sales, downloads, and financial data from App Store Connect directly into Google Sheets or Looker Studio — automatically, without writing any code.
What you can report on
- App downloads and units sold
- App sales revenue and proceeds
- In-app purchase performance
- Subscription metrics
- Refunds and cancellations
- Regional and storefront breakdowns
Prerequisites
- An Apple Developer account with access to App Store Connect
- Finance access on your App Store Connect account — this permission is required to fetch both sales and financial metrics
- An API key (
.p8file) generated from App Store Connect, along with your Issuer ID and Key ID
How to get your API credentials from Apple
- Go to App Store Connect → Users and Access → Integrations → App Store Connect API
- Click Generate API Key
- Give the key a name and set the access level to Finance
- Download the
.p8key file — this can only be downloaded once, so save it securely - Note your Issuer ID (shown at the top of the API Keys page) and the Key ID for the key you just created
The
.p8 file can only be downloaded once at the time of creation. If you lose it, you'll need to generate a new key.How to create a connection
- Go to https://hub.twominutereports.com/connections
- Click New Connection and select Apple App Store from the connector list
- Enter your Issuer ID, Key ID, and upload or paste the contents of your
.p8API key file - Click Test Connection to verify the credentials
After creating a connection:
- Enable the App Store accounts (vendor accounts) you want to use
Important: Only enabled accounts can fetch data and count toward your plan usage.
How to get Apple App Store data into your reports
To pull App Store data into Google Sheets:
- In the TMR sidebar, go to Data Queries and click Add
- Select the App Store account(s) you want to analyze
- Choose your metrics and dimensions from the available options
- Select the date range for your analysis
- Click Run Query to load results into your sheet
Next steps
To pull App Store data into Looker Studio:
- Click Open in Looker Studio, then click + Create Report.
- A query config panel will appear. Do one of the following:
Already have a query config? Select it from the dropdown and skip to step 3.
Creating a new query config: Enter a name, select the accounts you want to include from the dropdown, then click Save.
- Choose Create report from scratch to build a custom report, or select one of the pre-built templates to get started quickly.
- In the Looker Studio connector panel, select your team and choose the required query config from the dropdown. Click Connect in the top-right corner.
- You'll land on the Looker Studio dashboard. Drag and drop the available App Store metrics and dimensions onto your canvas to start analyzing your data.
Next steps
If you need help, contact [email protected] or submit a support ticket.