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

Salesforce Asked by The Chinese Filipino on November 4, 2020

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?

One 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.

Answered by Lukas Lunow on November 4, 2020

Add your own answers!

Related Questions

Apex Metadata API retrieve PageLayout assigned to Profile

1  Asked on November 20, 2021 by michael-yocca


Salesforce Integration User

1  Asked on November 20, 2021 by sheo-agarwal


Einstein intent – training dataset error

1  Asked on November 19, 2021 by wilson-kwok


Expression Functions for Lightning Web Components

5  Asked on November 19, 2021 by oleh-berehovskyi


how to make phone field unique

2  Asked on November 19, 2021 by pranav-mandlik


SOQL For Update to Release Locks

1  Asked on November 19, 2021 by jair


Emojis in Salesforce Community is not working

0  Asked on November 19, 2021 by nevrekar_amey


How to Blank Date value in Date formula field?

1  Asked on November 19, 2021 by sfdcprgmr


lightning:select selected value is not set

3  Asked on November 17, 2021 by xl-zhang


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP