The connector pulls Metrics and Dimensions for Amazon MWS. The Insights are retrieved at marketplace and product level.
Amazon MWS Google Data Studio Connector by Windsor.ai
+
About the Connector
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://www.windsor.ai/privacy-statement/
Available Metrics and Dimensions
| 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 |
| Amazon Order Item Id | TEXT | Amazon order item id |
| Amount Per Unit | NUMERIC | Amount per unit |
| Amount Total | NUMERIC | Amount total |
| Approval Date | TEXT | Approval date |
| ASIN | TEXT | Amazon Standard Identification Number, assigned by Amazon |
| Asin Limit | TEXT | Asin limit |
| Brand | TEXT | Brand |
| Buyer Email | TEXT | Buyer email |
| Product Group (duplicate) | TEXT | Product group (duplicate) |
| Cancelled Quantity | TEXT | Cancelled quantity |
| Carrier | TEXT | Carrier |
| Condition | TEXT | Condition |
| Condition Type | TEXT | Condition type |
| Currency | TEXT | Currency |
| Currency Unit | TEXT | Currency unit |
| Date | DATE | The Order Date |
| Detailed Disposition | TEXT | Detailed disposition |
| Disposed Quantity | NUMERIC | Disposed quantity |
| Disposition | TEXT | Disposition |
| Estimated Arrival Date | TEXT | Estimated arrival date |
| Estimated Cost Savings of Removal | NUMERIC | Estimated Cost Savings of Removal |
| Estimated Fee Total | NUMERIC | Estimated fee total |
| Estimated Monthly Storage Fee | NUMERIC | Estimated Monthly Storage Fee |
| Estimated Order Handling Fee Per Order | NUMERIC | Estimated order handling fee per order |
| Estimated Referral Fee Per Unit | NUMERIC | Estimated referral fee per unit |
| Estimated Variable Closing Fee | NUMERIC | Estimated variable closing fee |
| Expected Domestic Fulfilment Fee Per Unit | NUMERIC | Expected domestic fulfilment fee per unit |
| Expected Efn Fulfilment Fee Per Unit De | NUMERIC | Expected efn fulfilment fee per unit de |
| Expected Efn Fulfilment Fee Per Unit Es | NUMERIC | Expected efn fulfilment fee per unit es |
| Expected Efn Fulfilment Fee Per Unit Fr | NUMERIC | Expected efn fulfilment fee per unit fr |
| Expected Efn Fulfilment Fee Per Unit It | NUMERIC | Expected efn fulfilment fee per unit it |
| Expected Efn Fulfilment Fee Per Unit Se | NUMERIC | Expected efn fulfilment fee per unit se |
| Expected Efn Fulfilment Fee Per Unit Uk | NUMERIC | Expected efn fulfilment fee per unit uk |
| ASIN | TEXT | The Fulfillment Network SKU |
| Fulfilled By | TEXT | Fulfilled by |
| Fulfillment Center Id | TEXT | Fulfillment center id |
| Fulfillment Channel | TEXT | The Fulfillment Channel |
| Fulfillment Channel Sku | TEXT | Fulfillment channel sku |
| Gift Wrap Price | NUMERIC | The Price of the Gift Wrap |
| Gift Wrap Tax | NUMERIC | The Tax of the Gift Wrap |
| Has Local Inventory | TEXT | Has local inventory |
| In Bound Quantity | TEXT | In bound quantity |
| In Process Quantity | NUMERIC | In process quantity |
| 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 |
| 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 Amazon Business EU SARL (ABEU) |
| Item Package Weight | TEXT | Item package weight |
| Item Price | NUMERIC | The Price of the Item |
| Item Promotion Discount | TEXT | Item promotion discount |
| Item Status | TEXT | The Status of the Item |
| Item Tax | NUMERIC | The Tax of the Item |
| Last Updated Date | DATE | Last Updated Date |
| Length And Girth | TEXT | Length and girth |
| License Plate Number | TEXT | License plate number |
| Longest Side | TEXT | Longest side |
| 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 |
| Median Side | TEXT | Median side |
| Merchant Order ID | TEXT | The Merchant Order ID |
| 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 |
| Order Id | TEXT | Order id |
| Order Status | TEXT | The Order Status |
| Payments Date | TEXT | Payments date |
| Per Unit Volume | TEXT | Per unit volume |
| Price Designation | TEXT | The Price Designation |
| Product Name | TEXT | The Product Name |
| Product Group | TEXT | Product group |
| Product Name | TEXT | The Product Name (Duplicate of Product) |
| Product Size Weight Band | TEXT | Product size weight band |
| Projected Ltsf 12 Mo | TEXT | Projected ltsf 12 mo |
| Projected Ltsf 6 Mo | TEXT | Projected ltsf 6 mo |
| Promotion ID | TEXT | The Promotion ID |
| Purchase Date | DATE | Purchase date |
| Purchaser Order Number | TEXT | The Purchaser Order Number |
| 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 |
| Quantity Available | TEXT | Quantity available |
| Quantity For Local Fulfillment | TEXT | Quantity for local fulfillment |
| Quantity Reimbursed Cash | NUMERIC | Quantity reimbursed cash |
| Quantity Reimbursed Inventory | NUMERIC | Quantity reimbursed inventory |
| Quantity Reimbursed Total | NUMERIC | Quantity reimbursed total |
| Quantity Shipped | TEXT | Quantity shipped |
| Reason | TEXT | Reason |
| Reimbursement Id | TEXT | Reimbursement id |
| Removal Fee | NUMERIC | Removal fee |
| Reporting Date | TEXT | Reporting date |
| Requested Quantity | NUMERIC | Requested quantity |
| Return Date | TEXT | Return date |
| Sales Channel | TEXT | The Sales Channel |
| Sales Price | TEXT | Sales price |
| Sales Rank | TEXT | Sales rank |
| Sellable Quantity | TEXT | Sellable quantity |
| Seller Sku | TEXT | Seller sku |
| Shipping City | TEXT | The Shipping City |
| Shipping Country | TEXT | The Shipping Country |
| Shipping Postal Code | TEXT | The Shipping Postal Code |
| Ship Promotion Discount | TEXT | Ship promotion discount |
| Shipping Service Level | TEXT | The Shipping Service Level |
| Shipping State | TEXT | The Shipping State |
| Shipment Date | TEXT | Shipment date |
| Shipment Id | TEXT | Shipment id |
| Shipment Item Id | TEXT | Shipment item id |
| Shipping Price | NUMERIC | The Shipping Price |
| Shipping Tax | TEXT | Shipping tax |
| Shortest Side | TEXT | Shortest side |
| SKU | TEXT | Stock Keeping Unit, assigned by the Amazon merchant |
| Estimated Fee Total (duplicate) | NUMERIC | Estimated fee total (duplicate) |
| Status | TEXT | Status |
| Storage Rate | NUMERIC | Storage Rate |
| Total Quantity | TEXT | Total quantity |
| Tracking Number | TEXT | Tracking number |
| Transaction Revenue | NUMERIC | The Transaction Revenue (Duplicate of Item Price) |
| Transactions | NUMERIC | The Number of Transactions (Duplicate of Quantity) |
| Unit Of Dimension | TEXT | Unit of dimension |
| Unit Of Weight | TEXT | Unit of weight |
| 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 |
| 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 |