Import Data from SMSBump to Klaviyo

read
Last updated at:

Overview

Learn how to import your data from SMSBump to Klaviyo for your SMS program.

When migrating from SMSBump, you can upload your existing list of SMS subscribers to Klaviyo to start building out your SMS marketing strategy right away. Importing your SMS contacts allows you to centralize customer data so you can leverage Klaviyo’s robust analytics and tailor your customers' experience with SMS-integrated flows, emails, and push notifications.

Before You Get Started

Before you start the import process, you must: 

  1. Enable SMS in Klaviyo
  2. Set up you sending numbers for all countries you want to send to

Otherwise, consent for your imported customers will not be stored. 

Check this guide on migrating from another SMS provider for instructions.

Export SMS Subscribers from SMSBump

Before you begin migrating your SMS contacts from SMSBump into Klaviyo, it's important to distinguish between subscribers who have opted-in to SMS messaging and those who have not. It is against Klaviyo's Terms of Service and TCPA laws to market to contacts who have not explicitly opted-in to receive SMS communication from your business.

Klaviyo identifies opt-in subscribers as those who have a phone number and an SMS consent timestamp associated with their profile. In SMSBump, this timestamp may be assigned to the field Date added in your export file. Klaviyo will only send SMS messages to contacts who have both a phone number and an SMS Consent Timestamp stored within their Klaviyo profile.

SMSBump allows you to export a list of all SMS subscribers directly from your account into a CSV file. This list will simplify the import process into Klaviyo.

To begin, navigate to your linked SMSBump account from your ecommerce store’s integration. Here we use a Shopify store as an example. If you have trouble locating your SMSBump integration on the ecommerce site you use, we recommend reaching out to their support team for assistance.

Select Lists & Segments on the SMSBump menu pane.

listssegments.png

On the Lists & Segments page, select All Subscribers in the upper right corner.

allsubs.png

From the All Subscribers page, click Export in the upper right corner. 

smsbumpexport.png

SMSBump will display a modal window with several export options. If you would like to export all default fields, leave all boxes checked. At a minimum, you will require Phone and Created to be checked. When you are satisfied with your selections, click Yes, go ahead! to begin the export. Your download should begin immediately.

exporttype.png

Format Subscriber List CSV

You should carefully format your CSV file before importing it into Klaviyo. This will ensure that your contacts are imported smoothly and accurately. SMSBump’s exported CSV file includes most of the columns you will need, along with some additional columns you may choose whether or not to import. First, open your CSV in a spreadsheet editor like Microsoft Excel or Google Sheets.

Though not required, you will likely want to include these columns in your import. You will be able to map them to fields in your Klaviyo account during import. Consider whether or not these fields are valuable to you, and remove the columns if you choose. 

  • name
  • email
  • source

The phone number column is required to import your SMS contacts. Check the format of the phone numbers in your CSV file. Phone numbers must be in one of the following formats:

  • E.164 (e.g., +12345678910)
  • RFC966 (e.g., +12-34-567-8910)
  • E.123 national (e.g., 12345678910) 
  • international formats (e.g., +12 345 678 910)

Next, you will need to add a column for country, as it is not included in your SMS Bump export file. If you are sending in the United States, assign the value USA to all rows. Otherwise, check the country code of your opted-in subscribers and add a country value, such as UK or Australia, that corresponds to their country code. Note that you can only import consent for countries where Klaviyo SMS is available.

addcountrycolumn.gif

Klaviyo requires an SMS Consent Timestamp column, so you will need to rename the appropriate column heading. Locate the column heading Date added and delete the text, renaming it SMS Consent Timestamp. Doing so allows your import to automatically map the values to the correct field in Klaviyo.

smstimestampreplace.gif

Timestamps need to be specifically formatted or Klaviyo will not recognize them as timestamp fields. SMSBump exports timestamp data in the format YYYY-MM-DD HH:MM:SS by default. For additional supported timestamp formats, check out the guide here.

Import Subscriber List to Klaviyo

Before beginning to upload SMS subscribers into Klaviyo, turn off any flows triggered by the Consented to Receive SMS metric or by the list you're importing the contacts into by setting them to manual or draft mode. After uploading, wait one hour before turning these flows live again. 

After you've formatted your export data, you can import it into a Klaviyo list. To begin, log in to your Klaviyo account and navigate to Lists & Segments.

Click Create List / Segment in the upper right corner to create a new list for your SMS Subscribers. On the next page, select List.

Give your new list a name, such as SMSBump Subscribers and click Create List.

smsbumplist.png

Once your new list is created, click Upload Contacts to add your SMS subscribers via import. Drag and drop your CSV file into the field provided, or select it from your computer to upload your contacts. After selecting your file, Klaviyo will process the import and display a green loading bar with the text Uploading and validating file… If any required columns are missing, Klaviyo will alert you with an error message.

importsmsbump.gif

If you would like to add the contacts to an existing list, locate the list where you'd like to upload your contacts. Then, click the menu to the right of the list and select Import Data. Drag and drop your CSV file into the field provided to upload your contacts. 

SMS_Import_2.gif

For more detailed instructions on adding new contacts to a list, head to our article on Creating and Adding Contacts to a List.

Whether you create a new list or update an existing list, you will be prompted to review field mapping before Klaviyo begins the import. Carefully review each import field/corresponding Klaviyo field, and modify them as needed. By default, all identified fields are included in the import. You can omit a field from the import by unchecking the box to the right of the field name.

Here is an example of field mapping for an SMS contacts import from SMSBump:

smsbumpmapping.png

Import fields that are not automatically matched to a Klaviyo field are marked as Unmapped. If you try to import an unmapped field, an error message will appear, prompting you to map the field. From the dropdown, select an existing Klaviyo field name or create a custom field by typing a name into the blank entry field. To the right of the field name, select a data type from these options: String, Boolean, Numeric, Date, or List. If you're unsure of the data type, head to our article on data types in Klaviyo.

When you are satisfied with the field mapping, click Import Review on the upper right-hand corner of your screen. Review your selections, taking special note of SMS Consent verification. When finished, click Start Import.

startsmabumpimport.png

Your import will begin shortly. Depending on the length of your contact list, the import may take some time. You can stay on this page to watch the upload progress, but it is not necessary. Klaviyo will also send you an email confirmation as soon as the import is complete.

After the import finishes, you will see a summary of the completed import which includes a report of any skipped records. If your CSV file contains improperly formatted data, those fields may fail to import properly. When this occurs, you can download a report of the skipped records, resolve any formatting issues, and retry importing those records.

smsbumpuploads.png

For a deeper dive into importing contacts, head to our article on Migrating Existing Subscribers and Unsubscribes into Klaviyo.

Next Steps

After you import your data from Attentive into Klaviyo, you can begin sending. This guide walks you through other key steps of getting started with Klaviyo SMS

x
Was this article helpful?
12 out of 16 found this helpful