our blog chatter
|
|
.One of the best reports Amazon provides Sellers for understanding their business performance comes in the ‘Detail Page Sales and Traffic by Child Item’ report. It is not without its limitations, namely that you cannot view your ASIN level data in time series format, but considering it includes fields such as Ordered Product Sales (OPS), Conversion Rates (Unit Session Percentage and Order Item Session Percentage), Buy Box Percentage and Sessions… there is no better report for diagnosing what is driving changes in your business performance. In fact, this is the report we use in our ‘Bridge Analysis’ to calculate the ‘drivers of change’, which help us zero-in on growth opportunities for Brands and separate the ‘signal’ from the ‘noise’. But one thing I could never reconcile was how Amazon was calculating OPS for this report. If you have ever tried to compare the total OPS for the ‘by ASIN’ Business Reports against the ‘by Date’ Business Reports, you may have seen the issue yourself. By Amazon’s definition, Ordered Product Sales is “calculated by multiplying the price of order items and the number of units sold for the selected time period.” But if you compare the ‘OPS per Unit’ against your Amazon listing price, more often than not you’ll see that those two don’t tie either (for example, OPS per Unit equals $25.55 but your Amazon listing price is $24.99, what gives?). Having spent years working with Amazon data, their documentation, and the various APIs, I have come to expect a certain amount of squishiness and lack of precision from them as they attempt to accommodate for rapidly changing and evolving data points and definitions. When things don’t make sense, or the documentation seems out of date, my conciliatory refrain is “It’s Amazon.” These last few months we have been integrating the Marketplace Web Services (MWS) API data for Seller Central accounts into our DATA STUDIO solution, and through the tedious process of data validation… I have finally gotten to the bottom of the question, “How do I reconcile Amazon Ordered Product Sales across the Business Reports”. First let’s level set: Where is the Detail Page Sales and Traffic Report?You can find the ‘Detail Page Sales and Traffic by Child Item’ report by clicking “Reports” and then “Business Reports” from the main navigation bar at the top of the Seller Central dashboard. The report “Detail Page Sales and Traffic by Child Item” can then be found under the ‘By ASIN’ section of the left navigation menu of the Business Reports module. Within this report, you can select from a suite of metrics including B2B specific (not shown here) and Amazon will deliver reporting metrics for your ASINs that had performance data over the time period selected. Where Exactly is the Ordered Product Sale Discrepancy for Platform vs. Child ASIN Sales?As OPS = SUM(Item Price * Units Ordered), if you take the ‘Ordered Product Sales’ for an ASIN and divide it by the ‘Units Ordered’, you’ll get OPS per Unit, which by definition should equate to ‘Item Price’. But checking ‘Item Price’ against your actual Amazon listing price, you’ll see that OPS per Unit (or ‘Item Price’) can be overstated, usually in the range of ~2-4 percent. Per the example mentioned above, your OPS per Unit will be something like $25.55 while your Amazon listing price is $24.99, a difference of $0.56 or a 2.2% difference. So, either we have a data disconnect between Amazon’s reporting of ‘Units Ordered’ and ‘Ordered Product Sales’, or Amazon has incorrectly defined or labeled the field ‘Item Price’. Teaser, it’s the latter; Amazon has incorrectly defined ‘Item Price’ for this report. How Do I Then Reconcile Child Item Sales to Total Platform Sales?The best way to get a ‘true’ accounting of Ordered Product Sales, in total or by ASIN, is by leveraging MWS API data. It is also possible to perform a similar analysis by exporting the raw orders data out of Seller Central, but not one I’d recommend as you have to manually pull 30 days’ worth of data at a time...we’re all for streamlining that process, which is why we are working on providing MWS data via a database for our customers, no manual report pulling required. For some time now we have been delivering streamlined access to Amazon Advertising Data via stand-alone databases. Leveraging the Advertising API data has brought many benefits including time saved pulling manual reports, easy connection to most reporting platforms, and scaling Amazon reporting for internal teams and external clients. Now that we have begun incorporating MWS data, we are seeing similar benefits… and new possibilities. Among many other data elements, MWS delivers Amazon order information at an ASIN and day level. Each ASIN ordered is tied to an Amazon Order ID, with all of the customer fees broken out. Included in those fees are ‘Item Price’, which indeed matches the Amazon list price, but also included are: ‘Item Tax’, ‘Shipping Price’, ‘Shipping Tax’, ‘Gift Wrap Price’, ‘Gift Wrap Tax’, ‘Item Promotion Discount’, and ‘Ship Promotion Discount’. As part of our data validation we mapped MWS data to the Business Reports to ensure we could replicate and automate these reports going forward. Through that process we discovered that ‘Item Price’ in the ‘Detail Page Sales and Traffic by Child Item’ report is actually calculated as ‘Item Price’ + ’Item Tax’, whereas the ‘Detail Page Sales and Traffic’ report calculates OPS using only ‘Item Price’. The ‘why’ on this I’ll explain as ‘It’s Amazon’… but it is probably a legacy definition from before they were collecting sales tax. If you’ve ever been called upon to explain this discrepancy, you now have the most important disconnect. (I’ll save the other edge cases for another time.) But beyond this one use-case, there are other practical applications for tracking your MWS orders data in conjunction with your Business Reports. First and foremost, Promotional discounts are not being netted out of your OPS in the ‘Detail Page Sales and Traffic’ Business Reports. This can lead to surprises in your Amazon payments, as well as distort your conversion rates as price moves and price elasticity aren’t fully transparent in the business reports. Why Should You Care About Capturing MWS Orders Data?The Business Reports are still a valuable resource for your business and contain data currently unavailable from any other source; namely Sessions, Buy Box Percentage, and Conversion Rates. These reports do however have their limitations, and supplementing them with MWS data can help enrich your understanding of your business. Beyond what has been noted above, with MWS data you can calculate the Lifetime Value of your customers across both Amazon fulfilled and Merchant fulfilled orders. This is not possible through the manual reports. You can also measure customer repurchase cycles and gauge how well you are selling across your line. You open the door to Geo-mapping your sales, which can inform your DSP targeting (Amazon’s programmatic advertising platform or Demand Side Platform) and help in evaluating other off-platform initiatives. And I’d be remiss if I didn’t mention, with MWS data you can efficiently calculate ‘Total ACoS’ or ‘TACoS’, and more importantly, through all the above, establish your ACoS threshold for customer acquisition initiatives. All in, there is much to be gained by taking control of your MWS data, well beyond answering the irksome question of data consistency across reports.
0 Comments
A lot of people want to know, “How does Amazon work?”. Warm up the Wayback Machine, we are going back to the early days of Amazon to trace the lineage of what I call ‘The Amazon Game’. What you need to know about Amazon Search |
todd vanderstelt | founder | dash/APPLICATIONS
as a former Amazonian, todd is an amazon expert who works with brands, agencies, and investment firms to demystify the platform while leading the development of our amazon focused solutions. https://www.dashapplications.com/about-us.html |
It is easy to be distracted by the constant stream of policy changes, the launch of new ad units, or shiny ‘Beta’ launches, but it is the fundamentals of Amazon that determine whether or not your brand succeeds or fails… both on the platform and off. And as true as that statement was in the early days, it has only become more so as Amazon has grown in importance.
So, to get us back to the basics, let’s start with a simple question, “What exactly is Amazon?”
What you need to know about Amazon
- If you can not win the Buy Box, it all falls apart
- Optimize your detail pages so customers can find you in Amazon’s Search Results
- Use your detail page content to educate and motivate customers to convert
- Amazon affects sales in other channels, and other channels affect sales on Amazon
Amazon is a Marketplace
The primary determinations for the Buy Box winner are price and inventory availability. This is great for customers, who value selection, price, and convenience, and serves as the foundation of the famous Amazon Flywheel. For Brands however, it can mean price degradation, inconsistent signals for Forecasting and Inventory planning, and an inability to promote your products through advertising.
In short, if you cannot consistently win the Buy Box, you will not succeed on the platform.
Amazon is a Search Engine
You may have heard the term ‘Detail Page Optimization’, the purpose of which is to ‘optimize’ your pages for Amazon’s Search algorithms. The trick here is to balance content written for algorithms, with content written for customers… my next point.
Amazon is an Unassisted Sales Floor
There are plenty of best practices to find out there, but my best recommendation is to shop your pages like a customer. Do you give them all the information they need to make a purchase decision? And just as importantly, if they determine that this product is not for them, are you empowering them to shop across your line to keep them within your Brand?
Amazon is a Brand Builder and Breaker
But the inverse is also true. Gone are the days of dumping overstock in some far-away region, or leaving it to unchecked distributors to get your products out in the market. Any missteps your business makes has the potential to disrupt, if not destroy, your brand.
Amazon has a famous saying: “Start with the customer and work backward”, which is a great mental exercise regardless of your business. But for Brands today, I would also consider: “Start with Amazon and work backwards.” You will be happy you did. The health of your Brand depends on it.
Why Should You Care About the Amazon Fundamentals?
todd vanderstelt | founder | dash/APPLICATIONS
as a former Amazonian, todd is an amazon expert who works with brands, agencies, and investment firms to demystify the platform while leading the development of our amazon focused solutions. https://www.dashapplications.com/about-us.html |
sam hager, president dash / AMAZON |
Archives
July 2020
June 2020
April 2020
March 2020
February 2020
October 2019
June 2019
May 2019
April 2019
Categories
All
Advertising
Amazon
Amazon Advertising Performance
Amazon Campaigns
Amazon Data
Amazon Listings
Amazon Reporting
Amazon Reviews
Cycle Stock Optimization
Inventory Exceptions
Inventory Management
Inventory Open To Buy
Inventory Open-to-buy
Inventory Optimization
Inventory Planning
Inventory Position
Lead Time
Lead-time Accuracy
Lead Time For Forecasting
Lead Time For Inventory
Lead Time For Ordering
Open-to-buy Software
Overstocked Inventory
Safety Stock Calculation
Understocked Inventory
denver
|
boulder
|
fort collins
|
raleigh
|
© 2021 Dash Applications LLC. All Rights Reserved.
|