Lead lists often contain data that is no longer up-to-date—especially when it comes to phone numbers. Some companies keep an entire team busy calling long phone lists to check if the phone numbers are still active.
Using custom APIs like RealPhoneValidation or Nexmo, you can validate your leads’ phone numbers from within a spreadsheet and eliminate invalid or disconnected numbers before they enter your CRM. You can also identify the number type (landline, cell, virtual) ensuring that you don’t send text messages to landlines as well as carrier networks to optimize SMS routing when engaging with your leads.
Validate phone lists in bulk with RealPhoneValidation Turbo
The RealPhoneValidation (RPV) Turbo API identifies disconnected and invalid phone numbers. Their real-time service pings the phone switch and uses the live telco data to check landline and mobile numbers’ active status.
Note: The RPV Turbo API only validates phone numbers for US landlines and US mobile numbers.
With RPV Turbo, you can get the following response types:
- “Connected”: always connected
- “Disconnected”: always disconnected
- “Unreachable”: not reachable
- “Invalid phone”: phone not valid
- “Busy”: busy
- And more
iscell: Y for “yes”, N for “no”—determines whether the phone number provided is a mobile number.
Create a phone validator in dashdash
Step 1: Sign up for an account with RealPhoneValidation and retrieve your token
If you’d like to give the RPV Turbo API a try, sign up for a trial account here. Retrieve your Authorization Token via the Validation menu on the left sidebar.
Note: There is no charge for the first 100 validation requests.
Step 2: Set up your app
2.1. Insert Authorization Token
Copy-paste your RPV Authorization Token into
2.2. Make the API request
Create a column to insert the phone numbers you’d like to validate. In the next column, make your API request to the RPV Turbo API using the
Note that in this request, you’re referring to the phone number in cell
A9 as well as your Authorization Token in
2.3. Parse the desired objects
We’re parsing for the
is_cell as well as
C8=PARSE(B8,"['status']") D8=PARSE(B8,"['error_text']") E8=PARSE(B8,"['iscell']") F8=PARSE(B8,"['carrier']")
Ensure your leads are reachable with Nexmo
If you’d like to validate the legitimacy of international (not only US) customer phone numbers, then Nexmo’s Number Insight API is the better choice for you.
Note: API requests are not free. Upon sign-up, your Nexmo account will be topped up with 2-3 EUR which you can spend for testing purposes.
The API provides information regarding
- If the number is likely to be valid, i.e. if the number exists. Please note that this is applicable to mobile numbers only.
- Response Objects:
unknown: the number could not be validated.
valid: the number is valid.
not_valid: the number is invalid.
inferred_not_valid: the number could not be determined as valid or invalid via an external system and the best guess is that the number is invalid.
- Response Objects:
- If the number is ported.
- If the number is reachable, i.e. if you can call the number now. Please note that this is applicable to mobile numbers only.
- If the number is roaming and, if so, the carrier and country
Keep your database clean and make the most out of existing customer information with one of the above APIs. Hope you enjoy!