AnalyticsROI MarketingCustomer Data Is not Dirty Laundry

Customer Data Is not Dirty Laundry

Often scattered and rumpled, torn and discarded, customer data doesn't deserve the ill treatment it's getting at some companies.

Although nearly every business would claim that the information it gathers about its customers is a mission-critical, strategic asset, many don’t treat this “asset” accordingly. Most customer data is left lying around in different systems and in various stages of completeness and quality — not unlike dirty laundry.

It would appear that, though businesses cheerfully spend incredible amounts of time and money collecting customer data, they seem far less adept at turning this data into actionable information.

Customer Data Segmentation Framework

This is no small problem. For most organizations, customer information represents a huge amount of data, which gets bigger and more complex every day. When you look through the many different applications and systems of a modern corporation, you realize that nearly every major system has some type of information that is either about customers or relates to their actions.

And though some types of information change daily (sales transactions), other information does not (client name and address). Some types of information become old and worthless after a few months; yet for other types, the information is just as valuable as ever. To ensure the timeliness and value of customer information — and to help understand what types of information goes where — organizations develop “knowledge maps,” which comprise different categories for customer information, helping them to manage it and keep it up to date and well cared for.

One of the most popular knowledge maps, or metadata, about customer information is called a customer data segmentation framework, which is a sort of outline for organizing and thinking about such a huge amount of data.

Strategic Versus Tactical

The first task in creating a customer segmentation framework involves classifying customer data into strategic and tactical categories.

Strategic categories are broad, long standing, and elemental to the business you’re in. For example, if you’re an insurance brokerage, you know that you sell to businesses and individuals. Thus, corporate risk managers represent a customer segment that will be relevant to your business over the long run.

These strategic categories are defined by market analysis, competitive intelligence, and opportunity assessment. They can be further refined and more clearly detailed via data analytic tools such as online analytical processing (OLAP) for multidimensional queries and reporting or a descriptive data mining model called “clustering” to better define market or consumer strategic segments.

Cluster Analysis

Clustering is often used to define market segments by looking at the contributing attributes of a known outcome. For example, cluster analysis is used to discover the traits and features of high-value customers. These traits are then often used to filter customer prospect information, to highlight those prospects that share the same attributes as current high-value customers. These prospects represent superior potential value as customers and, accordingly, deserve special marketing and customer service attention.

Tactical customer segmentation is more fluid and dynamic. It should be refined and tracked more frequently and is usually defined via implicit and explicating profiling techniques.

Categories include:

  • Demographic: age, income, and financial/credit status for individuals; standard industrial classification (SIC) code, business financials, and Dun & Bradstreet ratings for companies
  • Behavior: buying habits, including recency, frequency, and monetary value; service history; and response and conversion rates to different marketing campaigns
  • Preferences: content, interests, navigation paths, and search-word selections; channel of preference
  • Lifecycle stage: anywhere from awareness, trial or first purchase, repeat purchase, and loyal customer status
  • Perception: attitudes, brand recognition, and perceived traits

Predictive Modeling

To create and maintain these buckets of short-term, tactical information, customer intelligence analysts use a combination of data warehousing and data mining techniques.

For predefined views of customers, analysts pull information sets from a relational database that serves as the repository of all stored information — called a data warehouse — and create multidimensional “cubes.” These cubes represent physical data structures that are optimized to process queries. These data structures are queried via OLAP techniques.

For more detailed analysis, data experts use specialized applications called data mining programs to help them uncover hidden patterns and unforeseen contributing attributes in the data and, in doing so, help them construct more informed (OLAP) queries.

A category of smart data mining applications known as predictive modeling, such as classification, regression, and sequencing, helps companies more accurately predict the future demand or behavior, relative to other independent variables.

Got an opinion on this stuff? Willing to share it? If so, please write.

Related Articles

6 ways to increase your conversion rate using behavioral data

Analyzing Customer Data 6 ways to increase your conversion rate using behavioral data

4w Mike O'Brien
Influencer marketing: Eight tools to identify, track and analyze your brand's next biggest fan

Content Influencer marketing: Eight tools to identify, track and analyze your brand's next biggest fan

4w Tereza Litsa
Tools and tips for calculating the ROI of social media

Conversion & ROI Tools and tips for calculating the ROI of social media

4w Clark Boyd
How to use behavioral data to enhance your website's conversion rate

Analytics How to use behavioral data to enhance your website's conversion rate

2m Chris Camps
Big data in the travel industry: How can travel companies do more to collect and use customer data?

Analyzing Customer Data Big data in the travel industry: How can travel companies do more to collect and use customer data?

2m Clark Boyd
How machine learning can help you optimize your website's UX

AI How machine learning can help you optimize your website's UX

1m Chris Camps
Why banks are becoming customer-centric organizations

Analyzing Customer Data Why banks are becoming customer-centric organizations

1m Al Roberts
How to achieve true omnichannel relevance

Analyzing Customer Data How to achieve true omnichannel relevance

1m Clark Boyd