This guide contains all permissions and requirements for connecting your Amazon Ads data to Supermetrics.
Availability
Amazon Ads is available only in Excel and our data warehouse and API data destinations.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in the available destinations.
Required permissions
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
Query types define what sort of metrics and dimensions are available. You need to select one of the following query types when pulling data.
- 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
Connection instructions
When connecting to Amazon Ads, you need to log in to Amazon Ads and select the account when prompted.
- Select the Amazon Ads data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Click Start.
- Log in to Amazon Ads.
- In your data destination, select the accounts and query type you'd like to include in your reporting.
See instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Amazon Ads from these destinations:
- Excel: How to connect data sources to Excel with Supermetrics
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer