Marketing Cloud CloudpageURL() link not reading data from data extension for added records in the Data Extension

Question

We have an email linked to a CloudPage that has a smartcapture feature. The DE that is used for the email contains customer info which is exposed to the Cloudpage via ampscript:
%%[
var @emailaddress,@FirstName
set @emailaddress = AttributeValue("emailaddress")

set @emailaddress = Lookup("VisaAcquiDeJuly","emailaddress", "emailaddress", _subscriberKey )

set @FirstName = Lookup("VisaAcquiDeJuly","FirstName", "emailaddress", _subscriberKey )
]%%

Everything works fine and custom URL strings show for each customer, but if I add a new record to the original DE (Contact Builder > Add Record), their data doesn't get passed to the cloudpage when clicking the email's Link to Cloudpage button, and there is no custom URL string that shows up when redirected. How may I get the cloudpage working for new records?

Lukas Lunow · Answer

Your lookup logic looks strange. You are both passing email address in your cloudpagesurl as an Attribute, and looking it up in VisaAcquiDeJuly based on subscriber key (which also seems to be the email address)?
Normally, I would just use email address which is automatically included as a parameter in CloudPagesURL (without you need to add it explicitly), as per this answer: Parameters passed in CloudPagesURL
This will make your solution much cleaner:
%%[
var @FirstName
set @FirstName = Lookup("VisaAcquiDeJuly","FirstName", "emailaddress", AttributeValue("emailaddr"))
]%%

You must add the new record to the Data Extension, with a value in emailaddress column, which matches the subscriber key of the email preview/send which you are testing.

Marketing Cloud CloudpageURL() link not reading data from data extension for added records in the Data Extension

One Answer

Add your own answers!

Ask a Question