Search

Talk to Sales

Retail Analytics Real Time Sales

Retail Analytics Real Time Sales

Retail Analytics - Real Time Sales

icon
Table Name: retail_analytics_real_time_sales

The Retail Analytics Real Time Sales table provides hourly snapshots of ordered revenue and ordered units. Vendors use this report to monitor hourly sales performance during events like Prime Day, Black Friday, or Cyber Monday.

Amazon calculates revenue by taking retail sales price and multiplying by either units ordered to the end customer. Revenue here represents Amazon’s revenue (not the vendor’s).

Business questions & scenarios

What is this data useful for?

  • Real time sales monitoring: How is our promotions and overall sales performing right now, especially during peak sales events like Prime Day and Black Friday?
  • Retail media performance tuning: When and how should we change ad tactics to reflect changing performance throughout the day?

Schema & update details

UI Report path
VC>Reports>Retail Analytics>
Amazon update frequency
Hourly (15-30 mins after top of the hour). Learn more
Reason update frequency
Every hour (15-30 mins after top of the hour)
Time Zone
Country local time zone
Granularity [?]
1 row per: - ASIN - Date_Time

Historical data & change management

Time Period
Hourly
History available from Amazon
None / Snapshot
Reason lookback period
Last Hour
Reason data retention window
7 days

Data dictionary: fields in this table

Table & data nuances

  • May not match retail_analytics_sales: Real Time Sales does not account for cancellations from erroneous or fraudulent orders. As such, Vendors should use final sales figures from retail_analytics_sales for business reporting purposes.
  • Manufacturing only: This table ONLY contains data for the Manufacturing distributor view
  • 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

Query this table by start_time to get an hour-by-hour view of sales by ASIN.

  1. Adjust ASIN as needed. The example query below will provide hourly sales data for a given ASIN that have occurred today.
 SELECT 
    _partneruuid
    , date_time 
    , asin
    , ordered_units
    , ordered_revenue

   FROM notifications_sales_event_real_time
   
   WHERE 
   asin in ('')
   and date_time >= current_date
  1. Aggregate to total ordered revenue and ordered units across all ASINS by hour.
 SELECT 
    _partneruuid
    , date_time 
    , sum(ordered_units) as ordered_units
    , sum(ordered_revenue) as ordered_revenue

   FROM notifications_sales_event_real_time
   
   WHERE
   and date_time >= current_date
   
   GROUP BY
   _partneruuid
   ,date_time
   
  ORDER BY
  date_time desc