Sum of (suspended_listings x velocity x ASP) + (failed-upload backlog x avg ASP), recoverable.
At a glance
Live estimate of recoverable Alibris revenue currently blocked by listing-health and feed-pipeline issues. The single number that translates an opaque ops backlog (suspended listings, failed uploads, broken feeds) into a daily money figure for merchants and finance teams.
| What it counts | (suspended_listings x velocity x ASP) + (failed_upload_backlog x avg_ASP). Sums two independent revenue-leak sources: listings hidden from buyers (suspensions/pending review) and listings whose updates haven’t reached Alibris (failed batches). |
| API endpoint + report | Derived. Combines Suspended Listings, Failed Batches (7d), and per-ISBN velocity from the trailing 30 days of orders. Recomputes every 4 hours. |
| ISBN vs account scope | Per-listing. Each suspended listing or failed-upload row contributes individually; the velocity-weighting means high-turn ISBNs dominate the headline figure. |
| Listing-quality impact | Direct. A high revenue-at-risk number means a high share of your active catalogue is operationally blocked, which feeds directly into Listing Quality Score and downstream search rank. |
| Fees / commission | Gross. The headline is gross-of-Alibris-15%-commission. The actual cash recovery is roughly 81% of the figure (after 15% commission and 4% card processing). Most merchants prefer the gross figure as it matches the visible Alibris listing prices. |
| Refunds / cancellations | Not applicable to the calculation. The downstream effect of unresolved suspensions: stockout cancellations on books that ARE active but mismatched can compound the figure. |
| Currency | Settlement currency, FX-normalised. |
| What “recoverable” means | The figure is the revenue that would land if the suspended listings were re-instated and the failed uploads succeeded, holding velocity constant. It’s a 30 to 60-day recoverable estimate, not a one-day-and-done figure. |
| Common composition | (1) Suspended listings cluster drives 40 to 70% of typical figure: pending review, condition-note violations, ISBN mismatches. (2) Failed-batch backlog drives 20 to 40%: rejected outbound files with corrections needed. (3) Stale listings (>180 days no update) drives the residual 5 to 15%: not strictly blocked but low-yield. |
| Multi-marketplace overlap | Per-marketplace. The same operational issue (e.g. ISBN-data malformation) often produces revenue-at-risk on Alibris AND AbeBooks AND Amazon Books simultaneously, but each card sums only its own marketplace exposure. |
| Time window | RT (live, recomputes every 4h). |
| Alert trigger | >$0, every dollar at risk is recoverable revenue. |
| Roles | owner, finance. |
Calculation
Calculated automatically from your Alibris 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 bookseller with 32,100 active Alibris listings, snapshot 01 May 26, settlement currency USD.| Source | Listings / batches | Avg velocity | Avg ASP | Daily revenue blocked | 30-day estimate |
|---|---|---|---|---|---|
| Suspended listings (ISBN mismatch) | 14 | 0.04/day | $18 | $10 | $300 |
| Suspended listings (condition note) | 11 | 0.06/day | $14 | $9 | $270 |
| Pending review (auto-clears) | 8 | 0.03/day | $12 | $3 | $90 |
| Suspended listings (price-drift anti-fraud) | 6 | 0.02/day | $180 | $22 | $660 |
| Failed-batch backlog (7d) | 3 batches, ~340 rows | n/a | $22 | $32 | $960 |
| Total Revenue at Risk (this card) | 35 listings + 3 batches | $76 / day | $2,280 / 30D |
>$0).
Six things to notice that are specific to Alibris and the book trade:
- The 6 price-drift suspensions account for 29% of daily exposure despite being only 17% of suspended count. All 6 are signed first editions priced 80%+ below catalogue median (a repricer mis-firing on rare stock). High-ASP rare books always punch above their weight in this metric; sort the underlying suspended list by ASP descending and treat top-quartile as P0.
- The failed-batch backlog ($960 over 30 days) is the most leverageable single line item. The 3 failed batches collectively contain roughly 340 listing edits awaiting re-submission. Resolving the schema-validation issue once unlocks all 340 rows; the cost-to-fix is hours, the recovery is full.
- Pending Review listings ($90 / 30D) auto-clear and shouldn’t drive ops attention. AbeBooks and Alibris both run routine catalogue sweeps; the 8 listings here will release in 24 to 72h. Subtract this from the headline when prioritising effort.
- The 15% Alibris commission means actual cash recovery is roughly 81% of headline. 1,847 net after commission and card processing. Compared to AbeBooks’s 92% net retention, every Alibris dollar at risk is slightly less valuable to recover, but rare-book ASP makes Alibris-side recovery still attractive.
- Cross-marketplace, the same root causes likely show on AbeBooks and Amazon Books. ISBN-mismatch and condition-note suspensions originate in the merchant’s inventory data; fixing once typically clears revenue-at-risk on all three marketplaces. Check AbeBooks Revenue at Risk for the parallel figure.
- Velocity weighting is the right model, not flat per-listing. A suspended listing for a slow-turning rare book with one sale every 2 years contributes near-zero to the daily figure; a suspended listing for a popular textbook selling 5x/month contributes meaningfully. The card correctly weights this; merchants who tracked “suspended count” alone missed which suspensions actually mattered.
Sibling cards merchants should reference together
Revenue at Risk is the headline finance-friendly figure. Pair with these to size, attribute, and act:| Card | Why pair it with Revenue at Risk |
|---|---|
| Suspended Listings | The first input. Drilldown to per-listing detail to action the suspension queue. |
| Failed Batches (7d) | The second input. Each failed batch is a multi-listing recoverable cluster. |
| Top Upload Error Types | Cause attribution. Once you know the dominant error type, the fix is usually batch-applicable. |
| Listing Quality Score | The composite that includes suspended ratio. Falling here lags falling Revenue at Risk by 24 to 72h. |
| Total Revenue | The headline this card complements. Total Revenue is what you earn; Revenue at Risk is what you’d earn if you fixed the queue. |
| Pending Dispatch | The other “at risk” view. Pending Dispatch is the SLA-side risk; this card is the catalogue-side risk. |
| AbeBooks Revenue at Risk | Sibling marketplace mirror. Cross-correlation surfaces shared root causes. |
| Amazon Books Revenue at Risk | Same. |
Reconciling against the vendor’s own dashboard
Where to look in the Alibris seller dashboard: Alibris does not publish a “revenue at risk” composite; this is a Vortex IQ derived metric. Three views help validate the inputs:- Sellers → Inventory → Suspended. Per-listing audit of the suspension cluster.
- Sellers → Inventory → Upload History. Failed-batch detail including rejection reasons.
- Sellers → Reports → Sales Summary. Cross-check the velocity figures used in weighting.
| Reason | Direction | Why |
|---|---|---|
| Velocity smoothing | Either | The card uses 30-day trailing velocity; for very-slow-turn rare books a single recent sale spikes the velocity unrealistically. The 30-day average is the right model for most stock; outliers can distort. |
| ASP estimation | Either | For listings that haven’t sold in the trailing 30 days (quite common for rare), the card uses listed price. Listed price is sometimes higher than realised price (the listing has been priced optimistically); the card may overstate exposure for that bucket. |
| Pending review handling | Card overstates | Pending Review listings auto-clear without seller action; including them in the headline overstates “actionable” exposure. Some merchants prefer to filter them out. |
| Failed-batch row counting | Either | A failed batch with 340 rows may include 280 unchanged rows and 60 actual edits. Treating the whole batch as 340 actionable items overstates exposure; treating it as just the edits requires per-row diff analysis. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
abebooks.ab_revenue_at_risk | Often correlates within 7 to 14 days. | Marketplace-specific suspension rules differ; AbeBooks rejects publisher-stock images, Alibris allows them. |
amazon.amzn_revenue_at_risk | Amazon typically larger by absolute size. | Amazon’s stricter listing rules surface more suspended-equivalent rows. |