Skip to main content
Bishoy_Riad
Level 2
Aug 20, 2019 11:53 PM UTC
Question

Fields overwritten with [null] by SFDC Sync

Hi Marketo Nation,

We found that sometimes, certain fields are being overwritten with "[null]" at the exact same time. There are no Salesforce automations that would clear them. There is also no consistent timing for this to occur.

I created a Smart List and found a few patterns:

1. All affected records are overwritten via Sync by SFDC, either referencing a Lead ID or Contact ID depending on the record type.

2. All affected records have a "Company" value ("Account Name" value in SFDC).

3. Among the Lead type records that are affected, they are only bookings imported from a legacy system. While they obviously do not have an Account associated, they do have a "Company" value populated.

Here's an example of how the Activity Log looks (this record includes all 5 fields that are affected):

The individual Activity Details for one of the logged events looks like this:

The Marketo Integration User has full edit level permissions for 4 of the 5 fields on the Lead and Opp objects, and read permissions for the same 4 fields on the Contact object.

Thanks for assisting!

Bishoy

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

7 replies

SanfordWhiteman
User Group Leader
User Group Leader
Aug 21, 2019 12:26 AM UTC

You seem to be leaving out something important: are those fields blank in SFDC? And when were they cleared?

Translate
Bishoy_Riad
Level 2
Aug 21, 2019 12:34 AM UTC

These fields are not blank in SFDC, and I don't believe they were cleared prior. We just turned on field history tracking for the fields in question to ensure they weren't cleared at any point in SFDC.

The [null] issue has been happening to different records since early 2018. At least 1 of the same 5 fields are being overwritten in each case.

Translate
SanfordWhiteman
User Group Leader
User Group Leader
Aug 21, 2019 12:52 AM UTC

Well, watch the history tracking closely before deciding there's a bug on the Marketo side.

Translate
Lauren_Hawes
Level 2
Aug 21, 2019 5:12 PM UTC

We are also having this issue. A campaign changes their 'Person Status' in Marketo, but a SFDC Sync messes with it. It looks like it's being changed from [null] to "None" but the field was clearly changed to "Purchased List" 2 minutes prior.

Translate
Justin_Schmidt
Level 1
Feb 27, 2020 11:18 PM UTC

Same here. Did you ever figure out the problem?

Translate