Funnel Conversion Count

Problem

Given event streams per user and an ordered funnel (e.g., signup -> add_to_cart -> purchase), count how many users completed each step in order.

Example

users' events -> count reaching each funnel step

Constraints

• Steps must occur in order

Approach

Per-user pointer advancing through funnel steps. Amplitude's bread-and-butter query.