Case Study Monday: B2B Database Marketing

We wanted to share today's case study because it illustrates how vital the company database can be. Sure, most direct marketers understand the importance of database marketing when we're talking about companies with hundreds of thousands of customers (think financial services or telecommunications firms). We liked this case study because it is all about maximizing customer data in an industry where the database is not typically considered a huge asset.

Industrial products firm, Lawson Products, realized success when they turned their focus on the customer, all enabled by their new focus on database marketing.

By the way, this article, in its entirety can be found in BtoB Online.

Company Background
Lawson Products sells and distributes a huge number of products—including screws, rivets and related fasteners—to the aerospace, agricultural, automotive, construction and transportation industries.

The company's 2007 sales of about $520 million was virtually unchanged from 2006. Revenue growth excluding acquisitions has been fairly slight since 2002. Further, because of its reliance on a huge but independent sales chain, the company found it had little ability to analyze customer data or track the results of its marketing efforts.

The Problem
"This is a family-owned business, and has been doing business successfully for a long time," said Lisa Kaplan, VP-corporate marketing at Lawson. "But it needed to change to keep up with the competitive set. So people like myself were brought on board to begin touching customers in a way we hadn't before."

The company, which relies on a channel of 1,600 independent reps, had no "actionable information," Kaplan said. Prior to her arrival five years ago, Lawson had no marketing department at all.

The Solution
Lawson turned to marketing firm Extraprise, whose main product, called i2i, is a conglomeration of commercially available software tools packaged under a common user interface. For Lawson, Extraprise put together a platform that at its core consisted of Microsoft's SQL Server database. In addition, Extraprise used a database cleansing tool from Firstlogic to make sure the flow of contact information into SQL Server was as accurate as possible.

To examine the newly cleaned data and formulate campaigns, Extraprise then added a database analytics system by Alterian. Another tool, already used in-house by Lawson, is a reporting and dashboard package by WebFocus. The whole process is supported by Extraprise's ongoing consulting services.

"Lawson didn't have many systems and processes defined around marketing," said Chris Baribeau, an Extraprise marketing strategist. "Our first challenge was collecting the data, putting it in a form to support Lawson's marketing needs." Baribeau said that Lawson had about 15 different databases companywide, such as Excel spreadsheets, Access files and mailing lists. All were dumped into SQL Server, cleansed by Firstlogic and examined by the Alterian application.

Kaplan said the initial task for the Alterian analytics tool was life cycle marketing, focusing on customer retention. "We had a lot of churn," she said. "We're attacking pockets of the business, and we'll see more this year. But already we're doing a better job of acquisition, penetration and retaining [at-risk] customers."

One big initial surprise from the effort, Baribeau said, was recognizing that customers tend to become inactive much more quickly than originally estimated. "After testing, we found you don't have a lot of time before a customer is inactive and must be treated as a win-back situation," he said.

Results
Because the program is only a little over a year old, the effort's ROI is still a bit vague, Kaplan said.

"The process has given us good direction on where to point, to make refinements," she said. "For the future, we're trying to drive more volume through the tool with greater impact."

However, the process has enabled Lawson to better identify its best potential customers; best products and specific pricing; and ideal industries and customers. Analytics, in turn, is helping predict attrition, as well as life cycle, segment and product marketing, as well as lay the groundwork for improvement in each area.

Case Study Monday: InfoCentricity and First National Bank of Omaha

As you know, we are firm believers in the power of data and analytics. When direct marketing professionals are able to use technology to improve performance, I love hearing about it. We hope you do, too :)

Here's a success story from InfoCentricity, an analytic solutions company that helps companies discover and leverage key insights hidden in their data. Their software, Xeno, helps direct marketers and risk management professionals build predictive models, perform profiling and create clustering solutions.

First National Bank Investing Successfully in Predictive Analytic Initiatives

In a recent marketing campaign, the bank achieved a 10 percent increase in net response rates using prediction scores developed with InfoCentricity's Xeno.

With over $17 billion in managed assets and over 7,500 employees, First National Bank of Omaha ranks as one of the fifty largest banks in the U.S. First National is the fifth-largest in-house credit card processor, the seventh-largest merchant processor, a top-ten commercial card issuer and the eleventh-largest issuer of bank cards in the United States.

The Challenge

First National's card division is growing fast. With close to two million active customers in the credit card division alone, successfully managing and retaining its current customers, as well as intelligently reaching out to new customer prospects, is an ever-increasing challenge.

Needle in the 10 Terabyte Haystack

According to Vice President Mihaela Kobjerowski, who manages the bank's Decision Science group working with the credit card divisions building predictive models to help determine who to market to, who to extend credit to--and how much--is also becoming more difficult.

Analysts sift through more than 10 terabytes of information dating back 10 years to find specific nuggets of information that might suggest trends. In addition to the rapidly growing customer database, credit card customers often post multiple transactions per day. Plus, the bank further enriches its data warehouse by regularly purchasing third party credit bureau and demographic data.

Prior to incorporating InfoCentricity's Xeno predictive modeling tool into their analytic environment, most of the bank's model development work was done in SAS. "We are a heavy user of SAS, but in the predictive analytics area we found that a significant amount of our analysts' time was being spent on coding, instead of analyzing what the data was telling them," Kobjerowski said. "Using Xeno we are able to do modeling that we were not previously able to do at the same level of detail, and then download the Xeno code seamlessly into SAS. A very powerful solution."

So, what did all that number crunching get them?

The Results

First National added a substantial number of new credit card accounts in 2006, the success of which can easily be associated with the efforts of the Decision Science group. The company's annualized growth rate in the last quarter was in double digits--well above the industry average. In the new account acquisition program alone, the group has more than 100,000 tests from 2006 alone to read and model. "Xeno provides a very robust tool to get insight into so much data," Kobjerowski said.

Kobjerowski said a recently completed model development project for marketing showed the performance of the score improved by as much as 30 percent through new development work using Xeno. That translated to a 10 percent increase in net response rates for a large marketing campaign, while also increasing approval rates. "That is huge in our world," Kobjerowski said.

Well, it's huge in our world, too!

Kudos to First National Bank of Omaha and their technology partner, InfoCentricity.