I hope you’re doing safe and well :).
I need your help with some JQL Funnel Analysis. The reason why we need this even though we have that information in a MixPanel Dashboard is that we want to give access to staff that actually do not have MixPanel users. Also, we want to import this into a Google Sheet and then do some sort of Slack integration.
Our funnel consists of two events:
- Started Pre-sales Chat
- Trial Started
There’s a filter in the first event, the conversion window between the two events is 24hs (this is really important to include in the JQL code) and we also need it broken down by the Agent Property in the first event (Started Pre-sales Chat).
I found the sample code for funnel analysis on the JQL docs but it doesn’t take into consideration the breakdown or window conversion. I also found this old topic on how to add breakdowns to the funnel results but without conversion window either.
Basically, I need to replicate what I already have in the existing funnel but in JQL. I attached screenshots of the funnel for clarity purposes.