How to use multiple targeting dimensions in email delivery?

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

14-06-2017

Could you please post screenshots for both the the options?

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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
Validate 1
Level 7
taciac
Level 7

Likes

17 likes

Total Posts

341 posts

Correct reply

188 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 7
taciac
Level 7

Likes

17 likes

Total Posts

341 posts

Correct reply

188 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
taciac
Level 7

21-01-2016

Hi Amit,

Which product is this related to?

Thank you,

Tacia