I have a lot of discount codes that contain MGM, can anyone help create a custom event prop to say if contains MGM then bucket as MGM?
It is a listed event prop
Hi Dominic! Julianne from Mixpanel Support here.
Diving right in, I'd recommend using the MAP() function to go through the values in the list and check to see if it contains "MGM".
This could look like the custom prop in the screenshot below. The property goes through each item in the list and checks to see if "MGM" is in the string. If it is, it replaces the string with "MGM". If not, it returns the string itself.
Inline Attachment: image.png