Migrate from Bronto to Klaviyo

read
Last updated at:

Overview

While Klaviyo does not have a built-in integration with Bronto, you can export your data from Bronto and upload it into Klaviyo. Bronto contacts and related data are exported from Bronto in CSV format. CSV files can be easily formatted to ensure successful import to a Klaviyo list. While this is not a complicated process, exporting each individual Bronto list may be a bit tedious depending on your volume of data. With consistency and thoroughness, your migration will be successful. 

This guide will walk you through migrating your data from Bronto to Klaviyo.

Checklist

Migrating from Bronto to Klaviyo requires several key steps:

  1. Export all Bronto lists into CSV reports.
  2. Download Bronto CSV reports.
  3. Format CSV files.
  4. Import CSV files to a Klaviyo list.
  5. Export Bronto unsubscribes.
  6. Load unsubscribes into your Klaviyo suppression list. 
  7. Migrate your email templates from Bronto to Klaviyo
  8. Sunset your Bronto Account
  9. Send your First Klaviyo Campaign

Export your Bronto Lists

Follow these steps to download each of your Bronto Lists. From your Bronto Dashboard, expand your Contacts tab.
Bronto1.png

Click Lists. Lists featured on Bronto screenshots have been blurred for anonymity. 
Bronto2b.jpg

Select a list to open the list's details. Review those details, and then click View Contacts.

Bronto3.png

Select Export.
Bronto4.png

Next, you'll choose your export filters. In the Search dropdown, you can choose All Contacts, Active Contacts, Inactive Contacts, or Suppression List. The first group we'll download is All Contacts, which includes only active and inactive contacts. We'll download your Suppression list later in a separate export. By default, All Contacts are selected. 
mceclip1.png

Now select the fields you wish to export with your contacts. These are the most important fields to include in each contact export:

  • email
  • first name
  • last name
  • last open
  • last click
  • address 1
  • address 2
  • city
  • region
  • country
  • zipcode

Adjust the settings for your export list, making sure to check off the important fields listed above. 
Bronto5.png

Here are some suggestions to keep in mind while selecting your export fields: 

  • Choose Field section: select each field you'd like to include in your export file. You'll be able to adjust the names of these fields later on the CSV file before you upload them into Klaviyo. 
  • Choose GeoIP section: we suggest omitting GeoIP data from your export as Klaviyo will automatically capture GeoIP information or purchase zipcode when your customers interact with your ecommerce store or emails.
  • Choose RFM Metrics section: If you have integrated your ecommerce platform, this data will already have been pulled in from that location, so RFM Metrics export may not be necessary.
  • Email Notification section: enter an email address so you can be notified when your CSV download is complete. 

Bronto5.png
When you are finished filling in details, select Export to begin running your report. All Bronto reports download into a CSV file. You'll receive a Bronto in-app notification when your CSV download is complete. If you filled-in the Email Notification section, you'll also receive an email notification.
Bronto7.png

Export every list from Bronto that you wish to import to Klaviyo. Save other list exports for reference.

Download Exported Bronto Files

All Bronto reports are download into a CSV file which can be opened in Excel, Google Sheets, or similar programs. Bronto stores all reports in Reports > Legacy Downloads

To find your Bronto CSV exports, head over to the Reports section and select Legacy Downloads.
Bronto8.png
Select each download, and then export each of them. Save your CSV files in an organized and secure place for future reference.

Format CSV Files

Contacts are imported into Klaviyo in CSV format. Carefully format each CSV file before it is imported into Klaviyo to ensure that your contacts are imported smoothly and accurately. 

Open each CSV file. Carefully comb through each list, paying special attention to the column headings: 

  • Column headings should be in the first row of the CSV file. If Bronto adds additional rows before the column headings, delete these extra rows.
  • Your CSV file must include an "Email" or an "Email Address" column.
  • You may want to include a "First Name" and "Last Name" column.
  • Include any custom profile properties such as "Gender" that you'd like to upload to Klaviyo
  • Timestamp fields such as "date added", "last opened", and "last clicked" need to be specifically formatted or Klaviyo will not recognize them as timestamp fields. Make sure timestamp data is formatted in one of these formats:

    YYYY-MM-DD HH:MM:SS

    MM/DD/YYYY HH:MM:SS

    MM/DD/YY HH:MM:SS

    MM/DD/YYYY HH:MM

    MM/DD/YY HH:MM

    YYYY-MM-DDTHH:MM:SS

This is an example of how your CSV file should be formatted:
CSV_Formatted_Import.png

Review your CSV file carefully, editing/deleting column headings, and contact entries as appropriate. 

Remember that it is much easier to parse and edit data within a CSV file before it is uploaded into Klaviyo. 

For more detailed instructions on formatting CSV files, head to our article on Creating and Adding Contacts to a New List

Import CSV Files to a Klaviyo List

After you've formatted your exported data, you can import it to a list in Klaviyo. Some Klaviyo flows are triggered by an email address being added to a list. Before you begin uploading contacts to a list, make sure these related flows are turned to draft or manual mode.

Log into your Klaviyo account and navigate to Lists & Segments. Select the list where you would like to add your contacts. For this example, we're going to add subscribers to the Newsletter list.

Bronto12.gif

On the upper-right hand corner of your list, choose Import Contact from the Manage List dropdown.
Import_Contacts_blurred.gif

Drag and drop your CSV file. You will be prompted to review field mapping before Klaviyo begins the import. Carefully review each import field/corresponding Klaviyo field, and modify as appropriate. By default, all identified fields are included in the import. You can omit a field from import by unchecking the box to the right of the field name.
Omit_Import_Field.gif

Import fields that are not automatically matched to a Klaviyo field are marked "Unmapped." If you try to import an unmapped field, Klaviyo will give you an error message and prompt 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.
ezgif.com-crop.gif

 

This is a simple example of field mapping for a  Bronto contacts import:

Generic_CSV_Mapping.png

When you're finished, click Start Import on the upper-right corner of your screen.
Start_CSV_Import.png

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

Export Bronto Unsubscribes

It is important to import your Bronto unsubscribes into your Klaviyo Suppression list to ensure compliance with SPAM laws and keep your deliverability high. Following the steps above, export a CSV file from Bronto that contains only a list of suppressed email addresses, and then add it to your Suppressed Profiles list in Klaviyo.

First, head over to your Bronto account and select the Contacts tab. 

Bronto17.png

Click Manage.
Bronto18.png

In the Choose Filter section, choose Suppression List from the Filter dropdown, and then click Export. No need to select additional import fields. 
Bronto19.png

Your unsubscribe list should be in CSV format and include just a single column containing email addresses. The suppress list file should be simple, containing a single column of email addresses. There can be an "Email" column heading, but this is not necessary for the import into Klaviyo. 

Load Historic Unsubscribes into Klaviyo

Navigate to the Profiles tab in your Klaviyo account, and click the Suppressed Profiles on the upper right. Then select Upload File.
Bronto20.gif

Format the suppress list so that it contains a single column of email addresses. There can be an "Email" column heading, but this is not necessary for the import into Klaviyo.

This is an example of how your Suppress List CSV file should be formatted:
Suppress_list_format.png

 

Click Choose File to select the CSV file containing your Bronto historic suppressions. Then, click Upload Suppressions.
Bronto21.png

Your Klaviyo Suppression List will now reflect your import.

Migrate Email Templates from Bronto to Klaviyo

Klaviyo has an intuitive drag-and-drop template builder that you can use to recreate your Bronto email templates. We highly recommend using this method to rebuild your templates because it will ensure that they are mobile-optimized, responsive, and easy-to-edit moving forward.

If you don't have time to recreate your Bronto templates using Klaviyo's template builder, it is possible to export your email templates from Bronto in raw HTML and then upload the updated raw HTML into Klaviyo. If you must import raw HTML templates, you can reference this doc: Import a Custom HTML Template 

Sunset your Bronto Account

After you've moved all your data over to Klaviyo, there are three key steps you can take to ensure that you no longer need your Bronto account:

  1. Ensure that your signup forms and list growth tools point to Klaviyo, not Bronto.
  2. Recreate your Bronto workflows as Klaviyo flows.
  3. Discontinue use of Bronto. 

Signup Forms and List Growth Tools

Recreate any Bronto signup forms in Klaviyo so that your list continues to grow in Klaviyo rather than in Bronto. You can:

  1. Use the Klaviyo Signup Form Builder to re-create your forms from scratch.
  2. Use a third-party list growth tool that integrates with Klaviyo.
  3. Integrate your custom form through your ecommerce platform.

If you are using third-party list growth tools, make sure that these sync to Klaviyo. Klaviyo integrates with a number of tools for list growth and landing pagesScan our list of app integrations to find the tool that you're using. If you don't see it listed, consider using Klaviyo's native Signup Form Builder to create your forms, or try switching to a different third-party tool.

Please note that all Klaviyo lists are double opt-in by default. If you would like to change a list to single opt-in and you are on a paid plan, reach out to support.

If you’re using a custom-coded form, there are two ways you can ensure that these contacts sync to Klaviyo. One option is to make sure that your custom form syncs new subscribers directly to your ecommerce platform and that your ecommerce store is integrated with your Klaviyo account. The second option is to point the form directly to your Klaviyo account by updating the Form Action URL. To find the Form Action URL in your Klaviyo account, go to your Lists & Segments tab and click on the list where you want to add your new subscribers. Click on the Subscribe Page tab and copy the URL from the right side of the screen.

Updating_Form_Action_URL.gif

After switching all your signup forms to point to Klaviyo, wait a few days and watch your lists in Bronto. If you notice subscribers are still being added to these lists, there's probably at least one form that still needs to be swapped out.

Next, you'll want to turn off your Bronto signup forms. Contact Bronto Support for information on how to turn off your Bronto signup forms. 

Email Automations

Klaviyo refers to automated workflows as "flows" which allow for more advanced and targeted sequences. It is important to recreate these in Klaviyo so that you don't need to continue to use Bronto to send triggered emails.

As you move from Bronto, it may be a good time to refresh and update your automated messaging. We recommend that you turn on your Welcome Series and Abandoned Cart flows as soon as possible. A welcome series is particularly important to engage new subscribers, and abandoned cart flows have the highest ROI of any other type of flow.

Once your Klaviyo flows are live, you'll want to turn off all of your workflows in Bronto to ensure that you're not double-emailing people. Contact Bronto Support for more information about turning off your Bronto workflows.

Discontinue Bronto Use

Once you’ve pointed all of your list growth tools to your Klaviyo account, paused your Bronto workflows, and turned your Klaviyo flows live, you can discontinue using Bronto. Before you close your Bronto account, double-check that everything is working as expected. Enter a test email into your signup form and other list growth tools, abandon a cart, and sign up for your newsletter to trigger a welcome series. Go to the Profiles tab in your Klaviyo account to make sure that the information in the profile reflects all of the correct communication. If the list you sign up to is double opt-in, be sure to confirm your email first.

After you've taken these steps and are fully migrated to Klaviyo you can close your Bronto account. 

Send Your First Campaign with Klaviyo

Once your Klaviyo account is integrated with your store and all of your data is ported over from Bronto, you can send your first campaign with Klaviyo.

 

Next Steps with Klaviyo

Build an Excellent Sender Reputation with Klaviyo

Once you begin sending to your most engaged segment of customers, you can gradually send to more of your customers. This gradual sending process enhances your sender reputation and is known as warming your IP address.

Head over to our articles on deliverability to read more about warming your sending infrastructure.

Use Advanced Segmentation to Reach your Customers

After you've engaged your most interested subscribers for the first month or so, you can begin reaching out to the rest of your customer base. Create additional segments to ensure you're reaching each corner of your customer base.

  • Duplicate your Engaged (3 Months) segment and tweak the settings, decreasing the timeframe from 3 months to 30 days.
  • Use historical Bronto data to refine and build out your segments.

For a deeper dive into segmenting and approaching the rest of your customer base, read Creating Customer Engagement Tiers

If you have questions about transitioning from Bronto or getting started with Klaviyo, please reach out to our Support Team

x
Was this article helpful?
7 out of 8 found this helpful