Cohort of users with same IP but multiple User IDs

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?

Find more posts tagged with

Event

User Properties

Cohort

Accepted answers

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!

All comments

Dmpm12

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

Esther Trapadoux

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?

Dmpm12

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

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.

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

Quick Links

Unanswered Questions

time format on import from Big Query
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!