Cohort not filtering user property consistently

I’ve defined a cohort to exclude internal users by defining it as:
Did have user property email, does not contain, catchbio.com any time since 1/1/2024

However when I look at charts with this cohort filter applied I still get some events for users with catchbio.com emails for example “alex+test06@catchbio.com”. We’ve been making a lot of test accounts in succession to de-bug things.

I’ve even added the specific emails directly to the list of does not contain. What am I missing?

Thanks,
Alex

Find more posts tagged with

Cohort

Accepted answers

eddie.gaona

Hi Alex,

Thank you for reaching out! I understand you’re experiencing an issue with your cohort definition to exclude internal users based on the email property, as events for users with 'catchbio.com' emails are still appearing. Let’s work through this together.

From your description and the screenshots provided, it seems the issue might be related to how Amplitude evaluates user properties over time. Here are a few key points to consider:

**Cohort Logic**: When using the 'does not contain' filter, Amplitude includes users who, at any point in the selected time range, did not have the specified value for the user property. This means:

- If a user performed an event without an email containing 'catchbio.com' at any time during the time range, they would qualify for the cohort, even if their email now contains 'catchbio.com.'
- The cohort logic evaluates user properties at the event level, not based on the most recent user property value.

**Possible Scenarios**:

- Users may have performed events before their email property was set or with a different email value.
- If the email property was updated via the Identify API, the update applies only to future events and is not retrospective. This could result in events with older email values still appearing.

**Suggested Next Steps**:

- Update your cohort definition to filter users based on their **most recent** email property value. This ensures that only users whose current email does not contain 'catchbio.com' are excluded.
- You can find more details about cohort definitions and filtering in our Behavioral Cohorts documentation: https://amplitude.com/docs/analytics/define-cohort#user-property-clauses.

Let me know if these steps help clarify the issue or if you’d like further assistance. I’m happy to dive deeper into this with you!

Best,
Eddie

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

All comments

eddie.gaona

Alex Bullock

eddie.gaona thank you. The explanation of how the cohort logic works with ‘does not contain’ is really helpful for wrapping my head around the issue. Using “most recent” does seem to work the way I want it to. Much appreciated!

eddie.gaona

Hi Alex,

I’m glad I could help. If you have any other questions or run into anything else, don’t hesitate to reach out—I’m always happy to assist.

Best,
Eddie

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

Quick Links

Unanswered Questions

playing videos 9:16 (vertical) in an iOS guide?
Hi all, We are getting set up on Amplitude and want to be able to have demo videos automatically show up in a guide in a 9:16 ratio (vertical/portrait) and not in the crunched landscape orientation that the current frame delivers for Vimeo and YouTube. We are using the iOS SDK, which seems like it may be the limiting…
Trying to import new user attribute from CSV but it doesn't work
I have a csv with 2 columns user_id and lead_source. I went to Catalog and selected CSV under Lookup Tables. Step 1: I brought in the CSV and Step 2: I mapped the first column (user_id) to User ID (Amplitude User). It showed me a sample of my CSV and showed both columns at the bottom of Step 2. I clickd Finish. I went to…
How to filter by Event properties in Segmentation chart
I am unable to find my Event Properties in the list of “+ Filters” in Segmentation chart.
notifications.integration.saveFailure - Unable to add Facebook Cohort as a Destination
Myself and other team members have tried using the Facebook Cohorts integration however we always receive the same error ‘notifications.integration.saveFailure When looking in Meta Business Manager it says that the integration is active however when going into the Destinations tab in Amplitude, it is blank I have tried the…
User ID is converting to a big number
I am setting user property wallet address, and using the same variable to set user ID. However, while walletAddress works (0xA66...54), User ID seemingly converts the hex to a big number (1.2905460614871781E+48) which is preventing us from using filtering and views. Any ideas?