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 Google Data 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.

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 Data 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 Data 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

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

      • 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 ...
      • 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 ...
      • 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 ...
      • Instagram Ads Data Connector User Guide

        The following article is a guide for automating reports with your Facebook Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Facebook Ads data. To create a Facebook Ads report, you will need at ...