Overview

Amazon Items Sold refers to the total number of individual items or products that were purchased by customers on Amazon.

📘

Amazon Items Sold = The total quantity of product units ordered on Amazon

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

• Items Sold = SUM(product_quantity_sold_in_order) --> Orders table
• Amazon Sales = where platform = 'amazon'
• Excluding Canceled Orders = amazon_fulfillment_status != 'Canceled'

🚧

Why Summary Page Values May Differ

The Summary page excludes canceled orders, while queries in Moby/Dashboards/SQL builder include all orders unless explicitly filtered.

To match the Summary page using SQL, use a filter to exclude canceled orders: WHERE amazon_fulfillment_status != 'Canceled'

Insights and Actions

Amazon Items Sold measures unit-level sales volume on Amazon, giving insight into demand patterns and product performance:

• Track Product Demand: Monitor how many items are sold over time to spot growth trends, seasonality, or declining products.
• Evaluate Average Order Size: Compare items sold against order counts to calculate units per order and assess customer purchasing behavior.
• Optimize Inventory Planning: Use unit sales trends to align stock levels with demand, reducing risks of overstock or stockouts.

Related Metrics

• Units Sold: Total units sold across all platforms, useful for benchmarking Amazon’s share of sales volume.
• Amazon Orders: Amazon order counts, providing context for calculating units per order.
• Gross Sales: Total revenue across all platforms, to see whether Amazon drives higher unit volume or higher-value sales compared to other channels.

Example Use

Prompt

How many Amazon items were sold over the last 30 days?

Response

Query

SELECT
  SUM(ot.product_quantity_sold_in_order) AS total_units_sold
FROM
  orders_table AS ot
WHERE
	ot.platform = 'amazon'
	AND ot.amazon_fulfillment_status != 'Canceled'
  AND ot.event_date BETWEEN CURRENT_DATE() - INTERVAL 30 DAY AND CURRENT_DATE()  - INTERVAL 1 DAY;