Hey @OG-GolfGUY,
When creating segments based on the “contains” logic, you would need to either input the exact phrasing or select the object from the dropdown menu. The “contains” logic does not accept partial matches as you’ve assumed.
There’s been some past discussion on this, and @alex.hong has some great explanation for this sort of behavior in the Community post below:
David
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.
Hey @dgibbs,
Thanks for sharing that specific use case and the suggestion of an SQL tool as a workaround. I’ll add it to the notes shared with our product team.
I’ll be sure to share any updates or news regarding enhancements to the segmentation functionality!
Thanks for being a part of the Klaviyo Community!
David
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.
Hey @dgibbs,
Really appreciate you sharing this feedback on our segment conditions! I’ll certainly share these thoughts with our Product Team to explore further. I particularly appreciate the feedback on the date conditions and selecting multiple values.
When it comes to the equals or contains condition, this would actually depend on the data type of the property and value you’re writing the logic for. I briefly explained this in a similar Community post which I’ve included below:
I hope this clarifies some things,
David