...
- Always create indicators of contacts with low or bad data.
- Here's a Data Quality Score I set up earlier. This was based on a Blog Post from Salesforce, I think.
IF( LEN( Phone) = 0, 0,10) + IF( LEN( MobilePhone ) = 0, 0,10) + IF( LEN( Email) = 0, 0,20) + IF( LEN(MailingStreet) = 0, 0,20) + IF( LEN(Title) = 0, 0,20) + IF( ISPICKVAL(Salutation,""), 0,20) |
Here's a formula to add the data quality score to your Indicators (see below)
IF( DataQualityScore__c <= 20,IMAGE("https://login.salesforce.com/logos/Custom/Flag_Red/logo.png","Not enough Contact info",60,60),"")
- Decide if they should be deleted.
...