How to Get Contact-Opportunity Relationships in Dynamics to Sync to Marketo?

Question

Hi Gang,We are in the process of testing our Dynamics 365 sync to Marketo in our Sandbox.  We were pleasantly surprised to find that our Contact-Opportunity relationships previously managed as Dynamics Connections sync'ed with no additional effort. From what we can deduce, Marketo will sync any contacts associated to the opportunity via a connection of "connection role category" = "external".  Yay!What we cannot figure out is this:We were hoping to put a primary contact relationship on the Opportunity itself.  If we create a contact relationship on the opportunity record via a lookup field to the contact object and update this value, it does not get sync'ed to Marketo.We followed our consultant's advice and looked at any contacts that synced where "Has Opportunity" equals True, but all of these are associated as Connections.Does anyone have any guidance on how the association should be set up within Dynamics 365 to allow this to work?Thank you,Adam

Paul_Wilson8 · Answer

Good day @Adam Monago​ - good question!In my experience there is a very specific field to denote the primary contact related to an Opportunity for Marketo to see the relationship. That field is the customerid field in MSD on the Opportunity, a standard field. If you use a custom lookup field Marketo doesn't know that that field's purpose is to connect the Contact and the Opportunity.Please let me know if you have resolved this, or if I can help you further on this!Regards,PW

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded