Open navigation

Amazon Ads connection guide

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

Availability

Amazon Ads is available only in 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.


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

Data warehouseAPIHub

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 left-side menu, under Export, go to Data warehousingTransfers.
  3. Click Create new.
  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.


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.