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.
Sales and Traffic - Overview of sales performance metrics as well as page traffic metrics. Aggregated by day.
Available for Order & Order Item Details
Dimensions
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"
Dimensions
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.
Metrics
Number of Items Shipped
Number of Items Unshipped
Order Total - The total charge for this order.
Available for "Order Item Details"
Dimensions
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
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.
Available for "Sales and Traffic"
Dimensions
Currency - The Funnel currency field maps to the Amazon currency code for Product Sales.
Metrics
Average Offer Count - The given day's average number of offers listed for sale.
Average Parent Items - The given day's average number of parent items listed for sale.
Average Sales Per Order Item (B2B) Amount - The given day's average B2B sales per order item, calculated by dividing the ordered product sales by the total order items.
Average Sales Per Order Item Amount - The given day's average sales per order item, calculated by dividing the ordered product sales by the total order items.
Average Selling Price (B2B) Amount - The given day's average price of the units sold B2B, calculated by dividing the ordered product sales by the total units.
Average Selling Price Amount - The given day's average price of the units sold, calculated by dividing the ordered product sales by the total units.
Average Units Per Order Item - The given day's average number of units in each order.
Average Units Per Order Item (B2B) - The given day's average number of units in each B2B order given per day.
A-to-Z Claims Amount - Monetary amount of filed A-to-Z Guarantee Claims.
A-to-Z Claims Granted - Number of A-to-Z Guarantee Claims Granted.
Browser Page Views
Browser Page Views (B2B)
Browser Sessions - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session.
Browser Sessions (B2B) - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session.
Featured Offer (Buy box) Percentage - The given day's percentage of page views where the featured offer (the add to shopping basket link) appeared on the page for customers to add your product to their basket.
Featured Offer (Buy box) Percentage (B2B) - The given day's percentage of page views where the featured offer (the add to shopping basket link) appeared on the page for customers to add your product to their basket.
Feedback Received
Mobile App Page Views
Mobile App Page Views (B2B)
Mobile App Sessions - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session.
Mobile App Sessions (B2B) - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session.
Negative Feedback Received - The given day's total negative feedback received divided by total feedback received.
Order Item Session Percentage - The given day's percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the order item.
Order Item Session Percentage (B2B) - The given day's percentage conversion metric indicating how many units were purchased B2B relative to the number of people who viewed the order item.
Order Product Sales (B2B) Amount - The amount of B2B ordered product sales, calculated by multiplying the price of order items and the number of units sold.
Order Product Sales Amount
Orders Shipped
Page Views - Hits in your Amazon.com presence.
Page Views (B2B) - Hits in your Amazon.com presence.
Received Negative Feedback Rate - Total negative feedback received divided by total feedback received for the given date.
Refund Rate - The given day's refund rate, calculated by dividing the number of units refunded by the number of units sold.
Sessions - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session.
Sessions (B2B) - Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session
Shipped Product Sales Amount - The amount of shipped product sales, calculated by multiplying the price of order items and the number of shipped units sold.
Total Order Items - Total number of order items. If "total order items" = "units ordered" then every customer ordered 1 unit.
Total Order Items (B2B) - Total number of B2B order items. If "total order items" = units ordered" then every customer ordered 1 unit
Unit Session Percentage (B2B) - The given day's percentage conversion metric indicating how many units were purchased B2B relative to the number of people who viewed the product.
Unit Sessions Percentage - The given day's percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the product.
Units Ordered - Number of units ordered. E.g. 3 copies of Book A and 4 copies of Book B is 7 units ordered.
Units Ordered (B2B) - Number of B2B units ordered. E.g. 3 copies of Book A and 4 copies of Book B is 7 units ordered.
Units Refunded
Units Shipped