This guide contains all permissions and requirements for connecting your Amazon DSP data to Supermetrics.
Availability
Amazon DSP 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, you need an Amazon user account with access to an Amazon DSP account. See Amazon's guide on obtaining consent to access an Amazon DSP account.
The account should have View and Edit permissions for Campaign Management.
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:
- Campaign: Get detailed performance metrics by order, line-item, and creative.
- Inventory: Get detailed performance metrics by supply and site
Connection instructions
When connecting to Amazon DSP, you need to log in to Amazon and select the query type and account when prompted.
- Select the Amazon DSP data source on the Supermetrics Hub or in the data destination.
- Select your account's region.
- Give your account a name. The name can be anything — its purpose is for you to recognize the login later in case you have multiple logins.
- If prompted, choose to make this connection shared or private.
- Click Start.
- Log in to your Amazon account.
- Click Allow to allow the Supermetrics app to access your profile data.
- In your data destination, select the query type to use and an account to pull data from.
See instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Amazon DSP 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