Segmentation brief: "all subscribers living within 5km of our Hanoi store." Data Filter doesn't have a geo-radius option. Before jumping to SQL Query, check whether Audience Builder covers it - it often does, and the build is point-and-click instead of code.

Here's how we decide between SFMC's segmentation tools.

Data Filter

Point-and-click, no SQL required. Filters subscribers by attribute values from a DE or profile fields.

Examples Data Filter handles:
- MemberTier = "Gold"
- BirthMonth = 3   (March birthdays)
- LoyaltyPoints >= 500
- City = "Hanoi"

What it can't do:

• Geo-radius (within X km of a location)
• Complex arithmetic or derived fields
• Joining multiple DEs
• Reading tracking data (opens, clicks)

Output: a Filtered Group (when run against a List) or Filtered DE (when run against a DE).

Audience Builder

A step above Data Filter. Adds:

• Geo-targeting: subscribers within X km of a point.
• Measures: filters based on tracking behavior (opened email in last 30 days, hasn't clicked in 3 months).
• Real-time count: as you build the segment, see how many subscribers match - useful before committing to a send.
• Drag-and-drop complex conditions that Data Filter can't express.

Built for segmentation that needs geo data, behavior data, or interactive audience sizing.

Measures - the thing Data Filter can't touch

Measures filter on tracking behavior, not DE fields:

Examples:
- Opened at least one email in last 30 days
- Has not clicked any email in last 3 months
- Opened at least 5 emails last year

Data Filter reads DE columns; tracking data lives in Data Views (_Open, _Click, _Sent). Measures bridge that gap without SQL.

If a client asks for "engaged subscribers only" and can't define engagement as a DE field, Measures in Audience Builder is the tool.

Decision table

Need

Use

Filter by attribute in DE

Data Filter

Filter by geo-radius

Audience Builder

Filter by tracking behavior

Audience Builder (Measures)

See real-time count while building

Audience Builder

Join multiple DEs

SQL Query (covered in the next post)

Complex arithmetic / derivations

SQL Query

Licensing note

Audience Builder is not included in every SFMC edition. Available with Marketing Cloud Advanced, Enterprise 2.0, or as an add-on module. Before promising a geo-targeted segment, confirm the client has access.

Data Filter is included with every edition.

Reaching for the right tool

The rule we use:

1. Can Data Filter do it? → Data Filter.
2. Need geo, real-time count, or tracking behavior? → Audience Builder.
3. Need joins or complex logic? → SQL Query (covered in the next post).

Stopping at step 1 whenever possible keeps builds debuggable for the client team. Jumping straight to SQL when Data Filter would've worked creates a maintenance burden nobody wants.

Examples from recent work

• Segment: "Gold tier members in Da Nang" → Data Filter (two attribute conditions).
• Segment: "Subscribers who opened any email in last 45 days and live within 10km of flagship store" → Audience Builder (Measures + geo).
• Segment: "Subscribers whose last purchase amount was >2x their average" → SQL Query (derived calculation, needs aggregation).

Takeaway

Audience Builder fills the gap between Data Filter's simplicity and SQL Query's complexity. Geo-targeting, tracking behavior, and real-time counts are the three signals that push a segment from Data Filter to Audience Builder. SQL comes out only when neither tool can express the logic.

Building SFMC audience segmentation? Our Salesforce team designs segmentation strategies matched to the client's edition and use case on production engagements. Get in touch ->

See our full platform services for the stack we cover.