Quick Thoughts on Funnel Metrics
Data Diver max_interana
Data Diver
2 Comments
Enthusiast

Hi @max_interana,

 

Thanks for posting this. In your dataset you have a column titled "funnel #" -- it seems you only have one funnel created, however you refer to them as two different funnels (i.e. funnel 1 and funnel 2). Can you please clarify what you mean by funnel 1 and funnel 2? Do you mean that a single visitor (username = max) passed through the funnel 2 times? 

 

Let's say with your dataset example, Max is the single visitor that made 2 pass throughs the same funnel (user_id 1 did all events 1 thru 11) . In Max's first pass through (events 1 thru 6), the furthest step he made it to is step 2. In Max's second pass through, he made it to step 4. If we set max.current_state = 4 in Explorer, and then added "event_number" in the GROUPS part of the COMPARE section, would we see events 1 thru 11, or events 6 thru 11, or what events would we see?

 

Thank you!

 

Kindly,

 

Tiffany

Data Diver

Hi Tiffany,


So when I say funnel 1 and funnel 2, I'm talking about different instances of the same funnel!

In this dataset, user_id 1, whose username is Max, enters the "Log In - View Page - Purchase - Log Out" funnel on their first event (event 1). 

 

user_id 2, whose username is also Max but is a different user_id also enters the funnel on their first event (event 6). 

Not sure if both user_ids having the same username was on purpose or not when I constructed the dataset :D

 

To answer your question of 

"If we set max.current_state = 4 in Explorer, and then added "event_number" in the GROUPS part of the COMPARE section, would we see events 1 thru 11, or events 6 thru 11, or what events would we see?"

Were you referring to the user_id.max.Log In - View Page - Log Out.terminal_state funnel metric? If we filtered to events where user_id.max.Log In - View Page - Log Out.terminal_state = 4 and grouped by event_number, we would see user_id 2's events, 6 through 11.

I hope this helps! Let me know if I answered all of your questions or whether you have any more.

Best,

Max