update country field by multiple condition

Anonymous
Not applicable

update country field by multiple condition

I want update the lead's country field by multiple condition using a list.
for example,below is a list that contain old value and new value:
old valuenew value
AMARMENIA
AOANGOLA
ARARGENTINA
ATAUSTRIA
....
....

if the old country value is 'AM',than change the country to 'ARMENIA',if the old country value is 'AO',than change the country to 'ANGOLA',......
I thought it can be implement by createing a campaing and using Change Data Value in it,
but I should create many more choices.

Anybody knows how to do it with a easy way?  
Tags (1)
4 REPLIES 4
Dory_Viscoglio
Level 10

Re: update country field by multiple condition

Hi Chen, to do this through Marketo you will either need to do this with a large list of data value change choices, or by exporting your database, making the updates, and then reimporting the data. There might be other options as well depending on your CRM and if it's connected to Marketo, but these are going to be the easiest methods to do the change directly in Marketo.
Josh_Hill13
Level 10 - Champion Alumni

Re: update country field by multiple condition

I'd go with the Excel update Dory Suggests. Doing this in Marketo with 200 countries will be difficult to build with choice steps.

Just pull email address and Country, then reimport the list.
Anonymous
Not applicable

Re: update country field by multiple condition

Thanks for you help,I think that using excel update is a good way  to do it instead of  add many choices.
Anonymous
Not applicable

Re: update country field by multiple condition

I tried to resolve your question using a campaign and a small app via REST API.
Unfortunately, marketo token does not work at 'IF' section at a campaign flow. Smart list section also.
If it work fine, you click an app once.
0EM50000000Spqh.jpg
If you like this idea, please vote blow.
https://community.marketo.com/MarketoIdeaDetail?id=08750000000Ha8ZAAS