Amazon Orders
orders
Overview
Amazon Orders refers to the total number of orders placed from Amazon.
Amazon Orders = Total count of Amazon Orders
The calculation is based on data from the Orders table.
Detailed Breakdown
The formula above is derived from the following components:
- Orders =
count(1)
--> Orders table - Amazon Sales =
where platform = 'amazon'
Why Summary Page Values May DifferAmazon Sales Metrics on the Summary page may appear lower than in queries in Moby/Dashboards/SQL builder.
This is because the Summary page excludes canceled orders, while queries in other surfaces include all orders by default.
To match the Summary page, add a filter excluding canceled orders, e.g.,
WHERE amazon_fulfillment_status <> 'Canceled'
Insights and Actions
Amazon Orders measures total order volume on Amazon, helping you track demand and performance in the marketplace:
- Track Demand Trends: Monitor order volume over time to identify seasonality, spikes, or declines in customer activity.
- Analyze Fulfillment Impact: Compare orders fulfilled by Amazon (FBA) vs. fulfilled by merchant (FBM) to assess operational efficiency.
- Benchmark Against Other Channels: Compare Amazon order volume to your main sales platform (e.g. Shopify, WooCommerce, or BigCommerce) to see Amazon’s contribution to overall sales.
Related Metrics
- Amazon Product Sales: Revenue from Amazon orders, providing monetary context for order counts.
- Amazon Items Sold: Tracks units purchased, useful for analyzing order size and product mix.
- Orders: Total orders across all platforms, showing Amazon’s contribution to overall order volume.
Example Use
Prompt
How many Amazon orders were there in the last 30 days?
Response

Query
SELECT
count(1) orders
FROM
orders_table AS ot
WHERE
ot.event_date BETWEEN CURRENT_DATE() -30 and CURRENT_DATE() -1
AND ot.platform = 'amazon'
AND ot.amazon_fulfillment_status <> 'Canceled'
Updated 18 days ago