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 Looker Studio.


Available Data

  1. Orders - Table: Quantity, Order Subtotal, Shipping, Tax, Fees, Order Total; by Date And Time, Amazon Order ID, Order Status, Fulfillment Channel, Marketplace. Scorecards: Quantity; Product Revenue; Shipping; Tax; Total Revenue. Options: Marketplace; Order Status; date range.
  2. Product Sales - Table: Qty Sold, Revenue, and Listing & Selling Fees; by SKU, ASIN, Product Name. Options: Marketplace; Order Status; date range.
  3. Sales and Traffic - Table: Ordered Product Sales, Units Ordered, Total Order Items, Average Sales per Order item, Average Units per Order item, Average Selling Price, Sessions - Total, Order Item Session Percentage, Average Offer Count; by Date. Options: Date range.
  4. Fulfillment: All Orders - Table: Quantity, Item Price; by Amazon Order ID, Date, Order Status, Fulfillment Channel, Order Channel, Ship Service Level, Product Name, Item Status, Currency. Charts: Quantity by Order Status, Quantity by Fulfillment Channel, Quantity by Ship Service Level, Quantity by Currency. Options: Date range.
  5. Inventory (FBA) - Table: Fulfillable Qty, Total Supply Qty, Inbound Shipped Qty, Reserved Qty, Unsellable Qty, Total Qty, Days Of Supply, Estimated Excess; by Inventory SKU, Product Name, Marketplace. Options: Marketplace; date range.
  6. Inventory (FBM) - Table: Pending Inventory, Total Inventory; by Seller SKU, ASIN, Item Name. Options: Marketplace; date range. 
  7. Manage Excess Inventory (FBA) - Table: Your Price, Estimated Excess, Units Shipped Last 30 Days, Days Of Supply, Est. long-term storage units, Est. Long-term storage fee; by Inventory SKU, Product Name, Buy Box Price. Options: Date range.
  8. Inventory Adjustments (FBA) - Table: Carrier Damaged, Customer Damaged, Distributor Damaged, Fulfiller Damaged, Warehouse Damaged, Unsellable, Unknown, Sellable; by Inventory SKU, Product Name. Chart: Warehouse Damaged, Customer Damaged, Carrier Damaged, Distributor Damaged, Defective; by Account ID. Scorecards: Quantity; Product Revenue; Shipping. Options: Date range.
  9. Inventory Age (FBA) - Table: 0-90 Days, 91-180 Days, 181-270 Days, 271-365 Days, 365+ Days, Units Shipped Last 30 Days; by Inventory SKU, Product Name. Charts: Inventory Age, Units Shipped Over Time. Options: Marketplace; date range.
  10. Returns (FBA) - Table: Qty Returned; by Date, Amazon Order ID, Inventory SKU, ASIN, FNSKU, Product Name, Disposition, Return Reason, Return Status. Charts: Quantity Returned Fba by Return Reason FBA, Qty Returned by Date. Options: Date range.
  11. Returns (FBM) - Table: Return Quantity; by Date, Amazon Order ID, SKU, Item Name, Return Reason. Charts: Return Quantity by Return Reason, Return Quantity by Returns - Order Date. Options: Date range.
  12. Reimbursement (FBA) - Table: Amount Total, Quantity Reimbursed; by Date, Product Name, Return Reason, Amazon Order ID, Inventory Condition, Inventory SKU, Reimbursement Type. Options: Date range.
  13. Fee Preview (FBA) - Table: Selling Price, Est. Referral Fee, Est. Fulfillment Fee, Est. Total Fees, Est. Revenue Minus Fees; by ASIN, Inventory SKU, FNSKU, Product Name. Options: Date range.
  14. Fees - Tables: Amount by Fee Type. Options: Date range.
  15. Negative & Neutral Feedback - Table: Review Rating; by Amazon Order ID, Inventory SKU, Comments. Chart: Review Rating (count). Options: Date range.
  16. Settlement - Settlement reports are available for 90 days.
  17. Complete list of fields.

API Limitations

  1. Sales and Traffic - Data for fields in the Sales and Traffic table is live only and may be delayed by up to 72 hours.

  1. Regional reporting - 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. Excess inventory - Not available in the EU.
  3. 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.
  4. 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!
  5. 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.
  2. 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. Fee and Quantity - The Quantity field cannot be used in the same table as the Fee field. Doing so will produce incorrect values for fees.
  3. Custom Fields - Custom fields are not available. 

Connection Requirements

Connecting to Amazon Seller is a very involved process. Please see our guide on How to Connect to Amazon Seller.

Backfilling Capabilities

Power My Analytics will initially backfill 13 months of data when you first create a report 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
Settlement Reports
90 days

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 ...
      • 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 ...
      • 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 ...
      • 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 ...
      • 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 ...