Skip to main content
Solved

When importing contacts into Klaviyo via CSV import, is it possible to skip contacts that already exist instead of overwritting their data


Forum|alt.badge.img+1

When importing contacts into Klaviyo via CSV import, is it possible to skip contacts that already exist instead of overwriting their data?

 

It seems the only option at the moment if contacts already exist in Klaviyo is that any mapped fields will be overwritten my new data from the CSV file.

 

Is there any option to skip/exclude contacts that already exist without having to mash the list in advance in Excel?

Best answer by ebusiness pros

Thanks @David To! Often the brands I’m working with are doing partnership giveaways, and then there’s a big CSV of emails to import into Klaviyo. We’ve found at least 10% of the CSV holds emails that were already subscribed to our client’s list. So that’s use case 1.

 

Second use case might be when we’re updating/ or bulk populating an existing custom profile property while creating a new custom profile property in the same CSV file. 

 

That said, there are also instances where information like email deliverability status as identified by a tool like Emailable, or a customer’s address, would need to be updated with the most current version as part of a CSV import. So it would most likely need to be a feature we can turn on when we want it, but otherwise it’s turned off by default. 

View original
Did this topic or the replies in the thread help you find an answer to your question?

7 replies

bluesnapper
Partner
Forum|alt.badge.img+45
  • Champion & Partner
  • 732 replies
  • July 4, 2023

Hi @DavidG 

You only have the option to exclude fields during import by unchecking/not checking the import buttons (see below). It will have to be an Excel manipulation prior to import if you want to exclude entire records from your .csv.

Regards

Andy

 


ebusiness pros
Partner - Silver
Forum|alt.badge.img+26

Hi @DavidG, welcome to the community!

 

This is a great question, and it’s a feature I’ve also thought would be helpful to have. @bluesnapper is right that you’d have to thoroughly prep your CSV file prior to importing in order to achieve this right now. 

 

That said, @David To - can you please help us pass along this feedback to the product team? Maybe it could be enabled by giving us the option to exclude specific segments of the list, so their existing data like custom profile property values would not be overwritten as part of the import process?

 

Warmly,

Gabrielle

 

Klaviyo Champion & Marketing Lead at ebusiness pros


David To
Klaviyo Employee
Forum|alt.badge.img+60
  • Klaviyo Employee
  • 2456 replies
  • July 5, 2023

Hey @bluesnapper and @ebusiness pros,

Great points!

@ebusiness pros, I’ll definitely route this feedback upwards to our Product Team! Can you also share some use cases for this sort of product enhancement? 

David

 


Forum|alt.badge.img+1
  • Author
  • Contributor I
  • 1 reply
  • July 5, 2023

Use case would be when doing a regular import of new subscribers from another system and you only want to import the delta (ie new subscribers).

Currently they data for existing subscribers will always be overwritten (custom fields for example) which you may not want.


ebusiness pros
Partner - Silver
Forum|alt.badge.img+26

Thanks @David To! Often the brands I’m working with are doing partnership giveaways, and then there’s a big CSV of emails to import into Klaviyo. We’ve found at least 10% of the CSV holds emails that were already subscribed to our client’s list. So that’s use case 1.

 

Second use case might be when we’re updating/ or bulk populating an existing custom profile property while creating a new custom profile property in the same CSV file. 

 

That said, there are also instances where information like email deliverability status as identified by a tool like Emailable, or a customer’s address, would need to be updated with the most current version as part of a CSV import. So it would most likely need to be a feature we can turn on when we want it, but otherwise it’s turned off by default. 


David To
Klaviyo Employee
Forum|alt.badge.img+60
  • Klaviyo Employee
  • 2456 replies
  • July 6, 2023

Thanks for sharing those use cases @ebusiness pros!

I’ll be sure to pass those along to our team to consider!

David


Vesna EGarden
Active Contributor I
Forum|alt.badge.img+5
  • Active Contributor I
  • 10 replies
  • September 18, 2024

Is there any updates about this? This was a year ago...