Normalize Phone Number
How to find this variable?
The phone number can be sourced from business cards, company websites, customer databases, or contact forms. The country information is usually provided alongside the phone number in databases or user profiles.
How to use it?
Using the E.164 formatted phone number ensures compatibility with telecommunication systems and software that require international dialing standards, such as VoIP services, SMS gateways, and mobile communication apps.
Use cases
• CRM Systems: Store and manage contact information in E.164 format to facilitate automated dialing and messaging directly from the system.
• Marketing Campaigns: Use standardized phone numbers for SMS marketing to ensure messages are delivered without issues related to international formatting errors.
• Data Integration: Simplify data integration processes between different systems (like customer service tools and marketing platforms) by using a uniform phone number format.
The Prompt TEST
Normalize the phone number specified in the input with a E.164 format.
If the input is empty, output 'N/A'
Remove all quotes from the Output
Remove all quotes from the Output
Input:
phone number: "{{phone 2}}"
country: [NAME OF THE COUNTRY]
phone number: "{{phone 2}}"
country: [NAME OF THE COUNTRY]
Output:
Your Input
• Phone number: ‘415-555-2671’
• Country: ‘USA’
Your Output
+14155552671
Why this prompt?
Format and normalize phone numbers to e164, international, and national formats
How to implement?
1
Open your 'Lead list' in your lemlist campaign.
2
Create a new column and select "Create AI column". Enter the name of your AI variable and click "Save".
3
Paste the prompt and click "Generate"!
Copy this prompt to the clipboard
Sales Leader @lemlist
WEBSITE
https://www.lemlist.com