So, we recently started using marketing cloud, and are looking to handle our newsletters campaign from there, we have a list of existing subscribers that we want to add to the Publication lists in Marketing cloud without sending a confirmation email, since these are existing subscribers, how can that be done?
So, after giving it some thought, I've come to this solution:
I created an automation with three steps:
- An SQL activity that will query the leads directly from our Sales cloud Org, and store the information I need in a Data extension, generating a csv file
- A file transfer activity that will get that CSV file from the Safehouse to the ExactTarget Enhanced FTP
- An import file activity that will take that csv from the FTP and import it onto the publication list.