Bulk update country fields | Community
Skip to main content
T
trevlarrr
New Participant
November 4, 2022
Solved

Bulk update country fields

  • November 4, 2022
  • 2 replies
  • 3197 views

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?

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

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!

2 replies

Darshil_Shah1
Darshil_Shah1
Community Manager
November 4, 2022

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.

 

T
trevlarrrAuthor
New Participant
November 4, 2022

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
SanfordWhitemanAccepted solution
New Participant
November 4, 2022

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!

    Balkar_Singh
    Balkar_Singh
    Community Manager
    November 4, 2022

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...