|
Don't miss out! Your cuppa could be a winner
%%[
var @CampaignID, @CampaignName, @PromotionID, @PromotionName, @EmailTag, @Message, @Brand, @Cell, @SubscriberKey, @SentDate, @email, @brand_preference, @brand_engagement, @campaign_brand
/*
Populate fields below
*/
set @CampaignID = "NUK1857826"
set @CampaignName = Concat(@CampaignID,"_","Nescafe_PDC_Nov23_Email_2")
set @PromotionName = Concat(@CampaignName ,"_","01")
set @EmailTag = "Newsletter"
set @PromotionID = Concat(@CampaignID,"_","01")
set @campaign_brand= "Nescafe"
/*
Do not touch fields below
*/
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 = "Coffee Lover"
ENDIF
SET @q1_start_the_day = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_start_the_day","CCID",@SubscriberKey)
SET @q1_be_refreshed_and_uplifted = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_be_refreshed_and_uplifted","CCID",@SubscriberKey)
SET @q1_recharge_during_the_day = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_recharge_during_the_day","CCID",@SubscriberKey)
SET @q1_for_your_wellbeing_and_wellness = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_for_your_wellbeing_and_wellness","CCID",@SubscriberKey)
SET @q1_enjoy_the_coffee_experience = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_enjoy_the_coffee_experience","CCID",@SubscriberKey)
SET @q1_have_a_moment_to_relax = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_have_a_moment_to_relax","CCID",@SubscriberKey)
SET @q1_connect_with_others = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q1_connect_with_others","CCID",@SubscriberKey)
IF @q1_start_the_day == 'y' OR @q1_be_refreshed_and_uplifted == 'y' OR @q1_recharge_during_the_day == 'y' OR @q1_for_your_wellbeing_and_wellness == 'y' OR @q1_enjoy_the_coffee_experience == 'y' OR @q1_have_a_moment_to_relax == 'y' OR @q1_connect_with_others THEN
SET @q1 = "1"
ENDIF
SET @q2_pre_ground_coffee = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_pre_ground_coffee","CCID",@SubscriberKey)
SET @q2_instant_coffee = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_instant_coffee","CCID",@SubscriberKey)
SET @q2_freshly_ground_beans_at_home = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_freshly_ground_beans_at_home","CCID",@SubscriberKey)
SET @q2_ready_to_drink_coffee = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_ready_to_drink_coffee","CCID",@SubscriberKey)
SET @q2_coffee_concentrates = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_coffee_concentrates","CCID",@SubscriberKey)
SET @q2_nespresso_machine = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_nespresso_machine","CCID",@SubscriberKey)
SET @q2_nescafe_dolce_gusto_machine = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_nescafe_dolce_gusto_machine","CCID",@SubscriberKey)
SET @q2_another_type_of_capsule_pod_machine = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_another_type_of_capsule_pod_machine","CCID",@SubscriberKey)
SET @q2_in_a_coffee_shop = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_in_a_coffee_shop","CCID",@SubscriberKey)
SET @q2_other = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q2_other","CCID",@SubscriberKey)
IF @q2_pre_ground_coffee == 'y' OR @q2_instant_coffee == 'y' OR @q2_freshly_ground_beans_at_home == 'y' OR @q2_ready_to_drink_coffee == 'y' OR @q2_coffee_concentrates == 'y' OR @q2_nespresso_machine == 'y' OR @q2_nescafe_dolce_gusto_machine == 'y' OR @q2_another_type_of_capsule_pod_machine == 'y' OR @q2_in_a_coffee_shop == 'y' OR @q2_other == 'y'
THEN
SET @q2 = "1"
ENDIF
SET @q3_nescafe_azera = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q3_nescafe_azera","CCID",@SubscriberKey)
SET @q3_nescafe_original = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q3_nescafe_original","CCID",@SubscriberKey)
SET @q3_nescafe_gold_blend = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q3_nescafe_gold_blend","CCID",@SubscriberKey)
SET @q3_nescafe_gold_mixes = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q3_nescafe_gold_mixes","CCID",@SubscriberKey)
SET @q3_other = lookup("NUK1857826_Nescafe_PDC_Landing_Page_Submissions","q3_other","CCID",@SubscriberKey)
IF @q3_nescafe_azera == 'y' OR @q3_nescafe_original == 'y' OR @q3_nescafe_gold_blend == 'y' OR @q3_nescafe_gold_mixes == 'y' OR @q3_other == 'y' THEN
SET @q3 = "1"
ENDIF
]%%
| |
Dear %%=v(@FirstName)=%%
We're still brewing and waiting to hear from you. Just click below to share your coffee habits for a chance to win up to £250 in retail vouchers.*
|
|
|
|
%%[IF @q1 != '1' THEN]%%
%%[ELSEIF @q2 != '1' THEN]%%
%%[ELSEIF @q3 != '1' THEN]%%
%%[ELSE]%%
%%[ENDIF]%%
| |
%%[IF @q1 != '1' THEN]%%
%%[ELSEIF @q2 != '1' THEN]%%
%%[ELSEIF @q3 != '1' THEN]%%
%%[ELSE]%%
%%[ENDIF]%%
Good luck and thanks for sharing. Every sip and every coffee story counts!
In the meantime, check out our website for updates and more.
Warmest regards,
|
|
|
|
|
|
|
Stay connected
|
|
Follow us on our social media accounts to get even more tasty content.
|
|
|
| |
|
|
Copyright Nestlé 2023