Marketo Custom Object Relationship | Community
Skip to main content
Malay_Chakrabo1
Malay_Chakrabo1
New Participant
March 5, 2021
Solved

Marketo Custom Object Relationship

  • March 5, 2021
  • 1 reply
  • 2658 views

Hi there, 

 

I am looking for some help from the community in regards to Marketo Custom objects. 

 

Description: 

Recently, we have moved our subscription renewal reminder emails from Zuora to Marketo and we are passing the renewal-related data from Zuora to Marketo custom object 'Renewal ReminderObject'. Then using velocity scripts we are translating the data from the renewal reminder object and reference them in the emails. 

 

Now I am trying to also include invoice details in the emails and in order to house the invoice data I have to create another Marketo custom object ' Renewal Invoice Object'. 

Thus, the goal is to pull in certain fields from the Renewal reminder Object and a few invoicing fields from the Renewal Invoice Object. 

 

Issue: 

One of the major issues with doing so is duplicate records. Our SFDC instance has a lot of duplicate personas of the same email addresses. Thus, how do I make sure when our data warehouse is pushing data to these custom objects, both are associated with the same person object? 

 

For eg. there are 2 person records with the same email address as below: 

 

A - test1@test.com

B - test1@test.com

 

How do I make sure that if the Datawarehouse is pushing data to the Renewal Reminder object for record A then DW also pushed the data for renewal invoice object for record A(not B)? 

 

I am very keen on your input and your help is deeply appreciated. 

 

Thanks,

Best answer by SanfordWhiteman

Hi,

 

If you're going to allow — or even encourage — having multiple Marketo people with the same Email Address, it's not feasible to link your COs via Email Address. You need to find a way to have the Lead ID be the link field.

 

This of course means your integration layer needs to have a column with the Lead ID — perhaps synced from Marketo to SFDC via a custom field. Bear in mind the Lead ID(s) that corresponds to an SFDC Contact isn't a single static value over time (think merges and conversions) but it is a relatively slowly changing value.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
March 5, 2021

Hi,

 

If you're going to allow — or even encourage — having multiple Marketo people with the same Email Address, it's not feasible to link your COs via Email Address. You need to find a way to have the Lead ID be the link field.

 

This of course means your integration layer needs to have a column with the Lead ID — perhaps synced from Marketo to SFDC via a custom field. Bear in mind the Lead ID(s) that corresponds to an SFDC Contact isn't a single static value over time (think merges and conversions) but it is a relatively slowly changing value.

    Terms & ConditionsAccessibility statement

    Loading footer...