Amazon MWS Google Data Studio Connector by Windsor.ai
+
About the Connector
The Amazon MWS Data Studio Connector pulls Metrics and Dimensions for Amazon MWS / Amazon Seller Central. The Insights are retrieved at marketplace and product level.
Prerequisites
To set up the connector, access to an Amazon Seller Central account login is. During the installation the user will be asked to enter a seller ID and grant access to Amazon MWS via its API.
Our privacy policy and terms of use: https://windsor.ai/privacy-statement/
Available Metrics and Dimensions
| name | type | description |
|---|---|---|
| Afn Fulfillable Quantity | TEXT | Afn fulfillable quantity |
| Afn Future Supply Buyable | TEXT | Afn future supply buyable |
| Afn Inbound Receiving Quantity | TEXT | Afn inbound receiving quantity |
| Afn Inbound Shipped Quantity | TEXT | Afn inbound shipped quantity |
| Afn Inbound Working Quantity | TEXT | Afn inbound working quantity |
| Afn Listing Exists | TEXT | Afn listing exists |
| Afn Researching Quantity | TEXT | Afn researching quantity |
| Afn Reserved Future Supply | TEXT | Afn reserved future supply |
| Afn Reserved Quantity | TEXT | Afn reserved quantity |
| Afn Total Quantity | TEXT | Afn total quantity |
| Afn Unsellable Quantity | TEXT | Afn unsellable quantity |
| Afn Warehouse Quantity | TEXT | Afn warehouse quantity |
| Amazon Order ID | TEXT | The Amazon Order ID. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report, FBA Reimbursements Report |
| Amazon Order Item Id | TEXT | Amazon order item id |
| Amount Per Unit | NUMERIC | Amount per unit. Report: FBA Reimbursements Report |
| Amount Total | NUMERIC | Amount total. Report: FBA Reimbursements Report |
| Approval Date | TEXT | Approval date. Report: FBA Reimbursements Report |
| ASIN | TEXT | Amazon 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 Limit | TEXT | Asin limit |
| Brand | TEXT | Brand. Report: FBA Fee Preview Report |
| Buyer Email | TEXT | Buyer email. Report: FBA Amazon Fulfilled Shipments Report |
| Campaign | TEXT | Product group |
| Cancelled Quantity | TEXT | Cancelled quantity. Report: FBA Removal Order Detail Report |
| Carrier | TEXT | Carrier. Report: FBA Amazon Fulfilled Shipments Report |
| Condition | TEXT | Condition. Report: FBA Reimbursements Report |
| Condition Type | TEXT | Condition type |
| Currency | TEXT | Currency. 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 Unit | TEXT | Currency unit. Report: FBA Reimbursements Report |
| Date | DATE | The Order Date |
| Detailed Disposition | TEXT | Detailed disposition. Report: FBA Returns Report |
| Disposed Quantity | NUMERIC | Disposed quantity. Report: FBA Removal Order Detail Report |
| Disposition | TEXT | Disposition. Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Removal Order Detail Report |
| Estimated Arrival Date | TEXT | Estimated arrival date. Report: FBA Amazon Fulfilled Shipments Report |
| Estimated Cost Savings of Removal | NUMERIC | Estimated Cost Savings of Removal |
| Estimated Fee Total | NUMERIC | Estimated fee total. Report: FBA Fee Preview Report |
| Estimated Monthly Storage Fee | NUMERIC | Estimated Monthly Storage Fee. Report: FBA Storage Fees Report |
| Estimated Order Handling Fee Per Order | NUMERIC | Estimated order handling fee per order. Report: FBA Fee Preview Report |
| Estimated Referral Fee Per Unit | NUMERIC | Estimated referral fee per unit. Report: FBA Fee Preview Report |
| Estimated Variable Closing Fee | NUMERIC | Estimated variable closing fee. Report: FBA Fee Preview Report |
| Expected Domestic Fulfilment Fee Per Unit | NUMERIC | Expected domestic fulfilment fee per unit. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit De | NUMERIC | Expected efn fulfilment fee per unit de. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit Es | NUMERIC | Expected efn fulfilment fee per unit es. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit Fr | NUMERIC | Expected efn fulfilment fee per unit fr. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit It | NUMERIC | Expected efn fulfilment fee per unit it. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit Se | NUMERIC | Expected efn fulfilment fee per unit se. Report: FBA Fee Preview Report |
| Expected Efn Fulfilment Fee Per Unit Uk | NUMERIC | Expected efn fulfilment fee per unit uk. Report: FBA Fee Preview Report |
| FNSKU | TEXT | The 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 By | TEXT | Fulfilled by. Report: FBA Fee Preview Report |
| Fulfillment Center Id | TEXT | Fulfillment center id. Report: FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Amazon Fulfilled Shipments Report |
| Fulfillment Channel | TEXT | The Fulfillment Channel. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Fulfillment Channel Sku | TEXT | Fulfillment channel sku |
| Gift Wrap Price | NUMERIC | The Price of the Gift Wrap. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Gift Wrap Tax | NUMERIC | The Tax of the Gift Wrap. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Has Local Inventory | TEXT | Has local inventory. Report: FBA Fee Preview Report |
| In Bound Quantity | TEXT | In bound quantity |
| In Process Quantity | NUMERIC | In process quantity. Report: FBA Removal Order Detail Report |
| Inbound Recommend Quantity | TEXT | Inbound recommend quantity |
| Inv Age 0 To 90 Days | TEXT | Inv age 0 to 90 days |
| Inv Age 181 To 270 Days | TEXT | Inv age 181 to 270 days |
| Inv Age 271 To 365 Days | TEXT | Inv age 271 to 365 days |
| Inv Age 365 Plus Days | TEXT | Inv age 365 plus days |
| Inv Age 91 To 180 Days | TEXT | Inv age 91 to 180 days |
| Is business order | BOOLEAN | Whether or not this is a business order. Report: Flat File Orders By Order Date Report |
| Is Hazmat | TEXT | Is hazmat |
| Sold by Amazon Business EU SARL | BOOLEAN | Is 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 Weight | TEXT | Item package weight. Report: FBA Fee Preview Report |
| Item Price | NUMERIC | The Price of the Item. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Item Promotion Discount | TEXT | Item promotion discount. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Item Status | TEXT | The Status of the Item. Report: Flat File Orders By Order Date Report |
| Item Tax | NUMERIC | The Tax of the Item. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Last Updated Date | DATE | Last Updated Date. Report: Flat File Orders By Order Date Report, FBA Removal Order Detail Report |
| Length And Girth | TEXT | Length and girth. Report: FBA Fee Preview Report |
| License Plate Number | TEXT | License plate number. Report: FBA Returns Report |
| Longest Side | TEXT | Longest side. Report: FBA Storage Fees Report, FBA Fee Preview Report |
| Lowest Afn New Price | TEXT | Lowest afn new price |
| Lowest Afn Used Price | TEXT | Lowest afn used price |
| Lowest Mfn New Price | TEXT | Lowest mfn new price |
| Lowest Mfn Used Price | TEXT | Lowest mfn used price |
| Marketplace | TEXT | The Amazon Seller Central Marketplace |
| Marketplace Country | TEXT | Marketplace country. Report: FBA Returns Report |
| Median Side | TEXT | Median side. Report: FBA Storage Fees Report, FBA Fee Preview Report |
| Merchant Order ID | TEXT | The Merchant Order ID. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Mfn Fulfillable Quantity | TEXT | Mfn fulfillable quantity |
| Mfn Listing Exists | TEXT | Mfn listing exists |
| Num Afn New Sellers | TEXT | Num afn new sellers |
| Num Afn Used Sellers | TEXT | Num afn used sellers |
| Order Channel | TEXT | The Order Channel. Report: Flat File Orders By Order Date Report |
| Order Id | TEXT | Order id. Report: FBA Returns Report, FBA Removal Order Detail Report |
| Order Status | TEXT | The Order Status. Report: Flat File Orders By Order Date Report, FBA Removal Order Detail Report |
| Payments Date | TEXT | Payments date. Report: FBA Amazon Fulfilled Shipments Report |
| Per Unit Volume | TEXT | Per unit volume |
| Price Designation | TEXT | The Price Designation. Report: Flat File Orders By Order Date Report |
| Product Name | TEXT | The 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 Group | TEXT | Product group. Report: FBA Fee Preview Report |
| Product Name (Duplicate) | TEXT | 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 Band | TEXT | Product size weight band. Report: FBA Fee Preview Report |
| Projected Ltsf 12 Mo | TEXT | Projected ltsf 12 mo |
| Projected Ltsf 6 Mo | TEXT | Projected ltsf 6 mo |
| Promotion ID | TEXT | The Promotion ID. Report: Flat File Orders By Order Date Report |
| Purchase Date | DATE | Purchase date. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Purchaser Order Number | TEXT | The Purchaser Order Number. Report: Flat File Orders By Order Date Report |
| Qty In Long Term Storage Program | TEXT | Qty in long term storage program |
| Qty To Be Charged Ltsf 12 Mo | TEXT | Qty to be charged ltsf 12 mo |
| Qty To Be Charged Ltsf 6 Mo | TEXT | Qty to be charged ltsf 6 mo |
| Qty With Removals In Progress | TEXT | Qty with removals in progress |
| Product Quantity | NUMERIC | The Product Quantity. Report: FBA Inventory Event Detail Report, FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, Flat File Orders By Order Date Report |
| Quantity Available | TEXT | Quantity available |
| Quantity For Local Fulfillment | TEXT | Quantity for local fulfillment |
| Quantity Reimbursed Cash | NUMERIC | Quantity reimbursed cash. Report: FBA Reimbursements Report |
| Quantity Reimbursed Inventory | NUMERIC | Quantity reimbursed inventory. Report: FBA Reimbursements Report |
| Quantity Reimbursed Total | NUMERIC | Quantity reimbursed total. Report: FBA Reimbursements Report |
| Quantity Shipped | TEXT | Quantity shipped. Report: FBA Amazon Fulfilled Shipments Report |
| Reason | TEXT | Reason. Report: FBA Inventory Adjustments Report, FBA Inventory Adjustments Report, FBA Returns Report, FBA Reimbursements Report |
| Reimbursement Id | TEXT | Reimbursement id. Report: FBA Reimbursements Report |
| Removal Fee | NUMERIC | Removal fee. Report: FBA Removal Order Detail Report |
| Reporting Date | TEXT | Reporting date. Report: FBA Amazon Fulfilled Shipments Report |
| Requested Quantity | NUMERIC | Requested quantity. Report: FBA Removal Order Detail Report |
| Return Date | TEXT | Return date. Report: FBA Returns Report |
| Sales Channel | TEXT | The Sales Channel. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Sales Price | TEXT | Sales price. Report: FBA Fee Preview Report |
| Sales Rank | TEXT | Sales rank |
| Sellable Quantity | TEXT | Sellable quantity |
| Seller Sku | TEXT | Seller sku |
| Shipping City | TEXT | The Shipping City. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Shipping Country | TEXT | The Shipping Country. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Shipping Postal Code | TEXT | The Shipping Postal Code. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Ship Promotion Discount | TEXT | Ship promotion discount. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Shipping Service Level | TEXT | The Shipping Service Level. Report: Flat File Orders By Order Date Report |
| Shipping State | TEXT | The Shipping State. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Shipment Date | TEXT | Shipment date. Report: FBA Amazon Fulfilled Shipments Report |
| Shipment Id | TEXT | Shipment id |
| Shipment Item Id | TEXT | Shipment item id |
| Shipping Price | NUMERIC | The Shipping Price. Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Shipping Tax | TEXT | Shipping tax |
| Shortest Side | TEXT | Shortest side. Report: FBA Storage Fees Report, FBA Fee Preview Report |
| SKU | TEXT | Stock 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 |
| Spend | NUMERIC | Estimated fee total. (duplicate) |
| Status | TEXT | Status. Report: FBA Returns Report |
| Storage Rate | NUMERIC | Storage Rate. Report: FBA Storage Fees Report |
| Total Quantity | TEXT | Total quantity |
| Tracking Number | TEXT | Tracking number. Report: FBA Amazon Fulfilled Shipments Report |
| Transaction Revenue | NUMERIC | The Transaction Revenue (Duplicate of Item Price). Report: Flat File Orders By Order Date Report, FBA Amazon Fulfilled Shipments Report |
| Transactions | NUMERIC | The 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 Dimension | TEXT | Unit of dimension. Report: FBA Fee Preview Report |
| Unit Of Weight | TEXT | Unit of weight. Report: FBA Fee Preview Report |
| Units Shipped Last 180 Days | TEXT | Units shipped last 180 days |
| Units Shipped Last 24 Hrs | TEXT | Units shipped last 24 hrs |
| Units Shipped Last 30 Days | TEXT | Units shipped last 30 days |
| Units Shipped Last 365 Days | TEXT | Units shipped last 365 days |
| Units Shipped Last 7 Days | TEXT | Units shipped last 7 days |
| Units Shipped Last 90 Days | TEXT | Units shipped last 90 days |
| Unsellable Quantity | TEXT | Unsellable quantity |
| Url | TEXT | Url. Report: Flat File Orders By Order Date Report |
| Warehouse Condition Code | TEXT | Warehouse condition code |
| Weeks Of Cover T180 | TEXT | Weeks of cover t180 |
| Weeks Of Cover T30 | TEXT | Weeks of cover t30 |
| Weeks Of Cover T365 | TEXT | Weeks of cover t365 |
| Weeks Of Cover T7 | TEXT | Weeks of cover t7 |
| Weeks Of Cover T90 | TEXT | Weeks of cover t90 |
| Your Price | TEXT | Your price. Report: FBA Fee Preview Report |