Ed_Selby
Level 1
Alpharetta, GA
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-08-2020
08:15 AM
|
6
Posts
0
Likes
0
Solutions
08-30-2018
05:36 AM
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
... View more
08-29-2018
08:20 AM
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?
... View more
Labels:
08-24-2018
10:27 AM
Glad to know I'm not alone. I think text only is the way to go
... View more
08-24-2018
09:28 AM
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?
... View more
Labels:
08-22-2018
07:31 AM
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.
... View more
08-22-2018
06:03 AM
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?
... View more
Public Statistics
| Date Registered | 08-14-2018 12:53 PM |
| Date Last Visited | 07-08-2020 08:15 AM |
| Total Messages Posted | 6 |
.png)