Quick Thoughts on Funnel Metrics
Data Diver max_interana
Data Diver
‎11-30-2016 04:46 PM
‎11-30-2016 04:46 PM

INTRODUCTION

Let's start with the simple dataset I've been using for my previous blog posts:

Screen Shot 2016-11-30 at 2.39.25 PM.png

 

Our dataset has 11 events that happen around 5AM on 11/15/2016. We have two user_ids (shard_keys) in our dataset.

Now let's create a funnel for each user_id with the following steps:

Step1: Log In - event_name is one of log_in
Step2: View Page - event_name is one of view_page

Step3: Purchase - event_name is one of purchase
Step4: Log Out - event_name is one of log_out

with our steps defined as follows:

Screen Shot 2016-11-30 at 2.51.18 PM.png

 

So we have a funnel on our dataset for each user_id comprised of 4 steps where all events have to happen within 20 minutes of the first funnel event and we will not reset the funnel if an event matches Step 1.

FUNNEL VISUALIZATION

The resulting visualization is as follows:

Screen Shot 2016-11-30 at 3.01.33 PM.png

 

These numbers makes sense based on our dataset:

Screen Shot 2016-11-30 at 3.07.47 PM.png

 

We have two user_ids who made it to step 1, two user_ids who made it to step 2, one user_id who made it to step 3, and one user_id who made it to step 4.

 

PER-FUNNEL METRICS

When we create a funnel, there are several metrics that are created:

Screen Shot 2016-11-30 at 3.19.46 PM.png

 

Let's go through them one by one and see how they relate to our data:

Screen Shot 2016-11-30 at 3.48.20 PM.png


The Funnel.Terminal_State is a metric calculated on a per-funnel instance basis. It returns the farthest step reached within the funnel instance. In the first funnel, user_id 1 made it as far as view_page so the funnel.terminal_state for that first funnel is equal to 2. In the second funnel, user_id 2 made it as far as log_out so the funnel.terminal_state for the second funnel is equal to 4. 

Screen Shot 2016-11-30 at 3.55.13 PM.png

The Funnel.Current_State is also a metric calculated on a per-funnel instance basis. It returns the most recent step reached within the funnel instance. In the first funnel, events 3, 4, and 5 will have a funnel.current_state of 2 since step 2 was the most recent step in the funnel (event 2). In the second funnel, events 8 and 9 will have a funnel.current_state of 2 since step 2 was the most recent step in the funnel (event 7).

Screen Shot 2016-11-30 at 4.09.58 PM.png

 

The Funnel.transition_time_to_current_state is also a metric calculated on a per-funnel instance basis. It returns how long it took to get from the previous step to the current_state. Since it took 1 minute to get from step 1 of the funnel (event_number 1) to step 2 of the funnel (event_number 2), events 2-5 will have a funnel.transition_time_to_current_state of 1 minute since their Funnel.current_state metric=2.

Screen Shot 2016-11-30 at 4.18.25 PM.png

The user_id.Funnel.time_between.1.2 is a metric calculated on a per-actor basis, not a per-funnel instance basis. It is an average of how long it took the user_id to go from step 1 to step 2 over all of their funnel instances.

 

In this case, user_id 1 had one funnel and it took 1 minute to get from step 1 to step 2. The user_id.Funnel.time_between.1.2 for user_id = 1 minute / 1 funnel = 1. Say that user_id had a second funnel during this time range where it took 2 minutes to get from step 1 to step 2. The user_id.Funnel.time_between.1.2 would then be (1 minute + 2 minutes) / 2 funnels = 1.5.

The same logic for user_id.Funnel.time_between.1.2 would apply to user_id.Funnel.time_between.2.3 and user_id.Funnel.time_between.3.4.

Screen Shot 2016-11-30 at 4.33.11 PM.png

 

The user_id.max.funnel.terminal_state is a metric calculated on a per-actor basis. It returns for each user_id, what is the farthest point the user_id reached in the funnel over all of their funnel instances. The farthest that user_id 1 made it over all of their funnels is step 2 and the farthest that user_id 2 made it over all of their funnels is step 4. 

In a later blog post, I'll talk about some ways to use these per-funnel metrics to do cool things in Interana!

2 Comments
tiffany
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 max_interana
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 Smiley Very Happy

 

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