Introduction

Datasources and destinations

Find all the data sources available at www.catchr.io/connectors
Find all the destinations available at www.catchr.io/destinations

Fields listing for Amazon Seller

Marketplace ID

Amazon marketplace identifier

Field ID	marketplaceId
Type	TEXT
Data Type	dimension

Ordered Product Sales Amount

The amount of ordered product sales, calculated by multiplying the price of products and the number of units sold for the selected time period.

Field ID	sales.orderedProductSales.amount
Type	NUMBER
Data Type	metric

Ordered Product Sales Currency

The currency of ordered product sales, calculated by multiplying the price of products and the number of units sold for the selected time period.

Field ID	sales.orderedProductSales.currencyCode
Type	TEXT
Data Type	metric

Ordered Product Sales B2B Amount

The amount of ordered product sales to Amazon Business customers, calculated by multiplying the price of products and the number of units sold for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.orderedProductSalesB2B.amount
Type	NUMBER
Data Type	metric

Ordered Product Sales B2B Currency

The currency of ordered product sales to Amazon Business customers, calculated by multiplying the price of products and the number of units sold for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.orderedProductSalesB2B.currencyCode
Type	TEXT
Data Type	metric

Average Sales Per Order Item Amount

The average ordered product sales, calculated by dividing orderedProductSales by totalOrderItems for the selected time period.

Field ID	sales.averageSalesPerOrderItem.amount
Type	NUMBER
Data Type	metric

Average Sales Per Order Item Currency

The currency ordered product sales, calculated by dividing orderedProductSales by totalOrderItems for the selected time period.

Field ID	sales.averageSalesPerOrderItem.currencyCode
Type	TEXT
Data Type	metric

Average Sales Per Order Item B2B Amount

The average ordered product sales to Amazon Business customers, calculated by dividing orderedProductSalesB2B by totalOrderItemsB2B for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.averageSalesPerOrderItemB2B.amount
Type	NUMBER
Data Type	metric

Average Sales Per Order Item B2B Currency

The currency ordered product sales to Amazon Business customers, calculated by dividing orderedProductSalesB2B by totalOrderItemsB2B for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.averageSalesPerOrderItemB2B.currencyCode
Type	TEXT
Data Type	metric

Average Selling Price Amount

The average price of the units sold in the selected time period, calculated by dividing the orderedProductSales by unitsOrdered for the selected time period.

Field ID	sales.averageSellingPrice.amount
Type	NUMBER
Data Type	metric

Average Selling Price Currency

The currency of the units sold in the selected time period, calculated by dividing the orderedProductSales by unitsOrdered for the selected time period.

Field ID	sales.averageSellingPrice.currencyCode
Type	TEXT
Data Type	metric

Average Selling Price B2B Amount

The average price of the units sold to Amazon Business customers, calculated by dividing the orderedProductSalesB2B by unitsOrderedB2B for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.averageSellingPriceB2B.amount
Type	NUMBER
Data Type	metric

Average Selling Price B2B Currency

The currency of the units sold to Amazon Business customers, calculated by dividing the orderedProductSalesB2B by unitsOrderedB2B for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.averageSellingPriceB2B.currencyCode
Type	TEXT
Data Type	metric

Claims Amount

Monetary amount of filed A-to-z guarantee claims.

Field ID	sales.claimsAmount.amount
Type	NUMBER
Data Type	metric

Claims Currency

Monetary currency of filed A-to-z guarantee claims.

Field ID	sales.claimsAmount.currencyCode
Type	TEXT
Data Type	metric

Shipped Product Sales Amount

The amount of ordered product sales shipped for the selected time period.

Field ID	sales.shippedProductSales.amount
Type	NUMBER
Data Type	metric

Shipped Product Sales Currency

The currency of ordered product sales shipped for the selected time period.

Field ID	sales.shippedProductSales.currencyCode
Type	TEXT
Data Type	metric

Units Ordered

The number of units ordered for the selected time period. For clarification on the difference between orders, order items, and units take the following order as an example: An order containing 2 copies of book A and 3 copies of book B; The number of orders is 1, the number of order items is 2 (book A and book B), and the number of units is 5 (2 + 3)

Field ID	sales.unitsOrdered
Type	NUMBER
Data Type	metric

Units Ordered B2B

The number of units ordered by Amazon Business customers for the selected time period. For clarification on the difference between orders, order items, and units take the following order as an example: An order containing 2 copies of book A and 3 copies of book B; The number of orders is 1, the number of order items is 2 (book A and book B), and the number of units is 5 (2 + 3). Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.unitsOrderedB2B
Type	NUMBER
Data Type	metric

Total Order Items

The number of items that were ordered for the selected time period. For clarification on the difference between orders, order items, and units take the following order as an example: An order containing 2 copies of book A and 3 copies of book B; The number of orders is 1, the number of order items is 2 (book A and book B), and the number of units is 5 (2 + 3).

Field ID	sales.totalOrderItems
Type	NUMBER
Data Type	metric

Total Order Items B2B

The number of items that were ordered by Amazon Business customers for the selected time period. For clarification on the difference between orders, order items, and units take the following order as an example: An order containing 2 copies of book A and 3 copies of book B; The number of orders is 1, the number of order items is 2 (book A and book B), and the number of units is 5 (2 + 3). Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.totalOrderItemsB2B
Type	NUMBER
Data Type	metric

Average Units Per Order Item

The average number of units in each order item for the selected time period.

Field ID	sales.averageUnitsPerOrderItem
Type	NUMBER
Data Type	metric

Average Units Per Order Item B2B

The average number of units in each order item ordered by Amazon Business customers for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	sales.averageUnitsPerOrderItemB2B
Type	NUMBER
Data Type	metric

Units Refunded

The number of units refunded in the selected time period.

Field ID	sales.unitsRefunded
Type	NUMBER
Data Type	metric

Refund Rate

The percentage conversion metric indicating how many orders were refunded by the seller, calculated by dividing unitsOrdered by unitsRefunded in the selected time period.

Field ID	sales.refundRate
Type	NUMBER
Data Type	metric

Claims Granted

The number of A-to-z guarantee claims granted.

Field ID	sales.claimsGranted
Type	NUMBER
Data Type	metric

Units Shipped

The number of units shipped in the selected time period.

Field ID	sales.unitsShipped
Type	NUMBER
Data Type	metric

Orders Shipped

The number of orders shipped in the selected time period.

Field ID	sales.ordersShipped
Type	NUMBER
Data Type	metric

Browser Page Views

Browser page views are the number of times any user visited your Amazon.com browser pages for the selected time period.

Field ID	traffic.browserPageViews
Type	NUMBER
Data Type	metric

Browser Page Views B2B

Browser B2B page views are the number of times an Amazon Business customer visited your Amazon.com browser pages for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.browserPageViewsB2B
Type	NUMBER
Data Type	metric

Mobile App Page Views

Mobile app page views are the number of times any user visited your Amazon.com mobile app pages for the selected time period.

Field ID	traffic.mobileAppPageViews
Type	NUMBER
Data Type	metric

Mobile App Page Views B2B

Mobile app B2B page views are the number of times an Amazon Business customer visited your Amazon.com mobile app pages for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.mobileAppPageViewsB2B
Type	NUMBER
Data Type	metric

Page Views

Page views are the number of times any user visited your Amazon.com pages using browser or mobile app for the selected time period.

Field ID	traffic.pageViews
Type	NUMBER
Data Type	metric

Page Views B2B

B2B page views are the number of times an Amazon Business customer visited your Amazon.com pages using browser or mobile app for the selected time period. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.pageViewsB2B
Type	NUMBER
Data Type	metric

Browser Sessions

Browser sessions are visits to your Amazon.com browser pages by any user. All activity within a 24-hour period is considered a browser session. For example, if any user visits your pages using browser multiple times within a 24 hour period it is counted as a single session.

Field ID	traffic.browserSessions
Type	NUMBER
Data Type	metric

Browser Sessions B2B

Browser B2B sessions are visits to your Amazon.com browser pages by an Amazon Business customer. All activity within a 24-hour period is considered a browser session. For example, if an Amazon Business customer visits your pages using browser multiple times within a 24 hour period it is counted as a single session. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.browserSessionsB2B
Type	NUMBER
Data Type	metric

Mobile App Sessions

Mobile app sessions are visits to your Amazon.com mobile app pages by any user. All activity within a 24-hour period is considered a mobile app session. For example, if any user visits your pages using mobile app multiple times within a 24 hour period it is counted as a single session.

Field ID	traffic.mobileAppSessions
Type	NUMBER
Data Type	metric

Mobile App Sessions B2B

Mobile app B2B sessions are visits to your Amazon.com mobile app pages by an Amazon Business customer. All activity within a 24-hour period is considered a mobile app session. For example, if an Amazon Business customer visits your pages using mobile app multiple times within a 24 hour period it is counted as a single session. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.mobileAppSessionsB2B
Type	NUMBER
Data Type	metric

Sessions

Sessions are visits to your Amazon.com pages using browser or mobile app by any user. All activity within a 24-hour period is considered a session. For example, if any user visits your pages multiple times using mobile app or browser within a 24 hour period it is counted as a single session.

Field ID	traffic.sessions
Type	NUMBER
Data Type	metric

Sessions B2B

B2B sessions are visits to your Amazon.com pages using browser or mobile app by an Amazon Business customer. All activity within a 24-hour period is considered a session. For example, if an Amazon Business customer visits your pages multiple times using mobile app or browser within a 24 hour period it is counted as a single session. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.sessionsB2B
Type	NUMBER
Data Type	metric

Buy Box Percentage

The percentage of page views where the buy box (the add to shopping cart link) appeared on the page for customers to add your product to their cart.

Field ID	traffic.buyBoxPercentage
Type	NUMBER
Data Type	metric

Buy Box Percentage B2B

The percentage of page views by Amazon Business customers where the buy box (the add to shopping cart link) appeared on the page for customers to add your product to their cart. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.buyBoxPercentageB2B
Type	NUMBER
Data Type	metric

Order Item Session Percentage

The percentage conversion metric indicating how many order items were generated relative to the number of people who viewed the products.

Field ID	traffic.orderItemSessionPercentage
Type	NUMBER
Data Type	metric

Order Item Session Percentage B2B

The percentage conversion metric indicating how many order items were generated by Amazon Business customers relative to the number of Amazon Business customers who viewed the products. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.orderItemSessionPercentageB2B
Type	NUMBER
Data Type	metric

Unit Session Percentage

The percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the products.

Field ID	traffic.unitSessionPercentage
Type	NUMBER
Data Type	metric

Unit Session Percentage B2B

The percentage conversion metric indicating how many units were purchased by Amazon Business customers relative to number of Amazon Business customers who viewed the products. Note: This field is only populated when the seller is a B2B seller.

Field ID	traffic.unitSessionPercentageB2B
Type	NUMBER
Data Type	metric

Average Offer Count

The average number of offers listed for sale in the selected time period. It is calculated from the total number of offers and the total number of days in the selected time period.

Field ID	traffic.averageOfferCount
Type	NUMBER
Data Type	metric

Average Parent Items

The average number of parent items listed for sale in the selected time period.

Field ID	traffic.averageParentItems
Type	NUMBER
Data Type	metric

Feedback Received

The number of customer feedback received in the selected time period.

Field ID	traffic.feedbackReceived
Type	NUMBER
Data Type	metric

Negative Feedback Received

The number of negative customer feedback received in the selected time period.

Field ID	traffic.negativeFeedbackReceived
Type	NUMBER
Data Type	metric

Received Negative Feedback Rate

The negative feedback rate is the number of orders that have received a negative feedback divided by the number of orders in the selected time period.

Field ID	traffic.receivedNegativeFeedbackRate
Type	NUMBER
Data Type	metric

Amazon Order ID

An Amazon-defined order identifier, in 3-7-7 format.

Field ID	order.AmazonOrderId
Type	TEXT
Data Type	dimension

Seller Order ID

A seller-defined order identifier.

Field ID	order.SellerOrderId
Type	TEXT
Data Type	dimension

Order Purchase Date

The date when the order was created.

Field ID	order.PurchaseDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Order Last Update Date

The date when the order was last updated.

Field ID	order.LastUpdateDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Order Status

The current order status.

Field ID	order.OrderStatus
Type	TEXT
Data Type	dimension

Fulfillment Channel

Whether the order was fulfilled by Amazon (AFN) or by the seller (MFN).

Field ID	order.FulfillmentChannel
Type	TEXT
Data Type	dimension

Sales Channel

The sales channel of the first item in the order.

Field ID	order.SalesChannel
Type	TEXT
Data Type	dimension

Order Channel

The order channel of the first item in the order.

Field ID	order.OrderChannel
Type	TEXT
Data Type	dimension

Ship Service Level

The shipment service level of the order.

Field ID	order.ShipServiceLevel
Type	TEXT
Data Type	dimension

Product Name

The name of the product

Field ID	order.ProductName
Type	TEXT
Data Type	dimension

Product SKU

The SKU of the product

Field ID	order.sku
Type	TEXT
Data Type	dimension

Product ASIN

The ASIN of the product

Field ID	order.asin
Type	TEXT
Data Type	dimension

Item Status

The Product Item Status of the product

Field ID	order.OrderItemStatus
Type	TEXT
Data Type	dimension

Item Quantity

Field ID	order.quantity
Type	NUMBER
Data Type	dimension

Item Currency

Field ID	order.currency
Type	TEXT
Data Type	dimension

Product Item Price

Field ID	order.OrderItemPrice
Type	NUMBER
Data Type	dimension

Product Item Tax

Field ID	order.OrderItemTax
Type	NUMBER
Data Type	dimension

Shipping Price

Field ID	order.OrderShippingPrice
Type	NUMBER
Data Type	dimension

Shipping Tax

Field ID	order.OrderShippingTax
Type	NUMBER
Data Type	dimension

Gift Price

Field ID	order.OrderGiftPrice
Type	NUMBER
Data Type	dimension

Gift Tax

Field ID	order.OrderGiftTax
Type	NUMBER
Data Type	dimension

Promotion Discount

Field ID	order.OrderItemPromotionDiscount
Type	TEXT
Data Type	dimension

Ship Promotion Discount

Field ID	order.OrderShipPromotionDiscount
Type	TEXT
Data Type	dimension

Ship City

Field ID	order.OrderShipCity
Type	TEXT
Data Type	dimension

Ship Postal Code

Field ID	order.OrderShipPostalCode
Type	TEXT
Data Type	dimension

Ship State

Field ID	order.OrderShipState
Type	TEXT
Data Type	dimension

Ship Country

Field ID	order.OrderShipCountry
Type	TEXT
Data Type	dimension

Promotion IDs

Field ID	order.OrderPromotionIds
Type	TEXT
Data Type	dimension

CPF

Field ID	order.cpf
Type	TEXT
Data Type	dimension

IS Business Order

Field ID	order.OrderIsBusinessOrder
Type	TEXT
Data Type	dimension

Purchase Number Order

Field ID	order.OrderPurchaseOrderNumber
Type	TEXT
Data Type	dimension

Price Designation

Field ID	order.OrderPriceDesignation
Type	TEXT
Data Type	dimension

Signature Confirmation Recommended

Field ID	order.OrderSignatureConfirmationRecommended
Type	TEXT
Data Type	dimension

Year

Year such as 2017.

Field ID	_NORMALIZED_DATE_FIELD_YEAR
Type	YEAR
Data Type	dimension

Year Quarter

Year and quarter.

Field ID	_NORMALIZED_DATE_FIELD_YEAR_QUARTER
Type	YEAR_QUARTER
Data Type	dimension

Year month

Year and month.

Field ID	_NORMALIZED_DATE_FIELD_YEAR_MONTH
Type	YEAR_MONTH
Data Type	dimension

Date

Year, month and day

Field ID	_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
Type	YEAR_MONTH_DAY
Data Type	dimension

Year week

Year and week.

Field ID	_NORMALIZED_DATE_FIELD_YEAR_WEEK
Type	YEAR_WEEK
Data Type	dimension

Quarter of the year

Field ID	_NORMALIZED_DATE_FIELD_QUARTER
Type	QUARTER
Data Type	dimension

Month of the year

Field ID	_NORMALIZED_DATE_FIELD_MONTH
Type	MONTH
Data Type	dimension

Week of the year

Field ID	week
Type	WEEK
Data Type	dimension

Month and day

Field ID	_NORMALIZED_DATE_FIELD_MONTH_DAY
Type	MONTH_DAY
Data Type	dimension

Day of the week

Field ID	_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
Type	DAY_OF_WEEK
Data Type	dimension

Day of the year

Field ID	_NORMALIZED_DATE_FIELD_DAY
Type	DAY
Data Type	dimension

Extracted Date

The date where the extraction take times.

Field ID	_catchr_date_extract
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Platform Name

Return the platform name

Field ID	_catchr_platform_name
Type	TEXT
Data Type	dimension

Getting Started with Catchr

Looker Studio

Connect all your marketing account to Looker Studio.

Google Sheet

Connect all your marketing account to Google Sheet