Top Search Terms by ASIN

Table Name: brand_search_terms_by_asin

The Brand Analytics Top Search Terms table helps brand-registered vendors and sellers see their share of clicks and conversions by ASIN by search term. You provide an ASIN, and Amazon provides the top search terms where your ASIN was one of the top 3 products. It is mainly used for keyword research and competitive monitoring.

Business questions & scenarios

What is this data useful for?

• Search trends: How are this item’s top search terms changing over time? What terms are becoming less relevant?
• Competitive monitoring: What brands earn the most clicks on my terms? What terms do my competitors’ products rank for and how do they perform?
• Conversion opportunities: For what term/ASIN combinations do we have high click share, but low conversion share?
• Retail Media: What terms should we spend more money on? To promote which ASINs?

Schema & update details

Historical data & change management

We perform a historical backfill when you subscribe. ASINs may be changed once per month. Newly-added ASINs will begin receiving weekly updates.

Data dictionary: fields in this table

Table & data nuances

• Amazon will provide data for any ASIN, not just ones registered to your brand.
• “Search Frequency Rank” (search_frequency_rank) shows how common the search term is for all of Amazon, not a specific ASIN.
• Unlike Search Query Performance, this data set includes relative data (rank, share) instead of actuals.
• Amazon provides

How to query this table

The example query below will provide all available weekly data for your account.

1. Change ‘WEEKLY’ in the where clause to ‘MONTHLY’ if needed.
2. To filter to a particular ASIN, add a filter to the where clause, e.g. and custom__search_asin = 'B123456789’

SELECT 
    _partneruuid,
    date,
    period,
    search_term,
    search_frequency_rank,
    no1_clicked_brand,
    no2_clicked_brand,
    no3_clicked_brand,
    no1_clicked_category,
    no2_clicked_category,
    no3_clicked_category,
    no1_clicked_asin,
    no1_product_title,
    no1_click_share,
    no1_conversion_share,
    no2_clicked_asin,
    no2_product_title,
    no2_click_share,
    no2_conversion_share,
    no3_clicked_asin,
    no3_product_title,
    no3_click_share,
    no3_conversion_share
   FROM brand_search_terms_asin
	
-- change period to MONTHLY below for monthly data
	where period = 'WEEKLY'

Example query output

On this page

• Business questions & scenarios
• Schema & update details
• Historical data & change management
• Data dictionary: fields in this table
• Table & data nuances
• How to query this table
• Example query output
• Related pages

Related pages

Search Query Performance by Brand (Seller Only)

Search Query Performance by ASIN (Seller Only)

Search Catalog Performance (sellers only)