Question

A customer has several values that need to be used in the body of an email send.

• The data would be stored in a reference data extension, related on SubscriberKey
• There may be one or more records for each subscriber
• The audience is generally over 1 million subscribers
• The content is time sensitive and should be sent as quickly as possible
• The customer is not using "Catch and release" sending
• The reference data extension contains 25 columns

What method should be used

A. AMPScript a single LookupOrderRows function
B. Dynamic content via the Dynamic content wizard
C. Server side JavaScript a single LookupOrderedRows function
D. AMPScript a single lookup function

Answer 1

The recommended method to use in this case is AMPScript with a single LookupOrderRows function.

Step-by-step explanation:

The method that should be used in this case is AMPScript with a single LookupOrderRows function. This function allows you to retrieve multiple rows of data from a data extension based on the order specified. In this case, you can use it to fetch the relevant values from the reference data extension based on the SubscriberKey.

Since the audience is over 1 million subscribers and the content is time-sensitive, it is important to send the email as quickly as possible. AMPScript with LookupOrderRows can efficiently retrieve the necessary data and populate the email with the correct values.