Part of my job here at ReachForce is helping our customers with a quick analysis of their marketing database and then helping them update and repair the company and contact information needed for their lead generation programs.  Here’s a list of 10 things I see in almost every marketing and sales database I’ve looked at:

1. Names are mis-mashed up with erroneous information.  Examples:

John “No Longer There” Smith
Jenny (female) Jones
Byron (buy-ron) Doe (Dough)

2. Web-to-Lead forms have left you with a lot of trash.  Examples:

First Name    Last Name    Email                         Company
Test              Test              test@test.com           None
None of        Your              absc@asklfjsl.com    Business

3. Your Customers are still listed as your prospects.
4. You have multiple copies of any one person.
5. Employees of your company are listed as prospects.
6. You have records created with companies someone wants to target but no contacts, instead of holding a valid contact your CRM is being used as a place holder.  OR, you have holey records, pieces and parts of a contact but no whole contact.

Examples:
First Name    Last Name      Email                           Company
Find Name    In Hoovers      na@na.com                 Microsoft
IT                  Dept Mgr        na@na.com                 Exxon
Amy              H.                   ???@reachforce.com    ReachForce
L.                  Wallace           ???@Reachforce.com   ReachForce

7. Phone numbers are missing digits and/or area codes.
8. Bad or Blank email addresses.
9. Invalid or incomplete mailing addresses – maybe you don’t do direct mail, but chances are you need this for something…
10. You have no way to segment your data.  Do you have information on these companies in a standardized format, for instance all tech companies have some kind of tag, or all operations contacts have a specific designation? If not, how are you segmenting your data? Wouldn’t it be easier if everything had the same system of tagging applied to it?

Is is not the most exciting or the most glamorous part of campaign planning but getting your database in order will have a huge affect on the success your marketing programs.

Dear Sales,

Now that we’re on the same page about the data, let’s talk specifics on how to make this happen.

• You know that we work hard to segment the data before it goes into campaigns, so first, get to know how we segment things.  Talk to us, find out why we do things the way we do and who gets batched together.   Seeing the world the way we do will help you better understand why certain types of contacts are getting certain messages and will help you better reach out to and tailor your messages to those contacts. We are open to your ideas too.  You know your prospects better than we do.  Help us to help you.
• Get to know the companies in your database, ask for help from Sales Operations or export a report of your prospects.  Spend time learning about each company on your list, what do they do, who do they sell to, what events do they attend, make yourself an expert on them so that when you talk to them they feel like you really do know them and their pain points.   Make notes in the record so that you don’t lose track of this valuable information.
• Do you use mail merge fields in your emails or letters?  If so, then really spend some time cleaning up the names of prospects and their companies.  Make sure people aren’t listed like this: “John NO LONGER THERE Smith” or “Jane SHE IS A REAL JERK Doe” – there is a notes section in your CRM, use it!
• If you’re using salesforce.com, set up views that capture activity, for instance, if your marketing automation tool integrates and marks activity on prospect records, set up a view where you can see that kind of activity.  Keep tabs on what people are doing so that you can reach out to those active prospects.

These are just ideas, but the idea is that if you are truly in the ‘weeds’ of the data, you’ll get a good handle on what you own, who you’re calling and hopefully begin seeing some great results!

Love,

Marketing

This tip comes from our very own Marketing and Sales Operations Manager, Lauren Kincke.  Lauren is responsible for integrating and managing our marketing and sales systems.  She spends most of her time working to make these systems and processes help us be more effective and efficient.  She is an integral part in our closed loop marketing and sales system.

As Sales and Marketing become better aligned, so do our tracking systems and metrics.  For a while, we at ReachForce have struggled with the question of how best to track our campaigns, we wanted to know (for instance), how many emails it took to get someone to respond, what email was it that seemed to be the trigger?  And the bigger piece to this puzzle, since we all know the Sales team doesn’t have the bandwidth to really track this information, how can we automate it?

Lucky for us, salesforce.com has a few cool features that we have found useful in tracking this type of things, the first is their Campaign Management tab.

Within the Campaign Management tab you can create a campaign, drop in the list of people who will be part of the campaign and as opportunities arise from that campaign, you can see exactly who they are.   Along with the ability to watch as opportunities join the funnel as a result of your campaign, you can keep tabs on the cost of your campaign, its possible ROI and its actual ROI.  Campaign Management gives you a full window into your programs.   For a full run-down on the Campaign Management feature as well as new Marketing related features in salesforce.com, you should check out their Marketing Blog.

Outside of the Campaign Management feature, we use individualized Dashboards to track activity on specific events/campaigns. For instance, after Dreamforce (salesforce.com’s user group conference and our one big trade show) this past year, we tagged leads that we gathered as having attended Dreamforce, exhibited at Dreamforce, or having had a conversation with someone at our booth.  To do this, we utilized a custom field we already had on our Lead and Contact records called “Marketing” – we populated all of the leads connected to Dreamforce with the right information (either a tag called “Dreamforce 08 Exhibitor”, “Dreamforce 08 Attendee” or “Dreamforce 08 Scan”).  One quick caveat is that not only did all of our leads go through a rigorous scrubbing process (to determine whether the companies were a fit for us), but in instances where we knew we needed a different person (i.e. we hadn’t had enough conversation to verify that these persons played a role in the Decision-Making Unit or buying process) we submitted the company to a role-based contact discovery project so that we could gather the right person.

Once all of those people were tagged, we were able to track them through the pipeline based on knowing they attended/exhibited at or were scanned at Dreamforce.  We built out a full dashboard tracking this information, it helps Marketing see the value in our investment at the event and helps Sales see the value of the data collected at the event and track to make sure that all of those leads get the proper follow-up.

On the Sales side we set up a view for all of our reps that showed their individual Dreamforce related leads.  This made follow up clean and easy because our Sales people knew exactly who attended Dreamforce and whether they showed up at our booth (we imported certain information to indicate whether leads had been at the booth and who they had spoken with).

Salesforce.com continues to roll-out new features that better enable Marketers to track the progress of their campaigns once from lead to customer.  As we test and use them, we will be certain to share our findings!  Have you found an easy way to track things once they hit the pipeline? What tricks do you have for tracking your campaigns?

I’m not a marketing or sales guy per se so please help me understand something here.

As the classic saying goes, “I know at least half of my data is bad…I just don’t know which half”.
Marketing Sherpa tells us that contact data degrades at a rate of 2.1% per month (and it’s probably gone up  substantially given the current rate of job loss), it’s easy to see how this is essentially a self-fulfilling prophecy.

Having said all that, does it matter you could be sitting on piles of dirty data?

Contact data cleanup seems to experience a run-up of demand at the end of the year when marketers have just enough budget to burn on something small to mid-sized but not enough to do anything substantial with.  Or at least this is what we saw. In fact, we cleaned up some of our own CRM data in December as well.

But come the turn of the new year and new budget, the psychology of “new” is the all the rage.  Sales reps are innately in perpetual want for new leads, but as we say around here, it seems most marketing and sales teams would rather keep building new add-on rooms to their houses than spend the money to fix the basement that is flooded with sewage.

So what is the psychology behind using what you have vs. buying something new?  Is it simply fueled by an unquenchable thirst for “new, new, new” (and the perception thereof)?  Or do you have a more systematic approach to if and when you elect to use what you have vs. buy new stuff?

Is it the same mentality of buying something that is on sale even if you don’t really need it?

I just don’t get it.

When times are tough we are forced to make use of what we already have.  After many events, lead forms, list exchanges and sales rolodex’s you have probably built a nice size database of prospects.  Before you get ready to launch your next program to your in-house database consider these things:

1. Marketing Sherpa has said that 2.1% of data goes bad every month. (This stat is about 2 years old, with so many people losing their jobs over the last couple of months I bet this number has gone up, but for this, we are going to use the 2.1) This means each year almost 25% of your contact data gets dirty.  Do you know which 25%?

   Contact records stay fresh about as long as a gallon of milk. Well maybe a little bit longer but you get the idea. Here’s some other interesting stats (also about 2 years old) According to Gartner, more than 30 million people out of the 138 million employed in the US will switch jobs in the next 12 months. In the same time, some 2.5 million businesses will move, according to the U.S. Census Bureau.  Again, I bet these numbers are up too.

2. Are you marketing to the entire DMU (decision making unit)?  Do you have your entire DMU in your database?

   B2B purchases are typically made by a group of people.  Each one with different concerns and specifications.  To accelerate sales cycles it pays to start the connections before your prospect moves into the sales funnel.  DMUs can include – end users, business managers, finance specialist, technology specialists, senior management, key influencers, procurement specialists, etc.

   Marketing Sherpa also says…For purchases of $25K or more -
   100 – 500 employees    6.8 people in the DMU making buying decisions
   501-1000 employees    13.5 people in the DMU making buying decisions
   0ver 1000 employees    21 people in DMU making buying decisions

3. If you are trying to upsell or cross sell to your existing customer database, do you have the right buyers and their contact information?

   If you are selling a platform or have solutions that affect multiple groups within a company, there’s a chance you don’t have the right buyers for your new product or solution.  Here’s an example:  You sell a CRM platform and have recently added accounting and marketing modules.  Marketing to the sales leader that bought the CRM piece probably isn’t your target audience for the new modules and won’t get you very far.  Their needs are already met. And while they may be involved in the additional purchases they probably are not the ultimate buying decision maker for your upsell or cross sell.

4. Do you have all of the relevant contact information needed to executive your marketing programs?

   Example – You are planning a breakfast city tour and want to invite people in each region via email and also with a direct mail piece.  Do you have everyone’s correct physical address for the actual events and the direct mail?  Do you also have correct email addresses for the series of emails you plan to send reminding people about the event?  Missing just once piece can hinder your results.

5. Have you considered international privacy and SPAM laws?

   While we’re all very familiar with our US CAN-SPAM laws, have you researched the other countries you are marketing to?  Each countries laws are different, like for example Germany requires a double opt-in for email marketing.

Am I missing anything here?  Remember the grass isn’t always greener with the unknowns.  Work what you have, at some point you thought these people were worthy of holding on to.

This is the 7th in a series discussing Customer Experience Indexing (CEITM) as a way to measure, plan and act on customer feedback.  (#1) (#2) (#3) (#4) (#5) (#6)

Here is the outline we’ve been following:

1. CEI Initiative Planning
2. Optimizing the flow of both loyalty and satisfaction feedback
3. Analysis of feedback and calculation of actionable CEI metrics
4. Using the data for short, mid and long term account plans for retention and growth
5. Using the data to plan and deliver action plans aimed at reshaping customer attitudes and opinions
6. (We are here) Using the data to locate new prospects using rule based company profiling and role-based targeting

So far we’ve gathered then used CEI response data for scoring to examine three existing customer scenarios as examples:

• An expanded Net Promoter-type way to calculate and measure satisfaction + prompted + unprompted customer advocacy
• Applying CEI-metrics for better account-by-account management planning
• Building CEI-lenses for better strategies and tactics for up-selling, cross-selling and renewals.

Next on the list is to take a look at using CEI response data to help locate, target and engage with net-New prospects.

Reference Account Management

The most obvious and useful way CEI scoring benefits the new sales process is the buttoned down way it sorts advocacy dynamics and pinpoints which current customers would make the best references based on data analysis, not on someone’s opinion. There is nothing more powerful from a news sales perspective than having a well stocked supply of sales ready references. It happens every day across the world, thousands of times a day ― a sales person bursts into the marketing or account manager’s office needing three references to connect with their prospect. Not only is the list of needed attributes arms length, but it all needs to happen before tomorrow afternoon. Sound familiar? Yes it does.

This scenario takes us back to the first exercise we did for determining what a customer’s advocacy rating is. Remember it’s a matter of reading how a customer feels about their entire experience with your company using a scoring schema that takes metrics from both qualitative (loyalty) and quantitative (satisfaction) feedback into account. So if asked to produce recommendations about what customers should be the best sales-ready references we’d produce response scores rendered from a two-step lens build that would look something like this:

Step 1 Top 10 Sales Ready Reference Accounts

Once each row on the customer list has an assigned CEI Advocacy Score, simply sort this column in descending order and in combination with the column for customer response time to your survey plus overall satisfaction scores, plus Key Weight. This  (if you remember back to the 1st and 2nd posts in this series) is because the survey invitations were sent as an integrated campaign, i.e. first an email, then another, then a phone call reminder from the account manager, then another from an executive, then perhaps another email, etc., thus determining how quick to respond each survey taker was. It stands to reason that someone who responded quickly in combination with high scores from Advocacy, Satisfaction and Key Weight are going to be a good sales ready reference account.

Step 2 Top 10 Sales Ready Reference Accounts

So the above mentioned sort produces a top 10 list based on:

Next week we’ll cover ways to build rules-based profiles of your most successful customers and your relationships with them and then use the data to score how well new company targets match the rules.

As we kick off the New Year, we’re typically in an “out with the old, in with the new” mindset.  While that may be true for a lot of things, it doesn’t have to be the case for your marketing database. As we ponder in 2009 how to do more with less, think about what you can do with what you have.

Most Marketers are overwhelmed by a customer or prospect database with hundreds of thousands of duplicate entries, old data, inaccurate contact details and countless records in myriad states of completeness. This existing data has likely been gathered by many different individuals over multiple years.

Did you know?

• More than 30 million people out of the 138 million employed in the US will switch jobs in the next 12 months – Gartner Group

• In that same 12 months, some 2.5 million businesses will move, according to the U.S. Census Bureau

• “The Company that markets with a healthy data-cleansing routine can realize nearly 70% more revenue than an ‘average’ organization, based purely on data quality.” – Sirius Decisions

Dirty data, whether purchased or collected from download offers hampers your lead generation results and drives up costs.  So sticking with the same theme from my last couple of posts, doing more with what you already have, consider this.

Before throwing out your dirty data and buying new or taking on a massive database clean up initiative, think relevance.

What lead data do you have in your database that is relevant to your target markets and buying roles today?  From there you can put together a repair program.  Here’s a starting point for determining what relevant data you already have at your fingertips.

1. What businesses you need to target?  Industries?  Vertical markets?
2. Who in those businesses are involved in the buying decision for your product or services?
3. What are you going to do with the data? (Email campaign, direct mail, telemarketing)

Now it is time to repair that relevant data.  Start with what’s missing.  Here’s a list of things to consider:
If you are doing segmented email programs, do you have the right buying roles within your target markets?

• Do you have all of the email addresses you need for each role in the decision making unit?
  If you are doing a direct mail program, do you have accurate mailing addresses for everyone you are targeting?
• Are there more companies out there that are in your target market that you currently don’t have in your marketing database?  If so, find these and add them.
• Is there data older than 6 months in your database that needs refreshing?  Remember how many people are moving around and how many companies are merging or going out of business on a monthly basis.  Consider refreshing this data.  **This does not have to be a manual solution.

Thousands, tens of thousands, or maybe even hundreds of thousands of records in your database, there’s bound to be gold there, you just have to uncover it and dust it off.

Here are a few resources for you to consider as you ponder your marketing initiatives in 2009 and the value of your current data.

Is Dirty Data Sabotaging your Marketing Results?
Dirty Data: Even More Expensive Than you Thought
Understanding the Role of Role

Hope you enjoyed this quarter’s Book Club series.  Just in case you missed an eBook or whitepaper we read and discussed, below are the links to them and what we had to say about each of them.

• Dianna Huff’s Five B2B MarCom Strategies to Increase Sales Now
• What we had to say…

• Brian Carroll’s Eight Critical Success Factors for Lead Generation
• What we had to say…

• HubSpots’s Get Found Online
• What we had to say…

• Marketo’s Best Practices in Lead Nurturing
• What we had to say…

• David Meerman Scott’s The New Rules of Viral Marketing
• What we had to say…

• ConnectDirect’s How to Choose your Carrot: Effective Lead Generation Offers for High-Technology Marketers
• What we had to say…

Happy Reading.  We look forward to sharing even more B2B Marketing and Sales tips with you in 2009.

This is the third post in a series on Deliberate Marketing. Be sure to check out the first post on Intention vs. Attention and the second post on Qualified Buyers vs. Leads.

Deliberate Marketing programs do not rely simply on prospect titles for targeting potential buyers.

For example, a B2B Marketer purchases a list or accesses a contact database and pulls a list of 1,000 Communications Analysts. How can that marketer be certain that the contacts who match those titles are involved with Network Communications instead of Corporate Communications?

Titles are simply a label of rank, not an indication of the actual role the prospect plays in the organization or in the buying decision. Instead, Deliberate Marketing programs are focused on “roles,” defined by Webster’s as: a function or part performed. They target communications based on organizational role and level in the DMU as well as stage of the buying cycle.

The average B2B marketing response rate is less than 3%, and it’s getting lower every year. It’s easy to see why title-based lists perform so poorly.

Consider a Fortune 500 company with 90,000 employees.
All told, this company has 500 IT staff.
Of those 500, 150 have a title of Manager, Director, and higher.
Only a handful of those 150 is in the right role to buy your product.

But what’s a marketer to do? Using current list technology, you can only get as specific as target title. So you have to market to all 150 people with ‘hot titles’, jamming the inboxes of the majority with an unwanted, off-topic solicitation. It’s simply not a cost-effective model.

I’ve been talking to a lot of people these days about database hygiene. Many have asked for best practices amounting to a “get well, stay well” healthy data routine. We do have a great white paper on this subject, Is Dirty Data Sabotaging Your Marketing Results?

One step is to make sure that users of your CRM system have a handy/easy way to “flag” inaccurate contact records.

If you are a salesforce.com customer, here is a way to help in this area:
The instructions/advice below requires administrative privileges in salesforce.com.

FINDING DIRTY DATA/EXCEPTION REPORTING

1. A field must be designated for data quality/lead quality to be reported through.  For instance, here, we use our “Lead Status” field and have created custom values in the pick-list to accommodate the error reporting.  Example: Bounce Back (Email); Wrong Phone Number; Contact No Longer There, Company Closed/Acquired.

a) A pick-list type field is best for this because it standardizes the options for reporting.
b) We have found it useful to go beyond the simple “Bounce Back, Wrong Phone Number” type of justifications for a contact being wrong and include information such as Company Acquired/Closed (with a custom field allowing users to input the company it was acquired by), Company No Fit: No budget/need, Wrong Contact: Need higher level contact/lower level contact, etc.  Once you have a basic infrastructure for error reporting customizing the field to your organization’s needs is easy.

2. After the field is in place and has begun being used, create a custom report that pulls the data you wish to report on.  It is typically much easier to report on the exceptions (the wrong data) rather than the correct data.

• Go to the “Reports” tab, select “Create New Custom report”
• Choose “Leads”
• Use a tabular report format
• The columns we use are:
• Lead Owner
• First Name
• Last  Name
• Title
• Company/Account
• Lead Source
• Lead Status
• Created Date
• Created Month
• Street Address
• City
• State/Province
• Zip/Postal Code
• Country
• Phone
• Email
• Website
• RF Internal Project (*Custom field, created to denote what project each
• contact came from)
• Nothing needs to be summarized on the standard summary fields
• Any changes in the placement of columns is strictly based on personal preference

For report criteria the following is important:
a) View – choose All leads.  Date/Duration/Start & End Date – leave the standard “Create Date” and “Custom” settings but delete the date in the “Start Date” field – leaving it blank ensures all possible data is captured in the report.
b) Advanced Filters:

• Field – Lead Status (or whatever field you have elected to use to report the error data in)
• Operator – contains
• Value – Whatever error messaging you have input, for example “Bounce Back, Wrong Phone Number, Contact No Longer There.”  If you have used a pick-list to populate the field then you will be able to use the look up (looking glass icon next to “AND”) to select all relevant information.

Here at ReachForce, we run this report on a weekly basis, but companies with less sales reps or reps who make fewer calls won’t necessarily need to run the report that frequently, conversely companies with lots of reps or reps who burn up the phones will want to run an error report more often.

RE-IMPORTING NEW/CLEAN DATA

To avoid lead duplication, it is best to export the bad data with a unique identifier (like the Lead ID provided by salesforce.com) and then re-import  the data using the same identifier. By using the Lead ID, you can ensure that notes and activity history that were previously attached to the record are not lost in the process.

It is important to remember to reset the Lead Status field once the data has been cleaned up (or whatever custom field designates the data as bad) so that sales reps calling on the data know it is ready to be called on again.  Here at ReachForce we also have a “born on date” for our refreshed data.  In that field we import the date that the records were updated in salesforce.com so that the rep calling on the record always knows how current the information is.

After data has been cleaned up, it is important to continue to keep the data up to date, using the error reporting discussed above and setting a time-table for how long it takes for a lead to “expire” allows you to keep all of the data in your database fresh.  For example, if a lead is new on 9/1/2007, it is safe to assume that by 9/1/2008 it might be in need of an update.

DATA SCORING/RECORD COMPLETENESS

We have found it useful to leverage a free AppExchange program put out by salesforce Labs called “Data Quality Analysis Dashboard 1.0″ to give better visibility into the completeness of records and what deficiencies exist. This package installs a set of dashboards and reports that give scores to each type of record within your CRM and then provide high level views of how your records score.  Using this tool can give you a better idea of where your records need improvement and/or if particular types of records are better kept than others.