I use the same AMP-script to send individual coupon codes in several newsletters. Until now It always worked very well.
This is the AMP Script I use:
%%[ /* COUPON VALIDITY */ VAR @CouponRow , @Coupon SET @CouponRow = ClaimRow('Geburtstagsgutscheine2021_ID', 'Used',"Email", @email) IF EMPTY(@CouponRow) THEN SET @Coupon= "Sie haben schon einen Coupon bekommen." ELSE SET @Coupon= FIELD(@CouponRow,'Geburtstags_Gutschein') ENDIF ]%%
With this AMP-Script I claim a coupon code and while claiming it I write the claim date and the email of the customer who received the code into the coupon code data extension.
My problem is, that every time I want to claim a code, the email field in the first available row of the coupon code data extension stays empty. Nevertheless, at first glance it looks like the next rows in the coupon code data extension are claimed correctly.
But at second glance all customers receive receive the code from the row with the empty email field. Although their addresses claimed an own code in the coupon code data extension.
Does anybody of you have a suggestion for me on how to solve this problem?
Thank you for your help and best regards Jessica