%%[
var @email, @CCID, @SubmitDate, @Brand, @sendId, @completed, @completedcheck, @firstname, @lastname, @optin, @uniqueid
SET @CCID = RequestParameter("_subscriberkey")
SET @email = RequestParameter("email")
SET @SubmitDate = now()
SET @sendId = RequestParameter("sendId")
SET @Brand = "Nescafe"
SET @firstname = RequestParameter("firstname")
SET @lastname = RequestParameter("lastname")
SET @uniqueid = RequestParameter("uniqueid")
IF EMPTY(@CCID) THEN
SET @optin = IIF(RequestParameter("optin")=="y",'y','n')
SET @CCID = RequestParameter("uniqueid")
ENDIF
UpsertData("NUK3529603_Nescafe_PDC_Landing_Page_Submissions",1,"CCID", @CCID,"email", @email, "Brand", @Brand,"SubmitDate", @SubmitDate, "sendId", @sendId, "firstname", @firstname, "lastname", @lastname, "optin", @optin, "uniqueid", @uniqueid)
SET @completedcheck = Lookup("NUK3529603_Nescafe_PDC_Landing_Page_Submissions", "q5_sustainability", "CCID", @CCID)
IF NOT EMPTY(@completedcheck) THEN
SET @completed = "y"
ENDIF
]%%
