Segmento Filters: Column Type Filters Guide


#

Overview

Segmento allows you to segment and filter your audience based on different data fields such as text, email, number, date, and more. Filters help you create targeted user groups based on specific conditions.

Using filters, you can create segments like:

  • Users whose email ends with @gmail.com

  • Customers whose purchase amount is greater than ₹1000

  • Users who signed up in the last 7 days

Each field type supports different filter conditions to help you build accurate segments.


#

How Filters Work in Segmento

Filters work by applying conditions to a specific field. Segmento checks the value stored in that field and returns only the records that match the selected condition.

Example:

Field

Condition

Value

Email

ends with

gmail.com

This filter will return all users whose email domain is gmail.com.


#

Supported Filters by Field Type

#

1. Text Filters

Text filters are used for fields that contain text values, such as name, city, or tags.

#

Available Conditions

Filter

Description

is exactly

Matches records where the text value exactly matches the provided value

is not exactly

Matches records where the text value differs from the provided value

starts with

Matches records where the text begins with the specified value

ends with

Matches records where the text ends with the specified value

contains

Matches records where the text contains the specified substring

in

Matches records where the text value is present in a list

not in

Matches records where the text value is not present in a list

is empty

Matches records where the field has no value

is not empty

Matches records where the field contains any value

Example:
City contains "Delhi"


Detailed Example:
If you want to target users from Delhi:
- Column: City
- Condition: contains
- Value: Delhi

This will include all users whose city field contains "Delhi".


Screenshot 2026-03-17 5.57.01 PM.png
#

2. Email Filters

Email filters are used to target users based on their email addresses.

#

Available Conditions

Filter

Description

is exactly

Matches emails exactly equal to the provided value

is not exactly

Matches emails different from the provided value

starts with

Matches emails starting with the given string

ends with

Matches emails ending with the given string (useful for domains)

contains

Matches emails containing the specified substring

in

Matches emails present in a list

not in

Matches emails not present in a list

is empty

Matches records where the email field is empty

is not empty

Matches records where the email field has a value

Example:
Email ends with @company.com


Detailed Example:
If you want to target users from a specific company:
- Column: Email
- Condition: ends with
- Value: @test.com


This will include users whose email domain matches the given value.

Screenshot 2026-03-17 4.06.11 PM.png
#

3. Number Filters

Number filters are used for numeric values such as order count, user age, or total purchases.

#

Available Conditions

Filter

Description

is exactly

Matches records where the number equals the provided value

is not exactly

Matches records where the number is different

is greater than

Matches records where the value is greater than the specified number

is less than

Matches records where the value is less than the specified number

in

Matches numbers present in a list

not in

Matches numbers not present in a list

is empty

Matches records where the field has no value

is not empty

Matches records where the field has a value

Example:
Order Count greater than 5


Detailed Example:
If you want to target high-value users:
- Column: Order Count
- Condition: greater than
- Value: 5

This will include users who have placed more than 5 orders.

Screenshot 2026-03-17 4.12.56 PM.png
#

4. Boolean Filters

Boolean filters work with true or false values.

Common examples include:

  • Email verified

  • Active user

  • Subscribed to notifications

#

Available Conditions

Filter

Description

is true

Matches records where the value is true

is false

Matches records where the value is false

is not defined

Matches records where the field has no value

has any value

Matches records where the field contains either true or false

Example:
Email Verified is true


Detailed Example:
If you want to target users who have verified their email:
- Column: Email Verified
- Condition: is true

This will include only users whose email verification status is true.

Screenshot 2026-03-18 2.04.36 PM.png
#

5. Decimal Filters

Decimal filters are used for values with decimal numbers, such as product price or rating.

#

Available Conditions

  • is exactly

  • is not exactly

  • is greater than

  • is less than

  • in

  • not in

  • is empty

  • is not empty

Example:
Product Price greater than 499.99


Detailed Example:
If you want to target users who purchased high-value products:
- Column: Product Price
- Condition: greater than
- Value: 499.99

This will include users whose product purchase value is greater than 499.99.

Screenshot 2026-03-18 2.08.05 PM.png
#

6. Date Filters

Date filters allow you to segment users based on time-based conditions, such as signup date or last activity.

#

Available Conditions

Filter

Description

after date

Matches records where the date is after the specified date

before date

Matches records where the date is before the specified date

exactly date

Matches records where the date exactly matches the given date

after (>=)

Matches dates after a relative time period

before (<=)

Matches dates before a relative time period

has current

Matches records within the current day, month, or year

in the last

Matches records within a specific recent time period

is empty

Matches records with no date value

is not empty

Matches records where a date exists

Example:
UpdateDate in the last 7 days


Detailed Example:
If you want to target recently active users:
- Column: Last Activity Date
- Condition: in the last
- Value: 7 days

This will include users who were active in the last 7 days.

Screenshot 2026-03-18 2.15.10 PM.png
#

7. Percentage Filters

These filters are used when the field contains percentage values, such as completion rate or discount percentage.

Supported filters include:

  • is exactly

  • is not exactly

  • is greater than

  • is less than

  • in

  • not in

  • is empty

  • is not empty

Example:
Completion Rate greater than 80%


Detailed Example:
If you want to target highly engaged users:
- Column: Completion Rate
- Condition: greater than
- Value: 80%

This will include users whose completion rate is above 80%.

Screenshot 2026-03-18 2.18.23 PM.png
#

8. Currency Filters

Currency filters are used for monetary values, such as revenue or order value.

Supported conditions:

  • is exactly

  • is not exactly

  • is greater than

  • is less than

  • in

  • not in

  • is empty

  • is not empty

Example:
Total Purchase greater than ₹300


Detailed Example:
If you want to target high-spending customers:
- Column: Total Purchase
- Condition: greater than
- Value: ₹300

This will include users whose total purchase value exceeds ₹300.

Screenshot 2026-03-18 2.38.04 PM.png
#

9. Phone Number Filters

Phone filters help segment users based on mobile numbers.

#

Available Conditions

Filter

Description

is exactly

Matches the exact phone number

is not exactly

Matches phone numbers different from the specified number

starts with

Matches numbers beginning with specific digits

ends with

Matches numbers ending with specific digits

contains

Matches numbers containing the specified digits

in

Matches numbers present in a list

not in

Matches numbers not present in a list

is empty

Matches records with no phone number

is not empty

Matches records where a phone number exists

Example:
Phone number starts with +91


Detailed Example:
If you want to target users from India:
- Column: Phone Number
- Condition: starts with
- Value: +91

This will include users whose phone numbers begin with the Indian country code.

Screenshot 2026-03-18 2.40.36 PM.png
#

10. Object Filters

Object filters are used for nested data fields or structured data objects.

#

Available Conditions

Filter

Description

is exist

Matches records where the object exists

not exist

Matches records where the object does not exist

Example:
User Profile exists


Detailed Example:
If you want to target users who have completed their profile:
- Column: User Profile
- Condition: is exist

This will include users where the profile object is available.

Screenshot 2026-03-18 2.54.03 PM.png
#

11. Dropdown Filters

Dropdown filters apply to fields where users can select values from predefined options.

#

Available Conditions

Filter

Description

in

Matches records where the selected option is in a specified list

not in

Matches records where the selected option is not in the list

is empty

Matches records where no option is selected

is not empty

Matches records where an option is selected

Example:
Subscription Plan in Premium, Gold


Detailed Example:
If you want to target premium users:
- Column: Subscription Plan
- Condition: in
- Value: Premium, Gold

This will include users who are subscribed to Premium or Gold plans.

Screenshot 2026-03-24 2.08.45 PM.png
#

12. Presence Filters

Presence filters help identify the activity status of users.

#

Available Conditions

Filter

Description

Online

Matches records where the user is currently active

Offline

Matches records where the user is inactive

Example:
Presence is Online


Detailed Example:
If you want to target currently active users:
- Column: Presence
- Condition: Online

This will include users who are currently active on the platform.

Screenshot 2026-03-24 2.11.38 PM.png

Using Nested Filters (AND / OR Conditions)

Segmento allows you to combine multiple conditions using AND and OR to create more specific segments.

Example:

  • Order Count greater than 5 AND City contains “Delhi”
    This will include users who match both conditions.

  • City contains “Delhi” OR City contains “Mumbai”
    This will include users who match any one condition.

You can also create grouped (nested) conditions:

  • (Order Count greater than 5 AND City contains “Delhi”)

  • OR (Order Count less than 2 AND City contains “Mumbai”)

This helps in creating advanced audience segments.

Screenshot 2026-03-25 1.27.09 PM.png
image (54).png

Note:
The filter works only when the field contains a valid value (string format).

In cases where the field value is null (no value present), the filter condition will not return any results.

For example, in the above data, fields like "CurrentFortnightTicketCount" have null values, so applying the "is exactly" filter on them will not work.

Example:
Value = "13" → Filter works
Value = null → No results returned



#

Best Practices for Using Filters

  • Combine multiple filters to create more precise segments

  • Use date filters for time-based campaigns

  • Use email domain filters for company-based targeting

  • Avoid overly complex filter combinations that may reduce segment accuracy