This guide will walk you through how to authenticate Apple Public Data with Google Sheets, Data Studio, and Microsoft Excel.
Please note that this data source is in early access, which means we're still fine-tuning its features. We'd love to hear your feedback.
For Excel users
If your team uses Supermetrics for Excel, you’ll see different options for managing and sharing data source connections in that destination. Learn more.
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.
- Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
- Click Create query.
- Under Data source, select Apple Public Data.
- 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.
- 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.
- Click Create report.
- Click Add to report to complete the authentication steps.
Before you can authenticate this data source in Excel, you need to install the Supermetrics add-in.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Apple Public Data.
- Choose to make this connection shared or private.
- Click Start.
- 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) and Maximum results per search term.
When you're ready, learn how to create your first Supermetrics query with Apple Public Data.