-
B2B Customer Intelligence - Flexibility
Posted on February 22nd, 2010 No commentsThis is the second post in a new Customer Intelligence blog series. Please add comments if you’d like me to expand on any of the points, or have suggestions for other topics. I also welcome any feedback on the content.
Customer Intelligence takes a lot of work. To implement it properly you or your company will need to invest time and resources on technology, data quality and ETL projects. You will also need to hire or contract with analysts who will help to derive the insights needed to properly target your best customers and prospects.
As soon as you’ve invested all of that money, the target will change. Sales goals are redefined yearly at most companies, and even the most stable change companies their approach every couple of years. The Customer Intelligence program you’ve defined needs to flex with your corporate goals to be effective. Rather than build a rigid model that’s engrained into your production systems, a flexible model will allow for longer term success and save money.
Strategic Flexibility
From your first brainstorming session on Customer Intelligence, you need to think about how the program can meet multiple corporate goals. Let’s say that today your company is dedicated to growing it’s customer base through prospect acquisition. If you’re successful at that approach, your company will likely mature into a customer retention focus over time. Seems logical, right? So from the start how do you create prospect scoring approach that will also translate into customer lifetime value models. Which factors are shared in determining prospect conversion and customer longevity? If you were the CEO, which direction would you take the company in next? Now ask others in the brainstorming session what they would do. Set 3 or 4 targets and be sure that your customer intelligence plan can support all of them with little adaptation.
Insourced vs. Outsourced Analysts
One of the first decisions you will need to make is who is going to do the work. I assume if you are reading this that you’ve got a solid background in data quality, project management, and a few other relevant skills that will vary from reader to reader. Are you a PHD statistician? I’m not. Are you willing to spend 80 hours next week writing ETL code? Having done that for a few years (anyone else remember clicking “run” at 2AM on a 4 hour denormalization package, then cuddling up under their desk for a nap?) I’m happy to hand that work to someone else. You will need support, and it will be expensive.
Depending on the size of your Customer Intelligence program and the size of your company, you will need to decide on the best approach. Personally, I’ve used both internally staffed and external analyst firms and I’ve had success and failure with both. I’ve found the key is to have more than one modeler working on the problem to share ideas and help you keep track of the other. There’s no bigger wake-up call than hearing from a statistician that their peer is incapable of doing the work assigned. This stuff is really hard. Not everyone who has a good resume can build a model from scratch that drives your business to the next level.
To stay flexible, you need to be able to grow your team quickly during development and then shed excess analysts while Customer Intelligence programs prove their success. I would recommend a hybrid aprpoach with some full-time employees to maintain models and external consultants available when new models are needed or when your internal folks hit roadblocks.
Developing a Library of Models
Another key to Customer Intelligence flexibility is to build your models on top of a standard data set that can be used over and over again. There are nuances to using corporate data. It’s time consuming to build a dataset of input variables for a statistical model. There are issues based on business definition, geography, time calculations, and data sparsity that all require both business analysis and technical work to get right. By building a single set of denormalized data (think one big table where the transactional keys have been resolved to their text values in the data set) you will save time and money the next time you try to build a new model. Of course you can add variables over time, and even include different versions of the same values. But by building it once and using it repeatedly you will get more results with less effort.
-
B2B Customer Intelligence Series - Introduction
Posted on February 12th, 2010 No commentsMy job title and primary focus is Data Governance, however the data I spend the most time managing is B2B data. As a former consultant, I constantly find myself suggesting new applications to drive Sales and Marketing programs. Sometimes it’s as basic as dipping into database reserves to find new prospects, but often my extracurricular projects are pure Customer Intelligence, also referred to as CI. Customer Intelligence can cover a lot of ground, so let me define it.
Customer Intelligence is the intersection of Sales, Marketing, and Analytics that helps present the best customers and prospects to inform company strategy and tactical approach.
Customer Intelligence work manifests itself as Analytic projects including predictive modeling, cross-functional leads programs, and Sales and Marketing strategy projects. In most companies I’ve worked with, Customer Intelligence is distributed across several functions and that group collectively defines the companies Customer Relationship approach. In others a central group focuses on Customer Intelligence and coordinates the distribution of related information to drive strategy.
Other companies have no Customer Intelligence. They are Customer Ignorant. In that case, the Sales and Marketing teams approach customers based on generic approaches and anecdotal history of which customers are the “best”. With good products and excellent customer service, this approach can work. However, over time it will open the door for competitors to take over and dominate the market.
Here are a few thoughts for the upcoming series. The plan is for each of these topics to be developed as an entire post over the next few weeks. If you have other suggestions, please comment on the post or tweet a reply to @markgoloboy.
1) Customer Intelligence Flexibility
No matter how successful it is, every sales strategy will be retired someday. It may be next week. It may be next year. But be sure, the target will be set somewhere other than it is today. How do you build a Customer Intelligence strategy that allows your organization to stay agile?
2) Aligning Against the Opportunity
Once properly implemented your Customer Intelligence approach should become an integral part of the sales reps’ day. How do you integrate the information with your existing processes and systems to align against the opportunity?
3) Direct Marketing Impact on Sales
Customer Intelligence can help define a set of high value prospects that deliver return on Marketing investment. Determining which factors influence purchasing requires advanced analytics. What’s the best way to develop analytic models and measure whether they predict a prospect’s likelihood to become a customer?
4) Defining Lifetime Value
Determining Lifetime Value (LTV) of a customer and potential LTV of a prospect can align Sales, Marketing and Product goals with corporate strategy. However, LTV analysis requires that your product and sales data has been collected consistently for your company’s history. How do you develop and use LTV to drive product direction and Sales and Marketing focus?
-
Data Governance for the Executive Level
Posted on November 1st, 2009 2 commentsYou’ve done your work. You understand the issues. This is your one chance, so it better be smooth.
My previous blog posts have focused on Lightweight Data Governance for the most part. I’ve sprinkled in some more fomal theory that I’ve learned from the experienced pros, but for the most part I’m writing about my own experience with Data Governance. If I sat here and told you the best way to manage a mature interdepartmental Data Governance practice, you’d call B.S. And you’d be justified in doing so.
With that backdrop, I’m going to begin to describe the transition from Lightweight to Formal practice. I don’t yet know where I’ll end up, but along the way I’ll try to help others with their journey. At some point you will find the limit of project based, department level Data Governance. Whether it’s funding for resources and tools, or interdepartmental coordination, you will need to present Data Governace to a room full of executives.
Do you have a mature presentation ready at a moments notice?
You never know when you’re going to be asked to present. Your boss may say something in a meeting and the next day you get your opportunity. You should create a short 3 or 4 slide presentation that quickly justifies the work your team does. It should be provocative, show the problems and your solutions to them, and clearly demonstrate the value your team represents to the company.
The slides should include:
- Your Company’s Problem and how Data Governance can solve it
- Your Current Work Plan, which should be High Level and written in business terms
- Your roadmap for the next 12 - 24 months
- Challenges (funding, resources, roadblocks) and your solution to them
Do you have sponsors who can describe your value?
If you are the only one who believes your work is necessary, then it’s not. You must build relationships with the teams you work with, and build credibility with their management over time. If you were called into a meeting right now, which three executives one or two levels above you would you invite? Who would be invited by the organizer. They should understand how your work benefits them, and be willing to stand up for you.
Get right to the point.
Why do the executives need to spend this 30 or 60 minutes listening to your presentation? Think about it from their perspective. They have much better things to work on than this, right? Tell them why it matters up front. Make it about revenue potential, solutions to business (not data or technology) problems, or cost savings. That’s the way an executive thinks. You can also talk about control, compliance, and the corporate maturity that your work representes. But, trust me, focus on the dollars and business problems first.
How can Data Governance increase revenue?
This one is especially important during this terrible economy. What’s your company’s #1 goal this year? Sales. Nothing else matters if there’s no money coming in the door. How can Data Governance help the Sales team?
- Clean up customer data so the reps know what to focus on. This will require improved systems, better processes for reps, Finance / Order Administration, Customer Service, and anyone else who touches customer data. That interdepartmental coordination requires Data Governance to understand the issues caused by poor data quality.
- Improving the data will remove inneficient admin tasks from your Sales Rep’s day, allowing them to focus on selling more. If the Rep needs to sift through old prospects that will never purchase to find the hidden gems, they are not working efficiently. Data Governance should develop the processes to maintain the Sales reps portfolio systematically so they have fresh data to work with. Obviously, this is more important as your Sales organization and customer base grows. If you have 100s or even 1000s of customers, you can probably ignore this one.
- Allow management to focus on the issue, and not the noise. Every time a Sales rep sees a bad row of data, they either move on, cringe and move on, or scream about it. The ones who move on quickly make the most money. The ones who scream are looking for excuses not to sell. They will complain to their management, who will invariably complain to those responsible for the data. Is that you? By removing the excuse that the data is bad, management can focus on the real issues of Sales productivity.
What business problem problem are you solving?
I think the fun part of Data Governance is that it allows you to help resolve longstanding business problems and answer tough questions. If that’s the result of your early data governance work, you’ll get funding to do more. What is the direct business impact caused by inconsistent, incorrect, or misleading data permeating your organization? Who screams about it in meetings? Go ask them how you can help. When you understand their business problem you will know where to start.
Lastly, how can it reduce costs?
The most important part of that question is “Lastly.” Everyone else starts there, but I think it’s the hardest to sell to your management. A revenue or business problem based justication is more strategic than a cost savings plan. Anyone can save costs. Cutting resources or choosing different tools is easy. Look around. Your management has done it repeatedly this year.
-
CRM Marketing Strategy To Drive Sales Revenue
Posted on September 4th, 2009 No commentsFor the purpose of this post, I’m defining Marketing Strategy to mean the analytics that complement the work done by the Database / CRM Marketing team and the influence that those analytics can have on Sales and Marketing programs. This article isn’t about Brand, Creative, or Media Purchase. It’s also not about Social Media, SEM or SEO. Just to be clear, I’m writing about using Data, Technology, & Analytics to reach out to customers and prospects, improve program results and drive revenue. Generally my recommendations are specific to Email Marketing, but may also be applied to Direct Mail or TeleMarketing.
Marketing Strategy should be the heading under which your company defines it’s analytically based sales programs. But you don’t need a fully developed internal analytics shop to be strategic. In fact, that isn’t the first step at all. First, focus on your data. It doesn’t matter how good your analysts are, they won’t be effective or efficient if you give them low quality data to work with.
So, let’s begin with the data. The following three areas of Marketing Strategy rely on Data Governance, so for my opinions there read up on Lightweight Data Governance.
Opportunity Analysis
If your data isn’t clean, you can’t get a feel for how well you are doing. For instance, duplicates in your data when analyzed in aggregate cause double-counting within buckets, double-counting across buckets, and general noise that diminishes the value of analytics and modeling. If you have the same company listed as both a customer and a prospect, and they both fall in the same industry or geography, your analytics driven programs will fail.
The solution is to develop a source system down approach to gathering data for your Marketing Strategy work. If you collect the data with reporting and analysis in mind, downstream processes will benefit. So work with your Sales, Service and Finance teams. It will take them an extra few seconds to correct the problem. Every customer facing employee should spend a few seconds each time they speak with a customer to ask, “Is our contact information for you still correct?” That change, which may require a culture shift that starts with the executive team, will dramatically improve program results.
Targeting and Personalization
Do you use Marketing Strategy and leverage data to drive campaign results? Test and Learn is a sneaky term for Marketing Strategy. It sounds less expensive, so use it.
Your content should be specific to your target’s business problem. It should be tailored to their purchase history, or lack thereof, and include next (or first) best product or cross-sell specific messaging. You should personalize the email to the targets name, title, company name, and other fields in your CRM system. If you have analyzed the lift generated by personalized vs. non-personalized messaging, you understand the need to target your emails.
When you segment targets and personalize the subject line and body content of your emails, your open and click-through rates will increase significantly. Also, your opt-out rates will go down. The quality of these key fields must be monitored and improved to take advantage of that lift.
Compliance and Customer Interaction
If you are not familiar with CAN-SPAM, read my take on your responsibilities as an email marketer. You are required by law to do a great job at managing email opt-outs and confirming that your business is transparently represented in your email marketing. Even forgetting about email compliance, you should still consider the customer impact of bad marketing. “Mark Goloboy or Current Resident” = Trash Can. Trash Can = Poor return on direct mail spend. Read: Not enough revenue to justify your program.
So how do you mature your processes quickly to take advantage of the potential sales impact of Marketing Strategy? You must develop quality processes that remove bounced emails from your lists and opt-out all instances of an email address when requested. You also need to be sure your sales reps are honoring your opt-outs. Lastly, you must review your data for patterns of Sales or Service rep entered garbage. What’s the most frequently occurring word in the First Name field of your contact records? I bet it’s not “John.”
Data Acquisition
Whether you are in B2C or B2B Marketing, there is value in purchasing reference data for your existing customers, and lead data for prospecting. How much value is there? You need to test purchases from different vendors to determine that. There’s no other way. Buy a small list. Or better, ask a list vendor for a free list to test. They aren’t selling a lot now. Take advantage! Then predict ROI by scaling the results and associated spend across your whole universe of customer and prospect data.
You can also measure the impact of cleaning, de-duplicating and referencing your data to a standard set by testing those processes against a statistically significant sample of your customer data. Again, you may be able to get some of these services for free by getting into a competitive sales situation. Your prospects ask you for this, right? Mastering this customer data requires assistance and cooperation from Sales, Marketing, Customer Service and Technology, which means Data Governance.
-
Pick The Low Hanging Fruit of Data Quality and Data Governance
Posted on August 21st, 2009 No commentsThis has always been my favorite terrible consulting / business cliche. I suppose I’m using this forum to solidify it’s status there, but I imagine many of you have been told or said something very similar. Of course this fits into my Lightweight Data Governance theory as well.
Saying that you are going to Pick the Low Hanging Fruit resonates with budget conscious managers and technologists who want to see quick results. It shows that you are unwilling to get bogged down in low value projects, and that you want to make a difference quickly. And, with slim budgets for new tools and consulting services due to the Economy, it’s a good approach for Data Quality and Data Governance today. Now which sagging branches are the most attractive?
Review Existing Processes
Have you reviewed your matching logic for external data entering your systems? What about the rejection rows from your ETL? These activities are essentially free - you can do them while you’re sitting on conference calls or waiting for others to join a meeting. They don’t take long but you may see patterns that help you to recommend great new projects.
Rethink Rollout of Underutilized Tools
I was at a conference recently and saw a demo of a Data Quality report from a vendor we work with. I went back and asked my Sales Rep if we owned the tool, and sure enough we do. It’s part of a larger contract, but no one is using it. Ca-Ching. That’s a free reporting tool from my perspective. How am I going to use it? To rollout Key Quality Indicators (KQIs) of course!
Educate, Communicate, and Build Relationships
Another freebee. A down economy is a great time to reach back out ot the business to understand their issues, and how you can help to resolve them. Also, take the time to formalize your message. Create a "walking deck" if you don’t have one. A walking deck is 3 or 4 slides you keep in your binder that you can present whenever the topic comes up. I use these when I meet someone new to quickly educate them on the Data Governance work at my company. It’s a relationship building opportunity that could lead to a new sponsor or commitment from a new department to join in your efforts.
Please comment with other ideas!


