QuestionQ52

VerifiedScripting and Automation

A developer needs to build an email that dynamically fills in the physical address for a company’s locations by using the variable @address. The deployment will reach millions of subscribers, and the developer requires the fastest possible performance.

Which AMPscript solution should be recommended?

Explanation

Lookup() directly returns the Address field value for the row whose Id matches @Id, avoiding the rowset creation and extra extraction calls required by LookupRows(). This makes it the appropriate approach when only one value is needed at very large send volumes. Salesforce documents Lookup() as returning a value, whereas LookupRows() returns an unordered rowset.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!