When we notice a drop in product performance, the first questions that come to mind are:
- What’s causing this decline?
- Is the demand dropping?
- Am I losing traffic for any of my main keywords?
- Has my conversion rate dropped for any of my main keywords?
You can find answers to these questions by analyzing the SQP Report.
To get accurate insights, it’s important to analyze multiple variations under a parent ASIN (if applicable) and compare data from at least two time periods: one when the product was performing well and another when the performance dropped.
To clearly identify which keywords are causing the decline, all the relevant data needs to be brought into one place.
That’s why I created this template. It brings together the most important data from your ASIN-level SQP Reports into a single sheet, allowing you to see:
- Your most important keywords
- Key metrics for these keywords (search volumes, clicks, and purchases) across both time periods
- Detailed data at the ASIN level for each period, focusing on the two most important metrics: number of clicks and purchases generated by each keyword
- A summary of data for the analyzed variations (referred to as “Parent Level”)
Here is the link to the template:
For a more detailed guide on how it works, check out this YouTube video: