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' - Excluding Canceled Orders =
amazon_fulfillment_status != 'Canceled'
Why Summary Page Values May DifferThe 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 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 8 days ago