Mixpanel Community Icon

Analyzing Active Users per Client Segmented by Monthly Usage

·
·

Hi, I have users (distincit id) and clients (client_id). i want to see how many active users i in average have per client per month. --> i would like to have it in segments: 0 users 1-2 users 2-5 users 5+ users could anyone help me with this task?

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    Is the client_id a user property or is it something being tracked on a certain event(s)

  • Avatar of Philip J.
    Philip J.
    ·
    ·

    Tracked on the event

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    I tried to simulate this with my data structure and I think you would need group analytics feature and set the client id as the group

  • Avatar of Philip J.
    Philip J.
    ·
    ·

    do you have 10 mins for a call to help out with this?

  • Avatar of Philip J.
    Philip J.
    ·
    ·

    today

  • Avatar of Christopher C.
    Christopher C.
    ·
    ·

    Without the nice segments, you should just be able to do 'Any event' -> Unique users -> Breakdown by client_id yeah?