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 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 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'