ADD EMAIL TO A QUERY

[bcollado]

Hi,

I have created the following query using this targeting dimension:

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

[bcollado]

384 means that there were 384 orders for a product.

[ParthaSarathy · Accepted solution]

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.

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

So that you can send a delivery to each recipient.