Adobe Campaign use case question

[stefanm38281801]

Hi,

I have following use case to test and implement, but I seem to be stuck:

Use case:

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?

Thanks

Stefan

[taciac · Accepted solution]

Hi Stefan,

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:

1. Use a query activity to target your recipients.
2. Add additional data “linked to the filtering dimension”. There is an option dedicated to this in the query activity.
3. From there, follow the wizard (each step corresponds to a new screen in the wizard, use ‘previous’ and ’next’ buttons to navigate between them):
   1. Select the collection corresponding to the recipient’s purchases.
   2. Define how many lines from this collection you want to keep for each recipient (3 in your case).
   3. From what you described, you don’t need to apply any filter.
   4. Add a “Sort” criteria based on the purchase date field, and select the “descending” checkbox.
   5. Select the fields from the collection that you want to use afterwards, for example Product name, date, code, etc.
   6. This way, when the query is executed, it should retrieve the last 3 purchases known in the database for each recipient in your target.
4. Add a delivery in your workflow. You should be able to find the data added from the query in the personalisation fields available for the delivery content.

• If you use the Web client (AC Standard), you can find a complete example here: https://docs.campaign.adobe.com/doc/standard/en/WKF_Repository_of_activities_Query.html#Example-_per... 
• If you use the rich client (Campaign v6.x), you can find more information about additional data in this page: https://docs.campaign.adobe.com/doc/AC6.1/en/WKF_Quick_start_Creating_queries.html#Adding_data 

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.

Tacia