How to create a segment based on property value that hasn't been collected yet?
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.
Page 1 / 1
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 1 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
Hi @Kirsten Thompson,
Sorry it has taken me so long to get back to you. I’m glad to hear that you can pull lists of SMS subscribers. I’m not sure if this is the “best” idea, but I would create a separate field for mobile numbers. - First, create the field in one profile - I typically create the field in my own profile when adding something new. Whatever you name it, know that you have to use the EXACT format if you want to pull it into an email, or update it, etc. For example, if it’s capitalized, it should always be capitalized. I’m not sure if this field should be a number or text field; text field seems to be more flexible in my opinion. -Create a blank list (can be deleted later). -Export all the SMS subscribers (and non-subscribers, if you want) and include the phone number field. -Import all the records you just exported to the blank list, and map the existing phone numbers to the new mobile number field. -Once done, you can delete the list (it only deletes the list, not the profiles in the list) if you want. -Then you can build a segment where the new mobile number field doesn’t have any numbers, as Dov mentioned above. Or, since it is a custom property, you can build a segment where the new field is not set. Hope this helps, let me know if I can explain anything further!