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

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.

Find more posts tagged with

Accepted answers

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

All comments

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

Matthew Sia

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

eddie.gaona

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.

Quick Links

Unanswered Questions

Why my chart doesn't synchronize
Hi, When I add a chart (widget) to my dashboard, and then go to the content and modify the chart (I user another type for exemple) and save, my dashboard doesn't reflect the latest modification. Would you by any chance know why ? Thank you
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…