I'm building a Trigger Campaign that relates to a customer's purchase.
The purchase data is located on a Data Extension table. This Data Extension table has Subscriber Key and Purchase IDs. There is another Data Extension table that maps out the Purchase IDs with the Marketing Product Name (i.e., what the end-user needs to get in the email.
My question is twofold:
Is it even possible to pull in Data Extension values on a Trigger Campaign that is being sent to a subscriber record? If so,
How can I string the data from the Data Extension table with the Purchase IDs to the Data Extension table with Marketing Product Names so that the customer will receive something like:
"Thanks for buying green gadgets" instead of "Thanks for buying PID-1"
I would like to note that a customer could buy more than one item.
Thank you in advance for your help.