Table Name: brand_search_query_performance_by_asin
The Search Query Performance by ASIN table lists the top product search queries that led customers to one of your products (ASINs). It includes overall query performance, such as impressions, clicks, cart adds, and purchase for each query, and your brand’s share of that performance.
This report is currently only available for Sellers who are brand registered.
Amazon provides two versions of this table: brand-level and ASIN-level.
- The brand-level table summarizes search query performance for your entire catalog. It is useful for measuring your brand’s total search performance and identifying opportunities across your catalog.
- The ASIN-level table breaks down search query performance for an individual ASIN. It is useful for deep diving performance for key items, and comparing item-level performance to brand-level.
Business questions & scenarios
What is this data useful for?
- Business performance review: Diagnose traffic changes / did search query volume change for my main terms?
- Retail Media: What terms should we spend more money on? To promote which ASINs?
- Retail Media: How to find what is organic vs. paid in terms of what is driven by clicks?
- Search trends: How are this item’s top search terms changing over time?
- Market share: What is my share of voice for top terms for an ASIN? How does it compare to my total brand share of voice for the same terms?
Schema & update details
UI Report path | |
Amazon update frequency | Weekly, with up to 24-48 hour latency
Monthly, with up to 24-48 hour latency |
Reason update frequency | Weekly
Monthly |
Granularity [?] | 1 row per:
- snapshot_date
- period
- custom_asin
- search_query |
Historical data & change management
Time Period | WEEKLY | MONTHLY |
History available from Amazon | 52 weeks | 12 months |
Reason lookback period | 1 week | 1 month |
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
- “Search Query Score” (
rank
) is not a useful field because it is relative to the specific ASIN you use, and it’s not clear what criteria Amazon uses to determine the score. - Data is available for ASINs for your brand that are not sold by your Seller account. In other words, you can monitor search query performance for ASINs under your brand code even if you do not have a listing on the ASIN.
- Our workflow gets all columns, including shipping speeds, that are not available by default in the UI
How to query this table
When querying this table, avoid duplicate data by always filtering to either WEEKLY or MONTHLY period, and pulling only data for the most recent snapshot_date. The example query below will provide the most recent snapshot of search query performance for all monitored ASINs, for the WEEKLY period (change ‘WEEKLY’
in the where clause to ‘MONTHLY’
if needed).
- To filter to a particular ASIN, add a filter to the where clause, e.g.
and custom_asin = 'B123456789’
with maxdate as
(
select max(snapshot_date) as date
from public.brand_search_query_performance_by_asin
)
select
_partneruuid,
snapshot_date,
period,
custom_asin,
search_query,
rank,
search_query_volume,
total_impressions,
impressions_asin_count,
impressions_asin_share,
total_clicks,
clicks_click_rate,
clicks_asin_count,
clicks_asin_share,
clicks_median_price,
clicks_median_asin_price,
same_day_shipping_speed_clicks,
one_day_shipping_speed_clicks,
two_day_shipping_speed_clicks,
cart_adds_add_rate,
total_cart_adds,
cart_adds_asin_count,
cart_adds_asin_share,
cart_adds_median_price,
cart_adds_median_asin_price,
same_day_shipping_speed_cart_adds,
one_day_shipping_speed_cart_adds,
two_day_shipping_speed_cart_adds,
total_purchases,
purchase_rate,
purchases_asin_count,
purchases_asin_share,
purchases_median_price,
purchases_median_asin_price,
same_day_shipping_speed_purchases,
one_day_shipping_speed_purchases,
two_day_shipping_speed_purchases
from public.brand_search_query_performance_by_asin
where
snapshot_date = (select date from maxdate)
-- change period to MONTHLY below for monthly data
and period = 'WEEKLY'
Example query output
_partneruuid | snapshot_date | period | custom_asin | search_query | rank | search_query_volume | total_impressions | impressions_asin_count | impressions_asin_share | total_clicks | clicks_click_rate | clicks_asin_count | clicks_asin_share | clicks_median_price | clicks_median_asin_price | same_day_shipping_speed_clicks | one_day_shipping_speed_clicks | two_day_shipping_speed_clicks | cart_adds_add_rate | total_cart_adds | cart_adds_asin_count | cart_adds_asin_share | cart_adds_median_price | cart_adds_median_asin_price | same_day_shipping_speed_cart_adds | one_day_shipping_speed_cart_adds | two_day_shipping_speed_cart_adds | total_purchases | purchase_rate | purchases_asin_count | purchases_asin_share | purchases_median_price | purchases_median_asin_price | same_day_shipping_speed_purchases | one_day_shipping_speed_purchases | two_day_shipping_speed_purchases |
12345abcde | 3/3/2024 0:00 | WEEKLY | B0123456678 | camp chair | 63 | 345 | 7795 | 50 | 0.64 | 171 | 49.57 | 3 | 1.75 | 34.99 | 52.19 | 10 | 90 | 39 | 4.35 | 15 | 1 | 6.67 | 34.99 | 52.19 | 3 | 4 | 3 | 5 | 1.45 | 1 | 20 | 29.99 | 52.19 | 1 | 1 | 1 |
12345abcde | 3/3/2024 0:00 | WEEKLY | B0123456678 | comfortable camp chair | 56 | 242 | 5257 | 166 | 3.16 | 106 | 43.8 | 3 | 2.83 | 43.9 | 52.19 | 11 | 51 | 31 | 3.72 | 9 | 1 | 11.11 | 52.19 | 52.19 | 1 | 5 | 2 | 2 | 0.83 | 1 | 50 | 52.19 | 52.19 | 1 | 1 | 0 |
12345abcde | 3/3/2024 0:00 | WEEKLY | B0123456678 | camp chair with cup holder | 41 | 816 | 21087 | 615 | 2.92 | 438 | 53.68 | 14 | 3.2 | 39.99 | 52.19 | 41 | 182 | 139 | 4.29 | 35 | 2 | 5.71 | 39.99 | 52.19 | 4 | 18 | 9 | 13 | 1.59 | 0 | 0 | 36.19 | 0 | 1 | 7 | 4 |
12345abcde | 3/3/2024 0:00 | WEEKLY | B0123456678 | folding chair | 40 | 8911 | 203342 | 303 | 0.15 | 4252 | 47.72 | 11 | 0.26 | 34.99 | 52.19 | 446 | 1729 | 1192 | 3.4 | 303 | 1 | 0.33 | 34.99 | 52.19 | 35 | 128 | 72 | 72 | 0.81 | 1 | 1.39 | 32.24 | 52.19 | 10 | 40 | 13 |
12345abcde | 3/3/2024 0:00 | WEEKLY | B0123456678 | portable chair | 11 | 1392 | 31291 | 1134 | 3.62 | 781 | 56.11 | 36 | 4.61 | 39.99 | 52.19 | 74 | 379 | 200 | 5.46 | 76 | 4 | 5.26 | 39.99 | 52.19 | 13 | 33 | 18 | 19 | 1.36 | 2 | 10.53 | 39.99 | 52.19 | 2 | 11 | 3 |
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