Open navigation

Amazon Ads connection guide

Follow these steps to connect your Amazon Ads data to Supermetrics and use your data in Excel as well as any of our data warehouse destinations and the Supermetrics API. You can also connect to data sources from the Supermetrics Hub.

Availability

Amazon Ads is available only in Excel and our data warehouse and API data destinations.

Before you begin

To connect to Amazon Ads, you need an Amazon user account that has access to an ad account.

  • If using a manager account to access a linked ad account, the Amazon user account needs to be an Admin in the manager account, and the manager account needs at least Editor permissions to the linked ad account. 
  • If the Amazon user account has direct access to the ad account, the Amazon user account needs at least Editor permissions.
  • If using granular permissions in either case, the user/manager account must have view permissions to both Advertising reports and Campaign manager options.

Note that Agency profiles are not supported. For Agency profiles, use the Amazon DSP data source connector instead.


Query types

  • Sponsored Products: Get data for Sponsored Products type ads
  • Sponsored Brands: Get data for Sponsored Brands type ads
  • Sponsored Display: Get data for Sponsored Display type ads


Instructions

Excel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open an Excel file.
  2. Click DataShow Supermetrics.
  3. Under Data source, select Amazon Ads.
  4. Choose to make this connection shared or private.
  5. Click Start.
  6. Log in to Amazon Ads.
  7. Navigate to Report configuration and select a query type.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.

Data warehouse

Follow these instructions to set up a transfer with Supermetrics for BigQuery (marketplace). See the instructions below for other data warehouse destinations.


Set up transfer for BigQuery (marketplace)

Make sure you've enrolled the data source before you connect.

  1. Log in to the Google Cloud Platform.
  2. Navigate to BigQueryData transfers.
  3. Click + Create transfer.
  4. Select the Amazon Ads data source.
  5. Fill in the transfer details. See detailed instructions on how to set up a transfer.
  6. Under Third-party connection, click Connect source.
  7. Accept the agreement.
  8. Click Authorize with Amazon Ads.
  9. Click Start.
  10. Log in to Amazon Ads.
  11. Select the accounts and query type you'd like to include in your reporting and define the transfer settings.
  12. Click Submit.
  13. Click Save.


Set up data warehouse transfer on the Supermetrics Hub

Make sure you've set up a data warehouse destination before you connect.

  1. Log in to the Supermetrics Hub.
  2. In the sidebar, go to StorageTransfers.
  3. Click New transfer. If you haven't created any transfers yet, click Schedule first transfer.
  4. Select the Amazon Ads data source, and click OK.
  5. Fill in the transfer details. See detailed instructions on how to set up a transfer.
  6. In the Connections section, click Add new connection.
  7. Click Start.
  8. Log in to Amazon Ads.
  9. In the transfer setup view, select the accounts and query type you'd like to include in your reporting.
  10. Click Create transfer.
The Supermetrics API
  1. Log in to the Supermetrics Hub.
  2. In the sidebar, click API.
  3. Click Create or edit queries.
  4. Click Select a data source.
  5. Select the Amazon Ads data source.
  6. Click Start.
  7. Log in to Amazon Ads.
  8. Select the accounts and query type to use in your query.
  9. Fill in the query details. See detailed instructions on how to set up a Supermetrics API query in Query Manager.
  10. Click Run to test your query.
Supermetrics Hub
  1. Log in to the Supermetrics Hub.
  2. In the sidebar, click Data sources.
  3. Scroll down to the list of data sources you haven't connected to. You see this list below your existing connections, under the title Connect to new data source.
  4. Hover over the Amazon Ads data source, and click Connect.
  5. Click Start.
  6. Log in to Amazon Ads.


More resources

Did you find it helpful? Yes No

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