Filtered Data Extension

  Filtered Data Extension – Practical Implementation

🔹 Objective

To create a dataset and apply different types of filters in order to understand how segmentation works in Salesforce Marketing Cloud (SFMC).

_____________________________________________________________________________________

🔹 Dataset Overview

A sample Data Extension was created with the following fields:

• CustomerID (Text, Primary Key)

• FullName (Text)

• EmailAddress (EmailAddress)

• Age (Number)

• PurchaseAmount (Decimal)

• City (Text)

• LastPurchaseDate (Date)

This dataset contains 10 records with a mix of values (including empty fields) to test all filter conditions.

___________________________________________________________________________________

🔹 Types of Filters Applied

___________________________________________________________________________________

1️⃣ Equal To Filter

Condition Applied:
City = Delhi

Purpose:
To identify customers belonging to a specific city.

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud. 

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

2️⃣ Not Equal To Filter

Condition: City ≠ London

Purpose: Exclude London customers

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

3️⃣ Greater Than Filter

Condition: PurchaseAmount > 500

Purpose: Identify high-value customers

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

4️⃣ Less Than Filter

Condition: Age < 30

Purpose: Segment younger customers

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

5️⃣ Greater Than or Equal To Filter

Condition: Age ≥ 30

Purpose: Include customers aged 30 and above

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

6️⃣ Less Than or Equal To Filter

Condition: PurchaseAmount ≤ 600

Purpose: Target moderate spenders

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

7️⃣ Is Empty Filter

Condition: FullName is empty

Purpose: Identify missing data.

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

8️⃣ Is Not Empty Filter

Condition: EmailAddress is not empty

Purpose: Identify valid users

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

9️⃣ IN Filter

Condition: City IN (Delhi, London)

Purpose: Include multiple cities

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

🔟 NOT IN Filter

Condition: City NOT IN (New York, Paris)

Purpose: Exclude selected cities

Applying filter conditions on the Data Extension using the filter activity in Salesforce Marketing Cloud.

Creating a new Filtered Data Extension by defining filter rules and selecting the target data extension.

Final filtered output displaying records that match the defined filter criteria.

___________________________________________________________________________________

🔹 Conclusion

This practical demonstrates how different filter conditions can be used to segment data effectively in SFMC. Filtered Data Extensions provide a simple and efficient way to create dynamic audience segments without requiring SQL.