Sum of (suspended_listings x velocity x ASP) + (failed-upload backlog x avg ASP), recoverable.
At a glance
Live monetary estimate of recoverable revenue currently locked behind operational issues: suspended listings that should be active, ISBN-mismatch flags blocking listings from search, failed-upload backlog stuck in the queue, and listings expiring within the next 7 days that haven’t been renewed. The number is operational, not strategic, every pound here can be recovered with a defined action.
| What it counts | SUM(suspended_listings * 30D_velocity * avg_selling_price) + SUM(failed_upload_backlog * avg_selling_price) + SUM(expiring_listings_7D * 7D_velocity * avg_selling_price). Each component is computed per ISBN and summed to a single account-level figure. |
| API endpoint + report | Computed locally in Vortex IQ Nerve Centre. Inputs: AbeBooks Inventory feed (active/suspended state per listing), Outbound Confirmations feed (last successful upload timestamp per batch), Inbound Orders feed (30D velocity per ISBN). |
| Listing-quality impact | Direct. Suspended listings are listings AbeBooks has demoted out of search, usually for ISBN-mismatch, condition-mismatch, or seller-error patterns. Each suspension has an underlying cause; this card tells you the money you’re leaving on the table while you fix the cause. |
| Fees / commission | Gross. Same basis as Total Revenue. For the post-fee at-risk figure, multiply by ~0.88 (12% blended fee assumption). |
| Refunds | Not applicable (the at-risk listings haven’t sold yet). |
| Cancellations | Not applicable. |
| Currency | Settlement currency. Same FX treatment as Total Revenue. |
| Recoverability | Recoverable, by design. Every component has a defined recovery action: suspended listings recover via Suspended Listings drill-down (typically 30 to 70% recoverable within 7 days); failed-upload backlog recovers by re-running the upload cycle; expiring listings recover via bulk renewal. Cards like Net Revenue measure realised cash; this measures avoidable lost revenue. |
| Multi-marketplace overlap | The same suspended ISBN may also be suspended on Alibris (often for the same underlying cause). Alibris Revenue at Risk double-counts conceptually but represents two separate revenue pools; sum them for total at-risk. |
| Time window | RT (real-time, recomputed every 4 hours alongside the inventory feed). |
| Alert trigger | >$0, any positive number is by definition avoidable revenue loss. The actionable threshold most booksellers use internally is >$500/£400 per recovery cycle. |
| Roles | owner, finance. |
Calculation
Calculated automatically from your AbeBooks data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
The same UK bookseller, snapshot taken 02 May 26 at 14:00 UTC.| Component | Listings affected | 30D velocity | Avg selling price | Estimated 30D revenue at risk |
|---|---|---|---|---|
| Suspended (ISBN mismatch flag) | 142 | 0.18/listing | £14.20 | £363 |
| Suspended (condition complaint) | 38 | 0.06/listing | £42.80 | £98 |
| Failed-upload backlog (3-day-old) | 410 | 0.14/listing | £11.50 | £660 |
| Expiring within 7 days (not yet renewed) | 1,248 | 0.04/listing × 7/30 | £8.90 | £104 |
| Total Revenue at Risk (this card) | 1,838 | mixed | mixed | £1,225 |
- The failed-upload backlog is almost always recoverable, and it’s almost always a config or credentials issue. The £660 backlog component represents 410 listings that uploaded with errors over the last 3 days. Investigation showed all 410 had the same root cause: a quote-character in 410 book descriptions that the FTPS feed parsed as a field-terminator. Fixing the description-sanitiser in the upload pipeline and re-running the batch recovered every listing within 12 hours. Cards like Top Upload Error Types and Failed Batches (7d) point to root cause; this card sizes the financial impact.
- Suspended listings often share a single root cause, not 142 individual issues. The 142 ISBN-mismatch suspensions traced back to a single inventory-import bug: when the bookseller imported a 4,200-row CSV from a wholesaler, ISBN-13 values longer than 13 digits got silently truncated, and 142 of those rows ended up with invalid ISBNs that AbeBooks’s catalogue lookup rejected. Fixing the import script and re-uploading the affected rows recovered roughly 60% within 7 days; the rest required manual ISBN-correction per row.
- Rare-book suspensions look small in count but large in money. Of the 38 condition-complaint suspensions, only 7 were rare books, but those 7 averaged £142 selling price and accounted for £71 of the £98 component. Cross-check the per-row drill-down in Suspended Listings for the rare/commodity split before deciding remediation order.
- Expiring listings are the silent killer. AbeBooks listings expire after 12 to 24 months unless renewed; expired listings vanish from search instantly. Most booksellers don’t realise this until a top-seller stops selling and they investigate. The 1,248 listings expiring this week represent £104 of next-7-days revenue (small), but if a top textbook expires in week 1 of August (peak buying), the same per-listing risk number could be 5 to 10x. Run bulk-renewal monthly, not in response to alerts.
- Cross-marketplace correlation matters. Of the 142 ISBN-mismatch suspensions on AbeBooks, 89 of the same ISBNs are also suspended on Alibris (same root cause, same import bug). Alibris Revenue at Risk shows £840 from largely the same listings. Total recoverable revenue across both marketplaces is £2,065 for a single import-script fix; the operational ROI on debugging that script is enormous.
Sibling cards merchants should reference together
Revenue at Risk sizes the recoverable money. Pair with these to act on it:| Card | Why pair it with Revenue at Risk |
|---|---|
| Suspended Listings | The component drill-down for the suspension portion. Tells you which ISBNs and which suspension reasons are pulling the number up. |
| Top Upload Error Types | Root-cause view for the failed-upload backlog. Most backlog is one error pattern, not 410 unique issues. |
| Failed Batches (7d) | Rolling count of failed upload cycles. A spike here precedes a spike on this card. |
| Listings Expiring Soon | The expiring-listings component. Bulk-renewal action target. |
| Listings Processed With Errors | Listings that uploaded but with warnings, often suspended within 24 to 72h if the warnings aren’t addressed. The leading indicator for the suspension component. |
| ISBN Coverage | Listings without ISBN are more likely to suspend. Coverage drops correlate with at-risk increases by 7 to 14 days. |
| Total Revenue | Context. £1,225 at risk against £29,974 monthly revenue is a 4.1% recoverable pool, meaningful but not existential. |
| Alibris Revenue at Risk | Cross-marketplace at-risk. Same root cause often suspends listings on multiple platforms; sum for total recoverable. |
Reconciling against the vendor’s own dashboard
Where to look in the AbeBooks seller dashboard: There is no single AbeBooks view that matches this card; AbeBooks doesn’t compute revenue at risk because it’s a derived figure that requires per-listing velocity data. Use these views to verify the component inputs:- My AbeBooks → Inventory → filter Suspended. Lists every suspended listing with the suspension reason. Compare the count and the per-listing reasons against Suspended Listings.
- My AbeBooks → Reports → Upload History. Failed-upload batches over the last 30 days with row-level error logs.
- My AbeBooks → Inventory → sort by Expiry Date. Listings approaching expiry. Bulk-renew action lives here.
| Reason | Direction | Why |
|---|---|---|
| Velocity assumption | Either | The 30D-velocity-per-listing figure is computed from order history; for listings under 30 days old, it uses the bookseller’s category average instead. Newer inventory tends to over-estimate at-risk; mature inventory is precise. |
| Average selling price | Theirs N/A | AbeBooks doesn’t publish an at-risk view, so there’s no “their number” to reconcile against. The per-listing ASP comes from the bookseller’s own listed price minus a 1.8% historic-discount adjustment. |
| Suspension state lag | Ours can lag by up to 4h | The Inventory feed refreshes every 4 hours; a listing suspended 30 minutes ago may not yet show in this card. AbeBooks’s seller-dashboard suspended-listings view is real-time. |
| Expiring-listings cut-off | Either | We use a fixed 7-day forward window. Some bookseller tools use 14 or 30 days; the resulting at-risk figure scales linearly with the window choice. |
| Cross-marketplace double-counting | None | This card is AbeBooks-only by construction; the same ISBN suspended on Alibris contributes to Alibris Revenue at Risk, not here. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
alibris.al_revenue_at_risk | Often correlated, sometimes identical at the ISBN level. | Different marketplace catalogue rules. Alibris’s ISBN authority is slightly less strict than AbeBooks’s, so an ISBN suspended on AbeBooks may still be live on Alibris (and vice versa for condition-mismatch). |
amazon.amzn_listings_suppressed_count | Independent. | Amazon’s suppression rules are stricter and category-driven (especially Books category, which has a separate gate). Same root cause may produce a 3x larger Amazon suppression set than AbeBooks. |
shopify.total_revenue | Inverse, weakly. | Recoverable AbeBooks revenue isn’t competing with Shopify revenue; the customer cohorts are different. But operational time spent on AbeBooks recovery is time not spent on Shopify; large at-risk numbers can starve DTC of attention. |