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
| Product Name | TEXT | The Product Name |
| Product Name | TEXT | The Product Name (Duplicate of Product) |
| Date | DATE | The Order Date |
| Transactions | NUMERIC | The Number of Transactions (Duplicate of Quantity) |
| Product Quantity | NUMERIC | The Product Quantity |
| Transaction Revenue | NUMERIC | The Transaction Revenue (Duplicate of Item Price) |
| Item Price | NUMERIC | The Price of the Item |
| Amazon Order ID | TEXT | The Amazon Order ID |
| Merchant Order ID | TEXT | The Merchant Order ID |
| Last Updated Date | DATE | Last Updated Date |
| Order Status | TEXT | The Order Status |
| Fulfillment Channel | TEXT | The Fulfillment Channel |
| Sales Channel | TEXT | The Sales Channel |
| Order Channel | TEXT | The Order Channel |
| Shipping Service Level | TEXT | The Shipping Service Level |
| Item Status | TEXT | The Status of the Item |
| Item Tax | NUMERIC | The Tax of the Item |
| Shipping Price | NUMERIC | The Shipping Price |
| Shipping Tax | NUMERIC | The Shipping Tax |
| Gift Wrap Price | NUMERIC | The Price of the Gift Wrap |
| Gift Wrap Tax | NUMERIC | The Tax of the Gift Wrap |
| Item Promotion Discount | NUMERIC | The Promotion Discount |
| Shipping Promotion Discount | NUMERIC | The Shipping Promotion Discount |
| Shipping City | TEXT | The Shipping City |
| Shipping State | TEXT | The Shipping State |
| Shipping Postal Code | TEXT | The Shipping Postal Code |
| Shipping Country | TEXT | The Shipping Country |
| Promotion ID | TEXT | The Promotion ID |
| Is business order | BOOLEAN | Whether or not this is a business order |
| Purchaser Order Number | TEXT | The Purchaser Order Number |
| Price Designation | TEXT | The Price Designation |
| Marketplace | TEXT | The Amazon Seller Central Marketplace |
| 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) |