Expand my Community achievements bar.

SOLVED

Mobile Country Code

Avatar

Level 2

The mobile numbers for our Profiles are all saved as 10-digit, without the US country code of 1 appended at the front. Is there a way in my workflow or in the delivery template or in the external account settings to add "1" to the recipients number automatically before sending to our SMS provider? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@Dnelson_WG There are a couple of ways to handle this. 

  • Update the data import workflow to have prefix 1 on the mobile number while importing the data into ACS.
  • If the above can't be done use a separate workflow to pull the records having mobile numbers and use update activity to update the mobile numbers for the existing records and it can be scheduled to run on regularly. This workflow will look like below having query and update data activity,

SatheeskannaK_1-1729274214232.png

update activity details,

SatheeskannaK_0-1729274166513.png

SatheeskannaK_2-1729274265317.png

SatheeskannaK_3-1729274282652.png

 

  • I won't suggest to handle this at each campaign workflow level to prefix with the country code on the mobile number. 
Thanks, Sathees

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@Dnelson_WG There are a couple of ways to handle this. 

  • Update the data import workflow to have prefix 1 on the mobile number while importing the data into ACS.
  • If the above can't be done use a separate workflow to pull the records having mobile numbers and use update activity to update the mobile numbers for the existing records and it can be scheduled to run on regularly. This workflow will look like below having query and update data activity,

SatheeskannaK_1-1729274214232.png

update activity details,

SatheeskannaK_0-1729274166513.png

SatheeskannaK_2-1729274265317.png

SatheeskannaK_3-1729274282652.png

 

  • I won't suggest to handle this at each campaign workflow level to prefix with the country code on the mobile number. 
Thanks, Sathees