Retail Analytics Sales

Retail Analytics Sales

icon
Table Name: 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.

  1. Change distributor view: search for and distributor_view = 'Manufacturing' and replace ‘Manufacturing’ with ‘Sourcing’.
  2. 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

dateasinordered_revenueordered_unitsshipped_revenueshipped_cogsshipped_unitscustomer_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
image
retail_analytics_sales