Best way to consolidate custom properties

Hello @MVHeather,

Great question!

Your assumption here would be correct. Using an exported .CSV and importing it back into Klaviyo would be the best solution for this.

In a case like this, I would recommend creating a segment with the rules: Properties about someone, CUSTOM_PROPERTY equals “previous ESP property is set as a tag” OR Properties about someone, CUSTOM_PROPERTY equals “previous ESP property is set as a AB custom property”. You can then go ahead and export this segment of customers. Within the resulting .CSV though, I would suggest adding a new column to the .CSV with the header of the “Klaviyo XY custom property” and value. Once completed, you can import this list back into Klaviyo  which would apply this Klaviyo XY custom property and value to these contacts. 

This would allow you to then create a segment while filtering for the Klaviyo XY custom property to return all of these customers highlighted in your example. In additional, if you need a custom profile property purged from your account such as these properties from your previous ESP, you can reach out to support to have this accomplished. 

I would also suggest taking a look at the following Klaviyo Help Center Articles for more details pertaining to Klaviyo properties and how to updates profile properties similar to the strategy mentioned above:

• Guide to Properties
• How to Import Profile Properties Using a CSV Upload
• About Custom Properties
• How to Export a List or Segment to a CSV File

Thanks for being Klaviyo Community member!

David