The Amazon Selling Partner connector provides data from Amazon Seller Central. The SP-API also provides data from Vendor Central, but that is not yet available in Funnel.

Note: Amazon Selling Partner data is not affected by the destination limitations imposed by Amazon on Amazon Ads data.

Report type

The report type you select on connect determines what fields will be available in Funnel for an Amazon Selling Partner data source.

These are your options:

  • Orders - High level order data where each row of data represents one order.

  • Order Item Details - Contains detailed order item information where each row represents one order item and therefore there can be multiple rows per order.

Dimensions

Available for all report types

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

  • Seller Order Id - A seller-defined order identifier.

  • Order Status

  • Sales Channel - The sales channel of the first item in the order.

  • Fulfillment Channel - Whether the order was fulfilled by Amazon (AFN) or by the seller (MFN).

  • Shipment Service Level

  • Purchase date - The date and time in UTC for when the order was placed.

Available for "Orders"

  • Order Type

  • Payment Method - The payment method for the order. This property is limited to Cash On Delivery (COD) and Convenience Store (CVS) payment methods.

  • Shipment Service Level Category - The shipment service level category of the order. Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard.

Available for "Order Item Details"

  • Product Name

  • Seller SKU

  • ASIN - The Amazon Standard Identification Number (ASIN) of the item.

  • Last updated - The date and time in UTC of the most recent order update.

  • Order Channel - The sub channel through which a sale was made for CBA/WBA orders.

  • Item Status

  • Shipping City - The city of a standard address.

  • Shipping State - The state or region of a standard address.

  • Shipping Postal Code - The postal (zip) code of a standard address.

  • Shipping Country - ISO 3166 standard two-letter country code.

  • Promotion IDs - List of all item promotions applied to this order item.

Metrics

Available for "Orders"

  • Number of Items Shipped

  • Number of Items Unshipped

  • Order Total - The total charge for this order.

Available for "Order Item Details"

  • Quantity Ordered

  • Item Price

  • Item Tax

  • Shipping Price - The amount the buyer paid for shipping. Amount is aggregate of the quantity, not unit price.

  • Gift Wrap Price - The amount the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price.

  • Gift Wrap Tax - The amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price.

  • Item Promotion Discount - Total of all promotion discounts applied to the order item.

  • Shipping Promotion Discount - Promotion discount applied to shipping.

Did this answer your question?