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.
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.
Account-wide Prime OTD: 96.3% (matches
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: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:
Cross-connector reconciliation: