Overview

Amazon Estimated Fees refers to the estimated fees to be charged by Amazon for the order, based on products purchased. The amount is an estimate, and not final until Amazon reports on actual fees.

📘

Amazon Estimated Fees = The estimated fees to be charged by Amazon

The calculation is based on data from the Orders table.

Insights and Actions

Amazon Estimated Fees helps you anticipate Amazon’s costs on each order, supporting profitability and pricing decisions:

• Track Fee Impact on Margins: Compare fees to Amazon Product Sales to understand how much revenue is reduced by Amazon’s charges.
• Benchmark Fulfillment Strategies: Analyze FBA vs. FBM orders to see how fees differ by fulfillment type and adjust strategy accordingly.
• Plan for Profitability: Incorporate estimated fees alongside taxes and shipping costs when modeling true net revenue.

Related Metrics

• Amazon Product Sales: Total sales revenue, providing context for fee percentages relative to revenue.
• Amazon Taxes: Customer tax amounts, another factor affecting net profitability.
• Gross Sales: Overall sales across all channels, to see how Amazon fees compare to costs on other platforms.

Example Use

Prompt

How much Amazon fees were charged by Amazon for orders?

Response

Query

select
  sum(amazon_estimated_fees) as amazon_estimated_fees
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'