0

This Marketing Cloud setup is integrated with Sales Cloud via Connect and FTP import activity.

So there are Contacts in separate DE's that are from FTP and there is data from SF via Synchronised Data Extensions.

Is there a way to use these two sources for a Data Filter and use its results to send Emails to?

  • Are you using data stream or an import activity for MC connect? – Samuel Dare May 31 '17 at 7:05
  • Hi, is there a way to verify which is it? – Rain May 31 '17 at 7:13
2

You could set up an Automation with a SQL query activity that joins the two data extensions and writes the result into another data extension which is then used for your email send. The query can also include filters if you like. If different filters should be applied leading to multiple segments, creating one joined data extension and filtered data extensions afterwards would be the best option in my opinion.

To keep the created data extension up to date you could create a triggered automation, that is started every time data is uploaded to the enhanced FTP.

Related documentation:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.