Reverse to previous Lead Source value | Community
Skip to main content
Nina_Valtcheva5
New Participant
August 8, 2016
Solved

Reverse to previous Lead Source value

  • August 8, 2016
  • 2 replies
  • 3074 views

Our sales ops team accidentally changed the value for "Lead Source" for a few dozen records in SFDC, and I'm trying to figure out if there is a non-manual way to reverse it through Marketo. Is there a way to see for all affected leads what the previous Lead Source value was and then change it back to that?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Devraj_Grewal

Nina,

What I would do is pull a smart list of "data value changed: lead source in timeframe today" with the constraint of source: salesforce.com and new value and previous value. You will need to run this for every previous value option it was changed from. Then in the flow you can change data value to what the previous value was. So you can create a number of smart campaigns or just modify the smart list and change data value flow for every previous value option.

2 replies

New Participant
August 9, 2016

Adding on to the above recommendations, if the lead volume is high, we can help you extract the activity log of the lead using the API. The data can be extracted in an excel where we can get the old Lead Source and the new Lead Source. Once you have cleaned up the data in an excel, you can import the data in Marketo.    

Devraj_Grewal
Devraj_GrewalAccepted solution
New Participant
August 8, 2016

Nina,

What I would do is pull a smart list of "data value changed: lead source in timeframe today" with the constraint of source: salesforce.com and new value and previous value. You will need to run this for every previous value option it was changed from. Then in the flow you can change data value to what the previous value was. So you can create a number of smart campaigns or just modify the smart list and change data value flow for every previous value option.

Josh_Hill13
New Participant
August 9, 2016

Yes, this is the only way in Marketo...

BUT, SFDC Admins can also do this more automatically if Lead History was on the field. You should really make this drop the Old Value to New Value. I've done this before.