Skip to main content
trevlarrr
Level 3
Nov 4, 2022 12:21 PM UTC
Solved

Bulk update country fields

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.
SanfordWhiteman
SanfordWhitemanAccepted solution
User Group Leader
Nov 4, 2022 5:59 PM UTC

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!

View in thread

4 replies

Balkar_Singh
Adobe Champion, Community Advisor, UG Leader
Balkar_SinghAdobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Nov 4, 2022 1:19 PM UTC

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.

Translate
Darshil_Shah1
Adobe Champion, Community Advisor, UG Leader
Darshil_Shah1Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Nov 4, 2022 1:29 PM UTC

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.

 

Translate
trevlarrrAuthor
Level 3
Nov 4, 2022 5:02 PM UTC

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

Translate
SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Nov 4, 2022 5:59 PM UTC

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!

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...