Merging audience from Data Load with a query of recipients - Workflow | Community
Skip to main content
M
MarioGlad
Level 2
January 28, 2022
Solved

Merging audience from Data Load with a query of recipients - Workflow

  • January 28, 2022
  • 3 replies
  • 1093 views

Hello, Masters of Adobe Campaign,

 

Thank you to all for the past guidance and ideas.

 

This time I am trying to include an audience from 2 different sources: a query and data load with a .csv file.
While pre-running the workflow, I am receiving an error that CSV file recipients are not in the Database.
What would be the desired way of merging 2 different data sets, such as the CSV file and query results?
Worth mentioning is that the emails in CSV file do not exist in the recipient's table.


Thank you,

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Tobias_Lohmann

Hi,

I think what you're trying to achieve is: load some recipients from the db and import some recipients from the file, merge both and send out communication. 

In that case you should import the file, reconcile it with possibly existing recipients and insert/update the data from the file into nms:recipient. 

Then you can send the delivery to the complete group. You can split import/reconcilation/upsert and targeting workflow, or have all activities in the targeting. 

There is a good explaination of the use case here: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/workflow-use-case/data-management/reconcile-file-audience-with-database.html

Best regards, Tobias

3 replies

Jyoti_Yadav
Jyoti_Yadav
Level 8
January 30, 2022

Hi @marioglad ,

 

What is the end result you want to achieve? Do you want to send emails to these recipients?

If yes, then you should first insert your data load recipients in the 'nms:recipient' table. You will not be able to send email to the email addresses which does not exist in database.

 

Thanks,

Jyoti

Tobias_Lohmann
Adobe Employee
Tobias_LohmannAdobe EmployeeAccepted solution
Adobe Employee
January 31, 2022

Hi,

I think what you're trying to achieve is: load some recipients from the db and import some recipients from the file, merge both and send out communication. 

In that case you should import the file, reconcile it with possibly existing recipients and insert/update the data from the file into nms:recipient. 

Then you can send the delivery to the complete group. You can split import/reconcilation/upsert and targeting workflow, or have all activities in the targeting. 

There is a good explaination of the use case here: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/workflow-use-case/data-management/reconcile-file-audience-with-database.html

Best regards, Tobias

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    February 10, 2022

    Hi @marioglad,

    Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know.
    Thanks!

    Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...