Organizations that efficiently and effectively get data into their CRM can maximize ROI on their lead gen efforts while maintaining a clean CRM. Haphazard data imports are a huge source of dirty data and will cause your team to spend time wrangling the data instead of leveraging it.
Whether you got your list from an event, webinar, or a purchase, we can all agree that leads are too valuable to waste. Like most data processes, there’s a lot to consider when importing lists into Salesforce.
1. Review and prepare the data before import.
A study by SiriusDecisions shows it’s 1/100 as costly to optimize your data import processes and fix errors on the front end; rather than waiting for chaos to manifest and attempting to correct them or allow your team to use these bad data insights.
No one wants to have to play catch up with their database hygiene. Which is why it is important to analyze the list for issues that may cause data performance problems later on.
- Mapping your fields is a natural first step in any Salesforce import job. Most lead lists don’t get too crazy with fields, so mapping shouldn’t take too long. Take a look at the column headings on your list. Do they match corresponding Salesforce fields? If there are fields in your source data that don’t exist in Salesforce, you’ll need to create custom fields to house that data.
- Check for typos and formatting errors and purge bad email addresses. Without a good email address, you won’t be able to match it against your existing data (more about that later) and leverage any pre-existing company or contact data. Many organizations opt for third-party tools to verify and validate email addresses before importing to avoid spam traps and prevent harming their sender score.
- Normalize your data before importing will help correct the aforementioned typos and formatting errors. Something as little as an improper case or a prefix can hamper data performance. Implement standard naming conventions for fields like company names, contact names, URLs, address information, phone numbers and job titles. To normalize your data before importing, you can either send your list to a bulk data processor or opt for a list import tool with built in normalization.
Being prepared isn’t just for boy scouts. Studies show it’s much more time-efficient and cost-effective to optimize your data import processes and fix errors on the front end; rather than waiting for chaos to manifest and attempting to correct or leave it in disarray. No one wants to have to play catch up with their database hygiene.
2. Check for Duplicates and Unlinked Leads at Accounts
Haphazard data imports cause chaos in the form of duplicate/redundant data and orphaned leads. What is an orphaned lead? Simply put, an orphaned lead is a lead that should be converted to a Contact at an existing Account, but isn’t. Avoiding duplicates and orphaned leads is especially important for companies using account-based sales and marketing in their strategy.
Here’s an example lead list. Let’s explore the potential red flags that are about to enter your Salesforce database
How to prevent duplicates and orphaned leads on list imports
You have a few options to check for duplicates on list imports, and even fewer options to link leads to accounts on import jobs. Your database admin (or intern) can check for duplicates and associated accounts by hand, but this is impractical & non-scalable for large lists. Export your existing Salesforce records and checking your list against these records in excel is also possible. However, as record counts can reach the hundreds of thousands, if you’d like to check the list against your whole org this is not a scalable process.
3. Choose the right import tool for the job (hint: it’s not Data Loader)
The data loader, as all SFDC Admins should know, is one of the foundations of any Org. This tool is great for speed and mass imports, but its tools to process data are very basic and it doesn’t come with advanced tools for integrating the new data with your existing data.
Salesforce Data Import Wizard Limitations
The data import wizard is limited in its ability to detect and merge duplicates. It can match duplicates on name, email, and Salesforce ID. As most lead lists do not have Salesforce ID, this matching criteria is not robust enough for most organizations to effectively prevent duplicates. And when using the data import wizard, there is no way to link Lead to Accounts.
The Import Wizard uses exact email match. With typos, non standard naming conventions, and formatting errors, exact matching crtieria is often not robust enough to effectively process this data to prevent duplicates and orphaned leads.
Using a third party tool to prevent duplicates and link leads to accounts.
You need to check for duplicates and linked accounts against more robust criteria than exact email match. Many organizations opt for an external data processing system to automate lead-to-account linking and merge duplicates.
RingLead provides an intelligent solution to import lists without creating duplicates or orphaned leads, all while normalizing, enriching, and routing in real time.
Our powerful duplicate matching technology automatically checks the list against your database to detect fuzzy match duplicates and merge with customizable match criteria. RingLead also normalizes the data at the point of entry to improve match rates. Lastly, if RingLead identifies an Account match, it can automatically convert or link the new lead to the existing Account.
Check out how the COO of Momentum Events uses the RingLead list import tool