SOLVED

Implementing SFDC Standardized State and Country Pick Lists

Go to solution
Delinda_Tinkey1
Level 5

Implementing SFDC Standardized State and Country Pick Lists

I'd like to implement the standardized SFDC pick lists, but see conflicting information on this in the Marketo community. Has anyone done this successfully or does it still break the Marketo integration?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: Implementing SFDC Standardized State and Country Pick Lists

Hi Delinda,

The real issue is that once you have made the change in SFDC, SFDC will become very pernickety with country field values an reject any value that is not in the picklist (while with previous free field, any crappy data could be inserted). This will put your data management and import process on first line, but if country is an important information for your business (for instance for lead assignment), the gain in data quality and process efficiency is significant (and IMHO worth the effort).

It will not break the integration if you anticipate it and proceed quickly with a few changes:

  • Make sure you update ALL forms quickly so that any country field used there uses the same list as SFDC for stored values. If you don't, leads created or updated with faulty country values will not be inserted/updated in SFDC.
  • If some lists are imported in your DB, make sure that only valid country values are uploaded through these imports
  • Create or update your data management campaign so that they cleanse all invalid country values.

SFDC country picklist migration wizard will replace all country values by values from the picklist. Let the sync propagates these changes to Marketo and then run some data management campaigns on the remaining (non synchronized yet) leads in Marketo to adjust the countries to be correct values

-Greg

View solution in original post

1 REPLY 1
Grégoire_Miche2
Level 10

Re: Implementing SFDC Standardized State and Country Pick Lists

Hi Delinda,

The real issue is that once you have made the change in SFDC, SFDC will become very pernickety with country field values an reject any value that is not in the picklist (while with previous free field, any crappy data could be inserted). This will put your data management and import process on first line, but if country is an important information for your business (for instance for lead assignment), the gain in data quality and process efficiency is significant (and IMHO worth the effort).

It will not break the integration if you anticipate it and proceed quickly with a few changes:

  • Make sure you update ALL forms quickly so that any country field used there uses the same list as SFDC for stored values. If you don't, leads created or updated with faulty country values will not be inserted/updated in SFDC.
  • If some lists are imported in your DB, make sure that only valid country values are uploaded through these imports
  • Create or update your data management campaign so that they cleanse all invalid country values.

SFDC country picklist migration wizard will replace all country values by values from the picklist. Let the sync propagates these changes to Marketo and then run some data management campaigns on the remaining (non synchronized yet) leads in Marketo to adjust the countries to be correct values

-Greg