Solved

List most active users

  • 23 August 2021
  • 1 reply
  • 36 views

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.

icon

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.  

Ian

 

 

Reply