Amazon MWS Fields

Suggest Edits

Dimensions (33)

Account

NinjaCat System ID: amazon_mws:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

ASIN

API Name: asin

NinjaCat System ID: amazon_mws:DIM_asin

Data Type: text

Currency

NinjaCat System ID: amazon_mws:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Currency

API Name: currency

NinjaCat System ID: amazon_mws:DIM_currency

Data Type: text

Data Source

NinjaCat System ID: amazon_mws:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: amazon_mws:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: amazon_mws:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: amazon_mws:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: amazon_mws:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Fulfillment Channel

API Name: fulfillment-channel

NinjaCat System ID: amazon_mws:DIM_fulfillment_channel

Data Type: text

Is Business Order

API Name: is-business-order

NinjaCat System ID: amazon_mws:DIM_is_business_order

Data Type: text

Item Status

API Name: item-status

NinjaCat System ID: amazon_mws:DIM_item_status

Data Type: text

Merchant Order ID

API Name: merchant-order-id

NinjaCat System ID: amazon_mws:DIM_merchant_order_id

Data Type: text

Month Of Year

NinjaCat System ID: amazon_mws:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: amazon_mws:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Order Channel

API Name: order-channel

NinjaCat System ID: amazon_mws:DIM_order_channel

Data Type: text

Order ID

API Name: amazon-order-id

NinjaCat System ID: amazon_mws:DIM_amazon_order_id

Data Type: text

Order Status

API Name: order-status

NinjaCat System ID: amazon_mws:DIM_order_status

Data Type: text

Product Name

API Name: product-name

NinjaCat System ID: amazon_mws:DIM_product_name

Data Type: text

Purchase Date

API Name: purchase-date

NinjaCat System ID: amazon_mws:DIM_purchase_date

Data Type: date

Quarter

NinjaCat System ID: amazon_mws:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: amazon_mws:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Sales Channel

API Name: sales-channel

NinjaCat System ID: amazon_mws:DIM_sales_channel

Data Type: text

Ship City

API Name: ship-city

NinjaCat System ID: amazon_mws:DIM_ship_city

Data Type: text

Aggregates To: DIM_CITY

Ship Country

API Name: ship-country

NinjaCat System ID: amazon_mws:DIM_ship_country

Data Type: text

Ship Postal Code

API Name: ship-postal-code

NinjaCat System ID: amazon_mws:DIM_ship_postal_code

Data Type: text

Aggregates To: DIM_POSTAL_CODE

Ship Service Level

API Name: ship-service-level

NinjaCat System ID: amazon_mws:DIM_ship_service_level

Data Type: text

Ship State

API Name: ship-state

NinjaCat System ID: amazon_mws:DIM_ship_state

Data Type: text

Aggregates To: DIM_STATE_PROVINCE

SKU

API Name: sku

NinjaCat System ID: amazon_mws:DIM_sku

Data Type: text

System Account ID

NinjaCat System ID: amazon_mws:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

URL

API Name: url

NinjaCat System ID: amazon_mws:DIM_url

Data Type: text

Week Of Year

NinjaCat System ID: amazon_mws:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: amazon_mws:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (10)

Count (Unique Dimensions)

NinjaCat System ID: amazon_mws:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

Gift Wrap Price

API Name: gift-wrap-price

NinjaCat System ID: amazon_mws:MET_gift_wrap_price

Data Type: decimal

Display As: currency

Gift Wrap Tax

API Name: gift-wrap-tax

NinjaCat System ID: amazon_mws:MET_gift_wrap_tax

Data Type: decimal

Display As: currency

Item Promotion Discount

API Name: item-promotion-discount

NinjaCat System ID: amazon_mws:MET_item_promotion_discount

Data Type: decimal

Display As: currency

Item Tax

API Name: item-tax

NinjaCat System ID: amazon_mws:MET_item_tax

Data Type: decimal

Display As: currency

Price

API Name: item-price

NinjaCat System ID: amazon_mws:MET_item_price

Data Type: decimal

Display As: currency

Quantity

API Name: quantity

NinjaCat System ID: amazon_mws:MET_quantity

Data Type: integer

Shipping Price

API Name: shipping-price

NinjaCat System ID: amazon_mws:MET_shipping_price

Data Type: decimal

Display As: currency

Shipping Tax

API Name: shipping-tax

NinjaCat System ID: amazon_mws:MET_shipping_tax

Data Type: decimal

Display As: currency

Ship Promotion Discount

API Name: ship-promotion-discount

NinjaCat System ID: amazon_mws:MET_ship_promotion_discount

Data Type: decimal

Display As: currency

Updated 6 months ago