What this audit checks
Authentication & access
- LWA refresh_token still issues access_tokens (no 401)
- Token cache hit-rate > 95%
- Marketplace ID maps to a region with SFP enabled
- Seller ID has Prime-Shipping role granted
SFP eligibility threshold (the eligibility-defining area)
- 30-day SFP OTD < 99% (Prime-badge revocation risk)
- 30-day Prime 1-day promise miss rate > 1%
- 30-day Prime 2-day promise miss rate > 1%
- Cancellation rate > 0.5% (SFP threshold)
- Late-shipment rate > 4% (SFP secondary metric)
Per-ASIN SFP performance
- Any ASIN-level OTD < 99% rolling 30D (Prime badge at risk for that ASIN)
- ASIN-level cancellation > 1%
- Top-revenue ASINs SFP-eligibility status (priority focus)
Exceptions, claims & failed pickups
- Exception rate > 3% rolling 30D
- Open claims unresolved > 14 days (Amazon A-to-z claim window)
- Wrong-address rate > 1% (data-quality signal)
- Refused-parcel rate > 1%
Cost & service-mix economics
- Avg cost / shipment up >10% vs prior period
- SFP cost per order vs FBA equivalent (when both used) -> economic case
- Same-day / scheduled-delivery uplift > 50% over 2-day
- Claim value as % of SFP revenue > 2% rolling 90D
Cross-channel: revenue at risk (the kill-shot area)
- Cross-channel: ASINs at SFP eligibility risk -> Buy Box loss exposure (amazon.listing.revenue)
- Cross-channel: late SFP shipments triggering Buy Box flips on those ASINs
- Cross-channel: A-to-z claims with no Jira tracker_item -> CS coverage gap
- Cross-channel: SFP-to-FBA migration candidates (ASINs with chronic SFP OTD < 99%)
- Cross-channel: late-delivery refund-propensity * sibling.order.total
Severity thresholds
| Signal | Warn | Critical |
|---|---|---|
on_time_delivery_rate | 99.5 | 99 |
prime_one_day_miss_pct | 0.5 | 1 |
prime_two_day_miss_pct | 0.5 | 1 |
cancellation_rate_pct | 0.3 | 0.5 |
late_shipment_rate_pct | 2 | 4 |
exception_rate | 2 | 3 |
open_claims_age_days | 7 | 14 |
wrong_address_rate_pct | 0.5 | 1 |
shipping_cost_per_order_change_pct | 5 | 10 |
same_day_uplift_pct | 30 | 50 |
claim_value_pct_of_revenue | 1 | 2 |
asin_otd_pct | 99.5 | 99 |
auth_token_failures_24h | 1 | 5 |
Data sources
POST TBD - pending CloudHub C# backend URL extraction- LWA token refreshGET TBD - pending CloudHub C# backend URL extraction- Shipment list + SFP performanceGET TBD - pending CloudHub C# backend URL extraction- Account-health metrics for SFP eligibility