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 Differ

Amazon 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: Shows the total revenue from Amazon orders, providing monetary context for order counts.
• FBA Amazon Orders: Breaks down Amazon order volume specifically for Fulfilled by Amazon, helping analyze operational efficiency.
• Canceled Orders: Tracks orders that were canceled, providing clarity on why order counts may differ between Summary and other views.

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'