Duplicate records in Salesforce can cause chaos for your organization, but in this post we’ll specifically look at the problems that duplicate records cause in the measurement of your marketing efforts.
We’re going to start with a very simple example that is almost certainly happening within your Salesforce org hundreds if not thousands of times over.
Let’s say I’m your prospect.
You have me stored in Salesforce as a Lead with my email address as firstname.lastname@example.org. We talk about your products, but ultimately I decide not to go with them right now because I have Gregg, Michael, John and Matt asking me for help in a variety of different projects. I clearly don’t have the bandwidth to make this decision right now, so I hold off.
About a week later, I decide I’m ready to buy. But I forget who I spoke to at your company because I’m frazzled from pulling a few all nighters to get all of those projects finished. So I fill out a new contact form, but this time I use email@example.com, which is my business-casual email address.
Your standard Salesforce Web-to-Lead form and the web forms that you’ve built with Marketo, Eloqua or Pardot will not prevent a duplicate record from being created. Why? Because all of these systems use exact-match email address duplicate prevention.
Now you have my information in your system (or systems) as two or more different records.
Let’s take a look at how this exact scenario would play out.
1. Deflated Email Open Rate
Over the next few weeks, months or years, your company is probably going to send me a lot of email. Except now that you have me in your system(s) twice, you’re going to be sending each email twice.
Again, you have firstname.lastname@example.org as the email address for one of your Leads, and email@example.com for another Lead. The problem is that I’m only going to open one of those emails. Now your open rate for me, personally, will be 50%. If you can imagine the potential for this to happen hundreds and thousands of times within your own database, you can imagine why you have had such a low open rate on your expertly crafted emails.
2. Deflated Lead Conversion Metrics
At RingLead, we are most definitely numbers driven. We have a monthly review of a whole slew of key performance indicators (KPI’s) and on the marketing team, we look at the gross number of Leads that we’re getting and how they track throughout the conversion funnel. At the final level of this conversion funnel, you have the number of Leads that have converted to a sale.
Let’s pretend for a second that these are the only two Leads in your system – firstname.lastname@example.org and email@example.com. Only one of these Leads would actually make it through to a sale (well, if your sales team is doing a good job, that is) while one Lead would remain in the ether of your marketing automation or CRM system.
So now your Lead-Sale conversion rate would be 50%…although it really should be 100%.
The more duplicate Leads that you have, stagnant and decaying in your databases, the lower your Lead-Sale conversion rate becomes.
3. Mixed Messaging to Engaged Prospects and Existing Customers
Continuing with the example from above, let’s say that you’ve marked firstname.lastname@example.org as a Customer. I’ve signed a 1 year deal with your company, I’m now using it for a few weeks, and things are going great.
A few weeks later, I receive an automatically generated email to email@example.com from one of your sales reps asking if I’d like a demo of your products. Why? Because that record, firstname.lastname@example.org, is still registered as a Lead in your system!
This is may sound like a minor incident, but this makes your company look unprofessional, and can quickly turn off prospects and users to your organization.
What can you do?
If you’re now biting your nails and wondering if this is happening within your own Salesforce org, take a minute and install Dupe Dive, RingLead’s free duplicate diagnostic app that gives you some great insight into the state of your data quaity.
Your Dupe Dive results will tell you one of two things. The first possible outcome is that you have a database infected with duplicates. In this case, you’ll want to take a look at Data Cleanse, a powerful yet easy-to-use application to identify and merge existing duplicate records in Salesforce. The second possible outcome is that your database is already pretty clean. If this is the case, you’ll want to ensure that it stays clean with the help of our duplicate prevention suite, which prevents the creation of duplicate records via the three main entry points: manual entry, list import and web form submission.