retail_analytics_sales
The Retail Analytics Sales table contains a vendor’s point-of-sale metrics by item (ASIN) by day. It is the primary source of customer sales data for vendors. Use this table to create point-of-sale reporting that tracks units and revenue, both ordered and shipped.
Amazon calculates revenue by taking retail sales price and multiplying by either units ordered or shipped to the end customer. Revenue here represents Amazon’s revenue (not the vendor’s).
Amazon calculates shipped COGS by taking product costs (price paid to the vendor) and multiplying by the units ordered by the end customer. As such COGS represents Amazon’s COGS (not the vendor’s).
Business questions & scenarios
What is this data useful for?
- Business performance review: How were sales last week, compared to the prior week and prior year?
- Customer returns analysis: What products do customers return most often? What trends can we get ahead of?
- Conversion rate (CVR) analysis: What is my detail page conversion rate by product?
Schema & update details
UI Report path | |
Amazon update frequency | Daily, with 24-48 hour latency. Learn more |
Reason update frequency | Every 8 hours |
Time Zone | Country local time zone |
Granularity [?] | 1 row per:
- ASIN
- Date
- Period
- Program
- Distributor View |
Historical data & change management
Time Period | DAILY | WEEKLY | MONTHLY |
History available from Amazon [?] | 1095 days | 6 weeks | 24 months |
Reason lookback period [?] | 14 days | 6 weeks | 3 months |
Data dictionary: fields in this table
Table & data nuances
- Time periods may not match: All retail analytics tables are available at DAILY, WEEKLY, MONTHLY granularity. There may be Amazon-driven discrepancies between different granularities that Amazon has not explained. For example, if you compare WEEKLY data to the sum of the seven DAILY periods in that week, the total units/revenue/etc. may not be an exact match. We recommend using the highest-granularity data you can, to minimize discrepancies and stakeholder questions.
- Manufacturing and sourcing view differences: This table contains data for both distributor views, manufacturing and sourcing. Each view behaves differently and contains different data. Learn more
- Sales channels or “Programs:” Amazon provides data for Amazon Retail, Amazon Fresh, and Amazon Business, separated by the
program
field. Despite its name, the “Amazon Retail” program contains data for Retail, Fresh, and Business combined. Vendors can submit a case to request separate Amazon Fresh and Amazon Business data. - Amazon wants you to connect a product catalog. This table contains data by date by ASIN, but does not provide any product attributes like category, size, or even product title to help you identify or aggregate products. Amazon expects you to connect this table to a catalog/dimension table that maps ASINs to attributes, such as the Product Catalog table or our custom catalog upload.
How to query this table
It’s important to filter this table by period, distributor view, and program to avoid duplication. The example query below will provide ASIN-level sales by day for the current year-to-date.
- Change distributor view: search for
and distributor_view = 'Manufacturing'
and replace‘Manufacturing’
with‘Sourcing’
. - Change program: search for
and program = ‘Amazon Retail’
and replace‘Amazon Retail’
with‘Amazon Business’
or another program.
select date
, asin
, ordered_revenue
, ordered_units
, shipped_revenue
, shipped_cogs
, shipped_units
, customer_returns
from retail_analytics_sales
where period = 'DAILY'
and distributor_view = 'Manufacturing'
and program = 'Amazon Retail'
and date >= '2024-01-01' and date <= '2024-03-31'
order by 1 desc, 2 asc
Example query output
date | asin | ordered_revenue | ordered_units | shipped_revenue | shipped_cogs | shipped_units | customer_returns |
---|---|---|---|---|---|---|---|
February 26, 2024 | ASIN_118 | 0 | 0 | 0 | 0 | 0 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_144 | 188.3 | 7 | 430.4 | 314.24 | 16 | 1 |
February 26, 2024 8:00 AM (UTC) | ASIN_149 | 58.74 | 6 | 97.9 | 45 | 10 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_155 | 864.12 | 38 | 1114.26 | 701.52 | 49 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_18 | 551.06 | 19 | 468.86 | 310.88 | 16 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_197 | 64.92 | 4 | 64.92 | 46.6 | 4 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_223 | 140.64 | 4 | 105.48 | 67.68 | 3 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_228 | 0 | 0 | 58.79 | 39.3 | 1 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_46 | 391.86 | 14 | 335.88 | 220.08 | 12 | 0 |
February 26, 2024 8:00 AM (UTC) | ASIN_5 | 616.77 | 63 | 558.03 | 256.06 | 57 | 0 |