Use funnels to track user activity
This example uses funnels to view all events that a group of actors or a particular actor took after an initial event. One real-world use case that we've solved using this strategy is understanding all of the events a new user generates within their first week using a service.
Start by creating a derived column that always returns 1. We named this column Always1
.
long always1() { return 1; }
To create a funnel for the actor you want to understand, specify the following conditions:
- In the first step of the funnel, set the entry conditions for collecting events. For example, if you want to analyze the events a user takes after creating their account, set the filter to
event_type='account_create'
. - Set the second step of the funnel to filter to Always1 "is one of" 0. Since
Always1
will always be 1, this requirement will never be fulfilled. - Funnel Settings: Set All events happen within to the period of time for which you want to collect events.
Save the funnel. In the Explorer, set the Filter to <yourfunnel>_current_state = 1
to filter to all events that happened during the funnel period.
Experiment with additional filters to understand the actions of certain groups of your users within the period you specified.