Is there a way to claim a row multiple times for the same customer using the claim row function? In my case I have a DE created with bunch of coupon codes with the required fields as per this guide ClaimRow
The code that I'm using is working fine and it's claiming a row as expected, assigning the details etc. but the issue I have is that a customer should be able to receive a coupon code multiple times if it's qualified so if the same customer came back in a month or so they should be able to get a new code from the list.
At the moment once a customer received a promo code and enter the journey second or third time (can be more) it will be assigned with the same code as I believe this is based on his ContactID that already exist in the DE. I want to be able to assign a coupon codes more than once for the same customer.
I came across this case which is similar to my issue but the solution given is only for claiming 2 rows for the same customer by setting ClaimRow1 and ClaimRow2. I assume you can continue but in my case the customers can claim a coupon multiple times so I won't know how many ClaimRows to set.
Is there a way to make this work?
Here is the code I'm suing:
var @ContactKey, @UnclaimedCodes, @couponRow, @couponCode set @ContactKey = AttributeValue("ContactID") set @UnclaimedCodes = LookupRows("TEST Dropless Coupon Codes", "IsClaimed", "False") set @couponRow = ClaimRow("TEST Dropless Coupon Codes", "IsClaimed", "ContactKey", @ContactKey) if Rowcount(@UnclaimedCodes) > 0 THEN SET @couponCode = Field(@couponRow, "CouponCode") endif