Skip to content

Instantly share code, notes, and snippets.

@guillaumelachaud

guillaumelachaud/funnel_simple.sql

Created October 7, 2021 09:24
Show Gist options
  • Save guillaumelachaud/50e56524315ab842b96fca38cd80fd31 to your computer and use it in GitHub Desktop.
Save guillaumelachaud/50e56524315ab842b96fca38cd80fd31 to your computer and use it in GitHub Desktop.
Download ZIP
Simplified query
Raw
funnel_simple.sql
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")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment