We are going to populate the region contact field based on the values we have in the country field. This would be good after we have standardized values in both, but we notice having a considerable group of contacts who have a value in the country field but none in the region field (this will be your audience to bring in the program builder).
We are going to use a program builder. See the below design.
We have 3 decision rules checking country value from a filter, and after them an update rule setting the region for each category. (This could be done in one run too, with some conditional update rules and an country to region update table. )
The filter inside the decision rule is like:
As you see, it checks the country field against a picklist of values.
This means that for each region, you would have to set up eloqua picklists with the corresponding country values. Make them in excel and upload.
The update rules ran in the program are like: