All Collections
Data Sources
Amazon
Amazon Rapid Retail Analytics Connector: Vendor Central Real-time Sales, Traffic, and Inventory
Amazon Rapid Retail Analytics Connector: Vendor Central Real-time Sales, Traffic, and Inventory
Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

Amazon’s Rapid Retail Analytics, via the Selling Partner API (SP API), enables brands to access near real-time Vendor retail analytics – sales, traffic, and inventory data.

Previously, metrics shared with brands via interfaces like Vendor Central and the Selling Partner API were only available at a daily grain and delayed 72 hours. Rapid Retail Analytics offers new levels of granularity and significantly reduced latency to critical performance data.

Our integration is a code-free, fully-automated integration to Amazon’s Rapid Retail Analytics API for available traffic, sales, and inventory data. Your data is delivered to a private cloud warehouse or data lake destination owned by you.

Available Data

There are three primary data feeds associated with the Rapid Retail data;

  1. GET_VENDOR_REAL_TIME_SALES_REPORT (Vendors/Sellers)

  2. GET_VENDOR_REAL_TIME_INVENTORY_REPORT (Vendors)

  3. GET_VENDOR_REAL_TIME_TRAFFIC_REPORT (Vendors)

Note: The Openbridge integration currently supports Vendor accounts only. Sellers will be supported at a later date. For Sellers, we suggest using Sales Reports or the Orders API. Both offer more robust sales data solutions than the current Rapid Retail Analytics release.

Types Of Metrics Available

The following is an overview of the metrics and their definitions for Sales, Inventory, and Traffic data feeds:

Sales

  • Ordered Units: It represents the number of units Amazon customers order for a specific ASIN within a given time frame. This number can be negative if there are more cancellations than orders.

  • Ordered Revenue refers to the total revenue generated from the aggregated ordered product sales for the specified ASIN within a given time frame. Adjustments are made to account for cancellations.

Inventory:

  • Highly Available Inventory Units: This metric represents the number of units available for sale on the Amazon website across different regions and apps. It is based on the units in Amazon fulfillment centers that are in a sellable condition, excluding units in customer shopping carts or allocated for other orders.

Traffic:

  • Glance Views: It indicates the number of times customers have viewed the product detail page for a specific ASIN. The views are counted when a particular merchant is the featured offer for the product. For vendors, this metric is applicable when retail is the featured offer. Glance views are reported based on the Amazon Retail Analytics manufacturing view.

Note: Here is feedback from Amazon about variations when comparing Rapid Retail Event Data to Amazon Vendor Reports:

"Hourly metrics in rapid retail analytics and daily retail analytics in other datasets will not align. These reports differ particularly with the methods used to identify traffic from shoppers and remove robotic traffic. Many signals contribute to identifying and classifying traffic from shoppers vs. robotic traffic. Although the best available signals are used to classify traffic intraday, additional information may lead to Glance Views being reclassified in the future. This results in differences (both +/-) when comparing datasets across granularity (hourly vs. daily, weekly, etc). We recommend that users continue to use other datasets for non-hourly use cases and, generally, avoid trying to compare hourly datasets to other sources."

See this post from Amazon for more details on how this data works and how it varies from other Vendor Reports.

Example Data Sets Sales, Traffic, And Inventory

Each data feed is ASIN-specific and provides a key set of core metrics.

The Traffic Report contains information about a specific time range, ASIN (Amazon Standard Identification Number), and the number of glance views.

The Inventory Report also provides a time range and ASIN, but it includes the number of highly available inventory instead of glance views.

Lastly, the Sales Report provides a time range and ASIN, but two metrics; order units and order revenue.

Following are examples of the core data elements in each;

Example Traffic Data

startTime

endTime

asin

glanceViews

2023-02-20T19:00:00Z

2023-02-20T20:00:00Z

B123456789

2700

2023-02-20T20:00:00Z

2023-02-20T21:00:00Z

B987654321

5000

Example Inventory Data

startTime

endTime

asin

highlyAvailableInventory

2023-02-20T19:00:00Z

2023-02-20T20:00:00Z

B123456789

270

2023-02-20T20:00:00Z

2023-02-20T21:00:00Z

B987654321

900

Example Sales Data

startTime

endTime

asin

orderedUnits

orderedRevenue

2023-02-20T19:00:00Z

2023-02-20T20:00:00Z

B123456789

2

37.98

2023-02-20T20:00:00Z

2023-02-20T21:00:00Z

B987654321

1

18.99

Supported Marketplaces

Rapid Retail data feeds are available in these markets;

  • US, CA, MX, BR, UK, DE, FR, IT, ES, NL, PL, SE, BE, EG, TR, SA, AE, IN, SG, AU, JP

IMPORTANT: Understanding Order Cancellations

Rapid Retail Analytics is a robust data analysis tool that captures cancellations with high accuracy, precisely logging the time at which they occur. The system offers transactional-level data, ensuring detailed information is available without summarization or aggregation. However, when interpreting and analyzing the data, it is essential to understand its contents clearly.

Data Presentation and Considerations:

The cancellation data provided by Rapid Retail Analytics is presented in a granular form, maintaining the individual transaction details without any consolidation. This level of data granularity ensures comprehensive insights into cancellations, enabling thorough analysis and evaluation.

Special Consideration:

Below are Examples A, B, and C for ASIN B123456789154. These examples show how an order for one (1) unit and subsequent cancellation is handled over time. It is important to note a specific scenario related to cancellations, referred to as "Example B" for illustrative purposes. In this scenario, it is crucial to be aware that Amazon may deduct an order from the dataset if canceled after a certain period. This time period can vary, spanning from several hours to even days. It is imperative to account for this deduction when analyzing and interpreting the cancellation data, ensuring accurate insights and conclusions are drawn.

Example A

The order and cancelation occur within the same hour. This would net to 0 for that hour, and the ASIN combination (+1 quantity, followed by -1 quantity) and the results would be:

startTime

endTime

asin

orderedUnits

orderedRevenue

2022-07-12T08:00:00Z

2022-07-12T09:00:00Z

B123456789

0

0

Example B

In “Example B”, the output would have two events (order and cancelation) represented in the hour they occurred. The output would be:

startTime

endTime

asin

orderedUnits

orderedRevenue

2022-07-12T08:00:00Z

2022-07-12T09:00:00Z

B123456789

1

18.99

2022-07-12T09:00:00Z

2022-07-12T10:00:00Z

B987654321

-1

-18.99

Example C

In “Example C”, the output would be the same as in Example B. The output will represent each event (order and cancelation) as they occur. The hour and ASIN combination are omitted with no events (orders or cancellations) in the 10:00 am hour. Zero values would only return if events occur and net to zero as in “Example A”.

startTime

endTime

asin

orderedUnits

orderedRevenue

2022-07-12T08:00:00Z

2022-07-12T09:00:00Z

B123456789

1

18.99

2022-07-12T09:00:00Z

2022-07-12T10:00:00Z

B987654321

-1

-18.99

FAQs

  • What information is available in the rapid retail analytics data? Information is available for each product (ASIN) on an hourly basis. Notifications and reports are sent for each hour with relevant activity.

  • Will each notification or report include only one ASIN? No, notifications and reports include all ASINs with activity during a specific hour.

  • Which ASINs are included in the notifications or report responses? ASINs are included if they have relevant activity for a specific notification or report type during that hour. This ensures the information is relevant and reduces unnecessary data.

  • How should I interpret the absence of a particular ASIN in the notifications or report responses? If an ASIN is not included, ASIN had no relevant activity for that specific notification or report type during that hour.

  • Can I receive notifications or reports with a granularity of less than an hour? No, the rapid retail analytics data is available on an hourly basis. Notifications are sent within 10 minutes of the hour's close, and reports can be requested shortly after the hour's close.

  • How should I interpret the timestamps in the outputs? Timestamps are based on UTC. Report requests should specify the dataStartTime and dataEndTime as full-hour timestamps.

  • How does this reporting differ from Amazon Retail Analytics (ARA) reporting? Rapid retail analytics reflects gross activity in real-time, while ARA reporting considers net activity after quantity changes, cancellations, and returns.

  • What is the "highly available inventory" metric? This metric represents the number of units of an ASIN that are available for sale and seen as the featured offer by Amazon shoppers. It excludes units in shopping carts or allocated for other orders.

  • Are all Amazon orders included in the sales dataset? Retail orders of physical products are included, but digital orders, free replacements, and try-before-you-buy orders are excluded.

Did this answer your question?