Home›Query Library›Amazon

Are you winning the buy box on your most important ASINs?

Buy box percentage is one of the strongest predictors of Amazon sales velocity. This query pulls it from your Sales & Traffic data and ranks your ASINs by buy box performance.

📊 Amazon Seller Central👥 Amazon FBA sellers🔤 Plain-English → SQL

The question

Show me buy box percentage by ASIN for the last 30 days, ranked worst to best

↓

The SQL Taptic generates

Amazon Buy Box Percentage by ASIN — generated by Taptic Data AI

SELECT
  asin,
  ROUND(AVG(buy_box_percentage) * 100, 2)  AS avg_buy_box_pct,
  SUM(units_ordered)                        AS units_ordered,
  ROUND(SUM(ordered_product_sales_amount), 2) AS revenue,
  COUNT(DISTINCT date)                      AS days_tracked
FROM amazon_sales_traffic
WHERE date::date >= CURRENT_DATE - INTERVAL '30 days'
  AND buy_box_percentage IS NOT NULL
  AND asin IS NOT NULL
GROUP BY asin
HAVING COUNT(DISTINCT date) >= 7
ORDER BY avg_buy_box_pct ASC
LIMIT 50

Schema-aware SQL generated from plain English14 lines

This query was generated by Taptic Data from plain English against a real Amazon Seller Central schema. In Taptic, you type the question — the AI writes the SQL, runs it, and returns the result. You can edit the SQL, ask for explanations, and save it as a refreshable report.

How this query works

Breaking it down line by line

Reads from amazon_sales_traffic which contains daily ASIN-level performance metrics from the Business Reports API
Averages buy_box_percentage across days and multiplies by 100 for percentage display
HAVING clause filters to ASINs with at least 7 days of data — removes noise from newly listed products
Orders ascending (lowest buy box first) so your most at-risk ASINs appear at the top
Includes revenue and units to help you prioritize which low-buy-box ASINs matter most

What it returns

Result description

A ranked table of ASINs with their average buy box percentage, units ordered, revenue, and days tracked — sorted worst-first so you can immediately identify and act on at-risk listings.

Why it matters

The business impact

Winning the buy box is the difference between making sales and watching a competitor make them on your own listing. Amazon's algorithm weights price, fulfillment speed, and seller metrics. A sudden drop in buy box % is an early warning signal that requires immediate investigation.

Generate this automatically

Skip the SQL. Ask the question.

In Taptic Data, you type "Show me buy box percentage by ASIN for the last 30 days, ran..." and this SQL runs automatically against your real Amazon Seller Central data.

Try Taptic Free — $29.99/mo

No credit card required. Connect your data source in under 5 minutes.