Skip to main content
Contributor II
November 15, 2020
Solved

How to create a segment based on property value that hasn't been collected yet?

  • November 15, 2020
  • 11 replies
  • 799 views

How do I create a segment for those whose birthday/birthdate is missing?

When I select Properties about someone and then select birthdate it doesn't give me any option to say "birthdate missing from profile".

I want to send an email to those who haven’t entered their birthday /birthdate yet but I can’t seem  select anything suitable to create the segment.

    Best answer by andrew.bialecki

    Hey!

    If you set the property type to “Text” then you can choose “is not set” and that’ll create a segment of everyone who doesn’t have a birthday set.

     

    11 replies

    andrew.bialecki
    Klaviyo Employee
    Klaviyo Employee
    November 15, 2020

    Hey!

    If you set the property type to “Text” then you can choose “is not set” and that’ll create a segment of everyone who doesn’t have a birthday set.

     

    AB
    Contributor II
    November 15, 2020

    Brilliant, thank you!

    Contributor I
    January 5, 2023

    What about when the property value is a system property like “Phone”? 

    I’m trying to build a segment of subscribers who we don’t have a phone number for. 

     

    “is not set” in this case doesn’t work ‘cause the Phone property is set, it’s set to empty. 

     

    I’ve tried “does not equal” with (blank), empty, “”, nothing seems to work. 

    Dov
    Klaviyo Alum
    January 5, 2023

    Hi @lkoczorowski,

    Thanks for sharing this with us.

    In order to resolve this, you’ll need to create a segment that uses properties about someone > Phone Number > doesn’t contain X, separated by AND, for numbers 0-9.

    In practice, it would look like the following: properties about someone > Phone Number > doesn’t contain 0 AND properties about someone > Phone Number > doesn’t contain AND properties about someone > Phone Number > doesn’t contain 2 and so forth. That will isolate users who do not have phone number set. Here’s a screenshot example as well:

    Thanks for being a community member.

    DD
    Contributor I
    January 5, 2023

    Dov, You are the greatest human I know. 

     

    THANK YOU

    Contributor I
    June 3, 2025

    @Dov I am keen to create a segment of Aus users we dont have mobile numbers for. The suggestion above I guess will also colelct landlines (we have an older demo so lots of these). Are you able to please help me with this oen? 

    JessFosnough
    Expert Problem Solver IV
    Expert Problem Solver IV
    June 5, 2025

    Hi ​@Kirsten Thompson ,

    Do you have mobile numbers and landlines stored in the same field, or do you have one field for landlines and one for mobile numbers?

    Jessica
    Contributor I
    June 5, 2025

    hi landlines and mobiles all same field - phone number

    JessFosnough
    Expert Problem Solver IV
    Expert Problem Solver IV
    June 6, 2025

    @Kirsten Thompson ,

    Ok, that might make things a little more tricky. When you look at a profile, is there any easy way to distinguish which numbers are landlines, and which are mobile? For example, maybe all landlines start with a specific set of numbers, or all mobile numbers? (This is not how it is where I live, but not sure about other countries).

    If not - do you have a list/segment of subscribers that are already subscribed to SMS and/or unsubscribed from SMS?

    Jessica
    Contributor I
    June 16, 2025

    @JessFosnough thanks for the reply. Yes I can pull / create lists of existing SMS Subs and SMS non subs