How do I create a filtered de in Marketing Cloud?

How do I create a filtered de in Marketing Cloud?

Create a Filtered Data Extension in Marketing Cloud

1. Hover over Subscribers.
2. Click Data Extensions.
3. Click Create.
4. Select Filtered Data Extension.
5. Click OK.
6. Select a standard data extension to filter as the source data extension.
7. Click OK.
8. Drag Fields, Filters, or Measure from the left column to the Create Filter canvas.

How can you use filters in Salesforce Marketing Cloud?

There is a solution to filter subscribers within SFMC called a ‘data filter’, which will segment your audience in data extensions (DEs) according to the criteria you set. How can you use filters in Salesforce Marketing Cloud? In order to create data filters for your Data Extensions (DEs) you have to go to the Email Studio in your SFMC environment.

What makes audience builder different from data filters?

Audience Builder also features a drag and drop interface, just like data filters – but, what makes it different, is that it also has the capability to filter across data extensions and append data to audiences. These Audiences* are also static in nature, which means that you need to refresh them daily to keep them up to date.

How are data relationships used to filter des?

Data relationships can be used as a solution to filter across several DEs when a relationship (e.g. a unique identifier) exists between these DEs, and you define this as a primary key. The creation of data relationships provides the opportunity to apply filters across two data extensions, known as ‘cross filters’.

What are the disadvantages of data filters in SFMC?

The disadvantage of data filters in SFMC is their limited possibilities. For example, you can only filter on one data extension at a time, unlike SQL queries or DESelect where it is possible to create complex segmentation across multiple DEs.