guillaumelachaud

SELECT
  org_id,
  org_name
FROM
  organization
WHERE
  did(org_id, "sign_up")
  AND then_did(org_id, "add_credit_card", "<=5m")
  AND then_did(org_id, "signed_form", "<=5m")
  AND never_did(org_id, "chat_started")

guillaumelachaud

WITH
  signup_occurrences AS (
  SELECT
    DISTINCT tracks.timestamp AS timestamp,
    orgs.org_id,
    tracks.event
  FROM
    `lazylantern.junon_webapp.tracks` tracks
  LEFT JOIN
    `lazylantern.junon_webapp.groups` orgs