Marketo to read SF Look up table

Question

My SFDC administrator is asking me to do something I am not sure can be done. He wants to create a look up table in SF to drive the association between a given lead and the relevant sales team.

Then of course, I can send alerts to the Account Exec for "x" territory. My understanding is that we would need a field on leads/contacts that would hold the email address associated to the sales team members. i.e. BDR email, AE email etc. The token {{my.BDR email}} would then be used in alerts.

Am I doing it the hard way? Is there a way Marketo reads SF look up tables?

Thanks for the help.

Grégoire_Miche2 · Accepted Answer

Hey Shari.No, that is like referencing another object. Copying @Grégoire Michel​ for confirmation  Darell is correct on this.But once the object is created, you could add some logic to it in SFDC such as create a field that gathers all the email addresses in the sales team, separated with comas.Once this field is created, you can have it copied to the lead in a dedicated field that you would be able to use in a token to address the alert. To do this, in the alert flow step, set the "send to" to blank and add the token to the "To Other emails" field. Yo will have to copy and paste the token, though.If you want all this to be really effective, you will have to use SFDC triggers and APEX, so that each time the sales team is updated, the leads linked to this sales team are also updated in SFDC and then in Marketo.-Greg

Darrell_Alfons2 · Answer

Hi Shari,The Send Alert flow step can send to different teams or people by adding constraints. I would see if you can work with that first. If this doesn't work for you, you can also create new fields on the lead and contact record for these different "owners" email addresses. Such as BDR email address, AE Email address etc.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded