When building a filtered data extension X, based on a data extension A with data relationships (A to B and B to C). We can easily filter A on a field in B. We can also filter B on a field in C. We can also see fields in C, when filtering A. But using them as conditions in our filter, always returns 0 rows. Even though we can repeat same filtering using a query, and get a number of rows returned.

Shouldn't this be possible? We have contacted SFMC support, and can't get a clear answer back from them.

  • 1
    Why use Filters and Relationships? A Query Activity would be a better (and more explicit) option -- especially since you're using Data Extensions. – Adam Spriggs Jan 30 '17 at 14:24
  • Point taken - and this would also be my preferred approach. However, I am building this solution for a client, and they would prefer using filters, since this is more intuitive than queries. – Lukas Lunow Jan 30 '17 at 15:51

This may seem anecdotal but I have seen on more than one occasion that Marketing Cloud has a very hard time with multiple exclusions and every time I split it apart to filter one thing at a time, it manages to do it better. I will mention I've seen this happen more frequently with Queries than with Filtered DE's but the same logic looks like it applies. Can you try spreading them out?

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.