I created a custom object called dealers, I linked the lead record(s) to my custom dealer object by a link field called dealercode, in which both objects share the same name as required. I imported my 100 dealers by the REST API into my new custom dealers object. To my surprise, only 100 leads could see dealer information. It seems, you cannot share the same dealer object or record with other lead records. Marketo seems to pick only the last lead with the same dealercode when creating object records. The other lead records that have the same dealercode are ignored. Looks like each lead record has to have its own dealer object or record.
Unless I'm doing something wrong, Marketo only support an one-to-one relationship. So why is this a big deal? Lets say I have 100 dealers and 50,000 leads, I would have to create 50,000 new dealer records, instead of 100. If I update the dealer information, I have to update 50,000 records instead of 100. If I update 1 dealer, I have to go find all the records for the same dealercode and update those records - could be thousands.
My questions:
- Does Marketo support one-to-many or many-to-many relationships? In other words, can several leads share the same dealer information in my case?
- If not, is there a plan to do so? and if so, timetime?
This is a common database scenario, I'm hoping I doing something wrong in my setup and Marketo isn't this limited or custom object support isn't done.
Thanks for any help or feedback.
.png)
Adchoices