Connect Amazon MWS to Google BigQuery with Windsor.ai

amazon logo

+

bigquery

Stream all your Amazon Seller Central data from Amazon MWS to Google BigQuery

About Amazon MWS

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.

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

NameTypeDescription
Product NameTEXTThe Product Name
Product NameTEXTThe Product Name (Duplicate of Product)
DateDATEThe Order Date
TransactionsNUMERICThe Number of Transactions (Duplicate of Quantity)
Product QuantityNUMERICThe Product Quantity
Transaction RevenueNUMERICThe Transaction Revenue (Duplicate of Item Price)
Item PriceNUMERICThe Price of the Item
Amazon Order IDTEXTThe Amazon Order ID
Merchant Order IDTEXTThe Merchant Order ID
Last Updated DateDATELast Updated Date
Order StatusTEXTThe Order Status
Fulfillment ChannelTEXTThe Fulfillment Channel
Sales ChannelTEXTThe Sales Channel
Order ChannelTEXTThe Order Channel
Shipping Service LevelTEXTThe Shipping Service Level
Item StatusTEXTThe Status of the Item
Item TaxNUMERICThe Tax of the Item
Shipping PriceNUMERICThe Shipping Price
Shipping TaxNUMERICThe Shipping Tax
Gift Wrap PriceNUMERICThe Price of the Gift Wrap
Gift Wrap TaxNUMERICThe Tax of the Gift Wrap
Item Promotion DiscountNUMERICThe Promotion Discount
Shipping Promotion DiscountNUMERICThe Shipping Promotion Discount
Shipping CityTEXTThe Shipping City
Shipping StateTEXTThe Shipping State
Shipping Postal CodeTEXTThe Shipping Postal Code
Shipping CountryTEXTThe Shipping Country
Promotion IDTEXTThe Promotion ID
Is business orderBOOLEANWhether or not this is a business order
Purchaser Order NumberTEXTThe Purchaser Order Number
Price DesignationTEXTThe Price Designation
MarketplaceTEXTThe Amazon Seller Central Marketplace
Sold by Amazon Business EU SARLBOOLEANIs 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

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.