Having trouble importing SMS #’s. When I have column with “+1” and number, when saved as CSV, the +1 is removed so the file will not upload correctly. Any suggestions?
Thanks!
Having trouble importing SMS #’s. When I have column with “+1” and number, when saved as CSV, the +1 is removed so the file will not upload correctly. Any suggestions?
Thanks!
Best answer by Dov
Hi
Yes, please keep us updated on the status.
Also, can you confirm if you have any additional fields in the .csv file aside from the phone number? For example, if you have the SMS consent timestamp column, it must be formatted in one of Klaviyo's accepted datetime formats (e.g., 2019-09-01 13:34:08+00:00) and should use the “Date” data type on the mapping page.
The phone number field should be using the “String” data type on the mapping page (depicted below):
You can find below the correct data types for the “standard” properties when uploading SMS consent to ensure a match:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.