=== Report 1: Platform billing risk: merchants past_due, suspended or churned (written by Grace) === Engineer's note: Fee revenue is converted to EUR by dividing payout fee_amount by the EUR→currency exchange_rates.rate on the paid_at date (treated as 1:1 when currency_code is already EUR); recency/tenure columns are day counts as of 2026-01-05, null where a merchant has no orders or no paid payouts. REPORT: Platform billing risk: merchants past_due, suspended or churned QUESTION: Which merchants are currently behind on paying us or already cut off, and how big/active are they — our clearest churn-risk signal? merchant_name | vertical | tenant_status | tenure_days | days_since_last_order | days_since_last_paid_payout | fee_revenue_ttm_eur -----------------+-----------------------+---------------+-------------+-----------------------+-----------------------------+-------------------- Silverthread | Jewelry & Accessories | suspended | 760 | 16 | 14 | 94.56 Grind Collective | Food & Coffee | past_due | 2744 | 5 | 5 | 1265.15 Meadow Row | Apparel & Footwear | past_due | 720 | 22 | 20 | 295.05 Saffron & Sage | Beauty | past_due | 1178 | 7 | 5 | 273.59 (4 rows) === Report 2: Deskline Supplies shipping cost breakdown by carrier (written by Bea) === Engineer's note: Shipments joined via fulfillments->orders to filter to Deskline Supplies' tenant_id, limited to shipped_at in 2025, with shipping_cost converted to EUR using exchange_rates (EUR base, shipment's own currency_code, falling back to the tenant's default currency if the shipment row has none) at the as_of date matching shipped_at's calendar day. Min/max per carrier+service_level lane should make it easy to spot whether the high average is driven by a few outlier shipments or a broad pattern. REPORT: Deskline Supplies shipping cost breakdown by carrier QUESTION: Is Deskline Supplies' unusually high average shipping cost (~€1,038/shipment vs. ~€4-30/shipment for comparable merchants) a real freight-cost pattern or a data outlier? carrier | service_level | shipment_count_2025 | total_shipping_cost_eur | avg_shipping_cost_eur | min_shipping_cost_eur | max_shipping_cost_eur -----------------+---------------+---------------------+-------------------------+-----------------------+-----------------------+---------------------- Albion Parcel | standard | 25 | 21754.7 | 870.19 | 5.33 | 7655.94 Kennet Freight | express | 4 | 17701.97 | 4425.49 | 144.97 | 9509.06 Kennet Freight | standard | 12 | 17040.84 | 1420.07 | 5.0 | 6680.11 Landfall Freight | standard | 12 | 9635.74 | 802.98 | 26.86 | 5052.49 Lowlands Express | standard | 8 | 8862.08 | 1107.76 | 21.25 | 4104.32 Regent Parcels | standard | 7 | 1704.74 | 243.53 | 10.51 | 1077.12 Albion Parcel | economy | 4 | 971.58 | 242.89 | 9.88 | 921.81 Landfall Freight | express | 2 | 147.61 | 73.81 | 34.26 | 113.36 Albion Parcel | express | 1 | 56.91 | 56.91 | 56.91 | 56.91 (9 rows) === Report 3: Directional unit economics by vertical, 2025 (first pass) (written by Bea) === Engineer's note: Refund amount is sourced from order_returns.refund_total (status='refunded', dated by refunded_at, falling back to requested_at) since the schema has no direct FK linking payment_refunds to order_returns — this is the closest EUR-denominated, return-linked refund signal available. As requested, rough net contribution excludes support cost, carrier penalties, engineering cost and platform-plan revenue; it is directional only. REPORT: Directional unit economics by vertical, 2025 (first pass) QUESTION: Using only the revenue and cost signals we currently trust, which verticals look directionally profitable to grow versus costly to serve? vertical | merchant_count | fee_revenue_eur | shipping_cost_eur | refund_amount_eur | support_ticket_count | rough_net_contribution_eur | net_contribution_pct_of_fee_revenue --------------------------+----------------+-----------------+-------------------+-------------------+----------------------+----------------------------+------------------------------------ Jewelry & Accessories | 6 | 250.26 | 244.79 | 235.72 | 7 | -230.25 | -92.0 Books & Stationery | 6 | 192.51 | 605.3 | 153.57 | 23 | -566.37 | -294.2 Pet Supplies | 10 | 1771.11 | 9886.73 | 711.02 | 122 | -8826.65 | -498.4 Beauty | 15 | 2887.84 | 7436.49 | 5470.44 | 210 | -10019.09 | -346.9 Home & Living | 16 | 5173.66 | 10045.28 | 16906.26 | 222 | -21777.89 | -420.9 Food & Coffee | 11 | 9692.1 | 42462.84 | 2572.59 | 450 | -35343.33 | -364.7 Sports & Outdoor | 13 | 9262.09 | 5727.65 | 45282.46 | 122 | -41748.02 | -450.7 Industrial Supplies (B2B) | 5 | 12722.73 | 33078.36 | 23398.42 | 81 | -43754.05 | -343.9 Consumer Electronics | 9 | 10116.22 | 3339.43 | 58469.88 | 75 | -51693.09 | -511.0 Office Supplies (B2B) | 4 | 8633.49 | 102264.92 | 31843.41 | 41 | -125474.84 | -1453.4 Apparel & Footwear | 25 | 32881.2 | 35048.53 | 280952.14 | 967 | -283119.47 | -861.0 (11 rows)