=== Report 1: Revenue by vertical, trailing 12 months (corrected) (written by Omar) === Engineer's note: Aggregated payouts per tenant first (converting gross/fee to EUR per-row via exchange_rates on paid_at date, avoiding the join fan-out from last night), then grouped by tenants.industry into verticals, exactly as specified. Dry-run tooling can't read real data, so I could not personally re-verify the ~EUR 53,186 grand-total check before submission — please have the printed report's vertical sum cross-checked against that figure, and flag back to us if it doesn't match. REPORT: Revenue by vertical, trailing 12 months (corrected) QUESTION: Which merchant verticals generate the bulk of Tidewick's processing volume and fee revenue today? (redo of night-1 report, which disagreed with the merchant-level total by ~1.76x) vertical | merchant_count | gross_payment_volume_eur | fee_revenue_eur | avg_fee_revenue_per_merchant_eur | share_of_total_fee_revenue_pct --------------------------+----------------+--------------------------+-----------------+----------------------------------+------------------------------- Apparel & Footwear | 12 | 1070404.44 | 29028.10 | 2419.01 | 54.58 Sports & Outdoor | 5 | 209893.74 | 5796.45 | 1159.29 | 10.90 Office Supplies (B2B) | 2 | 176549.46 | 4592.96 | 2296.48 | 8.64 Industrial Supplies (B2B) | 1 | 107753.57 | 3499.84 | 3499.84 | 6.58 Home & Living | 9 | 128877.56 | 3085.55 | 342.84 | 5.80 Food & Coffee | 5 | 77170.34 | 2597.96 | 519.59 | 4.89 Beauty | 8 | 125191.99 | 2346.81 | 293.35 | 4.41 Pet Supplies | 7 | 55346.78 | 1468.94 | 209.85 | 2.76 Consumer Electronics | 3 | 31713.49 | 529.66 | 176.55 | 1.00 Books & Stationery | 4 | 5565.70 | 145.03 | 36.26 | 0.27 Jewelry & Accessories | 1 | 2982.02 | 94.56 | 94.56 | 0.18 (11 rows) === Report 2: Processing take-rate trend by quarter (written by Ines) === Engineer's note: This report covers only the payment-processing fee side (payouts.gross/fee amounts, converted to EUR via exchange_rates as_of paid_at). I did not find a table modeling Tidewick's monthly platform-plan billing of merchants (plans/subscriptions in the warehouse model end-customer subscriptions sold by merchants, not merchant-to-Tidewick billing), so the platform-fee vs processing-fee revenue mix Maren asked about cannot be produced from this data. REPORT: Processing take-rate trend by quarter QUESTION: Is Tidewick's effective processing take rate (fee revenue as a share of payment volume) rising, falling, or stable over the last two years? quarter | gross_volume_eur | fee_revenue_eur | take_rate_pct | take_rate_change_pp --------+------------------+-----------------+---------------+-------------------- 2024-Q1 | 334645.05 | 9224.35 | 2.76 | NULL 2024-Q2 | 337030.2 | 9506.65 | 2.82 | 0.06 2024-Q3 | 318246.49 | 8562.88 | 2.69 | -0.13 2024-Q4 | 597320.96 | 15633.97 | 2.62 | -0.07 2025-Q1 | 452020.01 | 11429.2 | 2.53 | -0.09 2025-Q2 | 430094.89 | 11612.46 | 2.7 | 0.17 2025-Q3 | 396178.25 | 11047.02 | 2.79 | 0.09 2025-Q4 | 713155.92 | 19097.17 | 2.68 | -0.11 (8 rows) === Report 3: Vertical revenue growth, 2024 vs 2025 (written by Grace) === Engineer's note: Fee revenue is converted to EUR per payout using that day's EUR->currency_code rate (amount/rate), then summed per tenant before rolling up to vertical, avoiding join fan-out. Growth % is null where 2024 revenue is zero (vertical only appears in 2025). REPORT: Vertical revenue growth, 2024 vs 2025 QUESTION: Which verticals are growing and which are shrinking year over year, in both fee revenue and merchant count? vertical | fee_revenue_2024_eur | fee_revenue_2025_eur | yoy_fee_revenue_growth_pct | merchant_count_2024 | merchant_count_2025 | merchant_count_change --------------------------+----------------------+----------------------+----------------------------+---------------------+---------------------+---------------------- Apparel & Footwear | 25931.91 | 29028.1 | 11.9 | 10 | 12 | 2 Sports & Outdoor | 3814.07 | 5796.45 | 52.0 | 4 | 5 | 1 Office Supplies (B2B) | 3430.29 | 4592.96 | 33.9 | 2 | 2 | 0 Industrial Supplies (B2B) | 1946.58 | 3499.84 | 79.8 | 1 | 1 | 0 Home & Living | 2377.32 | 3085.55 | 29.8 | 9 | 9 | 0 Food & Coffee | 2178.41 | 2597.96 | 19.3 | 3 | 5 | 2 Beauty | 1811.72 | 2346.81 | 29.5 | 7 | 8 | 1 Pet Supplies | 906.35 | 1468.94 | 62.1 | 5 | 7 | 2 Consumer Electronics | 290.78 | 529.66 | 82.2 | 3 | 3 | 0 Books & Stationery | 99.92 | 145.03 | 45.1 | 3 | 4 | 1 Jewelry & Accessories | 140.49 | 94.56 | -32.7 | 2 | 1 | -1 (11 rows)