Ed_Selby

Ed_Selby · ‎08-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

Ed_Selby · ‎08-29-2018

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?

Ed_Selby · ‎08-24-2018

Glad to know I'm not alone. I think text only is the way to go

Ed_Selby · ‎08-24-2018

I used the Marketo standard email design template. It looks good. Then I ran it through 250ok and a few test platforms. WTF? That horrible green color you see does not exist ANYWHERE in the html of the email (got the hexcode for that color - searched the code - doesn't exist). Not only that, but the 250ok engine shows this for my primary email platform And this is how my desktop client renders it Am I going to have to go with a non-Marketo solution to create cross-platform compatibility?

Ed_Selby · ‎08-22-2018

I *think* the "only once" vs "every time" was part of the issue. I had a whole campaign set up to correct a lot of country name issues overnight, and none of them updated. I tried to run it again this morning manually - one country block at a time. So far, the "every time" fixes the now issue although the "why didn't it run last night" issue remains.

Ed_Selby · ‎08-22-2018

I am trying to normalize countries in my Marketo DB by changing all US, USA, and United States of America to the Marketo standard of United States. My smart list shows 90,480 records that meet one of those critera; however, in my Smart Campaign, when I use the EXACT same Smart List criteria and select Schedule, I see "Set to affect around 0 existing people" What am I missing here?

Online Status	Offline
Date Last Visited	‎11-09-2020 02:26 PM

Date Registered	‎08-14-2018 12:53 PM
Date Last Visited	‎11-09-2020 02:26 PM
Total Messages Posted	6

Top Badges Earned

Re: Marketo/SFDC Data Priority?

Marketo/SFDC Data Priority?

Re: Email Rendering Problems Redux and Redundant

Email Rendering Problems Redux and Redundant

Re: Data Normalization Problems

Data Normalization Problems