Unravelling the Data Mining Mystery - The Key to Dramatically Higher Profits

Data mining is the art of extracting nuggets of gold from a set of seeminngly meaningless and random data. For the web, this data can be in the form of your server hit log, a database of visitors to your website or customers that have actually purchased from your web site at one time or another.

Today, we will look at how examining customer purchases can give you big clues to revising/improving your product selection, offering style and packaging of products for much greater profits from both your existing customers and an increased visitor to customer ratio.

To get a feel for this, lets take a look at John, a seller of vitamins and nutritional products on the internet. He has been online for two years and has made a fairly good living at selling vitamins and such online but knows he can do better but isn't sure how.

John was smart enough to keep all customer sales data in a database which was a good idea because it is now available for analysis. The first step is for John to run several reports from his database.

In this instance, these reports include: repeat customers, repeat customer frequency, most popular items, least popular items, item groups, item popularity by season, item popularity by geographic region and repeat orders for the same products. Lets take a brief look at each report and how it could guide John to greater profits.

  • Repeat Customers - If I know who my repeat customers are, I can make special offers to them via email or offer them incentive coupons (if automated) surprise discounts at the checkout stand for being such a good customer.

  • Repeat Customer Frequency - By knowing how often your customer buys from you, you can start tailoring automatic ship programs for that customer where every so many weeks, you will automatically ship the products the customer needs without the hassle of reordering. It shows the customer that you really value his time and appreciate his business.

  • Repeat Orders - By knowing what a customer repeatedly buys and by knowing about your other products, you can make suggestions for additional complimentaty products for the customer to add to the order. You could even throw in free samples for the customer to try. And of course, you should try to get the customer on an auto-ship program.

  • Most Popular Items - By knowing what items are purchased the most, you will know what items to highlight in your web site and what items would best be used as a loss-leader in a sale or packaged with other less popular items. If a popular product costs $20 and it is bundled with another $20 product and sold for $35, people will buy the bundle for the savings provided they perceive a need of some sort for the other product.

  • Least Popular Items - This fact is useful for inventory control and for bundling (described above.) It is also useful for possible special sales to liquidate unpopular merchandise.

  • Item Groups - Understanding item groups is very important in a retail environment. By understanding how customer's typically buy groups of products, you can redesign your display and packaging of items for sale to take advantage of this trend. For instance, if lots of people buy both Vitamin A and Vitamin C, it might make sense to bundle the two together at a small discount to move more product or at least put a hint on their respective web pages that they go great together.

  • Item Popularity by season - Some items sell better in certain seasons than others. For instance, Vitamin C may sell better in winter than summer. By knowing the seasonability of the products, you will gain insight into what should be featured on your website and when.

  • Item Popularity by Geographic Region - If you can find regional buying patterns in your customer base, you have a great opportunity for personalized, targeted mailings of specific products and product groups to each geographic region. Any time you can be more specific in your offering, your close percentage increases.

As you can see, each of these elements gives very valuable information that can help shape the future of this business and how it conducts itself on the web. It will dictate what new tools are needed, how data should be presented, whether or not a personal experience is justified (i.e. one that remembers you and presents itself based on your past interactions), how and when special sales should be run, what are good loss leaders, etc.

Although it can be quite a bit of work, data mining is a truly powerful way to dramatically increase your profit without incurring the cost of capturing new customers. The cost of being more responsive to an existing customer, making that customer feel welcome and selling that customer more product more often is far less costly than the cost of constantly getting new customers in a haphazard fashion.

Even applying the basic principles shared in this article, you will see a dramatic increase in your profits this coming year. And if you don't have good records, perhaps this is the time to start a system to track all this information. After all, you really don't want to be throwing all that extra money away, do you?

About The Author

Steven Chabotte is president of Big-Web Development Corp, specializing in the development of email productivity and marketing tools for the web. Steven can be reached at webmaster@maxsponder.com or you can visit our websites at http://www.maxsponder.com or http://www.maxsvc.com

In The News:


pen paper and inkwell


cat break through


The Walmart Cult

The CultBecoming a part of the Cult, consists of being... Read More

Delegating Responsibility

Too many managers waste both time and energy performing tasks... Read More

The New Economy

This technological revolution has organization, efficiency and productivity requirements well... Read More

The Supervisors 14 Essential Truths For Communicating With Direct Reports

One amazing, but sadly true, fact of today's advances in... Read More

11 Strategies on How to Work in An Open Plan Environment

Many work environments now are open plan, with only a... Read More

Virtual Assistance: A Money Saving Opportunity For Employers

What is a Virtual Assistant? A Virtual Assistant is a... Read More

Innovation Management ? Innovation or Profit?

Creativity can be defined as problem identification and idea generation... Read More

Can A Business Still Be Profitable When People Skills Are Absent?

In our current world of rapid and amazing technological advances,... Read More

Creativity and Innovation Management ? Money Doesnt Do It

Creativity can be defined as problem identification and idea generation... Read More

Why Saying Well Done Works

Encouraged by the recognition, Sarah Lewsiton went home from work... Read More

Successful Managing Through Delegation

Managers should avoid the tendency to constantly delegate to the... Read More

On The Job Training is Something You Canâ??t Afford to Skip

Trained employees are more productive employees; thereâ??s no doubt about... Read More

People Literacy

Every Manager has experienced the frustration of not understanding why... Read More

Never Punish Yourself or Others for Failures

If you want to find success in various ramifications, be... Read More

Turbo Charge Your Career With The Most Powerful Leadership Tool Of All: The Leadership Talk Part 3

To develop and deliver a great Leadership Talk, you must... Read More

Must Project Managers Be Technically Savvy?

"Must Project Managers be technically savvy?" This topic always seems... Read More

The Red Phone - Management Consulting in 30 Seconds or Less

Modern business faces complex problems; management often calls upon highly-specialized... Read More

When Change Is In the Wind...Heads Up!

In these days of takeovers and mergers, of downsizings and... Read More

Creating Advisory Boards

There is no substitute for soliciting the opinions of the... Read More

What Makes A Good Media Story?

Media relations can be difficult, but also rewarding. And the... Read More

5 Steps to Continuous Process Improvement

Part One of Creating Well-Defined Processes SeriesWhat if your sales... Read More

Tales From the Corporate Frontlines:The Importance of a Competitive Wage and Benefit Package

This article relates to the Compensation and Benefits competency, commonly... Read More

Why Businesses Need to Start Nurturing Collective Wisdom

COLLECTIVE WISDOM CAN BE AN effective tool for solving the... Read More

Indiscretion Can Kill Your Business

The quickest way to cancel out all the thought, work,... Read More

Déjà Vu MCI to Qwest International Inc: Can this Corporate Marriage Survive?

Current Situation:As of this writing, the MCI Board of Governors... Read More

The Ivory Tower Syndrome

"His cardinal mistake is that he isolates himself, and allows... Read More

Business Innovation ? Tacit Knowledge

Creativity can be defined as problem identification and idea generation... Read More

Five Essential Hiring Practices

Recruiting and hiring are often done in haste, leaving the... Read More

Understand What Flows Through Your Business to Find Improvement

I remember once seeing a cartoon which showed two people... Read More

Dont Get Side-Tracked By The Nay-Sayers

You, the Entrepreneur, are 'normally' a type-A individual. One who... Read More

How to Leverage Your Strengths for Peak Performance

Ask almost any business leader how to most effectively develop... Read More

Recruitment - What Youre Really, Really Looking For

Imagine that you're a sports coach and you need a... Read More

Employee Motivation: Make Everyone A Cheerleader For Your Company

Do you manage by walking around? What do you see?... Read More