Skip to main content
Solved

What is the best way to create a segment/cohort that tracks accounts with more than 1 unique user?

  • April 11, 2024
  • 3 replies
  • 201 views

For example, I want to review all the accounts that have more than 1 active user. We have account_id and user_id properties on the events, but how do I filter out accounts that only have 1 active user_id.

Best answer by Saish Redkar

Hi @Matthew Sia 

Are you using the account add-on to instrument your accounts as groups?
If yes, then a cohort definition like this can help to identify orgs with 1 active user_id

 

View original
Did this topic help you find an answer to your question?

3 replies

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1378 replies
  • Answer
  • April 12, 2024

Hi @Matthew Sia 

Are you using the account add-on to instrument your accounts as groups?
If yes, then a cohort definition like this can help to identify orgs with 1 active user_id

 


  • Author
  • New Member
  • 1 reply
  • April 12, 2024

That’s it. I was looking for something like that “distinct values of property”. Thank you!


eddie.gaona
Team Member
Forum|alt.badge.img+9
  • Amplitude Support
  • 161 replies
  • April 15, 2024
Hello,

Thank you Saish for stepping into this thread and providing a solution!

-Eddie


P.S. Checkout upcoming events and user meetups on our events page.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings