We’ve added support for alternative phone numbers to the Customer table in Metrics, giving you greater visibility into customer contact details when planning telemarketing campaigns or resolving supporter issues.
What’s changed?
Alternative phone numbers are now stored in a new field called phones on the Customer table in the Metrics database.
This field contains a JSON object that surfaces secondary phone details, for example:
{
"phone2": "04xxxxxxxx"
}The phones field supports both mobile and landline numbers, making it easier to reference additional contact options alongside a customer’s primary phone number.
If Basic or Strict phone number validation is enabled on your JLP, please be aware that the validation protocols will apply to the alliterative phone number field.
Why it matters
With alternative phone numbers available in Metrics, you can now:
Query and analyse secondary contact details alongside existing customer data
Improve reporting and segmentation for outbound communications or telemarketing campaigns
Better understand how complete and up-to-date customer contact information is across your database
How to access it
You’ll find the data on the Customer table under:
customer.phonesThis field returns a JSON blob containing any available alternative phone numbers. To export the value from the JSON objet, use this query parameter:
phones::json->> 'phone2'