The Highly Engaged

Kindled's activation model calls somebody highly engaged once they have produced three or more tracked actions — an arbitrary line, drawn because the team needed one, and the sort of threshold every growth model eventually acquires. The analytics team wants the list with the action counts beside it so the threshold itself can be argued about. Internal ids are fine here.

events — one row per tracked action. user_id points at a row in users. event_type is one of signup, view_product, add_to_cart and purchase. event_date is the day the action happened. Nothing guarantees a person produces all four kinds, or any particular number of rows.

The table already exists in the database — there is nothing to create or load.

Task: Write a query that returns one row per person with three or more tracked actions, with columns user_id and events — how many actions that person produced. Busiest first; people on the same count are listed with the smaller user_id first.

Example output — shape only, on invented people. The last row shows the boundary: exactly three actions is enough to stay in: