Amazon Seller Data Connector User Guide

Amazon Seller Data Connector User Guide


The following article is a guide for automating reports with your Amazon 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 Seller accounts as well as Google Sheets and/or Google Data Studio.

Available Data

  1. Sales by Marketplace - Each Seller ID can report one Region (Americas, Europe and India, Far East) and all Marketplaces (United States, Germany, France, Spain, etc.) under each Region.
  2. Total sales over time - Report up to 2 years of history on the first day you connect. Going forward, we will store that historical data so that you can always access 2+ years of data. This data is available for FBM and FBA's sales.
  3. Sales by product - Product SKU and Product Name. This is available for all FBM and FBA's sales.
  4. Sales by ASIN - This data is available for FBM and FBA's sales.
  5. Fees reporting - Includes listing fees for both seller-fulfilled and Amazon-fulfilled order as well as fulfillment fees for Amazon-fulfilled orders.
  6. Inventory by SKU and ASIN for previous day - We currently provide yesterday's inventory.
  7. Excess inventory reporting - This data is available for FBA in the India, US, and Japan markets. It is not available for the EU.
  8. Returns reporting - Reporting over time, status of returns, order details, and return reason (both for seller-fulfilled and Amazon-fulfilled returns).
  9. Seller reviews - Includes neutral or negative seller feedback.
  10. Complete list of fields.

API Limitations

  1. Minimizing differences between Amazon UI and API values -  Amazon Seller's API reports values that differ from the values in Amazon UI, and this can be as small as a 1% difference. For example, the UI may report 3,000 orders, while the API could report 30 more or fewer orders. This difference will be smaller and typically below 5% when using longer date ranges, but the difference may become larger for shorter ranges, such as when comparing daily figures.
  2. Amazon Vendor Central data - The Amazon API currently does not support Amazon Vendor data. Upcoming API updates may support this. Check our newsletter for updates!
  3. Buy box % reporting - The Amazon API does not currently provide this information. We can only provide the Buy Box price in the Excessive Inventory table.
  1. Sales and Traffic reporting - The Amazon API does not currently provide these reports.
  1. Product reviews - The Amazon API does not currently provide these reports.
  1. Real time and historical inventory reporting - We are currently working on adding this feature.  Check our newsletter for updates .
  1. Sales reporting by date shipped - Sales reports are referenced by order date. If you attempt to compare Amazon's business reports to our connector's data, there will be a mismatch due to this key difference in sales reporting date.
  1. Sales and inventory by brand - Amazon does not provide this additional dimension in their API.
  2. Custom Fields - Custom fields are not available.

Connection Requirements

Amazon Seller requires specific permissions. It can be difficult to connect on your first try. Please see our guide on How to Connect to Amazon Seller.

Backfilling Capabilities

Power My Analytics will initially backfill 13 months of data with our Amazon connector. See the chart below for a detailed breakdown of our current backfilling capacity. Keep in mind that we are always updating and our capacity may change in the future.

Data Type
Time Frame
Sales
Up to 2 years
Fees
Up to 180 days
Returns
Up to 2 years
Seller Reviews
Up to 2 years
Seller-Fulfilled and FBA Inventory
1 day
FBA Unsellable Inventory
2 years

How To Blend Amazon Data With Other Data

Report Sales by Brand

To overcome this limitation in Amazon's API, create a Google Sheet with two columns.
  1. SKU
  2. Brand
Then, blend this data with your Data Studio report.



COGS reporting

To include the product cost of goods sold, create a Google Sheet with this data:
  1. SKU
  2. COGS

Report Amazon Ads data with Amazon sales data

To join Amazon Ads data with sales data, export your Amazon Ads data into a Google Sheet and then 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.

Then use the Blending feature in Data Studio when you need both Ads and Sales data in the same report.


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

      • 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 ...
      • How to Connect to Amazon Seller

        The following video and article provide instructions for connecting to Amazon Seller. Access Permissions Account administrators An administrator of the Amazon account can connect or grant access to other accounts to connect. Agencies and others Any ...
      • eBay Data Connector User Guide

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

        Most errors that occur in Amazon reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Amazon reports. If you have questions about regions ...
      • Mailchimp Data Connector User Guide

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