List most active users

  • 23 August 2021
  • 1 reply

I want to list my users sorted in the order of orders. Using SQL I can have a query similar to the following


SELECT user_id, count(*) AS num_orders

  FROM events

  WHERE event_name=’ORDER_SUCCESS’

  GROUP BY user_id

  ORDER BY num_orders DESC


How do I achieve the same in Mixpanel without having to update the user-profile every time an order is placed.


Best answer by ian 25 August 2021, 19:11

View original

1 reply

Userlevel 2
Badge +2

Hey Amit,

You should definitely be able to do this in an Insights report in Mixpanel.  First, you would select the ORDER_SUCCESS event in Insights.  From there, you breakdown by user_id and it should show the number of orders per user and you can then sort it in descending order at the top of the chart.