MarketplaceBeta Intelligence · Edition 1
An evidence-first intelligence dossier for e-commerce operators: what the data says is happening, what it says is likely next, and what to do about it before it becomes obvious.
Published October 14, 2026 · BeaconPath Holdings, LLC · DBA RD Consulting
Built on the MarketplaceBeta news archive (8,541 classified articles, 54 sources, Mar–Oct 2026), a 77-SKU refurbished-electronics market snapshot, and 80+ dated external sources. Every claim is labeled: Observed measured in our data Reported external source, cited Hypothesis plausible, not yet validated Forecast dated, graded hit or miss
Section 1
Demand is not the problem. Online sales are growing at twice the rate of total retail, and every major holiday forecaster expects a record season. The problem is who keeps the money. Gross margins are at record highs while net margins sit near 10%, because platforms, carriers, and advertising systems are capturing the spread. That one fact organizes almost everything else in this report.
Amazon's advertising revenue grew 26% and its seller-fee revenue 16% in Q2 2026, both faster than its own online store sales (+15%). Walmart's US advertising grew 38% against 24% e-commerce growth. US retail media will grow ~18% to $71B in 2026, with Amazon and Walmart capturing over 89% of the incremental dollars. Independent survey data shows the result: record gross margins, stagnant net margins, and only 23% of sellers both growing and improving profitability. Our own archive measured the same shift as attention: coverage of fees, advertising, and logistics displaced general e-commerce coverage through 2026.
Diesel set an all-time record ($6.53/gal, late Sept), trans-Pacific container rates ran 3–4x their 2025 levels ($8,400–$11,300/FEU in September), dry-van spot rates were +47% YoY, and FedEx's domestic fuel surcharge reached 32.25%. Carrier "5.9% rate increases" understate real parcel inflation because surcharges are rising far faster than base rates. Our archive's logistics coverage share crossed 50% in July, two months before holiday commentary caught up — an early-warning pattern we are now tracking formally (Section 4).
The Supreme Court struck down the IEEPA tariffs in February 2026; average effective tariffs fell from a 17.5% peak to ~10.9%, roughly $35B in refunds flows only to importers of record, and a temporary 10% surcharge now bridges to expanded Section 232/301 actions. De minimis is permanently dead (statutory repeal July 2027). Net effect: import costs are volatile but the structural duty advantage of direct-from-China retail is gone, which is a durable relative gain for sellers holding US inventory.
AI-referred traffic to US retail sites is still a low-single-digit share of sessions, but it converts 42–54% better and self-reports 69% lower return likelihood. The checkout rails churned within six months (OpenAI's Instant Checkout launched, charged ~4%, and was wound down; Google's UCP rose; Amazon is blocking third-party agents in court). The durable asset across every regime is structured product data: price, availability, shipping, and returns in machine-readable form.
On September 24, Amazon opened Seller Central to managing eBay, Shopify, TikTok, and Walmart orders, extended Prime and discounted fulfillment to sellers' own sites, and cited its own stat that 95% of its independent sellers are already multichannel. Walmart quietly cut referral fees in ~14 categories in June while growing its marketplace 50%+. Fee arbitrage and cross-channel pricing discipline have become core operator skills rather than optimizations.
Monthly secondhand buying jumped from 35% to 47% of consumers in a year (eBay, Oct 2026); pre-owned smartphones are a ~$83B market with Apple at 58% share; Back Market reached EBITDA profitability. Our 77-SKU market snapshot shows where the margin lives: high-ticket, low-density listings. Seller count correlates −0.81 with price point; the crowded sub-$150 tier shows ~a third of listings trading below any rational cost floor, while the $500+ tier wins Buy Box share at smaller discounts.
Section 2
| Platform | Latest print | Reading |
|---|---|---|
| Amazon | Online stores +15%; seller fees +16%; ads +26% (Q2 26) | Monetization outgrowing merchandising; fee layering via surcharges (Sec. 3) |
| Walmart | US e-comm +24%; marketplace +50-52%; ads +38% (Q2 FY27) | Buying seller supply with fee cuts; monetizing via ads and WFS |
| eBay | GMV $22.4B, +15%; US +24% (Q2 26) | Refurb/pre-loved >40% of GMV; the recommerce incumbent |
| TikTok Shop | US H1 26 GMV ~$11.8B, +103% (est.) | Post-divestiture; GMV doubling but fee structure still unsettled |
| Temu / Shein | US audiences ~30% below pre-tariff baseline; Shein US revenue −14% (Q1 26) | De-minimis casualties; their value demand migrated, it didn't vanish |
| Etsy | Marketplace GMS +7.5% (Q2 26) | First marketplace surfaced inside ChatGPT and Google AI Mode |
Sources: company earnings and SEC filings Jul–Aug 2026; Momentum Works/eMarketer estimates for TikTok Shop (TikTok does not disclose); Measure Protocol panel for Temu/Shein audiences. Where firms disagree, both figures appear in Section 12.
Two structural notes. First, the de-minimis channel that moved 1.36B packages in FY2024 is closed — CBP collected $1B+ in duties on 246M formerly-exempt shipments in the first months of enforcement — and the statutory repeal takes effect July 2027, so this is not reversing. Second, what looks like a "Temu collapse" is better read as value demand re-routing to Walmart, eBay, off-price, and secondhand, all of which printed their strongest numbers in years in the same quarters.
Section 3
Each line below is a cost channel growing faster than seller revenue. Together they explain how record gross margins coexist with ~10% net margins.
| Cost channel | 2026 change | Source, date |
|---|---|---|
| Amazon fulfillment | Headline +$0.08/unit avg (Jan 15) — then a 3.5% fuel surcharge (Apr 17), a per-FNSKU low-inventory fee extended to bulky goods, inbound placement fees, and a ~$0.32/unit holiday peak surcharge from Oct 15 | Amazon Seller Central updates via Goat Consulting, eComEngine, SellerMagnet |
| Effective take rate | Total Amazon fees (referral + FBA + storage + ads) approach ~50% of sale price (Marketplace Pulse); one operator analysis puts the average at ~34%, vs ~26% in 2020 | Marketplace Pulse via Modern Retail; operator analysis, Apr 2026 |
| Parcel carriers | UPS and FedEx GRIs both 5.9%, but surcharges decoupled: FedEx residential peak demand +23–25% YoY, UPS peak residential $0.60→$0.75, FedEx fuel surcharge at 32.25% in Sept | Carrier announcements; Value Added Resource; Modern Retail, Sept 21 |
| Ocean freight | Trans-Pacific $7,600–$10,200/FEU in October, down from September peaks but still multiples of 2025; Drewry composite $4,351/FEU | Drewry WCI, Oct 8; Freightwaves series, Sept |
| Advertising | US retail media +~18% to $71B; Amazon ads +26%; Walmart ads +38%; DSP share of Amazon ad spend 17.7%→23.4% across 2025 | eMarketer Dec 2025 fcst; earnings; SellerApp, Sept 12 |
| Marketplace fees (counter-trend) | Walmart cut referral fees across ~14 categories in June (apparel, electronics, home deepest — direction confirmed, exact rates unpublished); TikTok Shop reportedly moved 6%→8% (unconfirmed at primary source) | Ecommerce Times via Novadata, Jun 22; seller guides, Aug 4 |
The consequence, measured two independent ways: eCommerceFuel's ~300-store survey shows 49.5% gross margins against 10.6% net — sellers are successfully passing costs into price, and platforms, carriers, and ad systems are absorbing the difference. Marketplace Pulse's 181-seller index sorts the population into 23% thriving, 31% grinding, 38% distressed. The squeeze is documented, not anecdotal.
Operator translation. Treat fees as a variable, seasonal cost, not a rate card. The winners in both surveys differentiate on fee-structure arbitrage — channel mix, FNSKU-level inventory discipline, pooled fulfillment rates — rather than on price.
Section 4
This section reports analyses run for this edition on two proprietary datasets: the MarketplaceBeta news archive (8,541 relevant classified articles from 54 fixed sources, March–October 2026) and a 77-SKU refurbished-Apple market snapshot (one marketplace, one audit day). Reproducible queries are in the appendix (Section 12). Findings are labeled honestly: one of them is validated against an outcome; the others are measured facts or hypotheses awaiting the next edition.
We computed each category's share of monthly relevant coverage across our fixed source panel. Logistics coverage rose from a third of all coverage in April to more than half in July — before holiday-season freight commentary became mainstream in late September.
The surge was content-confirmed: the underlying articles carried record diesel prints, 3–4x container-rate moves, and explicit Q4 surge warnings from carriers and brokers. Keyword acceleration over the last eight weeks (rate-normalized against the April–August baseline) points the same way: policy 6.9x, diesel 3.5x, rates 2.8x, border 2.7x, truckload 2.5x, fee 2.3x, returns 1.9x. The two quieter accelerations worth watching: walmart (2.7x) and advertising-category coverage, which doubled from its spring level and held through September.
Known limitations: coverage share measures publisher attention, not market magnitude; the logistics panel is dominated by one trade publisher, so the index partly measures that newsroom's judgment; and a two-month lead on one episode is consistent with luck. The ledger (Section 12) commits us to scoring it rather than asserting it.
The 77-SKU snapshot (refurbished Apple, Amazon Renewed, audited 2026-08-05) shows a sharply structured market. Competitive density is a function of price point: seller count correlates −0.81 (Spearman) with the listing's market price, and +0.79 with its review count. Sellers crowd cheap, high-velocity listings; high-ticket listings stay thin.
| Segment | n | Median price | Median sellers | Median gap vs. lowest | Buy Box rate |
|---|---|---|---|---|---|
| MacBook Air | 36 | $755 | 4.5 | +7.6% | 30.6% |
| MacBook Pro | 11 | $514 | 7 | +7.7% | 9.1% |
| iPhone | 9 | $253 | 16 | +11.0% | 11.1% |
| Apple Watch | 6 | $165 | 11 | +2.6% | 0% |
| iPad | 15 | $105 | 32 | +12.7% | 0% |
A structural check using category-default cost estimates (labeled estimates, not real COGS) suggests the market's lowest offer sits below a 12%-margin floor on roughly 31% of these SKUs — concentrated in the crowded low-price tier. If even approximately right, a third of this market trades at prices a rational cost model cannot justify, which means matching the lowest offer there is donating margin to exit-bound competitors.
Three independent measurements agree. Our archive shows fees/logistics/advertising displacing general commerce coverage. External surveys show the gross-to-net margin spread at a record. Our market snapshot shows the mechanism at listing level: crowded segments trade below rational floors while platforms collect the same fees either way. When attention data, price data, and survey data triangulate, we treat the finding as high-confidence — and the triangulation method itself is the editorial standard for this dossier going forward.
Section 5
Every forecast below is stored in a database ledger (intel_forecasts, created for this edition) with its confirming and invalidating indicators and a resolve-by date. Next editions score each one as a hit or a miss. Forecasts are judgments grounded in the cited evidence, not model outputs.
| Scenario | Shape | What makes it true |
|---|---|---|
| Base case | Online +6–8% (Adobe/Deloitte band); record Cyber Week; discounts peak ~30%; parcel networks strained but functional | Freight stays expensive but no labor/fuel shock; sentiment stabilizes; BNPL absorbs budget stress |
| Bear case | Online +3–5%; late-season volume compressed; margin-destroying discount depth | Diesel keeps setting records into November; carrier surcharge stacking plus a sentiment leg down (UMich <44); tariff re-escalation on holiday categories |
| Bull case | Online +9%+; AI-referred conversion premium holds at scale; returns rate falls again | Tariff refunds reach consumers as price cuts; freight rates mean-revert fast (Drewry composite already −2% w/w in Oct); agentic traffic over-delivers |
| # | Horizon | Forecast | Confirms / invalidates |
|---|---|---|---|
| F1 | 0–3m | US online holiday sales (Nov 1–Dec 31) grow ≥6% YoY | Adobe/Salesforce weekly trackers; Census Q4 · Invalidated by UMich <44 + parcel disruption |
| F2 | 0–3m | Effective Q4 residential parcel cost inflation for DTC sellers lands ≥8% despite 5.9% GRIs | Carrier surcharge tables; shipper invoices · Invalidated by surcharge rollbacks |
| F3 | 0–3m | AI-referred retail traffic at least doubles YoY during Cyber Week, and its conversion premium stays ≥25% | Adobe holiday telemetry · Invalidated if premium compresses below 25% as volume scales |
| F4 | 0–3m | TikTok Shop US full-year 2026 GMV ≥ $20B | Momentum Works / eMarketer updates · Invalidated by post-divestiture operational disruption |
| F5 | 3–6m | Amazon's 2027 US fee announcement contains no headline referral increase but raises net cost via surcharge/restructure layering | Seller Central fee notice (expected Dec–Jan) · Invalidated by a flat, surcharge-free schedule |
| F6 | 3–6m | Walmart extends fee-cut or WFS-incentive playbook to additional categories to sustain >40% marketplace growth | Seller Center policy updates; Q3/Q4 FY27 prints · Invalidated by fee increases |
| F7 | 3–6m | At least one additional top-10 US marketplace (Amazon excluded) signs a formal agent-access integration (UCP, ACP successor, or equivalent) | Platform announcements · Invalidated by industry-wide agent blocking following Amazon's lead |
| F8 | 6–12m | US average effective tariff rate moves ≥2 points (either direction) from ~10.9% within 12 months | Yale Budget Lab series · Invalidated by 12 months of rate stability |
| F9 | 6–12m | Used/refurbished smartphone unit growth again outpaces new in 2026 full-year data (IDC direction: ~5.8% vs ~1%) | IDC/Counterpoint annuals · Invalidated by new-unit resurgence on an upgrade supercycle |
| F10 | 12–24m | De minimis is not restored before the statutory repeal (Jul 2027) takes effect | Federal Register / CBP · Invalidated by Congressional reversal |
| F11 | 12–24m | Consolidated multichannel operation (one console + one fulfillment network serving ≥3 channels) becomes the default stack for new multichannel sellers, with Amazon's offering a top-2 provider | Seller surveys; MCF adoption disclosures · Invalidated by antitrust action or seller boycott of cross-channel data sharing |
| F12 | 12–24m | Agentic commerce exceeds 2% of US e-commerce sessions by October 2027 | Adobe/Contentsquare session-share data · Invalidated by platform-wide agent blocking or consumer disinterest |
Mechanisms, briefly. F2 and F5 extend an observed behavioral pattern (surcharge layering) rather than predicting a new one. F8 is a volatility forecast: after a Supreme Court reversal, an expiring stopgap surcharge, and queued Section 232/301 actions, rate stability is the surprising outcome. F11 is the Amazon September 24 announcement read as strategy: the company that owns the seller's operating system owns the fee relationship, whichever channel the sale lands on.
Section 6
Opportunities are scored 1–5 on five axes — impact, confidence, execution cost (5 = cheap), time sensitivity, and defensibility — and ranked by the weighted sum (impact and confidence double-weighted). Scores are judgments made against the cited evidence; the point of publishing the rubric is so later editions can be audited against it.
| Opportunity | For | Imp | Conf | Cost | Time | Moat | Score /35 |
|---|---|---|---|---|---|---|---|
| O1 · Floor-disciplined, density-aware refurb positioning | Refurb/resale sellers | 5 | 4 | 4 | 4 | 3 | 29 |
| O2 · Channel fee arbitrage + pooled fulfillment | Any multichannel seller | 4 | 4 | 4 | 4 | 2 | 26 |
| O3 · Agent-readiness feed program | DTC / Shopify operators | 4 | 3 | 5 | 4 | 2 | 25 |
| O4 · Importer-of-record restructuring | Import-heavy sellers | 4 | 3 | 2 | 4 | 3 | 23 |
| O5 · Returns-economics program | Apparel/fit-risk DTC | 3 | 4 | 4 | 3 | 2 | 23 |
| O6 · Maker-commerce picks and shovels | Content/tool builders | 3 | 2 | 4 | 2 | 4 | 20 |
Signals: recommerce demand step-change (eBay 35%→47% monthly secondhand buyers); tariff-driven new-device price pressure; our snapshot's −0.81 density/price correlation and ~31% below-floor share in the crowded tier. The play: concentrate acquisition capital in high-ticket, low-density segments (the $500+ laptop tier in our data); price with explicit margin floors; deliberately hold above irrational markets instead of chasing them; use the DAMH ranking (Sec. 4.2) at buy time, not just at pricing time. Economics: in our snapshot the thin-density tier won the Buy Box 3x as often at half the price gap — the same capital works harder. Requirements: real landed-cost data per SKU, a repricing engine with floor discipline (ProfitTygr implements this), and warranty/grading quality that clears the branded-program bar (Renewed Premium / Restored Premium both now carry 1-year warranties). Risks: single-snapshot evidence; Apple trade-in repricing compresses sourcing spreads; velocity at high tickets is structurally lower. Time to value: 30–60 days. Confidence: medium-high.
Signals: Walmart's June fee cuts and 50%+ marketplace growth; Amazon's surcharge stack; carrier residential surcharges up 23–25%; Amazon's own 25%-cheaper-MCF claim for off-Amazon orders. The play: re-run per-channel contribution margin quarterly with current fee tables (fees are now seasonal variables); shift catalog weight toward the cheapest competent channel per category; pool fulfillment where residential surcharges bite hardest. A 2-point referral delta plus pooled last-mile is a 3–5 point net-margin swing on affected SKUs — larger than most conversion-optimization programs deliver. Risks: Walmart's cuts are acquisition spend and may reverse; cross-channel consoles (incl. Amazon's) see your sales data. Time to value: 30–60 days.
Signals: 42–54% conversion premium on AI-referred visits; 69% lower self-reported return likelihood; protocol churn penalizing deep integrations; schema completeness as the common denominator across ACP, UCP, and AI crawlers. The play: complete structured product data (Product/Offer schema with live price, availability, shipping speed, return policy; AggregateRating), prose product pages that answer questions agents ask, and feed monitoring. Treat checkout-protocol integrations as rented; treat the feed as owned. Economics: this buys the premium slice of traffic cheaply; it does not buy volume yet. Model a 3–6% agent toll scenario before committing to any agent checkout. Time to value: 30–90 days. Confidence: medium (the channel is young; the premium could compress as it scales — tracked as forecast F3).
Signals: ~$35B of tariff refunds flowing only to importers of record; CBP's September importer crackdown; de-minimis repeal re-routing supply chains. The play: import-heavy sellers who buy landed from middlemen captured none of the refund and carry a markup on someone else's duty handling. Becoming IOR (or moving to a transparent duty-pass-through broker) captures refund rights, duty drawback eligibility, and COGS visibility. Costs/risks: compliance burden is real and CBP enforcement is tightening; wrong for small import volumes. Time to value: 90–180 days.
Section 7
Section 8
Reading: the discovery layer is consolidating faster than the transaction layer. Whoever controls the agent controls the shelf, which is exactly why Amazon litigates while opening its own agent — and why marketplaces that welcome agents (Etsy, Walmart, Shopify) are making a strategic bet that distribution beats control. For operators the asymmetry is simple: blocking agents is a platform's option, not yours; being legible to them is yours.
Amazon's September 24 package — rival-channel order management inside Seller Central, Prime and discounted MCF on sellers' own sites, one inbound flow feeding eight countries — is a bid to become the operating system of multichannel selling. Its own disclosure that 95% of its independent sellers already sell elsewhere explains the move: the growth is in managing commerce, not hosting it. Expect Walmart and Shopify counter-moves; expect the console that wins to also win pricing-data advantages. Operators should take the efficiency but keep pricing logic and cost data in systems they own.
2026 produced: a Supreme Court tariff reversal, an 8-point swing in average effective tariffs, bilateral 50% tariffs with Canada inside a week, a $120/container ship fee, an importer-of-record crackdown with no grace period, and the permanent end of de minimis. The planning implication is not any one rate; it is that COGS certainty now decays in weeks. Operators need the reflexes (scenario-priced catalogs, supplier diversification across tariff regimes, refund-eligible import structures) more than any single hedge.
Section 9
Section 10
Section 11
The short list an operator should actually watch, with the threshold that means something changed.
| Indicator | Where | Cadence | Act when… |
|---|---|---|---|
| Drewry WCI trans-Pacific rate | drewry.co.uk (free weekly) | Weekly | >$12K/FEU East Coast = bear freight scenario; <$5K = cost relief to reprice into |
| DOE/EIA diesel benchmark | eia.gov | Weekly | New records into Nov = surcharge escalation; budget F2 at the high end |
| Adobe AI-traffic prints | Adobe Analytics releases | Monthly / holiday | Conversion premium <25% = the premium is commoditizing (F3 invalidation) |
| Amazon Seller Central fee notices | Seller Central news | Event | Any new surcharge class = re-run catalog economics same week (F5) |
| Walmart Seller Center policy updates | Seller Center | Event | Fee cuts in your category = harvest window opens; set a reminder for reversal |
| TikTok Shop official fee table | Seller University | Monthly | Primary confirmation of the 6%→8% move changes channel math |
| Tariff actions (232/301, Section 122 expiry) | Federal Register; Yale Budget Lab tracker | Event | ≥2-point effective-rate move = reprice imports, revisit IOR plan (F8) |
| UMich consumer sentiment | sca.isr.umich.edu | Monthly | <44 = bear holiday scenario gains; deepen discount contingency |
| Census quarterly e-commerce | census.gov (next: Nov 19) | Quarterly | YoY growth <9% = demand-side deterioration beyond the price effect |
| Archive: logistics coverage share | MarketplaceBeta intelligence (internal) | Monthly | Any category's CPI ≥1.5 two months running = investigate before it's news |
| Archive: keyword acceleration table | MarketplaceBeta intelligence (internal) | Monthly | New non-calendar term >3x = candidate emerging signal; verify against primary sources |
Section 12
The August 2026 ProfitTygr dossier embedded several market assumptions this edition can now test. Held up: the Walmart June fee-cut note (externally corroborated in direction); the race-to-the-bottom premise behind margin-floor repricing (now supported by two independent seller surveys and our below-floor measurements); the refurb demand thesis (strengthened by eBay's 35%→47% and tariff pass-through data). Revised: we previously treated "tariffs push buyers to refurbished" as near-axiomatic; the direct substitution evidence is thinner than assumed (the one survey found only 6% switching intent), so the thesis now rests on the broader value-seeking shift rather than a tariff-specific mechanism. Unchanged risk: dependence on third-party market history, pending first-party price capture.
| Layer | Implemented today | Proposed next |
|---|---|---|
| Market intelligence engine | Aggregation pipeline (54 sources → classification, keywords, impact levels, a database); manufacturing desk feeds; ProfitTygr live market data from third-party market history; the archive analyses in Section 4 with reproducible SQL (appendix) | Scheduled monthly runs of the CPI/keyword-acceleration queries; marketplace price/seller-count sampling beyond one catalog; complaint-theme mining from review data |
| Strategic decision engine | ProfitTygr pricing engine (exact floor/ladder math, elasticity-based Monte Carlo sales forecasting, reverse max-buy sourcing) — tested, deterministic; the opportunity-scoring rubric of Section 6 | DAMH density penalty wired into sourcing; automated opportunity flags joining search-interest, complaint, and density signals; backtests for the CPI |
| Intelligence dossier | This publication; forecast ledger intel_forecasts created in the production database with all 12 forecasts, indicators, and resolve-by dates | Monthly edition cadence; a public-facing "forecast scoreboard" page showing every hit and miss as forecasts resolve |
The critical requirement, honored: nothing here claims to be a continuously learning system. What exists is the storage-and-scoring mechanism that makes learning possible — forecasts are written to a ledger with resolution dates, and the next edition is obligated to score them. The first hit/miss grades arrive when the holiday forecasts (F1–F4) resolve in January 2027.
Observed measured directly in our datasets, query reproducible. Reported external source with publisher and date; conflicts disclosed. Hypothesis consistent with evidence, not yet validated; never the basis of a recommendation on its own. Forecast dated judgment logged with a resolve-by date and graded hit or miss when it resolves. Forecasts are evidence-based judgments, not model outputs; the ledger shows every hit and every miss.
-- Category share by month (fixed panel; relevant only)
select category, date_trunc('month', published_at)::date mo, count(*)
from articles where relevant and published_at >= '2026-04-01'
group by 1,2 order by 1,2;
-- Source-mix confound check
select date_trunc('month', published_at)::date mo,
count(distinct source_name) sources, count(*) n
from articles where relevant and category='logistics'
and published_at >= '2026-04-01' group by 1 order by 1;
-- Keyword acceleration (last 8 weeks vs Apr-Aug baseline, rate-normalized)
with recent as (select k.keyword, count(*) n from article_keywords k
join articles a on a.id=k.article_id
where a.relevant and a.published_at >= '2026-08-20' group by 1),
prior as (select k.keyword, count(*) n from article_keywords k
join articles a on a.id=k.article_id
where a.relevant and a.published_at >= '2026-04-01'
and a.published_at < '2026-08-20' group by 1)
select r.keyword, r.n n_recent, coalesce(p.n,0) n_prior,
round(r.n::numeric/(coalesce(p.n,0)*(55.0/141.0)+1),2) accel
from recent r left join prior p using (keyword)
where r.n >= 12 order by accel desc limit 40;
-- Catalog statistics: see lib/repricer analysis script (node),
-- Spearman rank correlations computed with midrank ties.