Create Segment For Expiring Coupons

Hi @paulo @CandyPink @retention, hope everyone is doing well! 

I just wanted to chime in on this thread to clarify some aspects regarding coupon codes that Klaviyo can and can not do today. 

• Filtering for coupons only works for static coupons, not dynamic coupons. Unfortunately, @paulo if you use a dynamic code, you would not be able to filter by “contains”. 
   
• If you are using a unique coupon in a flow, you could determine if someone has used a coupon based on the “placed order” metric. While that doesn’t explicitly say someone did or did not use that unique coupon, it gets you pretty close to knowing if someone placed an order by opening an email that contains the code and placed an order shortly thereafter. It is a common request that we hear from our customers that they’d want to be able to filter from dynamic coupons, and its something our team is evaluating. 
   
• It’s recommended that if you want to thoroughly track coupon codes, you should opt to use Static Codes. Alternatively, another method you could try to do is to send a dynamic coupon code in a Flow and setting a delay (ie. 60 days) after the email with the coupon code (in this case, it’s email 2). You can then set a conditional split on the “Placed Order” metric and if they have placed an order since entering this flow, they would exit the flow and if they have not, then you can send them Email #3 with a reminder to use their coupon. 
   

  

   

Hope this helps to clarify coupons! You can also reference our help center article on How to Use Coupon Codes & How to Use Unique Coupon Codes within Shopify (alternatively, if you have another integration, you can see the Coupon articles here.) 

-Cass. 

Hello @porter,

Great question!

Currently, there is no way to segment by users who has ever used a coupon code within Klaviyo. This is because Klaviyo is actually not completely informed when a coupon code has actually been used outside of the Placed Order event. As @cassy.lee had pointed out, this can be easily accomplished if you only used static coupon codes by using a segmentation rule such as “What someone has done, Placed Order at least once where Discount Codes contain STATIC_COUPON_A, STATIC_COUPON_B, STATIC_COUPON_C...” by listing out all your static coupon codes. This would be much harder to accomplish if you used dynamic coupon codes as each dynamic code would be unique. 

One solution I can recommend to identify users within your account that have used a coupon code versus those who have not, would be exporting this data from your ecommerce backend and then use Klaviyo to cross reference the results. For example, you should be able to export this sort of data from your ecommerce backend to identify all users who have used a coupon at least once. From there, you can import this customer data back into Klaviyo as a static list. Then to cross reference those contacts within your Klaviyo account who has made a purchase but has not used a coupon code, you can create a segment with the rules “What someone has done, Placed Order at least once over all time AND If someone is or is not in a list, Person is not in IMPORTED_LIST”. The resulting segment will return a list of customers who has placed an order at least once but is not in this list you imported which would be customers who has used a discount code at least once. You can certainly adjust these rules based on your goals as well such as simply using only the “If someone is or is not in a list, Person is not in IMPORTED_LIST” definition to capture all customers in your account, including those that have not purchased from you.

I hope this helps!

David