Extract a Story from the ASIN Report

Creating and analyzing standardized reports is a standard, good practice for any advertising or sales channel – and this is especially true for Amazon.

The approach defined here by Pat Petriello, Senior Marketplace Strategist at CPC Strategy is intended to guide sellers from taking an ASIN Report and efficiently analyzing it for meaningful takeaways.


What to look for in the ASIN Report:

“What we are looking for here are both recent trends and historical precedent. We also want to see how the most recent week compares to the average week over the last 2 months,” Petriello said.

  • Ordered Product Sales – This is an output metric because all of the buyability and discoverability levers marketers are pulling – ultimately intended to increase revenue. Specifically, businesses will want to identify whether this number is trending up or down over the previous week or weeks.
  • Sessions – The next place businesses will want to look is at their sessions. Sessions are the primary measure of discoverability and often provide insight into overall account performance. If all other variables are held constant, driving up sessions will typically produce an increase in revenue.


Questions sellers should ask if sessions are down

  • Has the average offer count gone down?
  • Have top products gone out of stock?
  • Did you make any changes to Sponsored Products in the time frame where sessions dropped?
  • Are there a key handful of products driving Sponsored Products performance which are facing heavy competition for the buy box?


The ASIN Report Approach:

1. Check for the current inventory levels for top selling products.

According to Petriello, “No matter what efforts we take with Sponsored Products, content, catalog structure, title optimization, and FBA recommendations, it won’t matter if the seller doesn’t have inventory to sell.”

Example: The screenshot below indicates that 5 of the 10 top best selling products over the last 60 days currently have no stock available. Where sellers will expect to see the impact of this condition is in weekly revenue and sales. They can also use this to project when potential dips might be coming as top selling products are at risk for selling out.

Amazon reports

2. You also want to look to see how heavily leveraged the seller is on a handful of ASINs.

Example: Below the top ASIN generated more revenue in the same time frame than did the 3 next best selling products combined. This indicates that not all ASINs are equal within a seller’s catalog. While the sellers approach is to give every product a chance to succeed, small changes in the performance of an ASIN which has a massive impact on the total account performance will overshadow more significant performance changes for ASINs that are not as strong.


3. Sellers should look at the buy box ownership for the ASINs driving channel performance.

One of the main drivers for channel performance is how much buy box they own for the ASINs which are most important to the channel. This also drives their strategic approach.


Extracting a Story Through Discoverability and Buyability

The key to interpreting reports is the output of the combined effects of discoverability and buyability factors such as:

Discoverability Metrics

  • Sessions
  • Average offer count


Buyability Metrics

  • Sales
  • Average sales per order
  • Average selling price
  • Buy Box Percentage
  • Average offer count


“For example, if a seller’s revenue is decreasing steadily over the last few weeks, and they see that sessions are also decreasing, they know they need to focus on their buyability levers to stabilize and grow the account, ” Petriello said.

“It’s important to remember that the data tells sellers where they are strong, where they are weak, what is working, what needs immediate attention, and what needs long term focus.”


Get the latest digital marketing insights and trends delivered straight to your inbox.

*By submitting your Email Address, you are agreeing to all conditions of our Privacy Policy.