I need to create a custom Salesforce field to track the SDR (Sales Development Rep -- they schedule appointments on behalf of the sales person who owns the account) who is assigned to an account. In Marketo, I need the ability to send email alerts to the SDR and send email campaigns from the SDR. I've seen a few posts on this topic and am looking for the best solution.
If I create a lookup field, Salesforce will sync over the Salesforce ID which isn't very helpful. I could create additional formula fields to convert the ID into a full name and email address, but that doesn't seem like a clean solution, and there are limitations to when formula field data will sync to Marketo. Plus I'm at our limit of formula fields that reference other objects.
It's common for many B2B companies (especially SaaS companies) to have SDRs and sales people working on the same account. How do others make this work in Salesforce and Marketo?
You can send the alert in SFDC - not perfect, but very viable. In SFDC, you can send an alert to any email field - that takes care of your first ask.
For the second ask, you can probably use a combination of segmentation and tokens to get what you're looking for.