Amazon Ads
The Amazon Ads connector gets your Amazon Ads data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Sponsored Products, Sponsored Brands, and Sponsored Display campaign performance
- Impressions, clicks, spend, sales, and ACOS (Advertising Cost of Sales)
- Keyword and targeting performance
- Ad group and campaign-level breakdowns
- Return on Ad Spend (ROAS) and conversion tracking
Some breakdowns do not include all three ad types. Before you compare a report with the Amazon Ads console, see Which ad types each breakdown covers.
Which ad types each breakdown covers
Amazon Ads gives a different report for each type of breakdown. Some of these reports are not available for all three ad types. Thus, the fields that you select set which ad types your numbers include.
| Fields that you select | Ad types included |
|---|---|
| Campaign, Ad group, Portfolio and the other fields not in the rows below | Sponsored Products, Sponsored Brands, Sponsored Display |
| Targeting | Sponsored Products, Sponsored Brands, Sponsored Display |
| Advertised product, Ad | Sponsored Products, Sponsored Display |
| Keywords, Placement, Search term | Sponsored Products, Sponsored Brands |
Amazon Ads has no advertised product report for Sponsored Brands. Thus, a report with Advertised product fields does not include Sponsored Brands spend, clicks or sales. If the account ran Sponsored Brands in the date range, the totals are lower than the totals in the Amazon Ads console. The data is correct, but the report does not include those campaigns. In the same way, reports with Keywords, Placement or Search term fields do not include Sponsored Display.
Two Minute Reports does not show a warning when a report does not include an ad type. To get the totals for all the ad types:
- Use Campaign or Ad group fields, and no fields from the last two rows of the table.
- To keep the product detail, make a second report with Campaign or Ad group fields. Use the second report for the account totals.
Prerequisites
- An active Amazon Ads account
- Edit access to Campaign Manager on the accounts you want to report on
- View access to Advertising reports for those same accounts
- Manager Account access if reporting across multiple sub-accounts
Note: KDP (Kindle Direct Publishing) accounts cannot be connected via the Amazon Ads API and will not appear in the accounts list.
Missing ad accounts? If an account doesn't appear after connecting, there are two common causes: (1) your user does not have the required Edit access to Campaign Manager on that account, or (2) the advertiser account has not granted API access to your Amazon Ads account. Check both on the Amazon Ads console.
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Amazon Ads in the connector list.
- Select Next.
- In Name the connection, enter a name.
- Sign in with Amazon. Then allow Two Minute Reports access.
- Enable the accounts you want to report on.
- Select Done.
How to get Amazon Ads data into Google Sheets or Google Data Studio
To get Amazon Ads data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.
To get Amazon Ads data into Google Data Studio:
- In the Hub, open Google Data Studio › Amazon Ads.
- Select Create report.
- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.
- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.
- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.
- In your new report, add Amazon Ads metrics and dimensions to the canvas.
