Overview

Amazon Product Sales refers to the total revenue from Amazon orders before adjustments such as shipping, fees, taxes, and refunds.

📘

Amazon Product Sales = Total Amazon-Reported Gross Product Sales

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

• Product Sales (Gross Sales) = SUM(gross_product_sales) --> Orders table
• Amazon Sales = where platform = 'amazon'

Insights and Actions

Amazon Product Sales highlights total revenue generated from Amazon orders, providing a key measure of marketplace performance:

• Evaluate Revenue Trends: Track changes in Amazon Product Sales over time to identify growth opportunities or periods of decline.
• Segment by Fulfillment Type: Compare FBA vs. FBM sales to understand which fulfillment strategy drives the most revenue.
• Benchmark Across Channels: Compare Amazon Product Sales against Shopify, WooCommerce, or BigCommerce sales to gauge Amazon’s role in total business revenue.

Related Metrics

• Amazon Orders: Number of orders placed on Amazon, useful for calculating average order value.
• Amazon ROAS: Measures revenue efficiency of Amazon ad spend, showing profitability of paid campaigns.
• Gross Sales: Total product sales across all platforms, providing context for Amazon’s contribution to overall revenue.

Clarification on Summary Page vs. Dashboards/Moby/SQL Editor

You may notice that the Amazon Product Sales value shown on the Summary page differs from what you see in Dashboards, Moby, or the SQL editor. This is expected and happens because:

• Summary page automatically applies filters:

  • Excludes orders where amazon_fulfillment_status = 'Canceled'
  • Includes only orders where amazon_fulfillment_channel = 'FBA' (Fulfilled by Amazon)

• Dashboards, Moby, and SQL editor do not apply these filters by default:

  • They include all Amazon orders unless you explicitly filter them.
  • If you want your query or prompt to match the Summary page, you’ll need to add the same filters yourself.

Example Use

Prompt

What are my Amazon Product Sales over the past 7 days?

Response

Query

SELECT
  SUMIf(ot.gross_product_sales, ot.amazon_fulfillment_status <> 'Canceled' AND ot.amazon_fulfillment_channel = 'FBA') AS amazon_product_sales_summary_page
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN CURRENT_DATE() -7 and CURRENT_DATE() -1
  AND ot.platform = 'amazon'