It's been a very long time since the last improvement to the Salesforce connector. Browsing the community product and Idea sections enables to see how much some improvement is needed. So I wrote this recap on all the ideas that would really make a difference and enable the Marketo / SFDC connector to widen the gap again with the competition, which has been catching up over the past 2 years.
The first item would be an increase in performance, as we just got for MS Dynamics in the Spring'16 release (Release Notes: Spring '16 - Marketo Docs - Product Docs). And this is especially true for the campaign member table that can be really huge!
This long list is also there for the reader to vote for them!
The first areas on which some improvement is the data schema management and mapping:
We also need some strengthening of the way custom objects are mapped and handled:
The way the user object is handled needs a serious enhancement:
On the chapter of how Marketo programs interact and sync with SFDC campaigns, a lot has to be done:
A few enhancements would be welcome in the way we can leverage SFDC campaigns in filters and triggers:
Task / activity creation needs a serious improvement:
Lead assignment mechanism is by far too limited to enable to manage all the complexities of the most flexible or largest organizations. In these advanced SFDC users, at minimum, some lead assignment rules have been set up but very often some complex logic has been created, for instance to attach leads to accounts before they are converted. So:
Last but not least, we really need some improvement in how we can manage the sync and troubleshoot any issue:
I'll probably also compile a list of improvement that we would need to see coming on Marketo Sales Insight...
-Greg
It looks like all of the links to ideas have been stripped from this post.
What's up with that? I want to vote on those ideas!
Is it just me or did the nation redesign break the ideas linked in this post?
I think did. Is this not one of the best, most referenced posts in the entire Marketing Nation?
Two things that would be hugely helpful for me is if we had field validation at Marketo level, so we don't have to wait for it to fail at SFDC, having a multi-select picklist field, and an easier way to append to a field that is multi-select on the website and in SFDC.
Have any of these ideas been resolved or delivered?
Hi Devon,
AFAIK, none
-Greg
This is amazing! Thank you so much for putting this together and now I can get my team to vote them all up! I'm hoping that some of my problems (such as fields not updating as quickly as they should) can be related to the connector being so much lower.
Really impressed with the thoroughness of your post here Gregoire Michel. I may have missed it, but adding in functionality to sync SFDC Person Accounts would be a helpful addition as well.
Hi Michael,
Sync'ing person accounts is already possible, though it could be enhanced. The default of the person account sync is that Marketo continues to sync account and contact data as if they were separate. You need in the Marketo admin interface to go an hide account fields that contain values that are identical to the contact ones. Of course, you should only do this if you only use person accounts in SFDC. If you are in a mixed environment, hiding account fields is not relevant.
-Greg
This is awesome!! Thanks, Grégoire Michel!
You are welcome. It's really useful if you vote
Oh I did! It's great to have all your related ideas mapped out this way.
Hi Greg,
The sync time between Marketo and Sfdc has been a big pain for us, as it sometimes takes hours to complete a sync cycle. As a result, high intent inbound leads wouldn't get to salespeople's hands in time. Is there a way to measure and report how long the sync time takes? How to improve the sync between the two systems? I want to come up with an internal benchmark first, and effectively measure the improvement.
Any thoughts?
Hi Amanda,
Greg's response correctly deals with the greater issue that the sync time implies that you have something overloading the sync which affects your total time and the sync of a given object's updates (at my current org we've dealt with certain usage fields overloading the Account Sync), to fix the immediate problem of needing to get a high value lead into SFDC and the sales person's hands, you can use a flow step labeled "Sync Person to SFDC" (Docs site link) that skips the normal sync cycle. You'd want to use this only in a centralized campaign and sparingly, as it does take up a lot of resources relative to other updates, but for those super high priority leads this is a way to hotfix while you deal with the other sync issues. If you're an org that creates a new lead regardless if the person already exists in the system, this is also how that's accomplished.
Thanks Oliver. That makes sense.
Another question - when using "Sync Person to SFDC", will the leads be synced at the campaign level as well? Having the leads associate with a campaign with proper status is the key to our lead scoring and lead routing (we use Full Circle Insight response management package to MQL; and only MQLs will be routed to sales).
Hi Amanda,
if campaign sync is activated in the admin, yes. But they can be many and explain the overload.
Greg
Hi Amanda,
No problem, as to the campaign sync (caveat: not sure on this) I believe it will for systems using the Campaign-Program level sync but for other instances, it would depend on the SFDC customizations - I've only ever used the flow step in this manner with a heavily customized campaign attribution setup so my experience wouldn't be indicative of the norm.
Hi Amanda,
It is not that simple to get the sync times, as the information is not available in the UI, neither in through the API.
You need first to ask support for sync logs that shows the volume of data per object. This volume is probably significant to explain such long sync times. Once you know what object is faulty, you will have to investigate what type of updates is causing such long insertions. You might also want to position some logs on the sync use in SFDC to check that the issue is not linked to intense processing triggered by the updates from Marketo, that would slow down SFDC data intake.
-Greg