help

How to install Google Sheets Add-ons?

1. Open a new Google Spreadsheet document.

2. Click the button Add-ons in the top spreadsheet navigation and choose "Get add-ons..."

3. Search for "AppStoreMetrix" in the top right search bar and click on the logo that appears.

4. Install AppStoreMetrix by giving it permission to access your Google Data. Choose the Google Account you want to run reports with and click "ALLOW". 

!!! Please note that the add-on is sometimes not loaded properly after an update. If only the help section is selectable just uninstall the add-on and re-install it !!!

How to uninstall Google Sheets Add-ons?

1. Click Add-ons in the top navigation of your Google Spreadsheet.

2. Then select Manage add-ons...

3. Select AppStoreMetrix and click MANAGE.

4. Click Remove.

Please note that your user credentials will be temporarily stored to your Google user properties for each session. Even though you choose the "remember my credentials" radio button no login data will be stored to our server.

We just cache the credentials temporarily to login to the iTunes Connect API for you.

If you are using AppStoreMetrix your data will be only stored permanently to your own Google Drive account. We may cache your query results temporarely on our servers to improve the performance. We do not use your personal data for any other purpose than for returning your query results.

We do not share it to third parties or other users of our add-on.

For further information please have a look at our privacy policy.

How to generate the iTunes Connect access token and login to AppStoreMetrix?

1. Login to your iTunes Connect account and choose Sales & Trends.

2. Choose Reports in the top left corner.

3. Click on the question mark besides About Reports in the top right corner.​

4. Click Generate Access Token in the pop up window.

5. Copy the existing Access Token or use the Regenerate button to create a new code.​

6. Launch the AppStoreMetrix sidebar and choose iTunes Connect.

7. Enter your Access Token and click login.

!!! Please note that the Access Token will be stored to your Google Account and automatically expires within 180 days !!!

How to import your iTunes app reports to Google Sheets?

1. Launch the AppStoreMetrix sidebar.

2. Choose iTunes Connect and enter your Access Token to login to AppStoreMetrix.

3. Choose Sales at the Report Type option.

4. Make your choice at the Date Type option and choose daily, weekly, monthly or yearly import.

!!! Please note that AppStoreMetrix currently just supports the import of sales summaries !!!

​

To define a day, week, month or year just choose a single day at the date picker:

!!! Please note that yearly reports are just available for complete years in the past. In case you need an overview of the current year please use monthly, weekly and daily reports !!!

How to get iTunes connect finance reports?

To import monthly finance reports please follow the descriptions below. The Vendor number will always be displayed automatically.

!!! Please note that Apple periods are different from the usual calendar. Finance data is usually available in monthly ranges with a delay of around two and a half months starting in September each year. For further details please have a look at screenshots below or visit the payments and financial reports section in your iTunes connect account !!!

How to get schedule iTunes connect sales reports?

1. Choose AppStoreMetrix under Add-ons and click Schedule Import.

2. Choose iTunes Connect and enter your Access Token to login.

3. Make your choice at Report Type and the Schedule Import options.

4. Click Submit.

​

!!!  Please note that scheduled imports are just available for iTunes connect sales summaries !!!

5. Manage your scheduled imports by choosing AppStoreMetrix and click Show Scheduled Imports.

6. The listet schedules can be deleted permanently by clicking the Delete button.