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 |
|---|---|---|
| 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 |
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.