Overview

Amazon Taxes refers the total amount customers paid in taxes for Amazon orders, before adjusting for refunded taxes.

📘

Amazon Taxes = Total taxes paid by customers for Amazon orders, before refunds

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

• Taxes = SUM(taxes) --> Orders table
• Amazon Sales = where platform = 'amazon'
• Excluding Canceled Orders = amazon_fulfillment_status != 'Canceled'

🚧

Why Summary Page Values May Differ

The Summary page excludes canceled orders, while queries in Moby/Dashboards/SQL builder include all orders unless explicitly filtered.

To match the Summary page using SQL, use a filter to exclude canceled orders: WHERE amazon_fulfillment_status != 'Canceled'

Insights and Actions

Amazon Taxes helps you understand the role of taxes in Amazon transactions and their impact on pricing, compliance, and profitability:

• Monitor Regional Tax Burden: Track Amazon Taxes across time periods or geographies to understand where taxes increase customer costs.
• Evaluate Pricing Strategy: Consider the effect of taxes on final order totals, especially in high-tax regions where it may impact conversion rates.
• Plan for Margins: Compare Amazon Taxes with Amazon Estimated Fees and shipping costs to get a full picture of profitability.

Related Metrics

• Amazon Estimated Fees: Fees charged by Amazon, which together with taxes affect margins.
• Amazon Product Sales: Total revenue before deductions, the base against which taxes are applied.
• Sale Taxes: Total tax amounts across all channels, helpful for comparing Amazon’s share of tax collection.

Example Use

Prompt

How much Amazon taxes were paid by customers over the last 30 days?

Response

Query

SELECT
  sum(taxes) as taxes
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'