Is there a way to create a segment of how many phone numbers I have?

[KimberlyR959]

Hello,

I am pretty new of SMS messaging, but I do see it as an option for future marketing efforts, especially for events. Our organization uses Square, which includes the text feature as well--but we only have 100+ contacts, while I have over 5,000 on email marketing.

Before I buy SMS through CC, I was wondering if there was a way to see exactly how many contact with phone numbers I have. Perhaps I find I have more through CC than Square. Is there a way of segmenting to create a list of contacts who have a cell phone number? I have tried a few segment types, including sorting my contact details, but it is not what I'm looking for.

[William_A · Accepted solution]

Hello @KimberlyR959 ,

At this time, phone numbers aren't a column that can be selected and viewed / sorted in the Contacts page. My advice, as far as tracking down every contact that's provided a phone number, would be to export your contacts as a CSV file, then use your preferred spreadsheet editing program to sort the column for phone numbers so any blank contacts are filtered down. With this, you'll at least have an idea of how many contacts have provided you a phone number.

That said, contacts that have opted into receiving emails may not have necessarily opted into receiving text messages. This is why SMS number and permission status are separate contact fields in our system, since there's an entire other world of regulation and anti-spam that we and our customers must comply with. Make sure to check out our SMS permission policy, as well as our article on importing SMS contacts.

For a quick-reference for various SMS-related articles and getting started with SMS marketing, I'd recommend checking out this response in our Community.