Help need in query

[Kumar Vivek]

So, I have a table which contains following columns - event_id, domain_userid, collector_tstamp, se_action.

I want to funnel analysis. Website has 3 levels -

Level 1 - SERP (search page)
Level 2 - view ad
Level 3 - conversion (something like checkout)

Based on level se_action can be following - SERP based on category, SERP based on location, AdDetails, SomeConversion.

I want events/users who has exactly followed this pattern

(SERP based on category -> AdDetails -> SomeConversion)

Some of the possibilities:

Possibility 1: consider

SERP-category ->Addeatils ->conversion

Possibility 2: don't consider

SERP category ->SERP location ->Ad details

Possibilty 3: consider and count should be 2 for SERP -> Ad detail and count 1 for SERP category ->Ad details -> conversion

SERP category -> Ad details ->Back to SERP category ->Another Ad -> conversion


I am unable to figure out query for this situation