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
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.
- Log in to the Google Cloud Platform.
- Navigate to BigQuery → Data transfers.
- Click + Create transfer.
- Select the Amazon Ads data source.
- Fill in the transfer details. See detailed instructions on how to set up a transfer.
- Under Third-party connection, click Connect source.
- Accept the agreement.
- Click Authorize with Amazon Ads.
- Click Start.
- Log in to Amazon Ads.
- Select the accounts and query type you'd like to include in your reporting and define the transfer settings.
- Click Submit.
- Click Save.
Set up data warehouse transfer on the Supermetrics Hub
Make sure you've set up a data warehouse destination before you connect.
- Log in to the Supermetrics Hub.
- In the left-side menu, under Export, go to Data warehousing → Transfers.
- Click Create new.
- Select the Amazon Ads data source, and click OK.
- Fill in the transfer details. See detailed instructions on how to set up a transfer.
- In the Connections section, click Add new connection.
- Click Start.
- Log in to Amazon Ads.
- In the transfer setup view, select the accounts and query type you'd like to include in your reporting.
- Click Create transfer.
- Log in to the Supermetrics Hub.
- In the left-side menu, under Transform, click Query Manager (API).
- Select for Supermetrics API from the dropdown menu next to the page title.
- Click Select data source.
- Select the Amazon Ads data source.
- Click Start.
- Log in to Amazon Ads.
- Select the accounts and query type to use in your query.
- Fill in the query details. See detailed instructions on how to set up a Supermetrics API query in Query Manager.
- Click Run to test your query.
- Log in to the Supermetrics Hub.
- In the left-side menu, select Connect → Data sources.
- 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.
- Hover over the Amazon Ads data source, and click Connect.
- Click Start.
- Log in to Amazon Ads.
