Skip to main content

Use funnels to view all events after an initial event


You can use a funnel to perform an open-ended path analysis and view all events that a group of actors or a particular actor took after an initial event. For example, one use case we've solved using this strategy is understanding all of the events a new user generates within their first week using a service.

Create a derived column that always returns 1

Use the following code to create a derived column that always returns 1.

long always1() {
  return 1;

Build the funnel for the dataset and actor you want to understand

Create a funnel for the dataset and actor combination you're trying to understand. 

  1. Set the entry conditions to use to start collecting events. For example, if you wanted to analyze the events a user takes after creating an account, set the filter to event_type is one of account_create. Or in the illustration, start when the user goes to the Register page. 
  2. Set the second step of the funnel to filter to Always1 equals 0. Since Always1 is always 1, this step will never be fulfilled.
    • For a typical funnel, the funnel is considered complete when the requirements for all steps are fulfilled. To perform this particular path analysis, we want the condition to remain unfulfilled. 
  3. In the Funnel Settings, set All events happen within to the amount of time you want to collect events. Don't set this to be too long of a duration, because queries can get very expensive.
  4. Save the funnel.

Use the funnel to explore your data

In the Explorer, use the funnel to explore your data by setting the filter to <funnel_name>_current_state is equal to 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 have specified.

  • Was this article helpful?