Dynamic Content in Adobe Campaign: Aggregating Data with JavaScript

[DiegoGar]

Hi everyone,

I'm working on an email campaign where I need to display a list of horses owned by each user along with their info. I have two tables: one with unique horse owners and another with all the horses. My goal is to send a single email to each owner that includes a table listing all their horses and their data.

What would be the best approach to do this in Adobe Campaign?

Horse Ower	Horse Name	Horse Birthday	Gender	Race
test@test.com	vera	3/5/2002	Merrie	KWPN
test@test.com	Agga	3/4/2002	Merrie	IJslander
test@test.com	Stor fra Flettuvollum	12/5/2002	Merrie	IJslander
test@test.com	Droopy	4/30/2008	Ruin	Shetland pony
test@test.com	Caspar	8/1/1994	Ruin	Haflinger
test@test.com	Polly	1/1/1990	Merrie	Welsh pony
test@test.com	Wavottie	1/1/2004	Merrie	KWPN
test@test.com	Ramona	1/1/1999	Merrie	KWPN
test@test.com	Daisy	1/1/2000	Merrie	Overig

Thank you

[ÓscarGo · Accepted solution]

Hi @DiegoGar 

You can create a custom field in the target schema of the workflow where you append Horse Names per recipient using a special character as separator:

Recipient	Horse_Names_custom_field
1	Vera|Polly|Daisy
2	Ramona|Wavottie
3	Caspar
4	Agga|Droopy|Stor

You can create this custom field via Javascript activity by querying the target schema using the QueryDef function.

Then, in the delivery you can use the targetData.Horse_Names_custom_field and via substring format a list.

Hope it helps,

BR Oscar

[ÓscarGo]

@DiegoGar 

In the case you want to use the whole Horse info, you can do this:

Recipient	Horse_Names_custom_field
1	Vera,3/5/2002,Merrie,KWPN|Polly|Daisy
2	Ramona|Wavottie
3	Caspar
4	Agga|Droopy|Stor

Using more than one separator and then processing it

[DiegoGar]

Thank you @ÓscarGo for your response.

I have been using this approach in other campaigns, however in this case there is a lot of data and the target schema string field has a limit of 255 characters. I could split the data in multiple fields but it overcomplicate it and I do feel this is not a proper solution. I think this works more like a hack so I wonder if there is a workaround in Adobe Campaign for this case (which is an email marketing basic)

[ÓscarGo]

Hi @DiegoGar 

The best way of doing so, will be to create an email with a link to a landing page where you can easily read Adobe database to print Horses info and also have better/easier UX configuration.

BR, Oscar