Category: Sales Force Automation


Marketing Consultant Lead Generation Minneapolis St Paul Minnesota AtlantaI imagine I have some readers that think these posts on messaging are too philosophical and not actionable enough.   Why not discuss the particulars of lead generation, 1:1 email marketing, subject line testing and so on?

The problem with diving into the detail is not that it’s not important.  It is.  But from and order of operations standpoint, B2B marketers must have their messaging down cold before any of marketing campaign or technology is relevant.  It doesn’t matter how many emails you send, or what your open rate is if your message is confused.

However, just to satisfy the need to deep dive and get technical, let’s talk about sex, or rather gender.  Regardless of your gender, if you’re a B2B marketer and not considering it, you are missing a key element in messaging.

While 90% of marketers may acknowledge that gender is important, I find only 10 percent of 1:1 marketing campaigns or databases have any data on gender.  Of course they know Linda is a woman’s name and Michael is a man’s name, and can see this in their data.  But they’ve failed to go the final step and add the gender to the database.

The reason for this is that most data is imported and doesn’t contain gender information.  Going back through a database with tens of thousands of names and trying to determine gender looks daunting.  But it’s not.  Here’s a simple deep dive technique to add gender to your database.

Step 1: Go to the US census bureau’s database of female names and download it into an Excel worksheet.  In a column next to the name add a column called gender.  Mark all names in this column “female.”

Step 2: Go to the same database and download male names. Create the column and mark these names “male.”

Step 3: Eliminate gender neutral names like Pat, Chris and Lee.  Do this by setting up VLOOKUP in Excel and comparing male to female and female to male.  You’re going to find and interesting thing.  There are more male names in the female list than female names in the male list.  It looks like men name their female children after themselves more often than you would think.  You may have to eyeball a number of names, but you will wind up eliminating the top 100 gender confused names.

Step 4: Create a master male and female name and gender list by combining the resulting male and female lists above.

Step 5: Make sure you have a gender field in your Sales Force Automation or CRM.

Step 6: Now export your Contacts list from your system along with the ID number.

Step 7: Run a VLOOKUP on your contacts list with your master name/gender list and return gender to your contacts.  You’ll hit about 90%.

Step 8: Re-import your contact names along with gender into your SFA or CRM system.

The final step is to start thinking about how to use gender in your messaging.  I’ll give an example in my next post: Men are from Mars.

Lee Stocking
Prairie Sky Group
Driving Sales Through Customer Focused Marketing
651-357-0110 (Cell 24×7)
lee.stocking@gmail.com

The reason I’ve dedicated the last nine posts on Sales Force Automation is that it’s a key bridge between marketing and sales.  Having a well organized and smooth running SFA or CRM process helps both marketing and sales, and improves the communications between the disciplines.  But nowhere in these posts have I mentioned “The Data”. 

People have asked me, “What about the data?  Don’t I need to assure accurate or quality data in the system?”

If you are responsible for the oversight, administration or operations of a SFA or CRM, repeat after me: “It’s not about the data.”  Repeat, “It’s not about the data.”  Your data will never be perfect.  It will always be out of date.  When your boss asks, you will never be able to run a query on, “All the left handed prospects with birthdays between 1980 and 1990,” because you know you only have those prospect’s children’s names in your data base, and not the prospect’s actual birthdays.  Too many people obsess about the quality of their data as the first thing to fix.  This is like worrying about the quality of the html code for your website.

Of course the data is important.  This doesn’t mean you don’t clean, de-dup and add data.  But your data doesn’t mean anything unless the system is easy to use, or your people are trained or you have a consistent sales process.  When you address some of the issues outlined in the last nine posts, you will find that your data quality will miraculously improve.  Sales people will start using the system and entering critical information.  For example, you will find that you don’t need to de-dup because users are following your rules for account name generation.  Reports will become more accurate as management sees the value and begins to require compliance of your lone rangers who resist its use. In the end, it’s not about the data, it’s about the overall process for using and managing your data.

The problem is that management often wants perfection immediately.  When faced with managment questions, your response should be, “What are you trying to accomplish with this information?  What are your goals?”  There is always a way to get information that can answer the immediate question. But your job is to get them to focus on the bigger picture.  Guide your management through the diagnostic questions and use their energy or frustration to help build the overall process.

Final Postscript for senior management:  If you are saying your data is crap, you may not be helping and may actually be hurting your chances at establishing a process that can help you sell more stuff.  Crappy data is a symptom.  You don’t need to treat the symptom, your need to treat the causes.

Who owns the system?  Oversight, Ownership, Administration and Change Management

This could easily be the first question.  It’s essential to know the differences between the above. If different players don’t know their roles or responsibilities, then nothing gets accomplished.  In many organizations, failure becomes a matter of not clearly assigning roles.

As senior management, your job is oversight.  You are the customer for the system.  Management should get paid to think of the consequences of problems, decide priorities and then get others to solve those problems.  It is not your job to solve the problem itself.

In many organizations, ownership for the SFA system is often vague or shared.  It can be owned by IT, (which is the wrong place for it), or by sales (sales has other battles to fight), or by operations, most often sales operations reporting up to sales.  When ownership is unclear, nothing gets done.  But we need to know:

a.  Who owns what?
b.  Do they know it?
c.   Have they accepted it?
d.  Do they have the skills?
e.   Can they do it?

Ownership means that person is responsible for the success of the system.  Success is defined by the metrics you put in place.  It doesn’t mean this person does all the dirty work, but rather they lead a team, assign tasks, measure results and report progress and needs to management.

Administration is the technical support trained in the SFA and having database expertise.  Training and support of this person is essential.

Lastly, having reached a point where your SFA is running and you’ve reached your primary goals, it’s essential to put in place a Change Management System for continued improvements (See Diagnostic Question #6).

When you take a systemic approach to diagnosing and improving your SFA or CRM system, you will find the improvements have a multiplying effect on each other.  Following this diagnostic process will allow you to focus on the business and not the system.

Good luck and thanks to all those who have helped me through this process.  If you’ve stuck with me through this series, here is a quick chart to help guide you.

Diagnostic Guide for SFA and CRM

The old adage is still true, when you have to invest more energy into something than you get out, you tend to stop doing it.  This is especially true with the use of SFA by sales people.  As an adjunct to the last diagnostic question on whether the system is easy to use, the number one request from sales people is “let me see my own stuff.”  This is important enough to call out as its own diagnostic question.  Do your sales people have easy visibility to their own information?

Fortunately, sales dashboards and easy reporting have become features of popular SFAs.  However, in my experience many organizations still don’t provide this core capability.  It’s important that people experience the benefit of seeing their own pipeline.  It helps when the find they don’t have to spend hours putting together Excel spreadsheets to report to management.  It helps sales management when they don’t have to spend hours combining sales reports in Excel.

So it’s useful to ask:

  1. Do reps have their own sales reports?
  2. Are they trained to run their own queries?
  3. Do we have the standard reports we need?
  4. Are they accurate and up to date?

Without a firm reporting foundation, you’re stuck asking, “Can the Bear can see himself?”

My first experience with Sales Force Automation was when a VP of Sales asked me to make it work for his people.  As with most important challenges, he indicated I had very little time to make this one happen.  I knew this demand would be an obstacle to diagnosing the real problem so I decided to buy myself some time.  I went to his top three sales people and asked, “If you could change just one thing about the SFA system, what would it be?”  Then I changed those three things.  It didn’t matter that they might not have been the correct things to change.  But a question I’ve learned when it comes to systems is….

Is the system easy enough to use?

You can have a great sales process that’s modeled accurately with usage policies, training and compliance, but if the system is hard to use, then it isn’t going to be used.  Ask yourself:

  1. Is the SFA system easy to use?
  2. What is it not doing that it needs to?
  3. What three things could you change about the system that would make your sales people happy?
  4. Is it providing value to the users as well as management?

Following the success of the first three changes, I put in a change management process (that was easy to use and embedded in the SFA) that resulted in over 200 suggestions from sales and 150 changes within the first six months.   They started to like the taste of blueberries.