Segments value limits when using contains any of

Avatar

Avatar

kostjohn87

Avatar

kostjohn87

kostjohn87

26-09-2018

Hi,

Im trying to isolate about 10k values in a segment using the contains any of filter/logic. Essentially if any of these 10k values are in the hit, visit or visitor only show me corresponding behavior for this segment. I uploaded using the segments api and everything saves and works fine there. But when I try to pull the segment in on workspace Im getting the dreaded contact support alert. In Report builder it just keeps queuing and never processed(at least in the 2 hours I had it running) and Data Warehouse it processed 1 day in 2 hours(request had 30 day range in it, doesn't seem right it would take 60 hours for this, projecting out based off the 1 day processing time). So that led me to inquire about the best practices or limits that might be involved with the segments.  So is there a limit on how many you can isolate? Is this a

performance issue. Any help would be greatly appreciated.

example segment contains any of.PNG

View Entire Topic

Avatar

Avatar

settytb1

Employee

Avatar

settytb1

Employee

settytb1
Employee

26-09-2018

Hi kostjohn87,

A segment is not meant to be a limitless list of conditions.  For example in your case the best use case would be to setup classifications on that variable.  Setup a column of like Auth GUID type or whatever.  Then just do a vlookup in excel with your list of ID's.  If the guid meets your list set the type to be X.  Then build a segment based on the Auth Guid type = X.  This makes the segment much simpler, and frankly easier to manage with classifications bulk export/import capabilities. 

I hope that helps,

Seth