This guide will walk you through how to authenticate Apple App Store / iTunes Public Data with Google Sheets, Data Studio, and Microsoft Excel.
Please note that this data source is in early access — it's not fully deployed, but is available for testing.
Before you begin
The Supermetrics Apple App Store / iTunes Public Data data source doesn't need you to log in to a specific account. Therefore, no access requirements are needed for this data source.
Data protection agreement
If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.
Instructions
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
- Open a new Google Sheets file.
- Click Add-ons → Supermetrics → Launch to open the sidebar.
- Under Data source, select Apple App Store / iTunes.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with commas.
- Select App Store country.
- Select the Platform (i.e. iPhone, Mac etc.) and Maximum results per search term.
Next steps
Learn how to create your first Supermetrics query with Apple App Store / iTunes.- Open this Data Studio link.
- Click Authorize.
If you're authenticating the data source for the first time, log in with the Google account you use with Supermetrics. Click Allow.
- Click Authorize to log in to the data source.
- Under Query type, select the query type and click Next.
- Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with a comma.
- Select App Store country.
- Select the Platform (i.e. iPhone, Mac, etc.) and Maximum results per search term.
- Click Connect on the top right-hand side. This will open a full list of fields available in this connector. You can skip this list.
- Click Create report.
- Click Add to report to complete the authentication steps.
Next steps
Learn how to create your first Supermetrics query with Apple App Store / iTunes.Before you can authenticate this data source in Excel, you need to install the Supermetrics add-on.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Apple App Store / iTunes.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with commas.
- Select App Store country.
- Select the Platform (i.e. iPhone, Mac etc.) and Maximum results per search term.