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 DifferAmazon 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'
Updated 1 day ago