Apple Public Data connection guide

1. Open this Looker Studio link.
2. You'll see two buttons that read Authorize. If you're using Supermetrics for the first time, click the left-hand one and log in with the Google Account you use with Supermetrics.
3. Once that's done, or if you've done it before, click the right-hand Authorize button (under "Apple Public Data requires authorization to connect to data").
4. Select a team that has access to the account you want to connect.
5. Choose to make this connection shared or private.
6. Click Start.
7. Under Query type, select the query type and click Next.
8. Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with a comma.
9. Select App Store country.
10. Select the Platform (such as iPhone or Mac) and Maximum results per search term.
11. Click Connect on the top right-hand side.
12. Click Create report.
13. Click Add to report.

Before you can authenticate this data source in Excel, you need to install the Supermetrics add-in.

1. Open an Excel file.
2. Click Data → Show Supermetrics.
3. Under Data source, select Apple Public Data.
4. Choose to make this connection shared or private.
5. Click Start.
6. Navigate to Report configuration.
7. Under Query type, select the query type.
8. Insert Keyword(s) or App ID(s) for searching apps. To select different apps, separate each one with commas.
9. Select App Store country.
10. 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.