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.

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.event_date BETWEEN CURRENT_DATE() - INTERVAL 30 DAY AND CURRENT_DATE()  - INTERVAL 1 DAY;