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?
    – 0xsegfault
    May 31, 2017 at 7:05
  • Hi, is there a way to verify which is it?
    – Rain
    May 31, 2017 at 7:13

1 Answer 1


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:

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .