How can I batch change a Field based on Opportunity Name?

[Anonymous]

We are doing some data cleanup while implementing Marketo. We have a opportunity field called Product. We need to batch update that field based on a word that is in the name of the opportunity. For example:

Opportunity Name Contains the word "Pilot"  = Change the product name field to "Pilot"

We have about 5K records that need to be changed. Can someone provide a solution?  I'm noticing that under the FLOW, we are unable to select Opportunity Name under a Change Data Value flow step.

Any help would be greatly appreciated.

Thanks,

Ron

[Grégoire_Miche2]

Hi Ron

To second Stijn, You can only do this is SFDC. Use a dataloader or a excel tool such as Enabler4Excel

-Greg

[Stijn_Heijthuij]

Hi Ron,

You'll notice that there's no way to change the data value of an Opportunity record anywhere in Marketo. That's because the Opportunity information should always be dictated by your CRM system. Take a look to see if you can mass update there.