=== Report 1: Lost B2B Wholesale Deals: When Does Activity Happen Relative to the Deal's Life (written by Ines) === Engineer's note: Scoped to the 5 named tenants' 'New business' pipeline, opportunities with is_closed=true and is_won=false. Activities with null/zero-duration relative position, or outside [0,1], are grouped into an 'outside window' bucket per the spec; pct_of_lost_opportunities uses a fixed denominator (total lost opportunities in scope) across all rows. REPORT: Lost B2B Wholesale Deals: When Does Activity Happen Relative to the Deal's Life QUESTION: For deals that eventually get lost, does sales activity cluster early, stay steady throughout, or come in a late flurry right before the deal is given up on — or does it go quiet before the end (stalled and forgotten)? lifecycle_quartile | total_activities_in_bucket | pct_of_total_activities | opportunities_with_at_least_one_activity | pct_of_lost_opportunities_with_activity_ -------------------+----------------------------+-------------------------+------------------------------------------+----------------------------------------- Q1 (0-25%) | 12 | 11.88 | 12 | 40.0 Q2 (25-50%) | 31 | 30.69 | 30 | 100.0 Q3 (50-75%) | 35 | 34.65 | 29 | 96.67 Q4 (75-100%) | 23 | 22.77 | 23 | 76.67 (4 rows) === Report 2: Youssef Meijer: Individual New-Business Opportunities (written by Grace) === Engineer's note: One row per closed opportunity owned by Youssef Meijer at Polder Packaging on the 'New business' pipeline; EUR conversion uses the exchange rate as_of the nearest date on or before closed_at. Expect ~7 rows as noted in the request. REPORT: Youssef Meijer: Individual New-Business Opportunities QUESTION: Looking at Youssef Meijer's own deals one by one — which accounts, what sizes, how long open — does his low win rate look like a few bad accounts/territory, or a pattern across all his work? account_name | outcome | amount_eur | currency_code | days_open | created_at | closed_at -----------------------------------------+---------+------------+---------------+-----------+----------------------------+--------------------------- van den Broek Logistiek BV | won | 5300.0 | EUR | 18 | 2023-12-24 19:05:29.039224 | 2024-01-11 17:18:22.797757 Jansen Metaal BV | won | 5500.0 | EUR | 0 | 2024-04-22 12:16:44.95064 | 2024-04-22 12:16:44.95064 Bos & van der Meer Bouw BV | lost | 5400.0 | EUR | 36 | 2024-04-06 14:53:29.325756 | 2024-05-12 14:53:29.325756 Krüger Elektro GmbH | won | 2300.0 | EUR | 18 | 2024-06-29 12:15:02.517082 | 2024-07-17 12:15:02.517082 Mulder Metaal BV | won | 1000.0 | EUR | 13 | 2024-11-07 14:49:34.195554 | 2024-11-20 14:49:34.195554 Claes & Willems Installatie BV | lost | 9300.0 | EUR | 38 | 2025-03-22 12:56:52.584993 | 2025-04-29 12:56:52.584993 van den Berg & van der Meer Logistiek BV | lost | 26000.0 | EUR | 22 | 2025-08-26 14:31:00.093123 | 2025-09-17 14:31:00.093123 (7 rows) === Report 3: Did B2B Wholesale New-Business Pipeline Ever Carry an Open Balance at Month-End? (written by Grace) === Engineer's note: Combined across all 5 named tenants' 'New business' pipelines (one row per calendar month-end, not split by tenant, per the requested grain). Months with no qualifying open opportunities show 0 / NULL / NULL as specified. REPORT: Did B2B Wholesale New-Business Pipeline Ever Carry an Open Balance at Month-End? QUESTION: Is the current complete absence of open new-business pipeline a constant feature of the last three years, or did merchants used to carry live open deals and that's changed recently? month_end_date | opportunities_open_at_month_end | avg_age_days_of_open_opportunities_at_mo | oldest_age_days_of_open_opportunity_at_m ---------------+---------------------------------+------------------------------------------+----------------------------------------- 2023-01-31 | 2 | 4.5 | 5 2023-02-28 | 2 | 11.0 | 13 2023-03-31 | 0 | NULL | NULL 2023-04-30 | 1 | 24.0 | 24 2023-05-31 | 2 | 15.5 | 18 2023-06-30 | 1 | 12.0 | 12 2023-07-31 | 1 | 13.0 | 13 2023-08-31 | 2 | 7.5 | 13 2023-09-30 | 2 | 2.0 | 3 2023-10-31 | 4 | 15.5 | 27 2023-11-30 | 1 | 3.0 | 3 2023-12-31 | 5 | 4.6 | 15 2024-01-31 | 1 | 8.0 | 8 2024-02-29 | 3 | 8.3 | 12 2024-03-31 | 1 | 19.0 | 19 2024-04-30 | 7 | 10.6 | 27 2024-05-31 | 1 | 43.0 | 43 2024-06-30 | 4 | 26.3 | 73 2024-07-31 | 2 | 0.5 | 1 2024-08-31 | 1 | 1.0 | 1 2024-09-30 | 4 | 6.8 | 17 2024-10-31 | 5 | 21.4 | 32 2024-11-30 | 3 | 22.0 | 36 2024-12-31 | 2 | 8.5 | 13 2025-01-31 | 1 | 44.0 | 44 2025-02-28 | 2 | 18.0 | 23 2025-03-31 | 3 | 6.3 | 9 2025-04-30 | 2 | 1.5 | 3 2025-05-31 | 1 | 1.0 | 1 2025-06-30 | 2 | 4.5 | 9 2025-07-31 | 0 | NULL | NULL 2025-08-31 | 4 | 7.0 | 17 2025-09-30 | 3 | 19.0 | 47 2025-10-31 | 5 | 13.4 | 25 2025-11-30 | 1 | 31.0 | 31 2025-12-31 | 0 | NULL | NULL (36 rows)