Funnel Analysis
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.
FunnelMatchStep
Similar to FunnelMaxStep , this function returns an array which reflects the matching status for the steps.
FunnelCompleteCount
This function evaluates all funnel events and returns how many times the user has completed the full steps.
FunnelCompleteCount