Skip to main content

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.

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.

 


Brilliant, thank you!


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. 


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.


Dov, You are the greatest human I know. 

 

THANK YOU


@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? 


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?


hi landlines and mobiles all same field - phone number


@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?


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


Reply