Trestle’s Phone Validation Integration Guide for Clay provides instructions on using Validate Phone Number in your Clay table. This integration allows you to identify connected/disconnected phone lines to help prioritize outreach.
Validate Phone Number can be queried directly through Clay, or you can sign up with Trestle and add your API key to Clay.
Please Note: Available for U.S. only
Getting Started #
To get started, login to your Clay account and select the table where you want to validate phone numbers.
Click the blue “Add Enrichment” button or “Add Column” > then “Add Enrichment”
Search “Trestle” to see the integration options.
Validate Phone Number (One Clay credit per number)
This option queries our Phone Validation API and allows you to validate phone numbers, returning a Phone Activity Score to determine active versus inactive phone lines and phone metadata like line type (e.g., mobile, landline, fixed or non-fixed VoIP, etc.).
Also available is:
Verify Contact (Three Clay credits per contact)
This option queries our Real Contact API and allows you to provide name + phone number and email address. It will provide contact grades based on if the name provided matches the phone number + email address. We will also return a Phone Activity Score and phone metadata like line type (e.g., mobile, landline, fixed or non-fixed VoIP, etc.).
For Verify Contact Integration instructions, please visit the guide.
Validate Phone Number #
Once “Validate Phone Number” has been selected, this window will pop up.
Account:
Select if you would like to use a Clay-managed Trestle account (1 credit per phone number) OR if you would like to bring your own API key from Trestle.
If you would like to use your own Trestle API key, click the dropdown menu under “Select Trestle Account.”
Click “Add Account.”
Then, paste in your API key from Trestle which can be found on the Developer Portal.
Name your API key and click “Save.”
Setup Inputs #
For Validate Phone Number, there is one required input field: Phone Number.
As Validate Phone Number is a global solution, you will need to include the country code.
Click the “Phone Number” dropdown and select the column where the phone number is located.
Phone Activity Score (Optional)
This field allows you to select which Activity Score dispositions you would like to be considered valid/good phone numbers.
The Phone Activity Score ranges from 0-100 and is a confidence level that a phone number is active or inactive.
Select “Good” if you would only like the highest confidence numbers to be marked as valid.
Select “Good and Uncertain” if you would like both highest confidence numbers and uncertain confidence numbers to be marked as valid.
We recommend selecting Good and Uncertain; otherwise, you may filter out some good phone numbers.
Mobile Phone Only
This field allows you to select if only mobile phone numbers should be considered valid. If you would like to filter out landline, VoIP, toll-free, etc., click this toggle to enable.
Once these steps are complete, click “Continue to add fields.”
Add Data as Columns to Your Table #
Select which data outputs you would like added as a column:
- Id: This is an internal field and can be disregarded.
- Phone Number: Returns the phone number queried in a standardized format
- Is Valid: This field checks phone number syntax and if the number is assigned to a carrier. Phone Activity Score and Mobile Phone Only settings will impact if a number returns valid or invalid.
- Activity Score: A score range of 0-100 based on past 12 months of phone activity.
- Country Calling Code: Numeric country calling code
- Country Code: Two-character alphabetic country code
- Country Name: The country name of the location associated with the phone number
- Phone Line Type: Line type indicating if the phone is landline, mobile, fixed or non-fixedVoIP, toll-free, etc.
- Carrier: Phone carrier associated with the phone number
- Is Prepaid: Determines if the phone number is a prepaid phone line
Once you have selected the fields you would like returned in the response, click “Save.” Once saved, these columns will be added automatically to your table.
Run the Query #
Once your columns have been added, it is time to run the query. Select the “Play” button in the cell to run a single line, or select the “Play” button in the column header to run the whole column.
Troubleshooting #
Number Format Incorrect #
Clay does not currently have a cell format specifically for phone numbers. It is recommended that each column containing a phone number be set to “Data Type” or “Text.” This will maintain the phone number format. Whereas, if “Data Type” is “Number” the phone number format will include commas (i.e., 1,112,223,334).
Response Columns Don’t Populate #
On occasion, you may find that the response columns you added do not automatically populate with the response data. This is an easy fix:
- Select the cell beneath the Validate Phone Number header. This will open a cell details page.
- Select the field that is not populating. This will open a mapping window.
- In the mapping window, you will see a list of your existing columns. Select the column that corresponds to the data field you need to populate.
- Repeat for all data fields that are not populating.
Support #
Should you have any issues with the installation, please contact support@trestleiq.com or schedule a call with us to review.