Converted Lead data isn’t lost forever…it’s just hard to find

Last Updated on Thursday, 15 June 2006 07:32 Written by Steve Thursday, 15 June 2006 08:59

I got a distress email from a user of my Rapid Lead Converter the other day:

In my excitement I converted a lead into a new contact, and a second later realized that I converted a lead…which is using a number of new custom lead fields for which I had not yet created an equivalent contact custom field. For example, they had a lead custom field “spanish level” that I had not yet created in as a custom contact field. Since I converted the lead into a contact, that field’s info is now lost?

Good news is the data isn’t lost. But you can’t get to the Lead record in Salesforce.com. You can’t find it with a search, and if you go to the Id directly, it tells you that it’s been converted to a Contact. But the data’s not gone.

The trick is to view the Lead data through one of the many tools for exploring the Salesforce.com schema. There is one written by the Salesforce.com folks in .Net, and you can install this HTML as an S-Control for viewing the schema inside Salesforce.

Install one of these tools, then create a manual query of the Lead table and find the lead record you’re looking for. Grab the data from the fields you care about. It’s manual, but it will potentially save your butt sometime.

Update: Scott pointed out in the comments that I’m making things way harder then they are. Salesforce has a report set for just this issue. It’s called Leads with converted lead information. Thanks Scott!

4 Comments

1. Scott   |  Thursday, 15 June 2006 at 10:03 am

   You can use reports to find it. Select the Leads with converted information data set and then filter where Converted = True. That will show you all the leads that were converted.

   
2. Steve   |  Thursday, 15 June 2006 at 7:29 pm

   Hey, that’s great! A whole lot easier than my method…thanks.

   
3. Fifedog   |  Thursday, 15 June 2006 at 10:38 pm

   If that Scott Stoney (sorry if misspelled) you’re awesome! I’m glad to see you still posting helpful hints. I’ve been off of the board since I changed jobs and had my user name locked out. Anyway, I hope to see you again at the next dreamforce!

   
4. Steve   |  Friday, 16 June 2006 at 7:00 am

   That’s Scott Hemmeter of Arrowpointe…