Funnel Analysis Functions

Apache Pinot supports a few funnel functions:

FunnelMaxStep

FunnelMaxStep evaluates user interactions within a specified time window to determine the furthest step reached in a predefined sequence of actions. By analyzing event timestamps and conditions set for each step, it identifies the maximum progression point for each user, ensuring that the sequence follows the configured order or other specific rules like strict timestamp increases or event uniqueness. This function is instrumental in funnel analysis, helping businesses and analysts understand user behavior, measure conversion rates, and identify potential drop-offs in critical user journeys.

https://github.com/pinot-contrib/pinot-docs/blob/latest/functions/funnel/funnelmaxstep-1.md

FunnelMatchStep

Similar to FunnelMaxStep , this function returns an array which reflects the matching status for the steps.

https://github.com/pinot-contrib/pinot-docs/blob/latest/functions/funnel/funnelmaxstep-2.md

FunnelCompleteCount

This function evaluates all funnel events and returns how many times the user has completed the full steps.

https://github.com/pinot-contrib/pinot-docs/blob/latest/functions/funnel/funnelcompletecount.md

FunnelCount

This function evaluates funnel steps and returns the distinct correlated counts for each step.

https://github.com/pinot-contrib/pinot-docs/blob/latest/functions/funnel/funnelcount.md

Additional Reference Pages

• funnelmaxstep.md