Skip to content
FullCRM logo
  • Home
  • About Us
  • Salesforce Consulting
    • Distribution
    • Construction
    • Professional Services
    • Manufacturing
    • Medical Devices
    • Transport and Logistics
    • Financial Services
    • Other Industry
  • Our Clients
  • Our Partners
  • Blog
  • Join Us
  • Contact Us
Menu
  • Home
  • About Us
  • Salesforce Consulting
    • Distribution
    • Construction
    • Professional Services
    • Manufacturing
    • Medical Devices
    • Transport and Logistics
    • Financial Services
    • Other Industry
  • Our Clients
  • Our Partners
  • Blog
  • Join Us
  • Contact Us
Contact

3 Easy Steps To Enrich Your Salesforce Data

FullCRM’s 3 easy step guide to improve your Salesforce Data

Clean and consistent data is an asset to any business and provides essential insights into past, current and expected performance.

Many businesses underestimate the importance and value of their data and allow their users to enter limited information in their system. It does not matter how well the platform is configured if it is running on weak data; the business will always be playing catch up.

Now is the perfect time to focus on the quality of your Salesforce data. 

Here is our 3 step guide on how to enrich your Salesforce data

1. Review your data to determine what needs to be updated:

Firstly you want to understand the current state of your data to determine what needs to be updated.

Start by reviewing your objects and detail what fields are critical to your business:

E.g. All Leads need to have a: 

  • Title
  • Email 
  • Phone Number 
  • Website

To understand how populated each field, we recommend creating a list view and utilising list view charts:

How to create a list view:

  1. Select the object from the menu bar (leads, contacts, accounts, opportunity)
  2. From the list view controls (cog wheel) > select new
  3. Name the list view 
  4. Select whom you want to share the list view with: 
    • Only you 
    • All users 
    • Group of users
  5. Click save
  6. Add filters, i.e. All Accounts
  7. Click Save
  8. Determine the fields you want to display from the list view controls (cogwheel) and select fields to display
  9. Move the fields you want visible within the list view > make sure to include the field that you want users to update

How to create a list view chart to identify the gaps in your data

  1. Select the list view created above 
  2. Click the pie chart icon on the right-hand side of the screen 
  3. In the charts panel that appears, click the cogwheel
  4. Select New Chart
  5. Enter a chart name 
  6. Select a chart type: vertical bar, horizontal bar, or doughnut. 
  7. Select the following:
    • The aggregate type specifies how the field data is calculated: Select Sum
    • The aggregate field specified the type of data to calculate: select a key field:  i.e. website
    • The grouping field labels the chart segments: i.e. Lead Owner 
  8. To view your chart, click save 
Note: Chart data does not automatically refresh when you change list view. To see the latest chart data,  manually update the list view using the refresh icon.
 
We recommend making a plan to update a field each fortnight with your Salesforce users.
 

2. How to empower your users to update their existing records:

It is unlikely that you will have great success asking your Salespeople to update the data by editing each record on mass. 

Create a list view following the above steps and share with your users.

They will be able to begin mass editing from the list view.

Tips for inline editing list view: 

  • You cannot make inline edits across multiple record types in a list view.  *If you are using them, filter your list view to a specific record type.
  • Fields that can be updated will have a pencil when you hover your mouse over them
  • Fields that cannot be updated will have a lock when you hover your mouse over them * Review here the field types that are available for inline editing
  • Don’t forget to save!

If there are still gaps in your data and your users are struggling to update their records you should engage a data specialist. We recommend reaching out to Database Consultants Australia (DCA) to discuss your data quality and enrichment needs. 

3. Maintain your data quality

Now that you have put in place the steps to update your data, you need to consider how you will continue to maintain this in the future.

We recommend setting your employees KPI’s around creating and maintaining rich and accurate data. Setting KPI’s around this will emphasise the value of the data they are putting into Salesforce.

Here is an example of the formula for data quality score on an Account:

IF(ISBLANK( Phone ),0,0.25) + IF(ISBLANK( Website ),0,0.25) + IF(ISBLANK( BillingAddress ),0,0.25)+ IF(ISBLANK( ABN__c ),0,0.25)

Using the formula field to determine the data quality score will provide the users with a visual queue as to how complete the data is on a record. It will also help you track which users are entering valuable data.

To report on this, we recommend setting up a report using the standard Salesforce reports based on the object of focus, i.e. Accounts. 

How to set up the report:

  1. Add in columns the data quality score field
  2. Edit the field and summarise by average
  3. Group by Account Owner
  4. Select the chart icon
  5. Save and run

Need help to enrich your Salesforce Data?

If you need help setting this up, or want to discuss how your business can improve and enrich your data, fill in your details below.

Share this post

You may also want to read

  • 5 Highlights from Salesforce Spring '19 Release

    5 Highlights from Salesforce Spring ’19 Release

  • How to find a Salesforce Consulting Partner?

    How to find a Salesforce Consulting Partner?

  • Salesforce Summer '19 Release Highlights: Top 5 Features

    Salesforce Summer ’19 Release Highlights: Top 5 Features

FullCRM logo white
Services
  • Sales Cloud
  • Service Cloud
  • Configure Price Quote (CPQ)
  • Field Services
  • Communities
  • Artificial Intelligence (AI)
  • Systems Integration
  • Managed Services
Industries
  • Manufacturing
  • Distribution
  • Medical Devices
  • Transport and Logistics
  • Construction
  • High Tech
  • Financial Services
  • What Our Clients Say
  • About Us
  • FullCRM Blog
  • Join Us
  • Contact Us
  • Privacy Policy

Contact Us

How can CRM transform your business?
Start a conversation and we’ll get in touch…

+61 2 8057 8250 hello@fullcrm.com

Suite 601, 17 Castlereagh Street Sydney 2000

Facebook Twitter Linkedin

Contact us

How can CRM transform your business?
Start a conversation and we’ll get in touch…