Clean up Marketo field values

Anonymous
Not applicable

Clean up Marketo field values

We have a couple of fields like Lead Status that have been used since we started learning Marketo and are still commonly used in List Uploads. This has led to a whole lot of incorrect values in our Lead Status picklist when adding the field to a Marketing Campaign. 

The picklist is accurate in Salesforce, but showing a mix of spaces, dashes, and misspellings in Marketo. There are no leads that still show the incorrect values, but they're still in our picklist.

Any ideas how we can fix this?  
Tags (1)
2 REPLIES 2
Anonymous
Not applicable

Re: Clean up Marketo field values

Here is an idea you can vote on:  https://community.marketo.com/MarketoIdeaDetail?id=08750000000Jp9JAAS

Josh_Hill13
Level 10 - Champion Alumni

Re: Clean up Marketo field values

Claire,
 

You can use a data management flow to select the erroneous leads and then map new values.

Smart List: Lead Status=Bad Values
Flow: Change Data Value: if Lead Status=Bad Data 1, then Good Data 1, etc

You can run this as a batch and then turn it into a trigger flow anytime a lead has this bad data.