Amazon Ads Data Connector User Guide

Amazon Ads Data Connector User Guide

The following article is a guide for automating reports with your Amazon Ads connector. It includes metrics available and how to connect, backfill, and blend your Amazon data. To create an Amazon report, you will need access to at least one or more Amazon Ads accounts as well as Google Sheets and/or Looker Studio.

Available Data

  1. Overview - Spend, clicks, impressions, attributed conversions, and attributed sales. Clicks and spend by date.
  2. Campaigns - Spend, clicks, impressions, attributed conversions, and attributed sales by campaign name and campaign type.
  3. Ad Groups - Spend, clicks, impressions, attributed conversions, and attributed sales by ad group name.
  4. ASIN/SKU Performance - Spend, clicks, impressions, attributed conversions, and attributed sales by ASIN and SKU.
  5. Keyword/Query Performance - Spend, clicks, impressions, attributed conversions, and attributed sales by keyword text and query.
  6. Complete list of fields.


API Limitations

  1. Realtime data - Realtime data is not available.
  2. Custom Fields - Custom fields are not available.

How To Blend Amazon Data With Other Data

Report Amazon Ads data with Amazon sales data

To join Amazon Ads data with sales data:
  1. Export your Amazon Ads data into a Google Sheet.
  2. Either join that data in Google Sheets/Excel or create a data source in Looker Studio with the Google Sheets connector. Google offers this support article on the subject if you require a more detailed walk-through.
  3. Use the Blending feature in Looker Studio when you need both Ads and Sales data in the same report.


Connection Requirements

Connecting to Amazon Ads is a complex process that can take several days. It is important to follow the directions in order to connect successfully. Please see our guide on How to Connect to Amazon Ads.

Backfilling

When you first create a report with Amazon Ads, Power My Analytics will automatically backfill 60 days of data.

Amazon Ads API limits backfilling to only 60 days of data. This is a hard limit. We will begin storing this data going forward when you connect with us and build a longer history over time.

Troubleshooting

Please see our Troubleshooting Amazon article for everything you need to know to get your Amazon reports working.


    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Twitter Ads Data Connector User Guide

        The following article is a guide to automating reports with your Twitter Ads connector. It includes information on available data as well as tips on how to get the most out of your Twitter Ads reports. To begin creating reports with your Twitter Ads ...
      • Quora Ads Data Connector User Guide

        The following article is a guide to automating reports with your Quora Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Quora Ads reports. To begin creating ...
      • Microsoft Ads Data Connector User Guide

        The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin ...
      • Google Ads Data Connector User Guide

        The following article is a guide to automating reports with your Google Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Ads reports. To begin creating ...
      • AdRoll Data Connector User Guide

        The following is a guide to automating reports with your AdRoll connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your AdRoll reports. To begin creating reports with your ...