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.

This guide will walk you through migrating your data from Bronto to Klaviyo. As you migrate your Bronto lists, keep in mind that the main objectives for migrating data are to ensure that all relevant contacts and fields are represented in Klaviyo, and that any opted-out contacts are treated as such in Klaviyo. Below we provide a recommended approach that will allow you to upload your Bronto contacts to Klaviyo and treat various contacts as unsubscribed based on the contact's status in Bronto. We recommend that you also review how Bronto defines these statuses so you can verify data quality in Bronto and ensure that this approach of uploading active, unsubscribes, bounces, and suppressions aligns with your intended use of Klaviyo.

This guide gives you general guidelines for migrating your data from Bronto to Klaviyo. Contact Bronto Support for the most up-to-date instructions on exporting your Bronto data.

Checklist

Migrating from Bronto to Klaviyo requires several key steps:

  1. Export active Bronto contacts as a CSV.
  2. Format CSV file.
  3. Import CSV file to a Klaviyo list.
  4. Export Bronto unsubscribes, bounces, and suppressions.
  5. Upload unsubscribes, bounces, and suppressions to your Klaviyo Suppression list. 
  6. Migrate your email templates from Bronto to Klaviyo.
  7. Sunset your Bronto account.
  8. Send your first Klaviyo campaign.

Export Your Bronto Lists

Each Bronto account is set up uniquely.  The following instructions are guidelines for exporting your Bronto Lists. Contact Bronto support and consult their documentation for the most up-to-date export instructions.

From your Bronto dashboard, select Contacts > Manage > Exports. In the Choose Filters section, select Active. This will include contacts who have opted in to receive marketing emails from your brand.

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. 

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. 

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. You can also locate all available downloadable files at Reports > Downloads and Reports > Legacy Downloads.

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 since they have already opted in.

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, you will receive an error message prompting you to add 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, Number, Date, or List, or Consent. 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, Bounces, and Suppressions

It is important to import your Bronto unsubscribes, bounces, and suppressions into your Klaviyo Suppression list to ensure compliance with spam laws and keep your deliverability strong. Suppressed contacts in Klaviyo cannot be sent marketing emails, however, if you use Klaviyo to send transactional emails, suppressed contacts will still receive these.

Go to Contacts > Manage > Exports and export CSV files from Bronto that contain only the following statuses:

  • Bounce
  • Unsubscribed
  • Unsubscribed by Complaint
  • Suppression List

These will include contacts that should be suppressed in Klaviyo because they have unsubscribed, marked one of your emails as spam, or bounced.

Additionally, you may have a suppression list in Bronto. This will contain contacts that you have manually suppressed. 

You can combine these exports into a single CSV, then format the CSV to only include a single column labeled "Email" containing email addresses. This will speed up the import.

You can view more information about exporting Bronto bounces and unsubscribed in their documentation.  

Upload Unsubscribes to 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. Below is an example of how your Suppression list CSV file should be formatted:

Suppress_list_format.png 

Click Choose File to select the CSV file containing your Bronto 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 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?
10 out of 12 found this helpful