Do you know the British clothing brand Boden? Well, I was a fan during 2 years and of course, I received tons of emails in that time.
This weekend, I was sorting my mailbox and I saw this email below
Then one question comes in my mind: how to create this e-mail with Salesforce Marketing cloud? Let’s look at this together …
1) Create a Data extension named
{ CouponCodes}
Fields:
{Name= Couponcode ; Data type= Text; Length =100; Primary Key= True, Nullable= none; Default Value = none}
{Name= Isclaimed; Data type= Boolean; Length =none; Primary Key= false, Nullable= true; Default Value = False}
{Name= EmailAddress; Data type= EmailAddress; Length =none; Primary Key= false, Nullable= true; Default Value = none}
2) Create a list of coupon codes like the ones below and save them in a CSV file
3) After that, you can import the data in your Data extension create “ Codes Coupons”
To do that, return to your data extension and click on the “import” button.
4) For this last step in Email studio, add this AMPScript to your e-mail.
%%[
var @couponRow, @email, @couponCode
set @email= AttributeValue(“EmailAddress”)
set @couponRow = ClaimRow(“CouponCodes”,“IsClaimed”, “EmailAddress”, @email)
if empty(@couponRow) then
RaiseError(“No coupon code”, false)
else
SET @couponCode = Field(@couponRow,“CouponCode”)
endif
]%%
Your coupon code: %%=v(@couponCode)=%%
By the way, you can follow #Boden 🙂
Some pieces of the new collection here 🙂
See you soon with a new post!
Live with pleasure
Cornelia