Which feature should be used to display the list of products for each subscriber in this email?

Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase.

The email will include a list of products they added to their shopping cart.

• A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart.

• A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.

Which feature should be used to display the list of products for each subscriber in this email?
A . Lookup AMPscript function
B. LookupRows AMPscript function
C. Dynamic Content Block
D. Enhanced Dynamic Content Block

View Answer

Answer: B

Explanation:

The LookupRows AMPscript function returns a rowset from a data extension that matches the specified criteria. It can be used to retrieve multiple rows of data from a data extension based on one or more column values. For example, NTO can use the LookupRows function to retrieve all rows from the second data extension that have the same session ID as the subscriber in the sendable data extension, and then loop through the rowset to display the product data for each abandoned cart item in the email.

References: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuprows.htm