Why is Marketo the Last Modified User for data that it did not update?

Chris_Willis1
Level 8 - Champion Level 8 - Champion
Level 8 - Champion

We've all had these moments of dread.

 

Your Salesforce admin pings you on Instant Message, and asks you... "Why is Marketo updating {insert random data value not associated at all with Marketing}?"  You go into Marketo, and upon doing some research you find that the record was indeed updated, but in the Marketo Activity Log you can clearly see that the record update was made by "sfdc" (Salesforce).  

 

You, after conducting some research/troubleshooting, reply back to your Salesforce admin and tell them that Marketo is telling you that the record was updated by Salesforce.

 

They, however, reply back to you and share a screenshot of the Salesforce record with the record history, and Salesforce is telling them that the record update was attributed to "Marketo Sync" (let's assume that this is the name of your sync profile).  

 

Who's right?  Technically, you both are but you need some more information to help you have this conversation with your Salesforce admin.  

 

The reason that this is happening is that Salesforce does not have a "user" assigned to workflow actions (APEX triggers or Process Builder Flows) that are active within Salesforce that act upon record updates.  Therefore, any data update that is processed from one of these Salesforce automations is attributed to the user record (in this case, "Marketo Sync") whose update initiated the trigger to fire. This video link below explains this more fully.  

 

https://youtu.be/kyIpLuz9lO0?si=pv9ux0OSGtxW7HPZ

 

This flow chart below explains the workflow at a high level:

Chris_Willis1_0-1731696550337.png

Any fields that are updated by APEX or a Process Flow, that are tracked via Salesforce change history, will be attributed not to a Salesforce APEX/Process flow, but to Marketo Sync in this case. 

 

What do you need to do?

 

First, demonstrate this knowledge of the Salesforce workflow to your Salesforce admin and present to them the evidence from Marketo that the updating user within the Marketo Activity Log is "sfdc" 

 

Second, if this is a troubleshooting case, offer to help with an audit of any APEX or Process flows that fired as a result of the Sync to Salesforce event from Marketo.  The result of this audit may require that you adjust Marketo sync behavior to avoid updating fields/data that would fire off the Salesforce triggers in question.  

 

These two steps should help you to start to resolve any of these questions that can come up. 

 

One piece of advice that I would give, especially with how interconnected these systems are and the degree to which IT or RevOps teams want to ensure that Salesforce is governed well, is to recommend that automation workflow that is updating Salesforce be outsourced from APEX/Process Flows to a third party orchestration tool for this reason.  The orchestration tool will have it's own Salesforce user and as a result any updates created by workflow in that platform will be attributed to the platform itself vs. your Marketo Sync User.  

622
1
1 Comment
Miray
Level 2 - Champion

Great post, Chris! Indeed, we keep hearing this question quite often.