How can I store multiple values on one email address, with multiple opportunities

Question

Hey,I have a pretty challenging situation:I have created some custom fields that should store business numbers for some of our clients, that would be used in a monthly business review newsletter. The trick is, that there are Contacts in our DB, that have multiple opportunities associated to the same email address, but I need to send out individual newsletters with the corresponding opportunity numbers, to the same email address.Ex: abc@domain.com, has 3 oppies attached:-  www.domain.co.uk-  www.domain.io-  www.domain.caHow can I send all emails at once, for each oppy, to abc@domain.com, without ovewriting the numbers. I would need another unique identifier besides the email address. Note.- I cannot create more fields to store the numbers, as I already have a lot more than Marketo can support to be used as tokens.- sending the email on different times is not the best case scenario as we would have to recreate 100 campaigns for this Kind regards,Mihai

Grégoire_Miche2 · Accepted Answer

Now it's starting to make more sense, But I need to re-create these fields at the opportunity object, right?

If I do so, can I prevent these fields to be synced in Salesforce? THat is another requirement I need to have in mind.

Many thanks for your patience and support

By the way, how did you figure out my full name is Mihail, instead of Mihai (that is used in marketo)?

Hi Mihail,

On the second question, just because it made more sense to use a first name that I new it exists

Yes, the fields need to be created in the opportunity object, but since they are opportunity fields, they can only be created and populated in SFDC. Then they will flow back to Marketo through the sync.

If you cannot populate them in SFDC, for whatever reason, then there is really no simple solution. You will have to use Marketo custom objects and populate them by import or with some API calls, the you will be abel to use email scripts to populate the emails.

-Greg

Grégoire_Miche2 · Answer

HI Mihai,Velocity Script tokens may help you there.-Greg

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded