1

Why do I need to add two or more data extensions as a source to data filter?

Sometimes we need to add customer or team member email addresses to an email campaign because they are not subscribed and don't need to subscribe to a specific campaign, but they need to receive an actual email the same as subscribers. My idea was to create one data filter which has two or more sources - one data extensions with actual subscriber data and another one for custom email addresses which can be added and removed any time. If someone knows a better solution how to do this, please chare. The solution to select two data extensions instead will not work, cause emails will be sent through API.

2 Answers 2

0

You cannot have more than one data source for a given filter. But, there are other options.

  1. You can run a query activity to add or update you team member email addresses in the source data extension prior to running the filter.
  2. You can specify more than one data extension as the target audience in a User-Initiated Send. But, only if the target is a data extension or list. If sending to a filter, you can only select one target audience.
0
3

Actually you can use filters across more than one DE by setting up Data Relationships. Once you have set up a data relation (and indicated it can be used in a filter), you can then create a filter and select one of the two DEs to start from. Now the other DE should also be available on the left hand side.

But, as pointed out here, this approach is unfortunately not reliable.

If you need something usable for end users you'll want something drag-and-drop though. But since you mentioned the API, why not retrieve the DEs data using the API and then write your own function to do some matching?

Alternatively/in conjunction you can run an SQL Query Activity, e.g. using an Automation, and afterwards run a script in the same automation. Hope that gives you some ideas...

You must log in to answer this question.

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