Ever Seen SFDC Campaign Sync not keeping members in sync?

[Chris_Vanderma1]

I've run a few webinars this year and I'm noticing that Marketo isn't keeping campaign membership in sync with SFDC. I've run hundreds of programs in marketo for many companies over the last few years and this is the first time I've ever seen this behaviour. Here's the proof...

The status had been set on the Marketo program for over an hour and multiple syncs occurred in that time. We've actually had this happen three times now recently and wonder if it could be related to the few SFDC release from around a month ago.

[Grégoire_Miche2]

Hi Chris,

1. Sometimes, the campaign member sync can run late. It's one of the objects that syncs last so if you have a lot of late sync, this may happen.
2. Make sure that no one tempered with the member status labels in SFDC. If they are even slightly different (even an uppercase / lowercase difference), the sync will break
3. Make sure that the leads themselves can sync. Look into their activity logs and check there is no sync error

-Greg

[Chris_Vanderma1]

Thanks for the Reply Grégoire!

Unfortunately, while they're good ideas I don't think any of those are the culprit.

1. Yes, but the Marketo program and the SFDC campaign would have been in alignment by the end of the Salesforce sync. I saw the Marketo <-> Salesforce sync complete multiple times with the statuses out of perfect alignment.

2. Nobody did tamper with the labels in SFDC. As you can see in the screenshots the labels are identical and worked for most, but not all of the leads.

3. I don't think this is the case, because all of the leads were eventually placed in the Salesforce campaign with the correct status when I disabled Program sync and used a smart campaign to push them to the correct status.

[Grégoire_Miche2]

Hi Chris,

Even if a lead could sync in the past, it may happen it can no longer sync if some values have changed and SFDC is now preventing the update, such as a validation that now fires.

-Greg