Not a number in a chat.An analysis you can re-run.

1-- Week 27 conversion, split by first-touch surface.
2-- Excludes internal domains: they run the smoke suite hourly and
3-- accounted for 4.1% of week-27 signups before this filter.
4with first_touch as (
5  select account_id,
6         min(occurred_at)                       as first_seen,
7         argmin(surface, occurred_at)           as surface
8    from events
9   where occurred_at >= date "2026-06-29"
10     and email not like "%@acme-internal.example"
11   group by account_id
12)
13select surface,
14       count(*)                                  as accounts,
15       countif(converted_at is not null)         as converted,
16       round(countif(converted_at is not null)
17             / count(*), 4)                      as rate
18  from first_touch join accounts using (account_id)
19 group by surface
20 order by accounts desc;