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.

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: Platform fees that, alongside taxes, influence margins.
• Amazon Product Sales: Gross sales revenue from Amazon orders, providing the base against which taxes are applied.
• Amazon Items Sold: Total quantity of items sold, useful for analyzing average tax per item.

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'