ASINs at risk of losing the Prime badge - sortable table with current OTD vs SFP threshold. Each row = a Buy Box loss waiting to happen.
At a glance
Per-ASIN view of Prime-promised on-time delivery rate, joined to Amazon listing data. Each row is one ASIN with current 30-day Prime OTD; sorted ascending so worst-performing rises to top. Rows below 99% are at SFP eligibility risk; rows below 96% are likely candidates for badge revocation. The card is the per-product diagnostic that goes underneath the seller-account-wide SFP eligibility number.
| What it counts | GROUP BY amazon_prime_shipping.shipment.asin COMPUTE otd_pct WHERE otd_pct < 99 JOIN amazon.listing ON asin over rolling 30 days. ASINs with sufficient sample (typically >20 shipments in 30D) included; low-volume ASINs filtered out for noise. |
| Required Amazon sibling | has_amazon_sibling. Card requires an Amazon connector (Seller Central or Vendor Central) for the listing-side data join. |
| Why ASIN-level matters | Amazon’s SFP eligibility scoring is at the seller-account level, but listing-level performance varies materially. A heavy SKU shipping from a single warehouse to East Coast may run 99.5%; a rural-customer-skewed SKU may run 96%. Account-wide dilution masks this; the per-ASIN view exposes it. |
| Buy Box loss correlation | Below 99% Prime OTD on an ASIN, Amazon’s Buy Box algorithm starts deprioritising the listing within 7 to 14 days. Each ASIN row in the table is a future Buy Box loss; the card surfaces them before the loss happens. |
| Service level scope | Prime-eligible 1-Day / 2-Day / Same-Day. |
| Time window | 30D |
| Alert trigger | any ASIN <99% OTD. Card alerts on the existence of any below-threshold ASIN; the table content is the diagnostic. |
| Roles | owner, operations, marketing |
Calculation
Calculated automatically from your Amazon Prime Shipping (SFP) data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US small-appliance merchant. Reading at 09:00 ET on 12 Mar 26 for the trailing 30 days.| ASIN | Listing | Prime shipments (30D) | Prime OTD | Buy Box risk |
|---|---|---|---|---|
| B07XYZ1234 | Kitchen blender, $89 | 380 | 94.2% | High - dropping out of Buy Box, est. 32% of shipments to rural ZIPs via USPS Priority |
| B07ABC5678 | Coffee grinder, $72 | 220 | 95.8% | High - similar rural-USPS profile |
| B08DEF9012 | Stand mixer, $189 | 145 | 97.1% | Medium - on warning list |
| B07GHI3456 | Hand mixer, $45 | 510 | 98.9% | Medium - just below 99% |
| B07JKL7890 | Food scale, $25 | 720 | 99.4% | OK |
| (38 ASINs above 99% OTD, omitted) | OK |
amazon_prime_sfp_otd_sla). Five things to notice:
- Two ASINs (B07XYZ1234 and B07ABC5678) account for ~70% of the seller-account-wide miss volume. Concentration matters: fixing two SKUs lifts the whole account toward 99%.
- Both worst-performing ASINs share the rural-USPS-Priority cohort. The fix is product-level: opt these ASINs out of Prime eligibility for rural ZIPs (in Seller Central → ASIN-level Prime settings if available, or globally for the seller account). Customers in those ZIPs see the listing without Prime; conversion drops on those orders but the account-wide Prime badge is preserved.
- B08DEF9012 (stand mixer) at 97.1% is the medium-risk SKU. Larger / heavier items run higher exception rates and are more carrier-mis-handled. Consider double-walled packaging or signature-required upgrades for this cohort.
- B07GHI3456 (hand mixer) at 98.9% is on the cusp. One bad week pushes it below 99%; pre-emptive monitoring required.
- The 38 ASINs above 99% are doing fine. Account-wide remediation should focus on the 4 problematic ASINs, not blanket-tighten all SKUs. The card surfaces the actionable cohort.
Sibling cards merchants should reference together
Per-ASIN view connects to listing-side data and Buy Box dynamics. Pair with these:| Card | Why pair it with SFP Eligibility by ASIN | What the combination tells you |
|---|---|---|
| SFP On-Time Delivery vs 99% Threshold | Account-wide SFP eligibility. | This card explains the account-wide number by exposing the ASIN concentration. |
| Late-Shipment Buy Box Loss | The financial-impact estimate for late-OTD-driven Buy Box loss. | Per-ASIN Buy Box loss is a function of per-ASIN Prime OTD; combine for SKU-level revenue at risk. |
| Prime 1-Day / 2-Day Promise Miss Rate | 7-day leading indicator. | When this card alerts, drill in to identify which ASINs are dragging. |
Cross-connector: amazon.buy_box_win_rate | Direct Amazon-side metric. | Compare per-ASIN Buy Box win rate against this card’s per-ASIN Prime OTD; correlation should be strong. |
Cross-connector: amazon.listing_inventory | Per-ASIN inventory. | Stock-out + Prime-OTD-risk = double trouble for Buy Box. |
Cross-connector: amazon.az_concessions | Per-ASIN Concession costs. | High-Concession ASINs typically map to high-Prime-miss ASINs. |
Reconciling against the vendor’s own dashboard
Where to look in Amazon Seller Central: Seller Central does not natively offer per-ASIN Prime OTD breakdown in a single dashboard view. Closest: Performance → Shipping Performance, drill into individual ASINs via the order-history reports. Most sellers manually export and pivot in spreadsheets. This card is the automated equivalent. Why our number may legitimately differ:| Reason | Direction | Why |
|---|---|---|
| Sample size threshold | Either | Card filters out low-volume ASINs (typically <20 30D shipments) for noise reduction. Manual analysis may include them. |
| Time zone | Boundary | UK/US merchants typically connect timezone-matched. |
| Listing-data join freshness | Ours <1 hour behind | Amazon listing data refreshes hourly via SP-API. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
amazon.buy_box_win_rate | Per-ASIN Buy Box. | Buy Box affected by price, stock, seller rating in addition to Prime OTD. |