@snoogs 

Yeah Klaviyo is a bit specific when uploading lists with dates.. so you will have to format it in one of the acceptable formats and then upload as date property in klaviyo (not a list that is usually basic for new properties when uploading)

Here is article explaining what are the acceptable date formats https://help.klaviyo.com/hc/en-us/articles/115005253428

The main issue is for me at least most of the times i have dates with dots for example 03.23.2024 but klaviyo doesn’t accepts it with dots so it has to be for example 03-23-2024 or 03/23/2024

Hmm, Mailchimp seems to already export in an acceptable Klaviyo format.   Perhaps I’m cataloging it in the wrong place, the only Klaviyo category that made sense to me is $consent_timestamp.   Is that the wrong place to put it? Do I need to create a new Klaviyo category?   It’d just be nice to maintain when they subscribed as I transition to Klaviyo.   Thank you @Bobi N.!

@snoogs 

I don’t know how Klaviyo looks at consent timestamp at the end but I think that is property more for legal purposes than for use in email marketing.. in klaviyo you are adding profiles now so because of that the day when you add them is the date when they will be considered as created profiles in Klaviyo. But if you want to use that date for segmentation or something similar in the future, if consent timestamp is not available option for choosing you can add those date in a new property and use that one for segmentation..

Hey @snoogs, jumping in here to clarify: I hear you only want to import one segment from Mailchimp which wasn’t possible with the integration, but did you try importing all your subscriber data this way? Klaviyo should maintain the proper subscription status and data accordingly. 

I’m wondering if just doing it all via the integration will solve your problem rather than trying to cherry pick which contacts you do and don’t import. 

@kaila.lawrence It was a massive rollercoaster of trying to get the integration to import a specific segment from mailchimp that ultimately failed.    I created a new audience in mailchimp out of the segment I wanted to transfer to Klaviyo because you need a specific API key to import a specific audience through integration.    So after hours of getting that set up it all integrated as unsubscribed.   

So I ended up integrating Shopify and importing via CSV the subscribed audience, that way I could select “all imports subscribed” and they would show up that way.   The good news is that Shopify integration was able to sync and recognized that CSV import and link to those who had purchased, which is ultimately what I wanted in the first place!

My advice to those reading this is forget about the mailchimp integration and export manual only subscribed users and then you can keep them all safely subscribed.   Thanks for you help!