CRM systems are designed to be user friendly, not imposing undue security in the interest of usability and fast adoption. CRM users are business
people who aren’t likely to put up with sound arguments about the need for data hygiene. After a few months of disappearing data and incomplete
reports, theyre more likely to listen…but not at the beginning.
CRM Tips: The Trouble With Activity Management
CRM Tips: The Fixed Price is Not Right
So for most CRM vendors, the default settings for access control, feature availability, and field-level C/R/U/D privileges are “wide open.” It doesn’t
take the Sales and Marketing types too long to figure out why they need to limit visibility of the opportunity pipeline or the lead queues, and they’ll soon
be asking to tighten up that level of data visibility. But they typically want far more privileges than is really good for system health.
As I wrote previously, a classic
symptom of this is an excessive number of people with System Administrator privileges. Just say no. Instead, use delegated administration, field sharing
controls, sales teams, or other advanced CRM features to give power users the access they need.
In this article, I’m going to dig into some more subtle access control issues, particularly around creating and deleting records.
Creating and Deleting Opportunities
The opportunity pipeline is almost the exclusive domain of the sales organization. So it stands to reason that they should be able to create
opportunities at will. (Although, I’ll argue that in a complex sales organization, the individual rep shouldn’t be doing even that — see chapter 9 of
my book for more on this).
Once an opportunity has been created, though, it really should never be deleted. The rep will want to, for emotional reasons. But that’s the wrong
thing to do: whether the opportunity is dead, has gone into no-action purgatory, or was completely unqualified (read: make-believe) in the first place,
you’ll never be able to improve your sales process if you delete these opportunities. Deleting opportunities not only masks the truth, it makes it
The right thing here to do here:
• Remove the delete button from opportunities for all users except the system administrator.
• Create new opportunity stage values for outcomes like unqualified deal, no action, budget withdrawn, politics, and bad data. (The wording here
is important, so that reps and management don’t interpret these as “sales rep failure.”)
• Add a reason-for-dead (not “reason for loss” which will scare the reps off) in association with dead or lost deals.
• As soon as an opportunity is marked with these values, make it automatically disappear from reports, views, and searches, so that reps won’t be
reminded about the negatives. This is done using CRM workflows, access control, and page layout features.
• Create management reports for the VPs of sales and marketing that help them understand the failure patterns, so the business processes in both
groups can be improved.
Creating and Deleting Accounts
The sales team typically believes that Accounts are their exclusive domain as well. But in an organization of any size, this just isn’t true. If you’re
serious, CRM is connected to the accounting system, and creating an account can trigger all kinds of processes in accounting, finance and legal. So the
reps should be allowed to create prospective accounts (that are not transferred outside of the CRM), but only sales operations, accounting, or finance
personnel should be able to create full-fledged accounts.
Deleting accounts is even more of an issue. The basic rule again is “no,” except by a system administrator or other data professional who
understands the ramifications. This can be a big issue if you have duplicate accounts in your CRM/accounting system caused by linkages to your
partners or channel. In some situations, you can’t delete duplicates — all you can do is rename them and create a parent-child relationship with
the main account in your Accounting system’s database. Make sure the people running your deduping and data cleansing tools are properly trained on
The marketing team is typically charged with Lead generation, and their campaigns may create leads by the hundreds on a daily basis. At least they
hope so. And there’s really no harm in creating lots of leads: with the right deduping tools and processing protocols, the history of customer interactions
will be properly preserved even if a lead has been deduped dozens of times.
The marketing team, for obvious reasons, has no interest in deleting leads. But the Sales team often does. They want to get the worthless ones out
of the way…and if there is a political war going on, they often like the opportunity to make marketing look bad. You want to look out for this: if you
find a lot of leads being deleted, or if you find the “lead source” being changed, this should raise red flags about room for improvement in
The hard reality is that 95% or more of leads may be no good: it does not help to hide this. You need to optimize your sales and marketing
investment to fit with the yield and conversion patterns of your target market. So, like opportunities, leads should never be deleted: only hidden. The
• Remove the Delete button from Leads for all users except the system administrator.
• Create new lead status values to reflect: no interest, wrong level, bad match, no response, lost interest, and other specifics of disqualification.
Also have a status for mailing list (these leads may come back to life) and bad data (these won’t).
• As soon as a lead is marked with any of these values, make it automatically disappear from reports, views, and searches, so that reps won’t be
reminded about the negatives. This is done using CRM workflows, page layouts, access control features.
• Create management reports for the VPs of sales and marketing to help them understand the lead failure patterns, the cost of a bad lead, the
proper qualification criteria, and the effectiveness of lead nurturing so the business processes in both Sales and Marketing can be improved.
CRM systems need to be used as the basis for optimizing business processes and improving the yield of sales and marketing efforts. If all you do
with CRM is brute-force automation, youre just executing a bad idea faster. The first step to health is removing the users’ ability to arbitrarily delete the
records that can be used to analyze and optimize your business.
David Taber is the author of the new Prentice Hall book, “Salesforce.com Secrets of Success” and is the CEO of SalesLogistix, a certified Salesforce.com consultancy focused on business process improvement through use of CRM systems.
SalesLogistix clients are in North America, Europe, Israel, and India, and David has over 25 years experience in high tech, including 10 years at the VP
level or above.
Follow everything from CIO.com on Twitter @CIOonline.