=== Report 1: B2B Wholesale: Win Rate and Cycle Time by Sales Rep (New Business) — Corrected (written by Omar) === Engineer's note: Filtered by the 5 confirmed tenant names and each tenant's own 'New business' pipeline, as specified. Note: the report itself only lists reps with >=3 closed opportunities (per the grain, one row per qualifying rep); the count of reps excluded by that threshold is not a row in this table and would need a separate quick count if wanted for the memo. REPORT: B2B Wholesale: Win Rate and Cycle Time by Sales Rep (New Business) — Corrected QUESTION: Among reps who own B2B wholesale new-business opportunities, are a few reps clearly underperforming on win rate or cycle time, or is performance broadly similar? rep_name | merchant | opportunities_closed | closed_won | closed_lost | win_rate_pct | avg_days_open | avg_amount_eur --------------------+-------------------------------+----------------------+------------+-------------+--------------+---------------+--------------- Youssef Meijer | Polder Packaging | 7 | 4 | 3 | 57.1 | 20.7 | 7828.57 Logan Roberts | Ballycorran Industrial Supply | 40 | 32 | 8 | 80.0 | 17.8 | 3867.50 Lotte van den Broek | Midland Safety Wear | 18 | 15 | 3 | 83.3 | 9.6 | 5800.00 Greta Schmitt | Hanse Industriebedarf | 12 | 10 | 2 | 83.3 | 8.9 | 4683.33 Joshua Jackson | Castell Fasteners | 21 | 18 | 3 | 85.7 | 11.6 | 7313.84 Niamh Harrison | Ballycorran Industrial Supply | 36 | 31 | 5 | 86.1 | 12.5 | 4280.56 Jesse Novotný | Midland Safety Wear | 22 | 19 | 3 | 86.4 | 11.1 | 4968.18 Megan Taylor | Castell Fasteners | 15 | 13 | 2 | 86.7 | 14.6 | 6096.30 Thijs Dijkstra | Polder Packaging | 9 | 8 | 1 | 88.9 | 13.1 | 5288.89 Sarah Hartmann | Hanse Industriebedarf | 5 | 5 | 0 | 100.0 | 12.1 | 7500.00 (10 rows) === Report 2: B2B Wholesale: Win Rate and Average Deal Size by Merchant (New Business) — Corrected (written by Bea) === Engineer's note: Fixed the EUR averaging bug by skipping the exchange_rates join entirely when currency_code = 'EUR' (amount_eur = amount directly); for non-EUR rows (Castell Fasteners, USD) we use the EUR/quote rate as of the nearest date on or before closed_at. avg_days_open is calendar days between created_at and closed_at. REPORT: B2B Wholesale: Win Rate and Average Deal Size by Merchant (New Business) — Corrected QUESTION: Does the merchant-level win-rate pattern hold once we also see typical deal size per merchant, and can we fix last night's missing EUR averages? merchant | currency_code | opportunities_closed | closed_won | closed_lost | win_rate_pct | avg_days_open | avg_amount_eur ------------------------------+---------------+----------------------+------------+-------------+--------------+---------------+--------------- Polder Packaging | EUR | 16 | 12 | 4 | 75.0 | 16.4 | 6400.0 Ballycorran Industrial Supply | EUR | 76 | 63 | 13 | 82.89 | 15.25 | 4063.16 Midland Safety Wear | EUR | 40 | 34 | 6 | 85.0 | 10.43 | 5342.5 Castell Fasteners | USD | 36 | 31 | 5 | 86.11 | 12.85 | 6835.52 Hanse Industriebedarf | EUR | 17 | 15 | 2 | 88.24 | 9.86 | 5511.76 (5 rows) === Report 3: B2B Wholesale: Win Rate and Cycle Time by Deal-Size Band (New Business) (written by Omar) === Engineer's note: Banded by EUR-converted opportunity amount (nearest exchange rate on/before closed_at) for closed New-business opportunities at the 5 named B2B tenants; 5 rows, one per band, ordered by lower bound. REPORT: B2B Wholesale: Win Rate and Cycle Time by Deal-Size Band (New Business) QUESTION: Does a bigger deal size correlate with a better or worse chance of closing, and does it drag out the cycle time? amount_band_eur | opportunities_closed | closed_won | closed_lost | win_rate_pct | avg_days_open ----------------+----------------------+------------+-------------+--------------+-------------- <3000 | 49 | 40 | 9 | 81.6 | 13.9 3000-5999 | 80 | 68 | 12 | 85.0 | 13.5 6000-8999 | 24 | 19 | 5 | 79.2 | 14.7 9000-11999 | 16 | 14 | 2 | 87.5 | 12.5 12000+ | 16 | 14 | 2 | 87.5 | 9.8 (5 rows)