Expand my Community achievements bar.

Enable "equals any of" filter in segment builder

Avatar

Level 3

7/6/17

In segment builder, we have fiew options such as "equals", "contains", "contains all of", "contains any of", "start with", etc. but there is no RegEx and no "equals any of"...

Here is my problem:

I have a prop or an eVar containing an id. I want to filter on this prop or eVar to have only a list of specific ids.

I can't use "equals" and the "OR" operator because the list is too long and I can't add the ids one by one.

I can't use "contains any of" because it's ids, so if I enter "id contains any of 42, 1804, 23", it will return 42, 1804 and 23, but also every id containing those numbers!!! (ex. 425 because it contains 42, 623 because it contains 23, 1000018040002. because it contains 1804)

So I need a "equals any of" that would be an automatic combination of "equals" and OR, in order to match exactly the list.

I guess this would be useful for many users that could be in the same trouble I am.

8 Comments

Avatar

Employee Advisor

7/10/17

Hi there - I realize it's a little less convenient, but would a sequence like this work?

 

eVarX equals 42

  OR

eVarX equals 1804

  OR

eVarX equals 23

Avatar

Level 3

7/16/17

Hi Eric,

yes, it could work...

But as I tried to explain: you will agree that it's very unconvenient for a long list of ids...

For example, let's imagine you have a list of 50 ids. It's very unefficient to drag and drop 50 times the eVar in the segment builder and then copy and paste each id one by one...

Avatar

Level 1

7/15/22

@jen_lasser  I tried to follow your recommendation and instead of using segment that says page contains X OR page contains Y I built segment with page contains any of X, Y. However I am getting different results. DO you know why?Screenshot 2022-07-15 at 13.16.48.pngScreenshot 2022-07-15 at 13.16.07.png

Avatar

Employee Advisor

7/15/22

@Lena_Konst_ sorry I don’t! I would recommend applying those one at a time to a Pages table, and then see what comes back with the “any of” option. 

This thread is about “equals any of” which is more performant. If you are able to look for any of those pages exactly, I’d recommend moving to that operator. It will also return the exact results you expect. Hope this helps!

Avatar

Level 1

7/15/22

OK, thanks @jen_lasser I will have a look at a free moment how to test it one by one.
Can I just clarify 1 thing once I have your attention  
If I use any of operator in a visits segment for pages, it should return all the visits which included pages with any of the phrases listed in the operator.
If I use equals any of operator in a visits segment for pages, I need to list the exact pages names that I have in mind. I see when I am suing the key phrases like in 'any of' it returns 0.

Avatar

Employee Advisor

7/15/22

That is correct - phrases need to be exact with equals any of. For contains, you can just look for portions of the phrase.