We have a Marketing Cloud Connect directly linked to our Service Cloud. All Contacts are stored in a main Data Extension (called FullContacts). All is working properly with the Salesforce ID, our Marketing Team is able to create filted Data Extensions on all our Contacts, etc...
Now, here is the reality we're all having, I guess, in our companies: today they came to me with a CSV file with email addresses into this. These email addresses are some of our contacts who purchased some specific products (we don't have this level of acuracy for now in Marketing Cloud). And the Marketing team needs to send an email to them.
I was searching the best solution and here are my leads :
They create a Standard DE, import their list in this DE and send the email to them. Pro : easy, they can do this alone. Cons : The subscriberKey will be the email, so the Contact can't unsubscribe from this email. That's a no go.
They create a Standard DE, import their list in this DE. Then they have to edit and run a query to retrieve the SF ID for each email address in the DE. Pro : it works, and the contact will be able to unsubscribe . Cons : Marketing team is, for now, not allowed and not able to use Automation Studio, the risk to let them modify things here is pretty important but still possible with clear documentation
I couldn't find any solution using the Data Designer. I wanted to find a way to link the Email address in some point with the existing SF ID but I couldn't.
Do you have better idea to answer my needs ?
Thanks in advance !