%%[
var @CampaignID, @CampaignName, @PromotionID, @PromotionName, @EmailTag, @Message, @Brand, @Cell, @SubscriberKey, @SentDate, @email, @brand_preference, @brand_engagement, @campaign_brand
/*
Populate fields below
*/
set @CampaignID = "NUK3161351"
set @CampaignName = Concat(@CampaignID,"_","NUK3161351_NHSc_TalkingTubeFeeding_January_2025_Newsletter")
set @PromotionName = Concat(@CampaignName ,"_","01")
set @EmailTag = "Newsletter"
set @PromotionID = Concat(@CampaignID,"_","01")
/*
Do not touch fields below
*/
set @campaign_brand= "Talking Tube Feeding Consumer"
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)
SET @FirstName = [hero_name]
]%%
Blended Diet Network is back!