Introduction

Datasources and destinations

Find all the data sources available at www.catchr.io/integrations
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

Purchase Date

The date when the order was created.

Field ID	order.PurchaseDate
Type	TEXT
Data Type	dimension

Last Update Date

The date when the order was last updated.

Field ID	order.LastUpdateDate
Type	TEXT
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

Order Total Amount

The total amount for this order.

Field ID	order.OrderTotal.Amount
Type	NUMBER
Data Type	dimension

Order Total Currency

The currency for this order.

Field ID	order.OrderTotal.CurrencyCode
Type	TEXT
Data Type	dimension

Number Of Items Shipped

The number of items shipped.

Field ID	order.NumberOfItemsShipped
Type	NUMBER
Data Type	dimension

Number Of Items Unshipped

The number of items unshipped.

Field ID	order.NumberOfItemsUnshipped
Type	NUMBER
Data Type	dimension

Payment Method

The payment method for the order. This property is limited to Cash On Delivery (COD) and Convenience Store (CVS) payment methods. Unless you need the specific COD payment information provided by the PaymentExecutionDetailItem object, we recommend using the PaymentMethodDetails property to get payment method information.

Field ID	order.PaymentMethod
Type	TEXT
Data Type	dimension

Shipment Service Level Category

The shipment service level category of the order. Possible values: Expedited, FreeEconomy, NextDay, Priority, SameDay, SecondDay, Scheduled, Standard.

Field ID	order.ShipmentServiceLevelCategory
Type	TEXT
Data Type	dimension

Cba Displayable Shipping Label

Custom ship label for Checkout by Amazon (CBA).

Field ID	order.CbaDisplayableShippingLabel
Type	TEXT
Data Type	dimension

Order Type

The type of the order.

Field ID	order.OrderType
Type	TEXT
Data Type	dimension

Earliest Ship Date

The start of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders.

Field ID	order.EarliestShipDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Latest Ship Date

The end of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders.

Field ID	order.LatestShipDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Earliest Delivery Date

The start of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders.

Field ID	order.EarliestDeliveryDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Latest Delivery Date

The end of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders that do not have a PendingAvailability, Pending, or Canceled status.

Field ID	order.LatestDeliveryDate
Type	YEAR_MONTH_DAY_SECOND
Data Type	dimension

Is Business Order

When true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer.

Field ID	order.IsBusinessOrder
Type	BOOLEAN
Data Type	dimension

Is Prime

When true, the order is a seller-fulfilled Amazon Prime order.

Field ID	order.IsPrime
Type	BOOLEAN
Data Type	dimension

Is Premium Order

When true, the order has a Premium Shipping Service Level Agreement. For more information about Premium Shipping orders, see "Premium Shipping Options" in the Seller Central Help for your marketplace.

Field ID	order.IsPremiumOrder
Type	BOOLEAN
Data Type	dimension

Is Global Express Enabled

When true, the order is a GlobalExpress order.

Field ID	order.IsGlobalExpressEnabled
Type	BOOLEAN
Data Type	dimension

Replaced Order ID

The order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true.

Field ID	order.ReplacedOrderId
Type	BOOLEAN
Data Type	dimension

Is Replacement Order

When true, this is a replacement order.

Field ID	order.IsReplacementOrder
Type	TEXT
Data Type	dimension

Promise Response Due Date

Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders.

Field ID	order.PromiseResponseDueDate
Type	TEXT
Data Type	dimension

Is Estimated Ship Date Set

When true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders.

Field ID	order.IsEstimatedShipDateSet
Type	BOOLEAN
Data Type	dimension

Is Sold By AB

When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU). By buying and instantly re-selling your items, ABEU becomes the seller of record, making your inventory available for sale to customers who would not otherwise purchase from a third-party seller.

Field ID	order.IsSoldByAB
Type	BOOLEAN
Data Type	dimension

Is IBA

Field ID	order.IsIBA
Type	BOOLEAN
Data Type	dimension

Buyer Invoice Preference

The buyer's invoicing preference. Available only in the TR marketplace.

Field ID	order.BuyerInvoicePreference
Type	TEXT
Data Type	dimension

Is ISPU

When true, this order is marked to be picked up from a store rather than delivered.

Field ID	order.IsISPU
Type	BOOLEAN
Data Type	dimension

Is Access Point Order

When true, this order is marked to be delivered to an Access Point. The access location is chosen by the customer. Access Points include Amazon Hub Lockers, Amazon Hub Counters, and pickup points operated by carriers.

Field ID	order.IsAccessPointOrder
Type	BOOLEAN
Data Type	dimension

Seller Display Name

The seller’s friendly name registered in the marketplace.

Field ID	order.SellerDisplayName
Type	TEXT
Data Type	dimension

Has Regulated Items

Whether the order contains regulated items which may require additional approval steps before being fulfilled.

Field ID	order.HasRegulatedItems
Type	BOOLEAN
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

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