<< Prev Question Next Question >>
Question 6/41
A consultant is planning the ingestion of a data stream that has profile information including a mobile phone number.
To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.
What is the most efficient way to guarantee that the various phone number formats are standardized?
To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.
What is the most efficient way to guarantee that the various phone number formats are standardized?
Recent Comments (The most recent comments are at the top.)
Answer should be A,
The most efficient way to guarantee that the various phone number formats are standardized is:
A. Create a formula field to standardize the format.
Here's why:
Efficiency: Formula fields allow you to transform data within the data stream itself. This avoids the need to:
B. Edit and update the data in the source system: This can be time-consuming and may not always be feasible.
C. Assign the PhoneNumber field type: While this helps with data validation, it doesn't automatically standardize existing data.
D. Create a calculated insight after ingestion: Calculated insights are useful for analysis and segmentation, but they don't modify the original data within the data stream.
How to create a formula field for phone number standardization:
Define the formula: The formula should:
Remove any non-numeric characters (hyphens, parentheses, spaces, etc.).
Ensure the country code is present (e.g., +1 for the US).
Format the number according to the E164 standard (e.g., +15551234567).
Implement the formula: Use the available functions within the data stream platform (e.g., REGEX_REPLACE, CONCAT) to create the formula.
Test and validate: Thoroughly test the formula with various phone number formats to ensure accuracy.
By creating a formula field, you can efficiently standardize phone numbers within the data stream, ensuring they are ready for SMS campaigns and other downstream processes....
Phone data type accepts textual data and FORMATS it as phone number. So you can have various patterns as input but everything will be standardized.
Is A) https://help.salesforce.com/s/articleView?id=sf.c360_a_data_types.htm&type=5
Stores phone numbers. Data Cloud doesn’t validate the format of the phone number. The phone data type is modeled on the text data type. Any valid text value is accepted for ingestion into a phone data type field.
You can explicitly choose the phone data type for a source field if you want it to be treated as a phone number. You can use a phone number field as a primary key but not as an engagement date field.
Formula functions that work with text values accept phone data type input. You can convert the text output from these formula functions into a phone data type. For more information, see Supported Library Functions.