Duplicate Data

Welcome to the ActivePrime Blog

In our blog, you’ll find helpful and informative posts dedicated to improving CRM performance and usability. Our topics include deep dives on the technical aspects of CRMs like searching and data quality. You’ll also find insightful posts about user productivity and adoption.

Say Goodbye to Cleaning, Complaints and Extra CRM Data Costs

Say Goodbye to Cleaning, Complaints and Extra CRM Data Costs

Low sales efficiency, poor marketing response rates, and declining revenues are the most visible effects of bad data in your CRM.

But poor data quality impacts business in more insidious ways. Lack of confidence in the accuracy of customer data causes user adoption rates to drop - along with your return on CRM investment.

Four Ways Dirty Data Is Hurting Your Marketing Results

Four Ways Dirty Data Is Hurting Your Marketing Results

Like it or not, you’re spending marketing budget on programs that bring poor or no results.

Research shows that on average, 12% of an organization’s annual income is misspent due to bad contact data.

And it’s not just the money. Dirty data, such as duplicates, results in inaccurate lead scores. Score sharing between duplicate leads means neither record gets a high enough score to move further down the sales pipeline.

Spring Cleaning

Spring Cleaning

Spring is here. As we open our windows to let the fresh air in, it’s time to start thinking about cleaning. So get under your desk and chase away the dust bunnies that are huddling around your surge protector. While you are down there, let’s also talk about your CRM system. How clean do you think your data is? The answer should be that it’s as squeaky clean as your desk. It’s easy to get complacent about your CRM system. You do a lot of maintenance, we know. You teach your staff how to enter in names properly. You catch duplicate entries and eliminate them. But you may not be aware of all the dirty data that’s sneaking into your system. That’s where we want to help.

The Impact of Duplicates in Your CRM System

The Impact of Duplicates in Your CRM System

How did those duplicates get in your Oracle CRM On Demand? Maybe it was when two CRM systems were integrated, or maybe a trade show list was imported multiple times. It could even have happened like a slow leak; a few from one rep, a few from customer or tech support and then, BOOM! before you know it, there are too many to count! The problem is that duplicates waste your time and cost you money. A lot of time and money.


Dirty Data Impacts Customer Retention

Dirty Data Impacts Customer Retention

Dirty data has an obvious impact on your customers. Say you have a VIP client, Ed Jones, whom your marketing and sales team has been nurturing for over a year. You’ve sent emails. You’ve had several face to face meetings. But somehow a duplicate record was created, and unbeknownst to you, Ed is getting two emails instead of one. To compound the error, you called Ed the other day to see if he got the proposal, but because you logged the call on the duplicate record, you made a second call later in the week. I know you are a good salesperson, but you rely on your CRM system, not your memory. Now Ed is laughing, but at you, not with you. Yikes.


How Many Duplicates Do I Have In My Oracle CRM on Demand System?

How Many Duplicates Do I Have In My Oracle CRM on Demand System?

Duplicates are more than just a pain to deal with when it comes to searching for a name. They can cost you money. They can waste your time. They can give you a false sense of security when projecting your sales.

So how do you determine how many duplicates you have? More importantly, how do you get rid of them?

How Does Poor Data in CRM On Demand Impact my Targeted Marketing Campaign?

How Does Poor Data in CRM On Demand Impact my Targeted Marketing Campaign?

The Data Quality Issue: I have a campaign budget of $20,000 for a fantastic glossy mailer. That budget needs to cover the cost of printing my new brochure and mailing it out First Class USPS. The number of Leads in my CRM On Demand is 5,800. So if I do a quick estimation of cost for the flyer of $2.25 each, and postage of $.85, plus another $.65 for the envelope, label and letter, that comes to over $21,750. Yikes! That’s $1,750 over budget!


Would Your Customers be Excited to Have Their Inboxes Filled by Duplicate Emails?

The Data Quality Issue:

Hi, I’m David Smith, a new customer of yours. I just spent close to $10,000 to acquire your top-of-the-line gizmo. And, I was welcomed to your customer family with no less than six emails; all with different salutations. Let’s see, I was Dave Smith; David Smith; Davey Smith; Dave Smythe; David Smythe; and Davide Smythe. They obviously all had the same email address, so who was the brain surgeon that entered this information 6 times? I tell ya, I feel more like a closed deal than a member of your ‘family’.

The Solution to the Issue:

The immediate solution to the issue is to throw some upgrades and give-a-ways to David Smith to make sure he doesn’t bad-mouth us! That could cost the company up to 10% of the sale.

The next step to the solution is to clean up CRM On Demand! I’ll use CleanCRM to scan for duplicate records. Maybe I’ll match on email address or some combination of city, state, last name. Thankfully, CleanCRM is so flexible that I can dink around with the settings and find what works best for our situation.

Now, I’ll need to go over protocol for new record creation with sales, and make sure they are using CleanEnter. CleanEnter could have caught all these duplicates right at the point of entry. It’s integrated right into CRM On Demand and the results are real-time.

Benefits to the Solution:

So much time could have been saved and so many headaches could have been avoided using ActivePrime solutions. We could have avoided embarrassment, never upset the customer and started off on the right foot.