How to Use Restock Report to Analyze the Ad Account
Who is this for?
Individuals dealing with Amazon accounts that have more than 100 ASINs in the catalog.
Objective:
The objective of this document is to identify ASINs that generate substantial organic FBA sales but have not been advertised yet, and those that have been advertised but currently do not have available FBA stock.
Instructions:
Note:
The restock reports from Amazon exclusively feature FBA SKUs, and we endeavor to prioritize advertising for these SKUs to optimize our ad performance wherever feasible.
Steps:
- Download the Restock Report
- To reach the Restock Report, log in to the account and click this link
- Download the Advertised Product Report
- To reach the Advertised Product Report, log in to the account and click this link
- Select "Report type" as "Advertised product" and click "Run report"
- To find out the ASINs that have been advertised but don’t have active FBA stock:
- Use VLOOKUP on your Advertised Product ASINs and get the “Available” column from Restock Report to find out if you have stock or not
The ASINs that have high organic FBA sales but are not being advertised
- Download the last x days of sales report from the Seller Central > Reports
Copy all the advertised ASINs from Advertised Product Report. Copy all the ASINs that have FBA sales. Then using a VLOOKUP, find out the ASINs that are not advertised but have FBA stock. Now you can also VLOOKUP the organic sales of this ASIN from Business Sales Report to find out which has the highest organic sales to prioritize your campaign creation strategy.
Below you can find an example Excel file that is generated. You can check the reports, formulas, and structure there.
