Анализ, который можно перезапустить — не число в чате.

-- Week 27 conversion, split by first-touch surface.
-- Excludes internal domains: they run the smoke suite hourly and
-- accounted for 4.1% of week-27 signups before this filter.
with first_touch as (
  select account_id,
         min(occurred_at)             as first_seen,
         argmin(surface, occurred_at) as surface
    from events
   where occurred_at >= date '2026-06-29'
     and email not like '%@acme-internal.example'
   group by account_id
)
select surface,
       count(*)                          as accounts,
       countif(converted_at is not null) as converted,
       round(countif(converted_at is not null)
             / count(*), 4)              as rate
  from first_touch join accounts using (account_id)
 group by surface
 order by accounts desc;

Иллюстрация. Исключённый домен — placeholder, не реальный клиент или tenant.