Sync interval between marketo and salesforce | Community
Skip to main content
September 4, 2014
Solved

Sync interval between marketo and salesforce

  • September 4, 2014
  • 4 replies
  • 1584 views
I created a custom formula field in salesforce that captures the lead owner if the lead owner is a queue. I could see there are around 47k leads currently in marketing queue in SFDC whereas in marketo it shows only 1300 leads.
This looks more of a sync issue. Could you please let us know the sync interval between salesforce and marketo for the existing leads. Also is there any criteria/rule that triggers the sync between 2 systems. Yesterday we manually pushed the sync then the lead count in marketing queue raised to 47k. This is a serious problem for us. 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kenny_Elkington
Hi Jamuna,

Formula fields do not update the symstemModStamp on an SFDC record when the caldulated value changes, so Marketo does not know to retrieve updates from these records.  To force marketo to pull down these changes you need to update the systemModStamp.  You can do this by exporting the SFDC ID of all of your leads owned by a queue and then reimporting this list through the SFDC Data Loader.  This will trigger Marketo to pull the changes from these records and pull down the value in the formula field.

4 replies

Level 9
September 4, 2014
Hi - Could you explain a little more about this custom formula field? Typically Marketo doesn't read queues in SFDC.

Kim
Kenny_Elkington
Adobe Employee
Kenny_ElkingtonAdobe EmployeeAccepted solution
Adobe Employee
September 4, 2014
Hi Jamuna,

Formula fields do not update the symstemModStamp on an SFDC record when the caldulated value changes, so Marketo does not know to retrieve updates from these records.  To force marketo to pull down these changes you need to update the systemModStamp.  You can do this by exporting the SFDC ID of all of your leads owned by a queue and then reimporting this list through the SFDC Data Loader.  This will trigger Marketo to pull the changes from these records and pull down the value in the formula field.
September 4, 2014
Thanks Kenny.
September 5, 2014
Step by step article for Kenny's suggestion