How can I find users who have completed a certain sequence of actions?

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
Segentation
Cohort Analysis
Path Analysis
Funnel Analysis