+ Start a Discussion
Bhanu Akella 21Bhanu Akella 21 

What is the best approach to clean up data into a Custom Object.

We have a custom object which is consuming 80% of org (80 GB) data and we are looking to clean up this data. What is the best way to do this? I can only think of writing a batch job and deleting it but wondering how long does that job run to clean 80 GB of data. Is there any better approach to do this? Appreaciate any help here. 
Nubes Elite Technologies Pvt. LtdNubes Elite Technologies Pvt. Ltd
Hi Bhanu,

You can use   Data.com

Data.com is a Salesforce product that allows you to perform a number of different services against your data, their flag ships products are Data Clean & Prospect. Data.com Clean can verify and clean your data by looking at your Accounts, Leads & Contacts providing up to date relevant information against Dun & Bradstreet database. This allows you to swap in old information for current, bad data for good and new data that you did not have before. This can all be done on a record by record basis or in bulk, annoying you to control how you clean your data. Being a Salesforce product, Data.com is fully integrated with Salesforce and does not require you to set anything up, venture outside the Salesforce UI, or even leave a record you are currently working on.


Thank You,
www.nubeselite.com
Development | Training | Consulting

Please mark this as solution if your problem is solved.
Khan AnasKhan Anas (Salesforce Developers) 
Hi Bhanu,

Greetings to you!

You can use Data.com Clean to Clean a List of Records in Salesforce Classic. Please refer to the below links which might help you further with the above requirement.

https://help.salesforce.com/articleView?id=data_dot_com_clean_cleaning_records_list.htm&type=5 (https://help.salesforce.com/articleView?id=data_dot_com_clean_cleaning_records_list.htm&type=5)

https://www.salesforceben.com/5-ways-start-data-cleansing/

https://www.marksgroup.net/blog/salesforce-delete-records-in-mass/

https://help.salesforce.com/articleView?id=admin_massdelete.htm&type=5 (https://help.salesforce.com/articleView?id=admin_massdelete.htm&type=5)

https://success.salesforce.com/answers?id=9063A000000ZuG4QAK

https://developer.salesforce.com/forums/?id=906F0000000AanTIAS

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
Deepali KulshresthaDeepali Kulshrestha
Hi, Bhanu

Use Data.com Clean to keep your Salesforce data current and complete with data from Dun & Bradstreet and crowd-sourced data from Data.com. Using Clean jobs, you can clean all your records regularly. You can also clean a single record or a list of records.
Data.com Clean compares your account, contact, and lead records with records from Data.com and creates a link between your records and matching Data.com records. Clean also provides clean status information for accounts, contacts, and leads.
In Salesforce Classic, your users can do the following.
Manually compare individual account, contact, and lead records side by side to matched Data.com records, and update records field by field .
Select account, contact, and lead records from a list, and update them all at once.
Manually refresh D&B Company records linked to accounts.
As a Salesforce admin, you can also do the following.
Configure and run automated Clean jobs to flag field value differences on Salesforce records, fill blank fields, and overwrite field values. Configuring and scheduling Clean jobs is only available in Salesforce Classic.
Use the Data.com Match API to create a custom solution for specific business purposes like updating leads as they are created and updating custom objects.
There are two versions of Data.com Clean: Corporate Clean and Premium Clean. Premium Clean includes more Dun & Bradstreet fields for adding to or manually cleaning account, contact, or lead records. The Salesforce Help refers to Data.com 
Premium Clean unless otherwise noted. For more information on Premium Clean, contact your Salesforce account manager.

https://help.salesforce.com/articleView?id=data_dot_com_clean_clean_overview.htm&type=5

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha
www.kdeepali.com