How to use multiple targeting dimensions in email delivery?

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

18-01-2016

I know we can select only one targeting dimension but i have to use data from more than one table.
i.e. I have two dimension which i want to use in an email
1. recipient
2. event
How can i use details from these two tables in an email?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

21-01-2016

After some research and help from adobe campaign community i am able to solve this. 

Option 1: create one to many link between the two dimensions, primary dimension will be your customer level and event data will be stored in temp table, then you can call the data in event dimension using a for loop within delivery by referring to the link name e.g targetdata.linkname[1].fieldname. This way is better when you have large number of events to write back.
 
 Option 2: Select your recipient data by using query activity and then create a link(1-1 or 1-n) between recipient and event by using enrichment activity . then In same enrichment activity pulled out data by clicking edit column. so then you will be able access the data in 
delivery like targetData.event field name. in case of 1-n it depends how many events you fetch and it will be like targetData.event1.fieldName etc. unfortunately you don't have possibility to use loop.

Hope this will help others and will save some time.

Answers (3)

Answers (3)

Avatar

Avatar

RamaRajesh

Employee

Avatar

RamaRajesh

Employee

RamaRajesh
Employee

14-06-2017

Could you please post screenshots for both the the options?

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

21-01-2016

Hi Tacia,

This question is related to Adobe campaign, sorry i was unable to find the correct tags for this.

Thanks,

Amit

Avatar

Avatar

taciac

Avatar

taciac

taciac

21-01-2016

Hi Amit,

Which product is this related to?

Thank you,

Tacia