Create a Filtered Data Extension

A filtered data extension is generated by filtering fields, filters, and measures. Filtered data extension takes on the same characteristics as the source data extension. To update a filtered data extension to sendable or non-sendable, change the source data extension to sendable or non-sendable.

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, and/orMeasure from the left column to the Create Filter Use the following table as a reference to building out your filter. 

Note: Be sure to choose an operator that makes sense with the type of field you chose. For example, do not use the less than operator with a text field. For attributes with type equal to date, only the following operators are supported: is equal to, is not equal to, is greater than and is less than

9. Select an ANDor OR You can group your criteria by hover over the grouping operator so that it turns a darker blue, and click to change the operator.
   If you choose AND, the record must meet all criteria to be included in the group. If you choose OR, the record must meet one of the criteria, not necessarily all criteria, in order to be included in the group.
10. Click Save & Build.
11. Enter a Namefor the filtered data extension.
12. Enter a Description for the filtered data extension.
13. Select a folder in which to store the filtered data extension. Or select New Folderto create a folder to store the filtered data extension.
14. Click Save.