Amazon MWS offers a CRM and inbound marketing software which helps companies to manage sales, marketing and customer service. It’s key features are blogging and search engine optimisation, advertising data integration and customer relationship management features such as customer support and account management.
Connect Amazon MWS to Google BigQuery with Windsor.ai
+
Stream all your Amazon Seller Central data from Amazon MWS to Google BigQuery
About Google BigQuery
Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.
Amazon MWS metrics and dimensions available for streaming into Google BigQuery
| Name | Type | Description |
|---|---|---|
| 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) |
Windsor.ai: Easily connect Amazon MWS to Google BigQuery
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.