Setting up a many-to-many relationship with Custom Objects

Question

Hi everyone,
 
We have a Salesforce instance in which all our Accounts are tagged for segmentation purposes. In Salesforce, each account has one Tag Assignment, which is related zero or more Tags. I'm assuming this constitutes a many-to-many relationship: many Accounts are related to many Tags through Tag Assignments, which serves as a 'Bridge Object'.
 
We would like to synchronize the Tags in our Salesforce instance with Marketo, either manually (Import Custom Object Data) or automatically (API). Therefore, I'm attempting to replicate the data model with Custom Objects in Marketo. Unfortunately, I can't seem to figure out what the best approach is.
 
I have taken the following steps:

Create a Custom Object 'Tag'

Create a 'Tag ID' field and set it as deduplication field
Create a 'Tag Name' field

Create a Custom Object 'Tag Assignment'

Create a 'Tag Assignment ID' field and set is as deduplication field
Create a 'Company ID' field, set is as link field and link it to the 'Company ID' field on the Company Object
Create a 'Tag ID' field, set it as link field and link it to the 'Tag ID' field on the Tag Object

At first glance, this approach seems to work. But when I import Custom Object Data, not all person records with the same Company ID receive a tag. It seems as if it only relates the Custom Object to the first 'Person' is sees, while it should be related to the 'Company'.
 
Does anyone have experience setting up something like this? It would be very helpful to get some additional pointers.

Michael_Florin-2 · Accepted Answer

Hey Tom, I don't think I said that. &#128578;https://docs.marketo.com/display/public/DOCS/Understanding+Marketo+Custom+Objects#UnderstandingMarketoCustomObjects-customcompanyUsingCustomObjectswithCompaniesHere's the passage I was referring to. It hides in this sentence:"Custom Objects can only directly link to a single record. This means that when your custom object type is linked by company field, you should ensure that your person records are associated to a company either using contact conversion in your CRM, or using the externalCompanyId field."So you can definitely tie a Custom Object to a Company - as seen in your screenshot. And you will see this Custom Object on the detail pages of all Contacts that Salesforce lists under that Account, same as a Smart List with the filter "Has Custom Object X" will return all these contacts.

Michael_Florin-2 · Answer

Just  for clarity on your phrase "not all person records with the same Company ID": If you link a Custom Object to a Marketo Company Object, only Contacts are being associated with the CO. If you happen to have Leads in Salesforce that are underneath Salesforce Accounts, these would not show up.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded