Segments with "Contains" instead of Equals and other hardcoded limitations

Thanks @David To, I am concerned that this was raised a year ago and “shared with the product team” but there does not seem to be any actual changes implemented into the segment builder tools.

I do understand that different data fields are set up differently, but I don’t understand why that should limit what segmenting options are available to us.

I’d like to select anyone whos order starts with “Offline” or anyone whos product contains the word “Bundle” to differentiate them from people who bought individual products - the naming conventions of our “Bundles” have fluctuated wildly over our companies history and are not always selectable from a drop down list as a new “Bundle” may be introduced tomorrow and I would need it to automatically be included in my segment.

I really don’t mean to be a bother, but if the segmenting power of Klaviyo is one of your selling points and there have been limitations and issues that have been pointed out to the product team over the years… this maybe should have gotten a bit more attention?

Or again, at the very least a SQL tool where we can free write our segments the same way we can HTML edit an email block. 

I think something is broken with segments (building) or never has worked as one would assume! :( - Angrily…..

Let’s build a simple segment based on Product Names or maybe Item Names.

We would want to use “contains” - because it’s safe to assume one would NOT have to select each and every product one by one.

Let’s Try ProductNames:

start with:   Placed Order > ProductNames > Contains = enter in part of the product name (same part that is in 30 different products).

Let’s use:   NES 

There’s  NES Single Pack, NES Double Pack, NES Triple Pack, NES Variety Pack, etc…

Contains =   NES

Plus Sign +   indicates = let’s add the keyword all products “contain”.

NO RESULTS.

+++

Let’s Try ItemNames:

try:  Placed Order > ItemNames > Contains = enter in part of the item name (same part that is in 30 different product item names).

Let’s use:   NES 

There’s  NES Single Pack, NES Double Pack, NES Triple Pack, NES Variety Pack, etc…

Contains =   NES

Plus Sign +   indicates = let’s add the keyword all item names “contain”.

NO RESULTS.

+++

Let’s Try and use something different:

Ordered Product > ProductName > ????  = EQUALS? 

But we have 30 different products with X in the ProductName.

Let’s use:   Equals   

and  maybe put it in quotes!  “NES”
Maybe an asterisk ?   NES *

There’s  NES Single Pack, NES Double Pack, NES Triple Pack, NES Variety Pack, etc…


NO RESULTS.