Skip to main content
Solved

"Does not contain" filter not working?

  • August 26, 2021
  • 2 replies
  • 1379 views

Forum|alt.badge.img

Hi, all!
 
 I’ve been trying to do something that I believe is supposed to be easy but it is not working as expected: Create a chart displaying New Users, but filtering users whose email (a custom property) does not contain a specific string.

I am trying to use the does not contain matching option, but it is always returning all the users.
In the following screenshot is a test I have done to check that:
 

Chart definition: Segment 1: All Users, Segment 2: Users whose email contains @hotmail.comSegment 3: Users whose email does not contain @hotmail.com


 

Result
  • Segment 1: All Users: 20
  • Segment 2: Users whose email contains @hotmail.com: 1
  • Segment 3: Users whose email does not contain @hotmail.com: 20

I was expected segment 3 would return 19 users, since the total is 20 and only 1 has an email with the string @hotmail.com, but it is returning all the 20 users (I doubled-checked it downloading the users and checking the email)

I’ve also made the same analysis but instead of using contains and does not contain, I’ve used glob match and glob does not match and the result was also confusing: glob match worked as expected, but glob does not match returned all the users.

 Have anyone experienced something like this or could help me to understand it? I’ve been struggling with this for quite a while.
 
 Thanks in advance!

Best answer by MikkoKarvonen

This is likely related to searching for New Users and that user property not being present in the first events sent to Amplitude. Essentially all your users have had events where the user property email does not contain @hotmail.com, because they have all had events where it’s empty.

Try setting up your search like this instead: https://analytics.amplitude.com/demo/chart/new/wn7qaxu

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

2 replies

Forum|alt.badge.img

Hello everyone, I also noticed the same issue. The article from Amplitude suggest to use segmentation to exclude internal users but it does not work for ‘does not contain”.

 

Does anyone have any suggestions to resolve it?


MikkoKarvonen
Peer Moderator
Forum|alt.badge.img+3
  • Peer Moderator
  • 113 replies
  • Answer
  • December 16, 2021

This is likely related to searching for New Users and that user property not being present in the first events sent to Amplitude. Essentially all your users have had events where the user property email does not contain @hotmail.com, because they have all had events where it’s empty.

Try setting up your search like this instead: https://analytics.amplitude.com/demo/chart/new/wn7qaxu


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