NEW QUESTION 68
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?
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 functionto 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