Target audiances from previous delivery

Question

Hi All,I am creating a campiagn where in I need to target the audiances from the previous delivery. I've created the query for pulling them. Howver, I need to know how to go about mapping the audiances to the right table, such as Recipients.
 
Adding the screenshots of query created for pulling the previously targetted audiances.

Can someone help me with this?Appreciating a quicker response!Thank you in Advance!

Marcel_Szimonisz · Accepted Answer

Hello @umav ,if you want to directly use such seleciton in the marketing communication. You can either change dimension to recipient or you have to change your query as follows:targeting dimension -> recipientfiltering dimension -> recipint delivery logsUse the same queries. add data you want to use in the targetting dimensions (further down the workflow)Marcel

akshaaga · Answer

@umav,To map them to the correct table, such as the Recipients table, you would need to identify a unique identifier in both tables, such as an email address or customer ID.Once you have identified the unique identifier, you can use it to join the two tables on that field. For example, if the email address is the unique identifier, you can use a SQL join statement to join the two tables on the email address field:SELECT *FROM Previously_Targeted_AudiencesINNER JOIN RecipientsON Previously_Targeted_Audiences.email = Recipients.email This will return all records in both tables based on the email address field. You can then use this result set to target your audience for your new campaign.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded