I have following use case to test and implement, but I seem to be stuck:
I want to send an email to a list of recipients with their 3 latest products purchased (assuming a simple scheme where one order only contains one product).
How should the query be set-up to get per recipient the latest 3 orders (I only want to have 1 recipient per line in the targeting dimension, since I want to send an email delivery).
How will de data-scheme on the targeting dimension (additional data?) should look like, and how is this addressed within the email delivery?
Any useful tips on how to achieve this?
The way to do it depends on the version of Adobe Campaign you’re using as the UI differs.
The basic principle is as follows:
Instead of using the Additional data feature from the Query activity, there is also the possibility to use an Enrichment activity, but note that this activity is more complex to use as it allows to enrich data in many different ways.
Hope this helps.