Open navigation

Apple Public Data connection guide

This guide will walk you through how to authenticate Apple Public Data with Google Sheets, Looker 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.


Google Sheets Looker Studio  Excel

Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Click Create query.
  4. Under Data source, select Apple Public Data.
  5. Navigate to Report configuration.
  6. Under Query type, select the query type.
  7. Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with commas.
  8. Select App Store country.
  9. Select the Platform (such as iPhone or Mac) and Maximum results per search term.
When you're ready, learn how to create your first Supermetrics query with Apple Public Data.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.