Andrew Hamada walks through the Retail Analytics Daily Sales Report in Amazon Vendor Central, showing where to find it and what the six core metrics mean: shipped COGS, ordered revenue, shipped revenue, ordered units, shipped units, and customer returns. The report updates daily with three years of data, but Vendor Central can't filter custom date ranges or aggregate across products.
A Guide to Shipt Cogs and the Amazon Vendor Central Sales Report if you're an Amazon vendor, you need to understand basic sales data like shipped cogs, shipped revenue, ordered revenue and other important metrics. This data is key to making important decisions about marketing and product development. You can find this data in Vendor Central as it is one of five key reports that is included within the Amazon Retail analytics tables Sales, Traffic, Inventory Forecasting and Net ppm. This guide will help you find this report and understand what the data is telling you. How to Find the Daily Sales Report in Amazon Vendor Central after logging in to the Amazon Vendor Central Dashboard, click on the Reports menu item in the bar at the top, select Retail analytics and click on Sales where you will find the daily sales report in Amazon Vendor Central. This report is updated daily and has a backfill of three years. In order to view this report correctly, you must filter it by distributor view, Manufacturing versus Sourcing and period daily. How to Understand the Sales Report Shipped Cogs and Revenue the Retail analytics sales report has the following six key Shipped cogs, ordered revenue, shipped revenue, ordered units, Shipped units and customer returns. Shipped cogs Shipped cogs or cost of goods sold is shipped units multiplied by the average wholesale price of units, which gives you a total revenue figure. Shipped cogs tends to be the number most brands care about the most because it references Amazon's cost of goods sold, not the vendors, which makes this a better reflection of the true revenue generated by the product. Ordered revenue vs. Shipped revenue ordered revenue is the number of units ordered multiplied by the average retail price of each unit. It's how much revenue you can expect based on orders that have actually been placed, but these units have not necessarily been shipped. Shipped revenue is also important, but it's not as important to vendors as shipt cogs because it is a measure of revenue going to Amazon, not the vendor. Shipped cogs specifically refers to the revenue that goes to the vendor Ordered units versus Shipped units. The ordered units and shipped units metrics have to do with actual units rather than revenue. It tells you how many units were ordered for an ASIN during the determined time period and how many were shipped during that time period. This is the ASIN level data that can give you different insights compared to just looking at revenue. Customer Returns this data shows you how many products were returned by customers broken down by their ASIN during the determined time period. By examining this data, you can diagnose recurring problems with certain products that are returned more than others. The data is difficult to analyze. Amazon's dashboard only allows you to filter daily data by day. They also offer the following daily, weekly, monthly, quarterly, yearly, week to date, month to date, quarter to date, and year to date. However, you will struggle to get the data you need strictly through Vendor Central. That's because you have to manually download Amazon's Vendor Central reports, and there's no way to do customized time range reporting. Fortunately, there are tools out there that help you download the data and crunch the numbers. To simplify things, we've created a white paper that breaks down each of these methods, the pros and cons of using them, how much they cost, and how to know which is right for you so you can get access to the data you need. We've put a link to that white paper for free to download in the description. Thank you for watching and have a great day.
