Skip to main content
Ed_Selby
Ed_Selby
Level 2
August 29, 2018
Question

Marketo/SFDC Data Priority?

  • August 29, 2018
  • 1 reply
  • 2653 views

A first assignment to clean up our MKTO data was normalizing country names. Our MKTO records use 6 variations for United States. There are numerous misspellings on some countries, and widespread use of the ISO code instead of the (MKTO preferred) country name. It was time-consuming, but I got it all done.

Today I pulled a report for a campaign, and I noticed that every single one of my corrections has been undone. I can only assume that my MKTO records were over-written by the SF record during sync (I don't have SF access so I can't confirm that).

How would a person go about making sure that the MKTO data takes priority and updates SFDC instead of the other way around?

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

1 reply

Grégoire_Miche2
Grégoire_Miche2
Level 10
August 29, 2018

hi Ed,

Are you sure in the first place that the values you entered are accepted by SFDC ? Are you sure you did not update Account information ?

Normally, the most recent update wins on leads and contacts (in case the record was updated on both ends between 2 syncs, SFDC wins). Account information cannot be updated from SFDC, it's a one way sync.

You need to look at the activity log of a couple of these leads / contacts to see whether you got any type of error message during the sync following the update.

-Greg

Ed_Selby
Ed_SelbyAuthor
Level 2
August 30, 2018

Here's the answer - I think...

.

I finally got access to SF and was able to look at the data structure. The "logic" for contacts in SF is that their country is the same as their associated account. The account country field SF uses the two letter ISO code, but also allows data imports - leading to multiple values for country choice. Marketo updates the country field in Marketo, but the SF sync over-writes that change.

Our SF admin is on a two week vacation, so I am unable to address this with him until he returns. Until then, no more country normalization in Marketo

Grégoire_Miche2
Grégoire_Miche2
Level 10
August 30, 2018

At least you know why. Not as good as having it fixed, but you can stop spending time trying to guess, and may be take 2 weeks of too

Terms & ConditionsAccessibility statement

Loading footer...