Amazon Product Sales

gross_product_sales

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

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 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 alongside revenue.
  • FBA Amazon Product Sales: Revenue from Fulfilled by Amazon orders, helpful for comparing FBA vs. FBM performance.
  • Amazon Estimated Fees: Fees charged by Amazon, providing insight into how much of sales revenue is offset by costs.

Example Use

Prompt

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

Response

Query

SELECT
  sum(gross_product_sales) as gross_product_sales
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN CURRENT_DATE() -7 and CURRENT_DATE()  -1
  AND ot.platform = 'amazon'
  AND ot.amazon_fulfillment_status <> 'Canceled'