%%[ VAR @FirstName SET @FirstName = [hero_name] IF EMPTY(@FirstName) THEN SET @FirstName = "Baker" ENDIF ]%% %%[ var @CampaignID, @CampaignName, @PromotionID, @PromotionName, @EmailTag, @Message, @Brand, @Cell, @SubscriberKey, @SentDate, @email, @brand_preference, @brand_engagement, @campaign_brand /* Populate fields below */ set @CampaignID = "NUK2095775" set @CampaignName = Concat(@CampaignID,"_","Carnation_Pancake_Day_Interactive_Email") set @PromotionName = Concat(@CampaignName ,"_","02") set @EmailTag = "Newsletter" set @PromotionID = Concat(@CampaignID,"_","02") /* Do not touch fields below */ set @campaign_brand= "Carnation" 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 @currentYear set @currentYear = Now() set @currentYear = format(@currentYear,"yyyy") ]%%