I just attended the Destination CRM conference in NYC. It was great - not just good, great. One thing about CRM professionals, most are very nice people, and generously share what they know. I think this is partly due to their "customer service" mindset and partly due to the "reputation points" mindset that Social CRM encourages. Whatever the cause, I found people happy to share their time and expertise, and it was fun. We all learned a lot.
I noticed three broad themes in this year's conference topics: Social CRM, integration of CRM data into the rest of the company's data stream, and metrics. (Of course, there were other interesting things happening that I missed - after the keynote speeches, there were three tracks going on at once and I had to pick and choose which sessions to attend.)
-----
Social CRM (loosely defined as Facebook, Twitter, external "enthusiast" forums, and company forums): Once cutting-edge, this facet of CRM has become relatively mainstream. Many "B to C" (Business to Consumer, also "B2C") companies already have extensive Social CRM operations, and others have similar projects in development. For those of you who aren't doing anything like this yet, the overhead of monitoring Twitter and Facebook plus running a simple discussion board is quite low, and the people who mention your company or log into your forum are likely to be more loyal as customers - if you treat them well.
The "B to B" (Business to Business, also "B2B") companies were asking "What about me? What can I do in the Social CRM arena?" I suggested they try to find out where their business customers talk to each other, then go further and find out where and how their business customers' consumers (end-users) discuss things publically, and monitor those. For instance, if you sell a component of Brand X to the manufacturer, you can monitor public social sites for mention of Brand X. Yes, you'll have more brands to monitor, but you don't have to do it in any great depth - just be aware of gossip and firestorms and such. Understanding your customer's business situation can only help with your own B to B sales.
People were also asking about Social CRM metrics. One attendee (I didn't get his name, sorry) said his company did some detailed studies and found that customers who are Facebook "Fans" and forum members are more loyal, more willing to recommend, and purchase more products. So his company was seeing a positive return from their Social CRM efforts from existing customers, before any online marketing efforts to bring in new ones.
-----
Integration: 20 years ago, integration of CRM data into the rest of the company's computer applications typically took 30 to 80% of an implementation budget. This hasn't changed. As the integration tools have gotten better, the apps have gotten more complex and the integration targets more numerous. The lesson I got was "NIM" - No Immediate Miracles. This is what has always made any implementation hard, and it's still hard. At the Keynote Panel discussion, I asked leaders from Oracle CRM, SAP, Microsoft CRM, and RightNow to work on this - they said they'd get back to me :-)
-----
Metrics: I've mentioned it in an earlier post, but the importance of Return on Investment (ROI) and other metrics in general was reinforced. Several separate speakers with successful rollouts said that they started by knowing what results they wanted, then built systems (or campaigns, or channels) to try to get those results. The less successful rollouts built systems and then tried to see what metrics were available.
-----
All in all it was a great show. Many thanks to the organizers, especially Paul Greenberg who was co-chair; in addition to helping many people (including me) with his sage advice, he did many of the tiny thankless tasks that made the event run smoothly.
Wednesday, August 4
Friday, April 23
Everyone wants something different from a CRM system – except your customer.
There are different groups that pull your CRM system in different directions. If you let any of them pull your system out of shape, it won't be much of a CRM system, and it won't really manage customer relationships. It's typically a balancing act between Sales, Marketing, and the Contact Center.
Sales staff are a special breed – relentlessly positive, pushy (in a nice way), and more often than not, far from tech-savvy. They rely on IT pros who will help them use “tech” (including web, mobile devices, computers, etc) to meet their needs. They care about buyers, influencers, decision makers, and want to categorize and rank people accordingly. They want the simplest possible CRM system, preferably one on a handheld device like a Blackberry or iPhone.
Marketing staff are typically also relentlessly positive, and want things right away! A new marketing idea might have much greater value if implemented immediately. Sometimes they have customer contact (often at larger events, not one-to-one). They want to help sell products, and to figure out what marketing messages work, and which do not. Thus Marketing often wants to ask lots of (time-consuming) questions of the customers when they get a chance.
Sales & Marketing management have a different set of challenges – they need data for forecasting and reporting. This data needs to come from the Sales staff, or external data. They want lots of data, but sales staff doesn't want to enter it.
Contact centers are different still – they talk to customers (including end-users) and hear inquiries and complaints. (Some contact centers also take orders directly, or this function may be outsourced. ) The staff wants to efficiently answer the questions, resolve the complaints. But then Marketing often wants them to ask extra questions. And Sales wants the call center to figure out the role of the person calling – is the caller a valid sales lead? The contact center often has other drivers, such as product improvement/surveillance, regulatory, etc.
What do all these groups have in common? Customers. The same customers, usually. A single person frequently sees a marketing message, talks to a sales person, and calls / emails the company. The Marketing, Sales and Contact Center staff typically report to 3 different Directors(!) So getting everyone on the same page is important, and not that easy to do - you need an overall plan to ensure this happens.
This brings up two related points – one on Master Data, one on the “360 Degree View” of the customer.
First, all Account and Contact data need to be centralized and de-duplicated; master customer data needs a single home. Also, processes need to be developed to keep this data authoritative and correct (no one will use the data if it is not substantially correct and constantly improving). An incoming email with a new phone number should propagate to the sales database, a business card collected at a conference should add a Contact record to the appropriate Account. (And try to get lower-cost staff to do the data entry for those, sales staff is expensive.)
Everyone says they want to know all about the customers, and get a “360 Degree View” of their wants and activities, but it’s usually neither practical nor efficient to try to get all the data at once. (If a salesman spent all his time gathering background data on the people he talks to, he’d never sell anything.) So it’s usually best to build this up little by little, and in different detail for different roles. For people who are most influential to sales, more data is worthwhile (including Sales Force Effectiveness type questions about role, personality, “energy type”, drivers, etc.). For auxiliary people at an account, it makes sense to capture less data. As long as there are places to put this info when it arrives, ways can be worked out to get the info into the correct record.
But it all comes back to the customer. It’s called Customer Relationship Management for a reason. To the customer, you are one entity. They don’t care if they are talking to Sales, Marketing, or the Contact Center – they want a good, comprehensive answer, and don’t want to have to repeat themselves over and over. It’s up to you to figure out how… but if you can do this successfully you will be more efficient internally and have better customer service too. I think they call that a “win-win”.
Sales staff are a special breed – relentlessly positive, pushy (in a nice way), and more often than not, far from tech-savvy. They rely on IT pros who will help them use “tech” (including web, mobile devices, computers, etc) to meet their needs. They care about buyers, influencers, decision makers, and want to categorize and rank people accordingly. They want the simplest possible CRM system, preferably one on a handheld device like a Blackberry or iPhone.
Marketing staff are typically also relentlessly positive, and want things right away! A new marketing idea might have much greater value if implemented immediately. Sometimes they have customer contact (often at larger events, not one-to-one). They want to help sell products, and to figure out what marketing messages work, and which do not. Thus Marketing often wants to ask lots of (time-consuming) questions of the customers when they get a chance.
Sales & Marketing management have a different set of challenges – they need data for forecasting and reporting. This data needs to come from the Sales staff, or external data. They want lots of data, but sales staff doesn't want to enter it.
Contact centers are different still – they talk to customers (including end-users) and hear inquiries and complaints. (Some contact centers also take orders directly, or this function may be outsourced. ) The staff wants to efficiently answer the questions, resolve the complaints. But then Marketing often wants them to ask extra questions. And Sales wants the call center to figure out the role of the person calling – is the caller a valid sales lead? The contact center often has other drivers, such as product improvement/surveillance, regulatory, etc.
What do all these groups have in common? Customers. The same customers, usually. A single person frequently sees a marketing message, talks to a sales person, and calls / emails the company. The Marketing, Sales and Contact Center staff typically report to 3 different Directors(!) So getting everyone on the same page is important, and not that easy to do - you need an overall plan to ensure this happens.
This brings up two related points – one on Master Data, one on the “360 Degree View” of the customer.
First, all Account and Contact data need to be centralized and de-duplicated; master customer data needs a single home. Also, processes need to be developed to keep this data authoritative and correct (no one will use the data if it is not substantially correct and constantly improving). An incoming email with a new phone number should propagate to the sales database, a business card collected at a conference should add a Contact record to the appropriate Account. (And try to get lower-cost staff to do the data entry for those, sales staff is expensive.)
Everyone says they want to know all about the customers, and get a “360 Degree View” of their wants and activities, but it’s usually neither practical nor efficient to try to get all the data at once. (If a salesman spent all his time gathering background data on the people he talks to, he’d never sell anything.) So it’s usually best to build this up little by little, and in different detail for different roles. For people who are most influential to sales, more data is worthwhile (including Sales Force Effectiveness type questions about role, personality, “energy type”, drivers, etc.). For auxiliary people at an account, it makes sense to capture less data. As long as there are places to put this info when it arrives, ways can be worked out to get the info into the correct record.
But it all comes back to the customer. It’s called Customer Relationship Management for a reason. To the customer, you are one entity. They don’t care if they are talking to Sales, Marketing, or the Contact Center – they want a good, comprehensive answer, and don’t want to have to repeat themselves over and over. It’s up to you to figure out how… but if you can do this successfully you will be more efficient internally and have better customer service too. I think they call that a “win-win”.
Monday, February 15
GIGO
Garbage In, Garbage Out. (Definition at ZDNet)
Ask any tech guy and they'll tell you that GIGO is one of the most common problems when business line people ask for useful information. You must develop processes and responsibilities to fix bad data. It's too common for users to say "the data is no good, we can't rely on it, so we won't use the system as intended" rather than to work on fixing it. Smart companies are hiring dedicated Data Stewards for their systems - key business decisions are made using this data, and it needs to be as close to perfect as you can get.
The reasons for GIGO issues can usually be broken down into three issues - data entry, data migration from other systems, and system changes over time.
The first is easy enough to grasp; errors are going to happen, your challenge is to minimize it and make it easy to fix. Things like postal code / address validation can help; most countries have postal-code / city mapping data available that lets you enter just the postal code and have the city + state/province populated. Also, turn on spell check for more fields - "Jhonson" is a possible but unlikely last name. And try to make it easy for anyone to fix the data without jumping through hoops, entering a "why did you change this" field, etc.
Data migration is data that comes in from another system, so human eyes don't see it at entry time. It can be a one-time feed at system implementation, or scheduled every day. If the problem is data entry error, fix it in the source system, but it's often more complicated than that. The key is to try to find patterns in the errors and re-do the migration process as needed. There may be a subtle business rule that allows an extra line of address for certain companies, moving every field after that to the wrong column (a real example). Whenever you start doing scheduled data migration, everyone "upstream" on the migration has to know what parts of their data are used "downstream" so changes can properly cascade throughout the business.
System changes are the most interesting challenge. If you migrate from one system to another, the Customer data is likely the same but some core fields like Reason for Contact and Product may have different values. Of course you will want to prepare a mapping document and, after much review by all, get everyone to sign off on it. I'd also suggest keeping a non-migrated version of the data (for the whole record) in a text field (visible or not), so you can see what the record was like in the old system. This can help save you later when someone figures out that the "approved" data mapping was not quite right. If you have the old values stored with each record, they are much easier to find and correct. (Listen to the voice of experience here! Nothing worse than trying to figure out which records are wrong by looking at a system that no one remembers, if it's even installed.)
If you keep the same system for a number of years, dropdown values will change, and what used to be valid data a few years ago won't match the current user interface. The reporting solution may need to have additional (deprecated) values in the dropdown for historical reporting. Also, Management often asks for three years of data when you have been collecting a particular field only one year - your challenge is then to figure out how (or if) that data was collected before and figure out how to report it. It's much better to report absence of data, or explain the report has a large margin of error, than to get it wrong.
Ask any tech guy and they'll tell you that GIGO is one of the most common problems when business line people ask for useful information. You must develop processes and responsibilities to fix bad data. It's too common for users to say "the data is no good, we can't rely on it, so we won't use the system as intended" rather than to work on fixing it. Smart companies are hiring dedicated Data Stewards for their systems - key business decisions are made using this data, and it needs to be as close to perfect as you can get.
The reasons for GIGO issues can usually be broken down into three issues - data entry, data migration from other systems, and system changes over time.
The first is easy enough to grasp; errors are going to happen, your challenge is to minimize it and make it easy to fix. Things like postal code / address validation can help; most countries have postal-code / city mapping data available that lets you enter just the postal code and have the city + state/province populated. Also, turn on spell check for more fields - "Jhonson" is a possible but unlikely last name. And try to make it easy for anyone to fix the data without jumping through hoops, entering a "why did you change this" field, etc.
Data migration is data that comes in from another system, so human eyes don't see it at entry time. It can be a one-time feed at system implementation, or scheduled every day. If the problem is data entry error, fix it in the source system, but it's often more complicated than that. The key is to try to find patterns in the errors and re-do the migration process as needed. There may be a subtle business rule that allows an extra line of address for certain companies, moving every field after that to the wrong column (a real example). Whenever you start doing scheduled data migration, everyone "upstream" on the migration has to know what parts of their data are used "downstream" so changes can properly cascade throughout the business.
System changes are the most interesting challenge. If you migrate from one system to another, the Customer data is likely the same but some core fields like Reason for Contact and Product may have different values. Of course you will want to prepare a mapping document and, after much review by all, get everyone to sign off on it. I'd also suggest keeping a non-migrated version of the data (for the whole record) in a text field (visible or not), so you can see what the record was like in the old system. This can help save you later when someone figures out that the "approved" data mapping was not quite right. If you have the old values stored with each record, they are much easier to find and correct. (Listen to the voice of experience here! Nothing worse than trying to figure out which records are wrong by looking at a system that no one remembers, if it's even installed.)
If you keep the same system for a number of years, dropdown values will change, and what used to be valid data a few years ago won't match the current user interface. The reporting solution may need to have additional (deprecated) values in the dropdown for historical reporting. Also, Management often asks for three years of data when you have been collecting a particular field only one year - your challenge is then to figure out how (or if) that data was collected before and figure out how to report it. It's much better to report absence of data, or explain the report has a large margin of error, than to get it wrong.
Wednesday, December 9
Is it a Successful Implementation? It Depends . . .
What is "success" when implementing a CRM system? It depends on who you are. Depending on your role in or outside of the company, you may have different ideas as to whether the CRM system is a success. Each group is asking different questions to evaluate success. Some examples are:
So implementing a CRM system is a juggling act (you knew that) and identifying the success drivers for each group, before you get very far, is one key to a successful system implementation.
- Executives – how does it fit in the business strategy, what is ROI? Are there any secondary or concealed reasons for implementing this particular CRM system at this time? Publicity, internal politics, etc.?
- Marketing – how does it help with marketing messages? Or does it confuse people by giving different marketing messages from web, email, printed marketing?
- Frontline Managers – Can I administer it / get reports / train users (and how easily?) Can I monitor my call center and sales force activity / application use?
- Internal Users (Call Center and Sales Force) – how easy is it to use? Is it fast, laid out logically, and does it have a minimum of required fields? Do passwords sync through the whole enterprise or do you need to remember yet another password? How easy to make/fix data entry mistakes?
- Field Sales Force – is remote access easy? Will I gain anything from entering my data? This is a huge subject all by itself, you need incentives or people will ignore the system.
- IT – how does the system work? Are we confident that our data will be stored correctly and secured? Does the system meet security requirements and fit in with the overall IT philosophy at the company? (Depending on whether the system is on-site or hosted, the answers may be quite different.)
- Customer Users (if web or telephone self service) – user interface design is a whole field of study by itself. Don't be fancy unless you have good reason, use graphics and Flash elements carefully; not everyone has fast broadband. There are some "best practices", conventions that people are accustomed to – use them! (Note that these conventions may be different in different countries; if you are doing business across international borders you will probably need multiple sites.)
- Customers (entered by the Call Center or Sales Force) – is data likely to be entered correctly, de-duplicated successfully, and are marketing preferences honored?
So implementing a CRM system is a juggling act (you knew that) and identifying the success drivers for each group, before you get very far, is one key to a successful system implementation.
Tuesday, November 3
Social CRM: An Introduction (sort of).
This is an edited & redacted version of email an sent to the divisional president of a huge multinational company. I spent quite a bit of time there implementing various projects, and discovered they were just about ten years behind the times in all things online. Everything except their call center involves one-way communication. That won't work these days, customers want and expect more.
The scary thing is that they are far from the most backward in their industry, and sales-wise are actually doing reasonably well (for now). I quite like them personally and as a company but they must change their marketing strategies or get swept away by competitors with inferior products and better sales and marketing - especially social CRM and online marketing.
(See the bottom for their response)
-----------------
Hi (Div. President Name) - I told you that I’d send you email about what the company could do better regarding all online communication. I've got a bunch of things to say and I tried to just hit the high points, but there are so many problems with your online strategies that I think I failed at brevity.
Online two-way conversation with the customer is the wave of the future, and is quite different than what you have been doing. [Company] has not participated in these conversations, to its detriment, and it's now hitting the bottom line.
[Company] has a reputation of having great products but being stodgy and old-fashioned. You do no direct e-marketing (I think the first email campaign went out a few months ago, or maybe it was delayed again and never made it.) Over the years the trade show staff has collected many user’s business cards with contact info and done nothing with them, sometimes not even passed them on to the territory reps. You do nothing direct (online) but do a good job of sending paper-based marketing materials, to certain groups at least, but you don't know what percentage go straight into the trash.
Many times these days people want to chose their own way of getting information; this is what makes web sites powerful. But that’s only half the equation; the most popular and “sticky” sites that people return to and recommend are always those that build a community, where people know they can talk to like-minded people and get their questions answered. As a member of one site I visited (for independent advice on use of a product) said, “we are all a bunch of ignorant nobodies, but between us, we know damn near everything!” [Company] has never even tried to work in this area, neither in (product area 1) nor (product area 2). It is the wave of the future, and you are standing on the dock watching the ship sail on the tide.
***
What is the most important asset of the company?
Manufacturing plants? Product development information? Employees? Customers?
No to all the above. It is the relationship with your customers.
What do the customers want out of this relationship? They want good products, and to communicate with the company.
So how do they want the company to communicate to them? Interactively, quickly, openly, humbly.
The sales force does some of this, but only on their schedule, and talking about what they want to. This is talking to the customer, but not really talking with the customer. It does not meet the customer’s needs or modern expectations.
The Call Center talks with the customer, but the customer needs to call during business hours and wait to talk to someone. It is necessary, but not sufficient (and very 1980s). Completely missing is the online two-way communication component. It’s costing you market share and mind share. See what your competitors are doing - search for "(brand name) blog" or "(product area) forum" or the like and see what you get. You won't like what you see; often competitors are kicking your butts with inferior products and better customer service.
It’s easy to ignore online communities. If you participate fully in any forum (especially one you don’t host or control), people will whine about trivia, lie, insult you, post spam, and all the other bad things that happen online. You need to be resolute and to accept (and act on) legitimate complaints, and gently correct errors about us or your products, and of course soft sell those products.
At a minimum, you need a position that works with the call center, spending 90% of their time online, preaching the [Company] product gospel (and posting carefully, with the call center’s advice on complaints and products).
Like your direct-to-consumer marketing it will be hard to measure success, and take a while to show results, so the typical reaction would be to eliminate the job after six months. This would be the worst possible thing to do, the position needs to be filled with someone the customers can rely on for the long run; it takes time to develop a brand, and in the online arena, [Company] is a new, unproven brand.
***
The days of select customers being “key opinion leaders” are history; anyone with an ax to grind and a blog can write a damaging article, and Google will pick it up. You wouldn’t know if this happened, and could not respond before any potential damage was done.
There is another related issue; at some point [Company] will become “news”, either by a false rumor or via something the company does, and hit top web sites and become daily conversation of thousands of people. At that point, damage control and replies at internet speed are needed. Most major consumer product brands have people dedicated to watching Twitter, Facebook, and news sites for product mention, and responding appropriately. [Company] would be wondering what hit them.
It all boils down to telling all your customer service people this: “Listen to the customer when they talk to us, listen to the customer as they talk about us, respond appropriately”, especially in all sorts of online forums (those we do and don’t control). Right now [Company’s] main action in this area seem to be sticking your heads into the sand.
Please let me know if this helps - I want [Company] to prosper. As I told you, I first came there as a consultant in the 1980s, and have been there many times over the years in various roles. The company has good products and can do better.
------------
The response I got I'm not at liberty to share with you, but the gist of it was some heartfelt thanks, that my ideas were discussed in the Executive Council meeting the next week, and that changes are forthcoming, soon. There is hope in the world :-)
The scary thing is that they are far from the most backward in their industry, and sales-wise are actually doing reasonably well (for now). I quite like them personally and as a company but they must change their marketing strategies or get swept away by competitors with inferior products and better sales and marketing - especially social CRM and online marketing.
(See the bottom for their response)
-----------------
Hi (Div. President Name) - I told you that I’d send you email about what the company could do better regarding all online communication. I've got a bunch of things to say and I tried to just hit the high points, but there are so many problems with your online strategies that I think I failed at brevity.
Online two-way conversation with the customer is the wave of the future, and is quite different than what you have been doing. [Company] has not participated in these conversations, to its detriment, and it's now hitting the bottom line.
[Company] has a reputation of having great products but being stodgy and old-fashioned. You do no direct e-marketing (I think the first email campaign went out a few months ago, or maybe it was delayed again and never made it.) Over the years the trade show staff has collected many user’s business cards with contact info and done nothing with them, sometimes not even passed them on to the territory reps. You do nothing direct (online) but do a good job of sending paper-based marketing materials, to certain groups at least, but you don't know what percentage go straight into the trash.
Many times these days people want to chose their own way of getting information; this is what makes web sites powerful. But that’s only half the equation; the most popular and “sticky” sites that people return to and recommend are always those that build a community, where people know they can talk to like-minded people and get their questions answered. As a member of one site I visited (for independent advice on use of a product) said, “we are all a bunch of ignorant nobodies, but between us, we know damn near everything!” [Company] has never even tried to work in this area, neither in (product area 1) nor (product area 2). It is the wave of the future, and you are standing on the dock watching the ship sail on the tide.
***
What is the most important asset of the company?
Manufacturing plants? Product development information? Employees? Customers?
No to all the above. It is the relationship with your customers.
What do the customers want out of this relationship? They want good products, and to communicate with the company.
So how do they want the company to communicate to them? Interactively, quickly, openly, humbly.
The sales force does some of this, but only on their schedule, and talking about what they want to. This is talking to the customer, but not really talking with the customer. It does not meet the customer’s needs or modern expectations.
The Call Center talks with the customer, but the customer needs to call during business hours and wait to talk to someone. It is necessary, but not sufficient (and very 1980s). Completely missing is the online two-way communication component. It’s costing you market share and mind share. See what your competitors are doing - search for "(brand name) blog" or "(product area) forum" or the like and see what you get. You won't like what you see; often competitors are kicking your butts with inferior products and better customer service.
It’s easy to ignore online communities. If you participate fully in any forum (especially one you don’t host or control), people will whine about trivia, lie, insult you, post spam, and all the other bad things that happen online. You need to be resolute and to accept (and act on) legitimate complaints, and gently correct errors about us or your products, and of course soft sell those products.
At a minimum, you need a position that works with the call center, spending 90% of their time online, preaching the [Company] product gospel (and posting carefully, with the call center’s advice on complaints and products).
Like your direct-to-consumer marketing it will be hard to measure success, and take a while to show results, so the typical reaction would be to eliminate the job after six months. This would be the worst possible thing to do, the position needs to be filled with someone the customers can rely on for the long run; it takes time to develop a brand, and in the online arena, [Company] is a new, unproven brand.
***
The days of select customers being “key opinion leaders” are history; anyone with an ax to grind and a blog can write a damaging article, and Google will pick it up. You wouldn’t know if this happened, and could not respond before any potential damage was done.
There is another related issue; at some point [Company] will become “news”, either by a false rumor or via something the company does, and hit top web sites and become daily conversation of thousands of people. At that point, damage control and replies at internet speed are needed. Most major consumer product brands have people dedicated to watching Twitter, Facebook, and news sites for product mention, and responding appropriately. [Company] would be wondering what hit them.
It all boils down to telling all your customer service people this: “Listen to the customer when they talk to us, listen to the customer as they talk about us, respond appropriately”, especially in all sorts of online forums (those we do and don’t control). Right now [Company’s] main action in this area seem to be sticking your heads into the sand.
Please let me know if this helps - I want [Company] to prosper. As I told you, I first came there as a consultant in the 1980s, and have been there many times over the years in various roles. The company has good products and can do better.
------------
The response I got I'm not at liberty to share with you, but the gist of it was some heartfelt thanks, that my ideas were discussed in the Executive Council meeting the next week, and that changes are forthcoming, soon. There is hope in the world :-)
Friday, October 23
Rightsizing your CRM System
CRM systems can cost a lot, in server costs, employee’s time, implementers time, and license fees. Before you budget millions for your CRM system, make sure it is sized for your business. You will probably want something more complex than a simple contact management system, but there is no need for a small-to-midsize business to spend millions of dollars on SAP, Siebel or Oracle CRM when they would only use a fraction of the overall features. (There are many sophisticated oraganizations that can use these features, don’t take this as a blanket condemnation of “Big CRM”. Just check the ROI, the return on investment - and look at the entire investment.)
I would encourage every company looking at CRM to first go to SugarCRM (http://www.sugarcrm.com) and download the free version of their (mostly) open-source product. Install it on a simple desktop PC (maybe running Linux) and start to play with it - in the Administration screens it’s easy to change the screens, add fields, etc. There are also online demos available but they expire very quickly and it’s easy to have your (test) customizations lost.
SugarCRM is a remarkably complete product, and fairly easy to modify. Many companies can use it with few changes; they also have a on-demand hosted service if you don’t want to run your own ‘live’ servers. Since it’s open source, you don’t have the same worries as you might otherwise - if you don’t like their prices, host the server yourself and change the code as you want.
I called the company "mostly open source" - they also have Professional and Enterprise versions with annual licensing fees that give you many more modules and access to better support. Prices for these versions seem to be competitive with other vendor's offerings (those from companies that end in ".com") With open-source (free) software you get less than Enterprise-level support, but then you don’t pay for support you don’t need.
SugarCRM gets a significant portion of their customers at other CRM software company’s license renewal time - the other CRM company tries to add major annual costs for customizations the client already paid for once, and people get annoyed and start to look for alternatives.
The moral is: make sure you aren’t paying hundreds of thousands of dollars, Euros, etc. for nothing more than you can get for free.
I would encourage every company looking at CRM to first go to SugarCRM (http://www.sugarcrm.com) and download the free version of their (mostly) open-source product. Install it on a simple desktop PC (maybe running Linux) and start to play with it - in the Administration screens it’s easy to change the screens, add fields, etc. There are also online demos available but they expire very quickly and it’s easy to have your (test) customizations lost.
SugarCRM is a remarkably complete product, and fairly easy to modify. Many companies can use it with few changes; they also have a on-demand hosted service if you don’t want to run your own ‘live’ servers. Since it’s open source, you don’t have the same worries as you might otherwise - if you don’t like their prices, host the server yourself and change the code as you want.
I called the company "mostly open source" - they also have Professional and Enterprise versions with annual licensing fees that give you many more modules and access to better support. Prices for these versions seem to be competitive with other vendor's offerings (those from companies that end in ".com") With open-source (free) software you get less than Enterprise-level support, but then you don’t pay for support you don’t need.
SugarCRM gets a significant portion of their customers at other CRM software company’s license renewal time - the other CRM company tries to add major annual costs for customizations the client already paid for once, and people get annoyed and start to look for alternatives.
The moral is: make sure you aren’t paying hundreds of thousands of dollars, Euros, etc. for nothing more than you can get for free.
Sunday, October 4
CRM's gone social - are you talking with your customers?
Customers are talking to each other much more than before. People are linking themselves into tribes of like-minded individuals. This has been happening for about ten to fifteen years, and accelerated (or reached critical mass) the past four or five years.
Let’s start with a story from January, 2008. The Black Mustang Club is a group of people with black Ford Mustang cars - they are passionate about their cars, and wanted to put out a calendar, showing some of these cars. They went to the cafepress.com online store to get them printed.
Somehow, Ford’s lawyers got involved with cafepress.com, and cafepress.com declined to print the calendars. The club members came to believe that Ford was claiming intellectual property rights to privately taken photos of their privately owned cars.
(http://www.bmcforums.com/showthread.php?t=42402&page=3)
This caused what might be called an “Internet Firestorm” as thousands of other sites linked to the original posting. Many of these were free speech sites, consumer-rights sites, etc. Ford began to look stupid and perhaps evil.
Six days after the first post appeared, Whitney Drake from Ford Communications clarified things: “[This] is essentially a misunderstanding... Ford has no problem with Mustang or other car owners taking pictures of their vehicles for use in club materials like calendars…The Black Mustang Club, and any other Ford enthusiast club, are free to take pictures of their own vehicles for use in calendars or other materials as long as they don't use Ford trademarks in products that will be sold.” (http://www.bmcforums.com/showpost.php?p=1339241&postcount=1)
So the problem went away, mostly. But there are several good lessons to learn here from a CRM perspective.
Let’s start with a story from January, 2008. The Black Mustang Club is a group of people with black Ford Mustang cars - they are passionate about their cars, and wanted to put out a calendar, showing some of these cars. They went to the cafepress.com online store to get them printed.
Somehow, Ford’s lawyers got involved with cafepress.com, and cafepress.com declined to print the calendars. The club members came to believe that Ford was claiming intellectual property rights to privately taken photos of their privately owned cars.
(http://www.bmcforums.com/showthread.php?t=42402&page=3)
This caused what might be called an “Internet Firestorm” as thousands of other sites linked to the original posting. Many of these were free speech sites, consumer-rights sites, etc. Ford began to look stupid and perhaps evil.
Six days after the first post appeared, Whitney Drake from Ford Communications clarified things: “[This] is essentially a misunderstanding... Ford has no problem with Mustang or other car owners taking pictures of their vehicles for use in club materials like calendars…The Black Mustang Club, and any other Ford enthusiast club, are free to take pictures of their own vehicles for use in calendars or other materials as long as they don't use Ford trademarks in products that will be sold.” (http://www.bmcforums.com/showpost.php?p=1339241&postcount=1)
So the problem went away, mostly. But there are several good lessons to learn here from a CRM perspective.
- Misunderstandings don’t save you from bad press. The fact that it took six days for Whitney to respond gave time for the problem to fester. (And this was before Twitter made things like this spread even faster.)
- Anyone can be an influencer - this started as a posting on a fairly obscure enthusiast car forum, but what damage did it do to Ford’s reputation?
- “The evil that men do lives after them; the good is oft interred with their bones.” (from Shakespeare’s "Julius Cesar") This BMC calendar information is widely available years after the fact, and doing a Google search for Black Mustang Club Calendar produces over 80,000 results, mostly as a result of this dust-up.
- Wow, there is such a thing as a Black Mustang Club. Is there an enthusiast group for our products that maybe we can encourage?
Friday, August 21
WNTD: Watch your ID values
What Not To Do: Random horror stories from the trenches.
Watch your ID values (this one is more technical, bear with me). Let’s say you have an old system that uses 8-digit ID numeric values for every table - people, accounts, cases, etc. A Case ID might match a Account ID, but that’s okay, they are always kept separate in the old system.
Then you migrate your data to a new system, which uses longer GUIDs (Globally Unique IDs) - the new system you can guarantee that no two records (no matter what table they are in) have the same ID. But the old data was just migrated in as-is, into similar tables. At the database level, there are no duplicate records in a table, so no problems, right? What are the chances that it matters that there are duplicate IDs in different tables?
Well, roughly 100%. Don’t ask me how I know, I’m sworn to secrecy, but associating the wrong customer with the wrong account can be a problem, especially when the customer is real and the account is a test account with a dumb name. When a mailing goes out to the correct customer address, with the less-than-helpful addition of the dumb account name, it's what we in the CRM business call a "problem". (Well, the actual name is an "ohshit".)
Watch your ID values (this one is more technical, bear with me). Let’s say you have an old system that uses 8-digit ID numeric values for every table - people, accounts, cases, etc. A Case ID might match a Account ID, but that’s okay, they are always kept separate in the old system.
Then you migrate your data to a new system, which uses longer GUIDs (Globally Unique IDs) - the new system you can guarantee that no two records (no matter what table they are in) have the same ID. But the old data was just migrated in as-is, into similar tables. At the database level, there are no duplicate records in a table, so no problems, right? What are the chances that it matters that there are duplicate IDs in different tables?
Well, roughly 100%. Don’t ask me how I know, I’m sworn to secrecy, but associating the wrong customer with the wrong account can be a problem, especially when the customer is real and the account is a test account with a dumb name. When a mailing goes out to the correct customer address, with the less-than-helpful addition of the dumb account name, it's what we in the CRM business call a "problem". (Well, the actual name is an "ohshit".)
Monday, July 13
Getting the Sales Force to use the CRM System: Compliance
It’s one thing to get decision-makers in a company to buy and install a SFA (Sales Force Automation) system. A good article about the many benefits of installing SFA is here:
http://www.insidecrm.com/features/selling-sfa-092707/
But then you need to get the sales force to actually use the system the way it was designed. If you have a new sales force automation system, or a major change to an existing one, getting the sales force to enter the data you want, in a timely manner, is always difficult. Sales reps say things like:
The best approaches I’ve seen have a “carrot and stick” approach, where there are some positive incentives for using the system are added. A simple “carrot” might be a semi-random prize (a small prize but with great recognition) for particularly well-entered customer data (for entering quality, not quantity).
The best single method I’ve ever seen (and it probably wouldn’t work everywhere) involved a carefully selected pilot group, and a longer-than-normal time the system was in pilot (over three months). A few pilot users found that being able to enter customer interactions the same day they occurred helped later sales calls, and that ranking the people they talked to by influence and decision-making power helped their sales closing - and that the mere fact of entering this data made them think more critically about where to spend their efforts.
These users were persuaded to talk to the rest of the sales force at the national sales meeting - the combination of “stick” (management says: do it!) and “carrot” (my fellow rep made more money this way!) led to about 80% compliance the first two months. (Typical compliance is under 50% to start.)
Compliance for the rest of the reps was a matter of management attention backed up by custom reporting. I designed a report that only showed date and time of day of data entry; it was an eye-opener as it showed who was entering a bunch of data late Sunday night, instead of all week as they were supposed to.
http://www.insidecrm.com/features/selling-sfa-092707/
But then you need to get the sales force to actually use the system the way it was designed. If you have a new sales force automation system, or a major change to an existing one, getting the sales force to enter the data you want, in a timely manner, is always difficult. Sales reps say things like:
- “Why do you want me to enter all this information into your dumb system? It takes forever.”
- “I’m good at my job, I beat quota every year. I don’t need this system, go away.”
- “You only want me to enter all this info about my clients so you can replace me!”
The best approaches I’ve seen have a “carrot and stick” approach, where there are some positive incentives for using the system are added. A simple “carrot” might be a semi-random prize (a small prize but with great recognition) for particularly well-entered customer data (for entering quality, not quantity).
The best single method I’ve ever seen (and it probably wouldn’t work everywhere) involved a carefully selected pilot group, and a longer-than-normal time the system was in pilot (over three months). A few pilot users found that being able to enter customer interactions the same day they occurred helped later sales calls, and that ranking the people they talked to by influence and decision-making power helped their sales closing - and that the mere fact of entering this data made them think more critically about where to spend their efforts.
These users were persuaded to talk to the rest of the sales force at the national sales meeting - the combination of “stick” (management says: do it!) and “carrot” (my fellow rep made more money this way!) led to about 80% compliance the first two months. (Typical compliance is under 50% to start.)
Compliance for the rest of the reps was a matter of management attention backed up by custom reporting. I designed a report that only showed date and time of day of data entry; it was an eye-opener as it showed who was entering a bunch of data late Sunday night, instead of all week as they were supposed to.
Monday, June 15
WNTD: Keep your staff notes to yourself!
What Not To Do: Random horror stories from the trenches.
Keep your staff notes separate from the customer correspondence: (My grandfather actually got the bedbug letter in the late 1920s, after being bitten on a Pullman carriage - though not the attached note.)
“The Bedbug Letter” (from http://www.snopes.com/business/consumer/bedbug.asp).
Keep your staff notes separate from the customer correspondence: (My grandfather actually got the bedbug letter in the late 1920s, after being bitten on a Pullman carriage - though not the attached note.)
“The Bedbug Letter” (from http://www.snopes.com/business/consumer/bedbug.asp).
A wealthy gentleman was badly bitten by bugs while riding on a certain railway line. Arriving at his destination, he wrote the company an indignant letter and received a prompt reply. It was, said the letter, the first complaint the company had ever had of this nature. Inquiry had failed to reveal any explanation for this unprecedented occurrence. Nevertheless, a number of new precautions were being taken to make absolutely certain such an unfortunate incident never happened again. The letter was signed by a high official of the railway.The gentleman was well satisfied with this reply and was returning it to the envelope when a slip of paper fell out onto the floor. The hastily scribbled note on it read: "Send this guy the bug letter."
Saturday, May 30
Are you (still) doing the right things?
Are you doing the right things? Are you still doing the right things? This is one of the questions that a good CRM system can help you come to grips with. Customers don’t know what’s “right” or “wrong” in your organization, so they ask, “Why don’t you do this...”. When they ask questions like that, try to be sure you are giving a correct, current answer.
There's story of a research experiment involving chimpanzees, bananas, and a garden hose.
The chimpanzees are put in a room with a bunch of bananas hanging from the ceiling. The room also has a stepladder in it; it doesn’t take long for a chimp to move the ladder to under the bananas and start to climb. But as soon as the monkey gets near the bananas, the researcher sprays him down with cold water from the garden hose, and sprays the rest of the chimps in the room as well. It doesn’t take very many repetitions for the chimps to all learn not to try to get the bananas.
Now a chimp is removed and a new one replaces him. The new chimp moves the ladder and tries to get the bananas. Of course all the other chimps in the room tackle him - they don’t want to get sprayed with cold water. So the new chimp quickly learns the same lesson, don’t try to get the bananas!
One at a time, all the original chimps are replaced - there are now none there that were ever sprayed with cold water. Yet when a new chimp comes in and tries for the bananas, the rest still tackle him - but if they could talk, none could tell you why, just that it was bad, not done.
Is that your organization? Are you still doing (or not doing) things a certain way “because that’s the way we do them here”?
And what is it costing you?
There's story of a research experiment involving chimpanzees, bananas, and a garden hose.
The chimpanzees are put in a room with a bunch of bananas hanging from the ceiling. The room also has a stepladder in it; it doesn’t take long for a chimp to move the ladder to under the bananas and start to climb. But as soon as the monkey gets near the bananas, the researcher sprays him down with cold water from the garden hose, and sprays the rest of the chimps in the room as well. It doesn’t take very many repetitions for the chimps to all learn not to try to get the bananas.
Now a chimp is removed and a new one replaces him. The new chimp moves the ladder and tries to get the bananas. Of course all the other chimps in the room tackle him - they don’t want to get sprayed with cold water. So the new chimp quickly learns the same lesson, don’t try to get the bananas!
One at a time, all the original chimps are replaced - there are now none there that were ever sprayed with cold water. Yet when a new chimp comes in and tries for the bananas, the rest still tackle him - but if they could talk, none could tell you why, just that it was bad, not done.
Is that your organization? Are you still doing (or not doing) things a certain way “because that’s the way we do them here”?
And what is it costing you?
Wednesday, May 13
WNTD: “Who signs your paycheck?”
What Not To Do: Random horror stories from the trenches.
“Who signs your paycheck?” A consumer products company outsourced part of their call center operations to the wilds of Utah, where labor was much cheaper. They worked with a company who’s expertise was outbound telemarketing, not that it mattered much. After weeks of training, they went live, and it worked okay. There was much monitoring from the parent company at first, then gradually the reins were loosened.
What was interesting was the metrics the call center reps were judged on - how long was the call (short is good) and how satisfied are your callers (based on surveys). One rep started getting higher marks, then much higher marks - in fact, he collected all the possible bonuses. He was demure when he was asked how he achieved his success - “I just listen to them, and try to do what’s right for the customer” was his reply.
The real answer turned out to be he essentially answered the phone with “Hey, it doesn’t matter what your problem is, will $25 in coupons solve the issue? What about $50? Great, let me get your name and address.” He was giving away ten times what some other reps were, over $2000 each day - but the cost of the coupons came from the parent company, not the outsourcing company that signed his paycheck.
Short call times, happy callers... but somehow, not good overall customer service. At least, not very cost-effective.
“Who signs your paycheck?” A consumer products company outsourced part of their call center operations to the wilds of Utah, where labor was much cheaper. They worked with a company who’s expertise was outbound telemarketing, not that it mattered much. After weeks of training, they went live, and it worked okay. There was much monitoring from the parent company at first, then gradually the reins were loosened.
What was interesting was the metrics the call center reps were judged on - how long was the call (short is good) and how satisfied are your callers (based on surveys). One rep started getting higher marks, then much higher marks - in fact, he collected all the possible bonuses. He was demure when he was asked how he achieved his success - “I just listen to them, and try to do what’s right for the customer” was his reply.
The real answer turned out to be he essentially answered the phone with “Hey, it doesn’t matter what your problem is, will $25 in coupons solve the issue? What about $50? Great, let me get your name and address.” He was giving away ten times what some other reps were, over $2000 each day - but the cost of the coupons came from the parent company, not the outsourcing company that signed his paycheck.
Short call times, happy callers... but somehow, not good overall customer service. At least, not very cost-effective.
Sunday, May 10
Designing your CRM system (Part 2) - An iterative, user-focused process
Design of your CRM system should evolve during the implementation process. “Release early, release often” is a mantra of many open-source developers, and it turns out to help in many applications. (I’ve heard of exactly one system that had no changes between initial design and final acceptance, and they spent four years in the design phase. It was aerospace-related.)
If you can get a good suggestion from a user, implement it quickly, show them the result during the programming / testing phase, you’ll develop a feeling of “ownership” with that user. When you have other glitches (and you will!), that goodwill will help you - they won’t be so quick to badmouth “their” system. Keep the lowest-level users as involved as you can (their managers will resist, wanting them to keep doing their jobs, but it’s important).
And once the system starts coming together, users will be able to try it in increasing completeness. In various implementations, in the few weeks before final testing I’ve done things like:
Of course you’ll need some more changes right after go-live, but that’s okay too. Change is good - you're making the system and process better, removing friction and saving money.
If you can get a good suggestion from a user, implement it quickly, show them the result during the programming / testing phase, you’ll develop a feeling of “ownership” with that user. When you have other glitches (and you will!), that goodwill will help you - they won’t be so quick to badmouth “their” system. Keep the lowest-level users as involved as you can (their managers will resist, wanting them to keep doing their jobs, but it’s important).
And once the system starts coming together, users will be able to try it in increasing completeness. In various implementations, in the few weeks before final testing I’ve done things like:
- Change field order on all main screens, and reworded all menus. (This is common.)
- Remove 20% of the app (Adding 6 fields to another area let them drop 8 full screens.)
- Add a complex nested dropdown field that subsequently powered lots of their reporting. During the design & implementation process, a manager had expressed “decreasingly vague” frustration with the design; after a series of meetings and fact-finding missions, it coalesced into needing this field added. If she hadn’t seen all the earlier iterations, we never would have gotten to this point.
Of course you’ll need some more changes right after go-live, but that’s okay too. Change is good - you're making the system and process better, removing friction and saving money.
Friday, May 1
Designing your CRM system (Part 1)
Okay, you need a new CRM system - what do you want in it? Management has high-level needs that will be part of the design, but the bulk of the system design will be screens, fields, databases, interfaces, etc. What should they look like? If you ask this question early in the implementation process, you will (deservedly) probably get blank looks back.
Brian Sooy’s General Theory of Design: "Design consists of creating things for clients who may not know what they want, until they see what you've done, then they know exactly what they want, but it's not what you did." (from http://bscodesignmatters.blogspot.com/2006/05/skeet-shooting-in-dark.html)
This is a common place to start. You want to reap the benefits of a good CRM system, but that’s awfully vague. If you ask people what they need, some will jump into too much detail (I’m sometimes guilty of this) , and some will know only the high level requirements and not be able to drill down to individual requirements.
Brian Sooy goes on to say, “Thankfully in my experience, the antithesis of the Theory has been true in most instances: "Clients who know what they want will provide a design brief, and evaluate all designs based upon that brief."
So how do you get to a decent design brief? I advocate, “Do one to throw away”, a true pilot system. Make an incomplete (quick-and-dirty) CRM system as fast as you can, and improve from there. The “system” may be as simple as some quickie web pages or linked PowerPoint slides with mocked-up screens on them; but preferably, it will be a very simple (almost out-of-box) version of the software, with anything complex put in the “work on this later” pile.
Then take this system to the stakeholders, as many of them as you can get together. Explain to management where the data they need for reporting will be entered; they will also have technical questions. Explain to the users what the screens might look like - they will be different than what they are used to, hopefully you can ease a few pain points in the current system.
Make sure you get end-users involved, because the ultimate success of the system depends on them. Explain what you are doing: “I’ll bet you are tired of getting systems thrust upon you; here’s a chance to tell us what you really need. Help us make a better system for you.” Not every user can do this, but every call center or sales force I’ve ever dealt with has a few users who have been extraordinarily useful with system design. They know their jobs better than anyone else (including their manager) and want to help.
Get the users off the road or off the phones for an afternoon or two early in the design process, and keep in touch with these users throughout the rest of the design and implementation process. They will be your biggest advocates in the user community, help you train the users, and help with the general dislike for new systems that is a simple part of human nature.
Brian Sooy’s General Theory of Design: "Design consists of creating things for clients who may not know what they want, until they see what you've done, then they know exactly what they want, but it's not what you did." (from http://bscodesignmatters.blogspot.com/2006/05/skeet-shooting-in-dark.html)
This is a common place to start. You want to reap the benefits of a good CRM system, but that’s awfully vague. If you ask people what they need, some will jump into too much detail (I’m sometimes guilty of this) , and some will know only the high level requirements and not be able to drill down to individual requirements.
Brian Sooy goes on to say, “Thankfully in my experience, the antithesis of the Theory has been true in most instances: "Clients who know what they want will provide a design brief, and evaluate all designs based upon that brief."
So how do you get to a decent design brief? I advocate, “Do one to throw away”, a true pilot system. Make an incomplete (quick-and-dirty) CRM system as fast as you can, and improve from there. The “system” may be as simple as some quickie web pages or linked PowerPoint slides with mocked-up screens on them; but preferably, it will be a very simple (almost out-of-box) version of the software, with anything complex put in the “work on this later” pile.
Then take this system to the stakeholders, as many of them as you can get together. Explain to management where the data they need for reporting will be entered; they will also have technical questions. Explain to the users what the screens might look like - they will be different than what they are used to, hopefully you can ease a few pain points in the current system.
Make sure you get end-users involved, because the ultimate success of the system depends on them. Explain what you are doing: “I’ll bet you are tired of getting systems thrust upon you; here’s a chance to tell us what you really need. Help us make a better system for you.” Not every user can do this, but every call center or sales force I’ve ever dealt with has a few users who have been extraordinarily useful with system design. They know their jobs better than anyone else (including their manager) and want to help.
Get the users off the road or off the phones for an afternoon or two early in the design process, and keep in touch with these users throughout the rest of the design and implementation process. They will be your biggest advocates in the user community, help you train the users, and help with the general dislike for new systems that is a simple part of human nature.
Friday, April 3
Luckiest scheduling problem ever
A large Call Center install of a new CRM system had training in 4 groups, two days each. But the training rooms were booked the week before go-live, so the first training group was held a week early - thus the three weeks before go-live were: training, training, downtime, (then go-live weekend).
As it turned out, this worked out perfectly and I’d recommend this schedule every time. Some people get sick and miss class, or don’t “get it” the first time they are trained, the extra week gave time for remedial training. Some bugs are inevitably discovered during training, this gave time for thought-out fixes (not the common “I hope this works” fix thrown in just before live deployment).
One of the bugs found was subtle and tricky, and took two days to fix. If we hadn’t had the extra week, we might have had to delay things (thus egg on our faces) or gone live with this bug and stored some bad data. Instead, with the help of this extra week, we looked like geniuses (we were, but that’s bragging :-) when the biggest post go-live problem was the occasional browser timeout.
So if you can, build in a short delay between training and go-live; you'll be glad you did.
As it turned out, this worked out perfectly and I’d recommend this schedule every time. Some people get sick and miss class, or don’t “get it” the first time they are trained, the extra week gave time for remedial training. Some bugs are inevitably discovered during training, this gave time for thought-out fixes (not the common “I hope this works” fix thrown in just before live deployment).
One of the bugs found was subtle and tricky, and took two days to fix. If we hadn’t had the extra week, we might have had to delay things (thus egg on our faces) or gone live with this bug and stored some bad data. Instead, with the help of this extra week, we looked like geniuses (we were, but that’s bragging :-) when the biggest post go-live problem was the occasional browser timeout.
So if you can, build in a short delay between training and go-live; you'll be glad you did.
Monday, March 23
WNTD: Why smart companies do surveys too
What Not To Do: Random horror stories from the trenches.
Company “X” in the late 1970s had a manager who was asked to cut the number of complaints the company received. His plan was simple and ingenious; he dropped the call center staff from twelve to five. Since people are more willing to call than write, the number of complaints received went down. The reports on “abandon rate” (people who called their service line, sat on hold, then finally gave up) for the call center never made it past his own desk, of course. And the of course their products never got better.
Eventually a VP’s wife tried to call via normal channels (their advertised toll-free number), and the 90-minute hold time she experienced put an end to the practice (as well as the manager’s employment there). It took several years to even start to get the company’s reputation back.
Company “X” in the late 1970s had a manager who was asked to cut the number of complaints the company received. His plan was simple and ingenious; he dropped the call center staff from twelve to five. Since people are more willing to call than write, the number of complaints received went down. The reports on “abandon rate” (people who called their service line, sat on hold, then finally gave up) for the call center never made it past his own desk, of course. And the of course their products never got better.
Eventually a VP’s wife tried to call via normal channels (their advertised toll-free number), and the 90-minute hold time she experienced put an end to the practice (as well as the manager’s employment there). It took several years to even start to get the company’s reputation back.
Wednesday, March 18
CRM IT Systems (Part 2)
I introduced CRM IT systems by explaining they are just like every other computer system - you enter data, transform it somehow, and get data out. Most companies know what they want to achieve from a CRM system, but not exactly how to do it. That is why you need a systems integrator with a business view, and it's always a moving target, so plan for change.
One key point on system design is to make sure that every field - every single field in your application - pays for itself. It needs to improve customer service, increase sales, or be required for technical or compliance reasons - otherwise it has no place in your system. Be ruthless in removing fields that you "might need someday, maybe". They will get in your way, slow down data entry and annoy both the system users and the people they are collecting the data from. [If you load data from an external source (like account numbers or sales figures), feel free to show extra data to your uses, but don't add them as data entry fields.]
So what should your system look like?
I.) Inputs
- User-entered data fields. (This is where most people start, and some get no farther.)
- System-entered data fields (timestamps, etc)
- Ongoing data uploads (customers, products, sales data)
- One-time data uploads (perhaps business card info from a trade show)
- Listing reports
- Summary reports
- Letters/emails/campaign mailings
- Samples (for pick-and-pack operation)
- Ongoing data downloads (customer data updates; and export to enterprise reporting systems, database marketing systems, etc.)
- This is where “running the business” comes in; there are few guidelines and even fewer hard-and-fast rules to help you.
- A successful CRM manager will need to know their CRM system very well, and know the entire business organization almost as well.
- CRM Managers need to work closely with the rest of the organization. The CRM system, properly implemented, will capture the true voice of the customer, and every group - manufacturing, sales/marketing, supply chain, compliance, etc. will all be able to use insight gathered there. (But these groups need to be prepared to not like everything they hear. I could tell you stories...)
- If you know your Inputs and Outputs well, some transformations will be immediately obvious, and others will suggest themselves in time. And talking to other groups in your organization will produce ideas that come only from open collaboration.
- Be flexible! Change your system as needed; there is no sense in answering questions that no one is asking anymore.
IV.) Feedback
- How do you tell if the Inputs made good Outputs? (error and exception reporting)
- Listen to the customers! This is one of the great values of a CRM system.
- Listen to the sales reps, and especially the call center reps, regarding the company and the products.
[Many executives making important decisions at mid-size and large companies have not talked to an actual product user in years. Yes, years, and it’s not from indifference, it’s due to priorities, usually quite valid ones. So they should listen to their best available proxy, the people who currently talk directly to the customers. Don't let the executives rely on their experience as a sales rep ten years ago.]
V.) Process & Process Improvement
- What do people have to do to use the CRM system? Is it as easy as it could be?
- Does everyone need the same level of detail, or can some have a “CRM Lite” system to give them just what they need?
- What workflows are needed in the system? (What data must be entered first, etc.)
- How do you make the process of using the CRM system better?
Monday, March 16
CRM and IT Systems (Part 1)
CRM IT Systems - what are they, and how do you make a good one?
There are dozens of sites, white papers, etc. that will (try to) help you select a CRM system, usually based on features and technical capability. But how do you know what features you need? First you need to go through a fairly high-level business review process, then try to map that to a CRM system.
Like many other IT systems, a CRM system is just inputs, outputs, and transformation. The key to a successful CRM system is to keep things lean and agile, and avoid “dead wood” (data captured for no reason), and “GIGO” (garbage in, garbage out) - data that is factually incorrect. (This is easier said than done, you have to constantly monitor the system and the business for change). The basics are:
So then you work on your Inputs, Outputs, Transformation, along with Feedback and Process Improvement. If you can build in the Feedback and Process Improvement from the start, you will have a more valuable system, not another "bit-bucket" that holds data no one uses.
In part 2, I'll continue this with some details on Inputs, Outputs, Transformation, along with Feedback and Process Improvement.
There are dozens of sites, white papers, etc. that will (try to) help you select a CRM system, usually based on features and technical capability. But how do you know what features you need? First you need to go through a fairly high-level business review process, then try to map that to a CRM system.
Like many other IT systems, a CRM system is just inputs, outputs, and transformation. The key to a successful CRM system is to keep things lean and agile, and avoid “dead wood” (data captured for no reason), and “GIGO” (garbage in, garbage out) - data that is factually incorrect. (This is easier said than done, you have to constantly monitor the system and the business for change). The basics are:
- Decide, define, design, and refine the business view of the application. (What are you trying to accomplish?)
- Cast this business view in terms of the application and technology platform. (How are you going to do it?)
- Prepare for change, both on the business and application side. “I changed my mind, I have a better idea” should be met with a grin, not a scowl.
So then you work on your Inputs, Outputs, Transformation, along with Feedback and Process Improvement. If you can build in the Feedback and Process Improvement from the start, you will have a more valuable system, not another "bit-bucket" that holds data no one uses.
In part 2, I'll continue this with some details on Inputs, Outputs, Transformation, along with Feedback and Process Improvement.
Friday, February 13
WNTD: Nothing is completely private
What Not To Do: Random horror stories from the trenches.
My "CRM Metrics" post brought up the word "actionable". It means either something you can use to take positive action on, or something you can be sued for. Which brought to mind a tip for you...
A wise company will carefully NOT have a place in the application for call center reps to enter private comments about the callers; because no matter how private it is supposed to be, this information is “discoverable” in litigation. I know some horror stories in this area, but I shall demure listing their details; they are probably no worse than those your fevered imagination can come up with.
Suffice to say there are some words that just never belong anywhere in a CRM system’s data, including “snotty”, “stupid”, and “liar” (as well as most swear words).
My "CRM Metrics" post brought up the word "actionable". It means either something you can use to take positive action on, or something you can be sued for. Which brought to mind a tip for you...
A wise company will carefully NOT have a place in the application for call center reps to enter private comments about the callers; because no matter how private it is supposed to be, this information is “discoverable” in litigation. I know some horror stories in this area, but I shall demure listing their details; they are probably no worse than those your fevered imagination can come up with.
Suffice to say there are some words that just never belong anywhere in a CRM system’s data, including “snotty”, “stupid”, and “liar” (as well as most swear words).
Tuesday, February 10
CRM Metrics
What the heck are CRM Metrics? Let’s start with some classic ones:
1. Coverage / frequency of sales force visit, by customer, by quarter
2. Complaints by Product, by month
3. Web site visits by referrer, by campaign
Each of these has a time component and an outcome component, and each is incomplete in its own way. Let’s try it again:
1. Coverage / frequency of sales force visit, by customer, by quarter. Put one version in order by customer sales volume, and another in order by customer profitability per unit sold.
2. Complaints by Product, by month. Trend this year over year (seasonal adjustments), and note times of new advertising campaigns and new product launches.
3. Web site visits by referrer, by campaign. See which sources of contact led to new purchases or new inquiries.
This is closer to something “actionable”. (The word in legal circles means something you can be sued for, but in CRM terms it’s data you use to can take useful actions.)
So now we might get answers we can do something with. Each of the insights below is based on actual results I’ve seen over my 20 years in CRM.
1. a) Acme & Sons doesn’t buy that much but they pay full price, a slight volume increase there would help a lot.
1. b) Beta Co. is our fourth-largest customer when you add all our product lines they buy. Each of the three sales reps we have calling on them thought they were a smaller customer, and didn’t know about the other reps.
1. c) Beauty Supply has low volume and low profits; the scantily-clad receptionist is not a valid reason to visit them every week!
2. a) Complaints about leaking bottles doubled in the past quarter. See if there is something wrong with the bottle-making process. Did we outsource something that we need to inspect better?
2. b) We had several dozen new “I love it” calls on the new Autumn Spice fragrance. Should we do a Christmas fragrance? Or continue this all year long?
2. c) All three members of the Flea and Cockroach Anti-defamation League call us each day, complaining about our advertising. Report on this separately so we can ignore it.
3. a) We got 17,000 visits from BigSite.com, average stay at our site, 5 seconds, 22 purchases. We got 150 visits from FocusedSite.com, average stay 7 minutes, 18 purchases. See if we can find more focused sites to advertise on!
Two related points to keep in mind: You can’t report on something if you don’t collect the data. But if you start always collecting extra data “just in case” you will do nothing but annoy your employees and customers. If you need that extra data only sometimes, do surveys. The amount of time you expect to take on a survey is different, and the chance of annoying the customer is less.
So, collect the bare minimum data to start; keep your interactions as smooth and quick as you can. Add questions (also known as ‘data fields in your CRM system’ and ‘friction between you and your customers’) only when you need to; make sure every additional question / time spent pays for itself.
1. Coverage / frequency of sales force visit, by customer, by quarter
2. Complaints by Product, by month
3. Web site visits by referrer, by campaign
Each of these has a time component and an outcome component, and each is incomplete in its own way. Let’s try it again:
1. Coverage / frequency of sales force visit, by customer, by quarter. Put one version in order by customer sales volume, and another in order by customer profitability per unit sold.
2. Complaints by Product, by month. Trend this year over year (seasonal adjustments), and note times of new advertising campaigns and new product launches.
3. Web site visits by referrer, by campaign. See which sources of contact led to new purchases or new inquiries.
This is closer to something “actionable”. (The word in legal circles means something you can be sued for, but in CRM terms it’s data you use to can take useful actions.)
So now we might get answers we can do something with. Each of the insights below is based on actual results I’ve seen over my 20 years in CRM.
1. a) Acme & Sons doesn’t buy that much but they pay full price, a slight volume increase there would help a lot.
1. b) Beta Co. is our fourth-largest customer when you add all our product lines they buy. Each of the three sales reps we have calling on them thought they were a smaller customer, and didn’t know about the other reps.
1. c) Beauty Supply has low volume and low profits; the scantily-clad receptionist is not a valid reason to visit them every week!
2. a) Complaints about leaking bottles doubled in the past quarter. See if there is something wrong with the bottle-making process. Did we outsource something that we need to inspect better?
2. b) We had several dozen new “I love it” calls on the new Autumn Spice fragrance. Should we do a Christmas fragrance? Or continue this all year long?
2. c) All three members of the Flea and Cockroach Anti-defamation League call us each day, complaining about our advertising. Report on this separately so we can ignore it.
3. a) We got 17,000 visits from BigSite.com, average stay at our site, 5 seconds, 22 purchases. We got 150 visits from FocusedSite.com, average stay 7 minutes, 18 purchases. See if we can find more focused sites to advertise on!
Two related points to keep in mind: You can’t report on something if you don’t collect the data. But if you start always collecting extra data “just in case” you will do nothing but annoy your employees and customers. If you need that extra data only sometimes, do surveys. The amount of time you expect to take on a survey is different, and the chance of annoying the customer is less.
So, collect the bare minimum data to start; keep your interactions as smooth and quick as you can. Add questions (also known as ‘data fields in your CRM system’ and ‘friction between you and your customers’) only when you need to; make sure every additional question / time spent pays for itself.
Subscribe to:
Posts (Atom)
