Is it possible to create a segment of customers who have placed 2 orders or more over all time, but the first order contained a specific product.
Segment based on purchases
Best answer by bluesnapper
Welcome to the community
Great question!
As
The flow will trigger on their first order for the specific product. So you’ll have a placed order trigger filter for the specific product and a profile filter to only include first-time orders (see below for Shopify for the product ‘’blue_widget’)). Any customer whose first order contains a blue_widget will have their custom property blue_widget_purchased_first_order set to ‘true’.
You can then create a segment using that custom property with the conditions ‘placed order is at least 2 over all time AND blue_widget_purchased_first_order = ‘true’.
That will populate your segment as new orders are processed after the flow is live.
Including historical profiles who have purchased a blue_widget as their first order, can’t be done directly in Klaviyo as exported segment data doesn’t include products ordered and date of orders.
You’ll need to create that list from your ecomm platform. Filter all orders containing blue_widget, export those as a csv. and then manipulate to extract customers where blue_widget was in their first order. Add a column to those profiles of ‘blue_widget_purchased_first_order’ and set all to ‘true’. Then import the email addresses and that additional custom property into Klaviyo mapped to ‘blue_widget_purchased_first_order’.
Your Klaviyo segment above should now contain historical 2+ order customers with blue_widget as their first order and the flow will keep that segment updated with new customers who meet those conditions,
Happy to hear from others on here if there’s a simpler solution!
Hope that helps
Andy


Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.