How can I find users who have completed a certain sequence of actions on my site?
you want to see which have your users have completed the series of the next actions:
-action a
-action b
-action c
-action d
as well as who did not continue the process all the way and where they dropped off.
SELECT STEP_ID, STEP_NAME, USER_COUNT
FROM cooladata
WHERE date_range(last 7 days) AND 1 = 1
CLUSTER FUNNEL BY user
STARTS WITH 'action a'
FOLLOWED BY 'action b'
FOLLOWED BY 'action c'
FOLLOWED BY 'action d'
END CLUSTER