Bulk update country fields

[trevlarrr]

I need to change the values of the country field for all contacts/leads in Marketo, is there a quick way to bulk update these without having to create a separate 'change data value' option for every single country?

[Balkar_Singh]

Looks like you have a spreadsheet with the new values for certain leads - would suggest to upload the list directly and the values would change wherever those are different.

[Darshil_Shah1]

The answer to this question depends on what are the parameters/criteria you wish to use for changing the country - i.e., what is the source/criteria for updating the new Country field values? Is it based on a field - e.g., if Field A is "XYZ" set Country = "ABC" or do you have a spreadsheet with people and their new Country field values? In the latter, you can directly import the file to a static list in Marketo as Balkar said above.

Also, FYR, if there are field blocks enabled on the Country field for the input source(s) (e.g., List Import, Flow change data value, etc.) that you're trying to update the values, then you'd not be able to update the Country field values.

[trevlarrr]

Basically all leads (some imported, some via form fills) have countries using the full country names, but to sync them with the SFDC campaign they need to be the two-letter ISO code (we weren't told this previously), by the sounds of it we'd need to export all and reimport with the new values, but I was wondering if there was a way to run a smart campaign or similar that would update the country field, without having to create a flow step for each and every country

[SanfordWhiteman · Accepted solution]

There are non-native methods that you can use via calling a webhook. For example, querying a Google Sheet or SmartSheet that you use as a lookup table.

You could even cobble together your own webhook just using files in Design Studio: create one file for each (initial) Country value, with simple content:

italy.json

{
  "canonical" : "IT"
}

etc.

Of course, this is only easier than creating Flow steps if you automatically generate the files!