%%[
var @CampaignID, @CampaignName, @PromotionID, @PromotionName, @EmailTag, @Message, @Brand, @Cell, @SubscriberKey, @SentDate, @email, @brand_preference, @brand_engagement, @campaign_brand
/*
Populate fields below
*/
set @CampaignID = "NUK1666202"
set @CampaignName = Concat(@CampaignID,"_","SmartiesxMilkybar_Christmas")
set @PromotionName = Concat(@CampaignName ,"_","01")
set @EmailTag = "Newsletter"
set @PromotionID = Concat(@CampaignID,"_","01")
/*
Do not touch fields below
*/
set @campaign_brand= "Smarties"
set @Message = emailname_
set @Brand = brand
set @Cell = customer_retention_date_band
set @SubscriberKey = _subscriberkey
set @SentDate = xtshortdate
set @SendId = jobid
set @email = emailaddr
set @brand_preference = brand_preference
set @brand_engagement = brand_engagement
InsertDE("Campaign Reporting Extract_Consumer","CampaignID", @CampaignID,"CampaignName", @CampaignName,"Message", @Message,"PromotionID", @PromotionID,"PromotionName", @PromotionName,"EmailTag", @EmailTag,"Brand", @Brand,"Cell", @Cell,"SubscriberKey", @SubscriberKey,"SentDate", @SentDate, "SendId", @SendId, "email", @email, "brand_preference", @brand_preference, "brand_engagement", @brand_engagement, "campaign_brand", @campaign_brand)
var @FirstName
SET @FirstName = [hero_name]
IF EMPTY(@FirstName) THEN
SET @FirstName = "Smarties Lover"
ENDIF
/* To use personalisation copy and paste the below variables into your email
%%=v(@FirstName)=%%
*/
var @currentYear
set @currentYear = Now()
set @currentYear = format(@currentYear,"yyyy")
]%%
