Scope:
Monitoring product details of products with Sponsored Product Ad campaigns and identifying product issues.
Frequency of data collection and aggregation of provided data:
Based on daily data collection, the Product Insights Report provides monthly aggregated data (aggregated month-to-date for the current month).
- Data Collection: Daily
- Aggregation: Monthly, month-to-date for the current month
UPDATE: You can reach a special Product Development View (on a daily level) by right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History - Data update in reporting tool: Daily
 | Tips & Tricks |
| By right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History, you can reach a special Product Development View (daily level). Please find below the Use Cases where this feature is helpful. |
You will reach a Tab with General Product Information, Campaign KPIs, as well as the development of several product KPIs over the last 30 or 90 days (default: 30, you can switch it via the buttons on the top right corner).
The Product Insights Report can help you to identify performance issues of products using the following KPIs:
- Low conversion rate
- High ACoS/TACoS Ratio
The Product Insights Report gives the possibility to easily identify products with a performance issue. They either generate only a few or no conversions or have a rather high ACoS/TACoS Ratio. The first case means that customers click on the campaign but do not want to buy the product. In the second case, we cannot achieve the desired performance.
The Product Insights Report provides information, which can be helpful to identify possible reasons for performance issues:
- Buybox & Availability
- Content
- Reviews & Ratings
- Pricing
- Ranking
- Other reasons
1. Buybox & Availability
The Product Insights Report allows you to conveniently identify ASINs with availability & Buybox issues, useful KPIs, therefore, are "Availability", "Availability Rate", "Buybox Owner" & "Buybox Owner Rate". You can see the availability rate of ASINs for the selected month. Furthermore, you can see who currently owns the Buybox and the "Buybox Owner Rate" tells you for which percentage of observations Amazon has held the Buybox for the ASIN.
 | By right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History, you can reach a special Product Development View (daily level) |
Development Buybox Price
Shows the development of the Buybox Price and ownership over the last 30/90 days.
green: amazon owned the Buybox
red: amazon did not own the Buybox
Buybox Information
Shows the Highest, Average, and Lowest Buybox price over the last 30/90 days
2. Content
The Product Insights Report contains an overview of content-related KPIs, which can be used to quickly identify issues:
- Number of bullet points & the length
- Description [yes/no] & Description length
- A+ Content [yes/no]
- Number of images
- Number of videos
These content KPIs can indicate whether a product page is attractive for a customer or not. Appealing product pages have a significant influence on the customer's purchasing probability.
According to our best practices, we recommend having at least three bullet points, two images, a product description, and A+ Content.
3. Reviews & Rating
Reviews & ratings have a powerful influence on purchase decisions. Bad reviews and ratings or no reviews and ratings might deter customers from purchasing a product. The Product Insights Report gives an overview of the number of reviews and the rating per product, which allows you to see at one glance which products are having issues and room for improvement. A product should ideally have at least 20 reviews and not less than 3.5 stars.
 | By right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History, you can reach a special Product Development View (daily level) |
Development of Ratings and Star Rating
Shows the development of the number of Reviews and the Star Rating over the last 30/90 days:
Ratings Information
Shows the latest Star Rating and the latest number of reviews.
4. Pricing
The Product Insights Report can help you with analyzing pricing information for your products using the following KPIs:
Ad ASP/Buybox Price Ratio
Substitutes & their prices
The Ad ASP/Buybox Price Ratio compares the Buybox price and Average Sales Price (ASP). At a value of 100%, the Buybox price is exactly the same as the ASP. Since Amazon delivers the BuyBox price in gross, but the ASP in net, a certain deviation is to be expected (consider country-/product-specific taxes). Values above 130% or below 70% may indicate that customers did not buy the advertised product, but another product of the same brand and category.
Additionally, you can find information about substitute products displayed on the Amazon product detail page, including information about the ASIN, its brand, and its Buybox price. This information helps you to identify which products are considered direct substitutes for your product by Amazon. The substitute could either be your own product or a competitor's product.
 | By right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History, you can reach a special Product Development View (daily level) |
Buybox Information
Shows the Highest, Average, and Lowest Buybox price over the last 30/90 days.
5. Bestseller Ranking
The Amazon bestseller rank (or sales rank) of a product is an important indicator in terms of product performance. It indicates how well the product is selling compared to all other products in the same category. The rank represents all sales of a product, i.e. organic and paid, and the better the sales rank, the better usually is a product's organic visibility. The monitoring of the changes in the bestseller rankings of your products helps you to understand if certain marketing activities have a sustainable impact on your product sales.
And, if a product has a “Bestseller” badge in its category (rank = 1) sales increases because customers trust that this is a quality characteristic.
 | By right-clicking on any Line in the Product Insights Table and selecting Drillthrough → see History, you can reach a special Product Development View (daily level) |
Development of Category Ranks
Shows the development of the Product’s Category Rank(s) over the last 30/90 days. All Categories of the Product are shown.
Category Information
Shows the name of, and the rank in the Category, in which the product held the highest rank in the selected time period. Also shows the worst rank in the selected time period of this category.
6. Other reasons
Other reasons for performance issues that can be identified with the help of the Product Insights Report are:
- Restricted buying options (e.g. plus products, Prime exclusive, pantry). These products are not suitable for advertising or are only available for a subsegment of consumers (e.g. Prime members).
- Identifying variations of a product becomes easier with the integration of the respective parent ASIN. This supports you in managing your advertised product portfolio more efficiently.
- Missing product pages
Filters
Value | Description |
|---|---|
Country | Amazon country (de, es, it, fr, gb, us) |
| Currency | Local currency of the respective Amazon country |
Month | Choose a month to see the aggregated data for that month. If no month is selected data will be displayed for the whole period [yyyy-mm] |
Amazon State | Enabled, campaign paused, campaign archived, campaign out of budget, account out of budget, portfolio out of budget, advertiser payment failure (state_reason) |
Entity | Entity name as defined in the metoda Campaign Manager |
| Campaign Tags | As defined by the customer for filtering options in Ad Optimizer Campaign Manager |
Category | As defined by the customer for filtering options in Ad Optimizer Campaign Manager |
| Product Name (ASIN) | Amazon Product title and ASIN of product |
Start Date | Start date of SPA campaign |
| CR | Conversion Rate [Conversions/clicks] |
| ACoS/TACoS Ratio (Ad Performance Ratio) | Ratio of ACoS and TACoS to identify deviations more easily; [ACoS/TACoS] |
| Product Page | Flags products for which no offer page was found on Amazon for the last 3 days of current month [yes/no] |
Description of column names/values and color codes
Value | Type | Description | Colour Code |
ASIN | Alphanumeric character | Amazon product ID of promoted ASIN (Sponsored Product Ads (SPA) only) | |
SKU | Alphanumeric character | Stock keeping unit (only necessary for sellers) | |
| Parent ASIN | Alphanumeric character | Different variants of a product (e.g. colors, sizes, etc.) can be grouped together under a parent ASIN. The parent ASIN does not refer to a physical product, but only links the individual product variants (child ASINs) to a product group. | |
Product Name | Text | Last observed product name by year-month | |
Brand | Text | Last observed brand name by year-month | |
Product URL | Image (text in mouseover) | URL to amazon product page | |
Start of Campaign | Date yyyy-mm-dd | Start date of the first campaign for promoted ASIN | |
Month | Date yyyy-mm | Observed month as year-month | |
Target State | Text | The state a campaign should have at a given time. In comparison with the "Amazon State" it helps identifying campaigns that should run but do not. (enabled, disabled, upcoming) | green: Target State and Amazon State “enabled”;
orange: Target State “enabled” and Amazon State “other”;
red: Target State “enabled” and Amazon State “campaign paused”, “portfolio out of budget”, “advertiser payment failure”, etc.;
red: Target State “disabled” and Amazon State “enabled”;
grey: Target State “disabled” and Amazon State not “enabled” or both "upcoming". |
| Amazon State | Text | State reason as stated in Amazon Advertising (enabled, campaign paused, campaign archived, campaign out of budget, account out of budget, portfolio out of budget, advertiser payment failure, upcoming (state_reason)) | see above |
TACoS | Percentage | Last target ACoS for promoted ASIN by year-month | |
ACoS | Percentage | Mean of costs/revenue of all SP campaigns for promoted ASIN by year-month; NA if revenue = 0 | |
ACoS/TACoS Ratio (Ad Performance Ratio) | Decimal | Ratio of ACoS and TACoS; ACoS/TACoS | |
CR | Percentage | Conversions/clicks; NA if clicks = 0 | red: CR < 2% yellow: 2% < CR < 5% |
CTR | Percentage | Clicks/impressions; NA if impressions = 0 | |
Costs | Decimal | Sum of all monthly costs generated by SPA campaigns of promoted ASINs | |
Revenue | Decimal | Sum of monthly revenue generated by SPA campaigns of promoted ASINs | |
Impressions | Number | Sum of monthly revenue generated by SPA campaigns of promoted ASINs | |
Clicks | Number | Sum of monthly clicks generated by SPA campaigns of promoted ASINs | |
Conversions | Number | Sum of monthly conversions generated by SPA campaigns of promoted ASINs | |
CPC | Decimal | Costs/clicks; NA if clicks=0 | |
Buybox Price (gross) | Decimal | Mean Buybox Price (gross) of all observations of a month by year-month | |
Ad ASP (net) | Decimal | Average sales price (net) generated by sales from related campaign. revenue/conversions; NA if conversions = 0 | |
Ad ASP/Buybox Price Ratio | Decimal | Ratio of Ad ASP and Buybox Price; ASP/Buybox_price | |
Reviews | Number | Last observed count of reviews on Amazon product page for promoted ASIN by year-month | red: Reviews = 0; yellow: 1-20; green: >20 |
Rating | Decimal | Last observed count of ratings on Amazon product page for promoted ASIN by year-month | red: Ratings ≤3; yellow: 3 < Ratings <3,5 green: Ratings ≥3,5 |
Images | Number | Last observed count of images on Amazon product page for promoted ASIN by year-month | red: Images ≤2; |
Videos | Number | Last observed count of videos on Amazon product page for promoted ASIN by year-month | red: Videos = 0; |
Bullet Points | Number | Last observed count of bullet points on Amazon product page for promoted ASIN by year-month | |
Bullet Points Length | Number | Last observed sum of the character count of all bullet points on Amazon product page for promoted ASIN by year-month | |
Description | Text | Last observed status (yes/no) if a product description is available on Amazon product page for promoted ASIN by year-month | |
Description Length | Number | Last observed sum of the character count of the product description on Amazon product page for promoted ASIN by year-month | |
A+ Content | Text | Last observed status (yes/no) if A+ content is available on Amazon product page for promoted ASIN by year-month | |
Restricted Buying Options | Text | Text of "Plus Product", "Prime Exclusive", "Pantry" or empty if no restrictions | |
FBA | Text | Fulfilled by Amazon; Last observed status as displayed on Amazon product page; (yes/no) | |
Availability | Text | Last observed availability status as text | |
Availability rate | Percentage | Percentage of status "Available" of all observed availability information for promoted ASIN by year-month | |
Buybox Owner | Text | Last observed Buybox owner | |
Buybox Owner Rate (Amazon) | Percentage | Percentage of Amazon as Buybox owner over all observations (over all obersvations does not necessarily mean every day in the month, but only observable ones) | |
Amazon Offer | Text | Last observed status if Amazon offers this product yes/no (Amazon does not need to be the Buybox Owner to have Amazon Offer status "yes") | |
Amazon Offer Rate | Percentage | Percentage of Amazon Offer status "yes" of all observed data points for promoted ASIN by year-month (over all obeserved data points does not necessarily mean every day in the month, but only observable ones) | |
| Amazon Category 1 | Text | Amazon bestseller category your promoted ASIN is listed in (as displayed on Product Details Page | |
| First listed on Amazon | yyyy-mm-dd | Shows the initial listing date of an ASIN on Amazon. This allows you to distinguish between new and established products. | |
| Amazon Main Category | Text | Amazon main category your promoted ASIN is listed in (as displayed on Product Details Page) | |
| Rank (Main Category) | Number | Last observed rank of your ASIN in this Amazon main category | |
| Amazon Category 1 | Text | Amazon bestseller category your promoted ASIN is listed in (as displayed on Product Details Page) | |
| Rank (Category 1) | Number | Last observed rank of your ASIN in this Amazon bestseller category | |
| Amazon Category 2 | Text | Amazon bestseller category your promoted ASIN is listed in (as displayed on Product Details Page) | |
| Rank (Category 2) | Number | Last observed rank of your ASIN in this Amazon bestseller category | |
| Amazon Category 3 | Text | Amazon bestseller category your promoted ASIN is listed in (as displayed on Product Details Page) | |
| Rank (Category 3) | Number | Last observed rank of your ASIN in this Amazon bestseller category | |
Substitute 1 | Last observed substitutes ASIN by year-month | ||
Brand (Sub 1) | Text | Brand name of substitutes ASIN | |
Buybox Price (Sub 1) | Decimal | Mean of all observations of a month by year-month | |
Substitute 2 | Last observed substitutes ASIN by year-month | ||
Brand (Sub 2) | Text | Brand name of substitutes ASIN | |
Buybox Price (Sub 2) | Decimal | Mean of all observations of a month by year-month | |
Substitute 3 | Last observed substitutes ASIN by year_month | ||
Brand (Sub 3) | Text | Brand name of substitutes ASIN | |
Buybox Price (Sub 3) | Decimal | Mean of all observations of a month by year-month | |
Substitute 4 | Last observed substitutes ASIN by year-month | ||
Brand (Sub 4) | Text | Brand name of substitutes ASIN | |
Buybox Price (Sub 4) | Decimal | Mean of all observations of a month by year-month | |
Entity | Text | Entity name | |
Currency | Text | 3-character currency code | |
Country | Text | 2 character country code of sourced data point | |
Campaign Tags | Text | As defined by customer | |
Category | Text | As defined by customer | |
Product Page | Text | Flags products for which no offer page was found on Amazon for the last 3 days of current month (yes/no) |