Data Studio Amazon MWS Overview Report

amazon mws overview report

Wondering how to get your Amazon Seller Central / Amazon MWS data into Data Studio. This template will help you get it done. The insights are retrieved at an order level, which allows you to go really granular in your data analysis. The full list of supported metrics and dimensions is below. In case you have other fields which are currently not shown in the dashboard or the connector, contact us via chat and we’ll get them added for you.

 

This dashboard connects to the following data source

  • Amazon MWS

Available metrics and dimensions in this dashboard

NameDescription
Afn Fulfillable QuantityAfn fulfillable quantity
Afn Future Supply BuyableAfn future supply buyable
Afn Inbound Receiving QuantityAfn inbound receiving quantity
Afn Inbound Shipped QuantityAfn inbound shipped quantity
Afn Inbound Working QuantityAfn inbound working quantity
Afn Listing ExistsAfn listing exists
Afn Researching QuantityAfn researching quantity
Afn Reserved Future SupplyAfn reserved future supply
Afn Reserved QuantityAfn reserved quantity
Afn Total QuantityAfn total quantity
Afn Unsellable QuantityAfn unsellable quantity
Afn Warehouse QuantityAfn warehouse quantity
Amazon Order IDThe Amazon Order ID. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report, FBA Reimbursements Report
Amazon Order Item IdAmazon order item id
Amount Per UnitAmount per unit. Report: FBA Reimbursements Report
Amount TotalAmount total. Report: FBA Reimbursements Report
Approval DateApproval date. Report: FBA Reimbursements Report
ASINAmazon Standard Identification Number, assigned by Amazon, FBA Returns Report, FBA Storage Fees Report, Flat File Orders By Order Date Report, FBA Fee Preview Report, FBA Fee Preview Report, FBA Reimbursements Report
Asin LimitAsin limit
BrandBrand. Report: FBA Fee Preview Report
Buyer EmailBuyer email. Report: FBA Amazon Fulfilled Shipments Report
CampaignProduct group
Cancelled QuantityCancelled quantity. Report: FBA Removal Order Detail Report
CarrierCarrier. Report: FBA Amazon Fulfilled Shipments Report
ConditionCondition. Report: FBA Reimbursements Report
Condition TypeCondition type
CurrencyCurrency. Report: FBA Storage Fees Report, Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report, FBA Fee Preview Report, FBA Removal Order Detail Report
Currency UnitCurrency unit. Report: FBA Reimbursements Report
DateThe Order Date
Detailed DispositionDetailed disposition. Report: FBA Returns Report
Disposed QuantityDisposed quantity. Report: FBA Removal Order Detail Report
DispositionDisposition. Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Removal Order Detail Report
Estimated Arrival DateEstimated arrival date. Report: FBA Amazon Fulfilled Shipments Report
Estimated Cost Savings of RemovalEstimated Cost Savings of Removal
Estimated Fee TotalEstimated fee total. Report: FBA Fee Preview Report
Estimated Monthly Storage FeeEstimated Monthly Storage Fee. Report: FBA Storage Fees Report
Estimated Order Handling Fee Per OrderEstimated order handling fee per order. Report: FBA Fee Preview Report
Estimated Referral Fee Per UnitEstimated referral fee per unit. Report: FBA Fee Preview Report
Estimated Variable Closing FeeEstimated variable closing fee. Report: FBA Fee Preview Report
Expected Domestic Fulfilment Fee Per UnitExpected domestic fulfilment fee per unit. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit DeExpected efn fulfilment fee per unit de. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit EsExpected efn fulfilment fee per unit es. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit FrExpected efn fulfilment fee per unit fr. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit ItExpected efn fulfilment fee per unit it. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit SeExpected efn fulfilment fee per unit se. Report: FBA Fee Preview Report
Expected Efn Fulfilment Fee Per Unit UkExpected efn fulfilment fee per unit uk. Report: FBA Fee Preview Report
FNSKUThe Fulfillment Network SKU. Report: FBA Inventory Event Detail Report,FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Storage Fees Report, FBA Fee Preview Report, FBA Reimbursements Report, FBA Removal Order Detail Report
Fulfilled ByFulfilled by. Report: FBA Fee Preview Report
Fulfillment Center IdFulfillment center id. Report: FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Amazon Fulfilled Shipments Report
Fulfillment ChannelThe Fulfillment Channel. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Fulfillment Channel SkuFulfillment channel sku
Gift Wrap PriceThe Price of the Gift Wrap. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Gift Wrap TaxThe Tax of the Gift Wrap. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Has Local InventoryHas local inventory. Report: FBA Fee Preview Report
In Bound QuantityIn bound quantity
In Process QuantityIn process quantity. Report: FBA Removal Order Detail Report
Inbound Recommend QuantityInbound recommend quantity
Inv Age 0 To 90 DaysInv age 0 to 90 days
Inv Age 181 To 270 DaysInv age 181 to 270 days
Inv Age 271 To 365 DaysInv age 271 to 365 days
Inv Age 365 Plus DaysInv age 365 plus days
Inv Age 91 To 180 DaysInv age 91 to 180 days
Is business orderWhether or not this is a business order. Report: Flat File Orders By Order Date Report
Is HazmatIs hazmat
Sold by Amazon Business EU SARLIs true if the items in this order were bought and re-sold by. Report: Flat File Orders By Order Date ReportAmazon Business EU SARL (ABEU)
Item Package WeightItem package weight. Report: FBA Fee Preview Report
Item PriceThe Price of the Item. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Item Promotion DiscountItem promotion discount. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Item StatusThe Status of the Item. Report: Flat File Orders By Order Date Report
Item TaxThe Tax of the Item. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Last Updated DateLast Updated Date. Report: Flat File Orders By Order Date Report, FBA Removal Order Detail Report
Length And GirthLength and girth. Report: FBA Fee Preview Report
License Plate NumberLicense plate number. Report: FBA Returns Report
Longest SideLongest side. Report: FBA Storage Fees Report, FBA Fee Preview Report
Lowest Afn New PriceLowest afn new price
Lowest Afn Used PriceLowest afn used price
Lowest Mfn New PriceLowest mfn new price
Lowest Mfn Used PriceLowest mfn used price
MarketplaceThe Amazon Seller Central Marketplace
Marketplace CountryMarketplace country. Report: FBA Returns Report
Median SideMedian side. Report: FBA Storage Fees Report, FBA Fee Preview Report
Merchant Order IDThe Merchant Order ID. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Mfn Fulfillable QuantityMfn fulfillable quantity
Mfn Listing ExistsMfn listing exists
Num Afn New SellersNum afn new sellers
Num Afn Used SellersNum afn used sellers
Order ChannelThe Order Channel. Report: Flat File Orders By Order Date Report
Order IdOrder id. Report: FBA Returns Report, FBA Removal Order Detail Report
Order StatusThe Order Status. Report: Flat File Orders By Order Date Report, FBA Removal Order Detail Report
Payments DatePayments date. Report: FBA Amazon Fulfilled Shipments Report
Per Unit VolumePer unit volume
Price DesignationThe Price Designation. Report: Flat File Orders By Order Date Report
Product NameThe Product Name. Report: FBA Inventory Event Detail Report,FBA Inventory Adjustments Report, FBA Returns Report, FBA Storage Fees Report, Flat File Orders By Order Date Report, FBA Fee Preview Report, FBA Reimbursements Report
Product GroupProduct group. Report: FBA Fee Preview Report
Product Name (Duplicate)The Product Name (Duplicate of Product). Report: FBA Inventory Event Detail Report,FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Storage Fees Report, Flat File Orders By Order Date Report, FBA Fee Preview Report, FBA Reimbursements Report
Product Size Weight BandProduct size weight band. Report: FBA Fee Preview Report
Projected Ltsf 12 MoProjected ltsf 12 mo
Projected Ltsf 6 MoProjected ltsf 6 mo
Promotion IDThe Promotion ID. Report: Flat File Orders By Order Date Report
Purchase DatePurchase date. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Purchaser Order NumberThe Purchaser Order Number. Report: Flat File Orders By Order Date Report
Qty In Long Term Storage ProgramQty in long term storage program
Qty To Be Charged Ltsf 12 MoQty to be charged ltsf 12 mo
Qty To Be Charged Ltsf 6 MoQty to be charged ltsf 6 mo
Qty With Removals In ProgressQty with removals in progress
Product QuantityThe Product Quantity. Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, Flat File Orders By Order Date Report
Quantity AvailableQuantity available
Quantity For Local FulfillmentQuantity for local fulfillment
Quantity Reimbursed CashQuantity reimbursed cash. Report: FBA Reimbursements Report
Quantity Reimbursed InventoryQuantity reimbursed inventory. Report: FBA Reimbursements Report
Quantity Reimbursed TotalQuantity reimbursed total. Report: FBA Reimbursements Report
Quantity ShippedQuantity shipped. Report: FBA Amazon Fulfilled Shipments Report
ReasonReason. Report: FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Reimbursements Report
Reimbursement IdReimbursement id. Report: FBA Reimbursements Report
Removal FeeRemoval fee. Report: FBA Removal Order Detail Report
Reporting DateReporting date. Report: FBA Amazon Fulfilled Shipments Report
Requested QuantityRequested quantity. Report: FBA Removal Order Detail Report
Return DateReturn date. Report: FBA Returns Report
Sales ChannelThe Sales Channel. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Sales PriceSales price. Report: FBA Fee Preview Report
Sales RankSales rank
Sellable QuantitySellable quantity
Seller SkuSeller sku
Shipping CityThe Shipping City. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Shipping CountryThe Shipping Country. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Shipping Postal CodeThe Shipping Postal Code. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Ship Promotion DiscountShip promotion discount. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Shipping Service LevelThe Shipping Service Level. Report: Flat File Orders By Order Date Report
Shipping StateThe Shipping State. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Shipment DateShipment date. Report: FBA Amazon Fulfilled Shipments Report
Shipment IdShipment id
Shipment Item IdShipment item id
Shipping PriceThe Shipping Price. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
Shipping TaxShipping tax
Shortest SideShortest side. Report: FBA Storage Fees Report, FBA Fee Preview Report
SKUStock Keeping Unit, assigned by the Amazon merchant. Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, Flat File Orders By Order Date Report, FBA Fee Preview Report, FBA Reimbursements Report, FBA Removal Order Detail Report
SpendEstimated fee total. (duplicate)
StatusStatus. Report: FBA Returns Report
Storage RateStorage Rate. Report: FBA Storage Fees Report
Total QuantityTotal quantity
Tracking NumberTracking number. Report: FBA Amazon Fulfilled Shipments Report
Transaction RevenueThe Transaction Revenue (Duplicate of Item Price). Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report
TransactionsThe Number of Transactions (Duplicate of Quantity). Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, Flat File Orders By Order Date Report
Unit Of DimensionUnit of dimension. Report: FBA Fee Preview Report
Unit Of WeightUnit of weight. Report: FBA Fee Preview Report
Units Shipped Last 180 DaysUnits shipped last 180 days
Units Shipped Last 24 HrsUnits shipped last 24 hrs
Units Shipped Last 30 DaysUnits shipped last 30 days
Units Shipped Last 365 DaysUnits shipped last 365 days
Units Shipped Last 7 DaysUnits shipped last 7 days
Units Shipped Last 90 DaysUnits shipped last 90 days
Unsellable QuantityUnsellable quantity
UrlUrl. Report: Flat File Orders By Order Date Report
Warehouse Condition CodeWarehouse condition code
Weeks Of Cover T180Weeks of cover t180
Weeks Of Cover T30Weeks of cover t30
Weeks Of Cover T365Weeks of cover t365
Weeks Of Cover T7Weeks of cover t7
Weeks Of Cover T90Weeks of cover t90
Your PriceYour price. Report: FBA Fee Preview Report

 

Connecting your data

The process to set up this dashboard shouldn’t take more than 5 minutes. Before you get started please make sure that you have your Seller ID and that you have rights on your Seller Central Portal to create a Access token

To create a Seller Central Access token follow the steps below:

  1. Go to your Amazon Seller Central page.
  2. Click Settings  ⇒   User Permissions  ⇒ Visit Manage Your Apps  ⇒ Authorise new developer.
  3. Use Windsor’s Developer ID: 360676257802

 

Setting up the Data Studio connector and dashboard

  1. Configure the Google Data Studio Connector: Amazon MWS Insights
  2. Once you have added your API key click Finish
  3. Back in Data Studio click CREATE REPORT

To get other channels connected and visualised please check out our Template Gallery.