Solved

Why did my Manually Imported List from a CSV Disappear?

  • 1 December 2020
  • 4 replies
  • 116 views

Userlevel 1
Badge

I uploaded a csv of about 30 contacts when I created my Klaviyo account. I confirmed they were all there, then cancelled my MailChimp account. I logged into Klaviyo today and the profiles were all gone. Hopefully these are recoverable?

icon

Best answer by Paul S 2 December 2020, 17:33

View original

4 replies

Userlevel 5
Badge +3

Hi @mattelustra

What was the name of the list that you had imported your contacts to and roughly when was the list imported? Since it seems like you manually imported in the contacts it does seem strange that they’d no longer be in the account. If you could provide any additional information, we’d like to work together to get to the bottom of this.

 

I’m sure you followed all of the steps below, but I’m going to provide in case other members who view this post may find it helpful when they’re trying to import contacts to a list via CSV:

 

Import Contacts from a CSV File

If you are migrating from an ESP that we do not currently integrate with or have a subscriber list already saved as a CSV or Excel file, you can easily import or copy and paste your subscribers into Klaviyo. If you have your list saved as an Excel file, make sure to save it as a CSV file first.

Your CSV should have the first row formatted as the headings for the columns you intend to upload. You must have a column labeled "Email" or "Email Address." Other columns you may want to include are "First Name" and "Last Name," along with any other custom properties you wish to upload.

When importing a list from another ESP, most platforms have a link to export lists to a CSV or Excel file. If you're having trouble, we recommend reaching out to your current platform for help.

Once you have your list exported, navigate to the Lists & Segments tab in Klaviyo and click on the list called Newsletter. Within this list, if it's empty, choose the Upload Contacts option to import your CSV file.

2019-10-07_13-42-50.png

If you already have subscribers in this list, click Manage List in the upper right and you'll see these same options for how you can add additional contacts to your list.

Then, you can drag and drop your CSV directly into Klaviyo or select it from your files. Alternatively, you can select Upload via copy/paste instead, and copy and paste your list into Klaviyo.

upload_file.png

You will be taken to a page where you will review the data you're importing. Select Import Review.

import_review.png

You will then preview how many columns and new properties will exist in your import. If this information is correct and you are ready to complete the process, select Start Import.

start_import.png

 

Userlevel 1
Badge

I imported the CSV exactly as described above, to my “Newsletter” list.

Userlevel 5
Badge +3

Taking a look at the list growth for the “Newsletter” list, I’m not seeing anything that indicates the list had contacts added other than those that are currently present in that section. What I am referring to is:

Your list Growth Report. To access your list growth report, head to your Lists & Segments tab and navigate into a given list. Then, click Reports > Growth Report.

Snip20170831_57.png

Analyzing the Source of Your List Growth

Klaviyo will assign all list subscribers a $source property that reflects how the contact was added to your list. When someone unsubscribes, we will also track how they unsubscribed.

Default Subscribe Source Values

  • Unknown: Source is non-identifiable
  • Back in Stock: Added via subscribing for back in stock notifications
  • Modal: Added via a popup form
  • Fly Out: Added via a flyout form
  • Embedded Form: Added via an embedded form
  • Subscribe Page: Added via a subscribe page
  • Klaviyo UI: Added via quick add or uploaded from a CSV file
  • Integration: Added via opting in through an integration
  • API: Added to a list via the Klaviyo API

but in this case we’re not seeing those users. Is there anything else that you can think of? Looks like the list dates back to the end of October but perhaps the import failed?

Userlevel 1
Badge

Thanks. I suspect I neglected to save the list after uploading or made some other user error. It was only 30 names anyway.

Reply