Skip to main content
Solved

Cohort of users with same IP but multiple User IDs

  • February 12, 2024
  • 4 replies
  • 311 views

I want to create a cohort of users who performed a specific event using the same IP address but have multiple User IDs (user property). Could someone please help guide me in the correct direction?

Best answer by Saish Redkar

Hi @Dmpm12 

Translating this requirement in cohort definition is a bit tricky.

If your use case was identifying user ids who have had multiple IP address recorded on events, then the distinct property count clause would have been helpful.

Since your primary entity is the IP address, I would suggest trying out an event segmentation chart using “Any Event” + uniques + group by IP address. If an unique IP has a count > 1 in this chart, you will see more than one user ID associated with that IP.

Let me know if I have interpreted your question correctly. Hope this helps!

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

  • February 12, 2024

@Esther Trapadoux or @belinda.chiu could you please help with this?


Esther Trapadoux
Community Manager
Forum|alt.badge.img+9

@Dmpm12 good question! IP Address is a default property in Amplitude. When you search for user properties, do you not see IP Address in the dropdown?


  • February 12, 2024

I do but my question is how do I complete the specific analysis? @Esther Trapadoux 


Saish Redkar
Expert
Forum|alt.badge.img+10

Hi @Dmpm12 

Translating this requirement in cohort definition is a bit tricky.

If your use case was identifying user ids who have had multiple IP address recorded on events, then the distinct property count clause would have been helpful.

Since your primary entity is the IP address, I would suggest trying out an event segmentation chart using “Any Event” + uniques + group by IP address. If an unique IP has a count > 1 in this chart, you will see more than one user ID associated with that IP.

Let me know if I have interpreted your question correctly. Hope this helps!


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