Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

ADD EMAIL TO A QUERY

Avatar

Level 3

Hi,

 

I have created the following query using this targeting dimension:

bcollado_0-1698942997996.png

bcollado_2-1698943051012.png

 

bcollado_1-1698943017123.png

bcollado_3-1698943121088.png

bcollado_4-1698943140459.png

 

 

As you can see, the field "email" is not included, and I want to add it because I want to send an email to the resultant population. The email is in the recipients schema. Any way to get it?

 

 

Thanks in advance and kind regards,

B

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @bcollado ,

You need to link targeting dimension schema with recipient schema using enrichment activity.

Figure out on what field you're going to link targeting schema with recipient schema and in enrichment> reconciliation tab > enable the checkbox and select targeting dimension as nms: recipient

And in simple join, map the source and destination fields.

ParthaSarathy_0-1699007768662.png

After enrichment, use change dimension and select recipient in it.

ParthaSarathy_1-1699007902068.png

So that you can send a delivery to each recipient.

ParthaSarathy_2-1699007941431.png

View solution in original post

2 Replies

Avatar

Level 3

384 means that there were 384 orders for a product.

Avatar

Correct answer by
Community Advisor

Hi @bcollado ,

You need to link targeting dimension schema with recipient schema using enrichment activity.

Figure out on what field you're going to link targeting schema with recipient schema and in enrichment> reconciliation tab > enable the checkbox and select targeting dimension as nms: recipient

And in simple join, map the source and destination fields.

ParthaSarathy_0-1699007768662.png

After enrichment, use change dimension and select recipient in it.

ParthaSarathy_1-1699007902068.png

So that you can send a delivery to each recipient.

ParthaSarathy_2-1699007941431.png