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


AddThis Social Bookmark Button

In The News:


New York Times

Under New Management Why Should Recession Stop the Recruiters?
New York Times, United States - 13 hours ago
In a survey in early October of nearly 450 human resources officials by the Society for Human Resource Management, some 39 percent thought that future ...

AIG to Sell ILFC to Management Group, Udvar-Hazy Says (Update2)
Bloomberg - Nov 21, 2008
“We’re in the process of selling ILFC to a group of investors including management that will take back the company from AIG,” he said earlier at the ...
AIG to sell plane lessor ILFC to investors- report Reuters
all 27 news articles

Gothamist

UPDATE 1-Owners battle over fate of 65 Steve & Barry's stores
Reuters - Nov 21, 2008
... the new owners of Steve & Barry's -- investment firms Bay Harbour Management and York Capital Management -- filed for bankruptcy protection on Wednesday ...
Steve & Barry’s to liquidate Bizjournals.com
Steve & Barry's again files for bankruptcy Newsday
Steve & Barry's plans closing store at mall Monroenews.com
Bizjournals.com - Bizjournals.comall 282 news articles

The Republican - MassLive.com

MassMutual Announces Promotions for Two Co-Chief Operating Officers
MarketWatch - Nov 21, 2008
Bill has also proven his exceptional capabilities as a leader in the asset management business and in building strong financial services organizations," Mr. ...
MassMutual promotes pair in succession plan The Republican - MassLive.com
MassMutual Life promotes COOs Bizjournals.com
MassMutual Names New President Hartford Courant
Markets Media (press release) - MarketWatchall 45 news articles

Cloudbreak Resources Ltd.: Amended and Restated Management ...
MarketWatch - Nov 21, 2008
... the Company has, with the assistance of the BCSC, revised and re-filed its annual Management Discussion and Analysis for the year ended April 30, ...

Orr Construction Management wins Greensburg streetscape contract
Bizjournals.com, NC - Nov 21, 2008
Kenny Orr, president of Raytown-based Orr Construction Management Inc., attends City Hall groundbreaking ceremonies Oct. 10 with Orr's Garden City-based ...

Dallas school officials missed, misread signs of deficit
Dallas Morning News, TX - 2 hours ago
For anyone trying to understand how the budget mess developed, Deloitte & Touche's 2006-07 audit – and its accompanying "Report to Management" – is a good ...

Target Corp. Won't Pursue Pershing Real-Estate Plans
Wall Street Journal - Nov 21, 2008
... structure ideas proposed by activist investor Pershing Square Capital Management LP, calling the potential value of the deal "highly speculative. ...
Target rejects Pershing's real estate proposal Reuters
Target rejects Pershing's proposals on real estate structure MarketWatch
Target Corporation Announces Decision on Real Estate Structure ... WELT ONLINE
Financial Times - MSN Moneyall 417 news articles

Winning Management Lessons From the NFL
MSNBC - Nov 21, 2008
So when you find yourself scrambling for new clients or having to deal with a notoriously difficult employee, recall these seven management lessons that ...

Regional workshop on management of ship balance waters begins
Yemen News Agency, Yemen - 1 hour ago
... Presidency of Metrology and Environment Protection arrived on Sunday in Aden to take part in a regional workshop on management of ship balance waters. ...
management - Google News
Your Ad Here

Games at Buy.com

Holiday Home Store at Buy.com

Introducing the 15 Frameworks of Successful Self-Employed Professionals

A framework is a way of thinking, a point-of-view, a perspective on something. Here are the 15 frameworks of the successfully self-employed professional. You'll find some of... Read More

Cultural Awareness - an HR Perspective

The use of cultural awareness training has increased rapidly in the majority of global companies over the last decade.My experience working in global companies in which effective... Read More

How to use NLP for Business?

What is Neuro-Linguistic Programming?Neuro-Linguistic programme is nothing but the study of human excellence. It is an art. It teaches you to be at the very best. It... Read More

5 Ways to Work More Effectively With Your Administrative Assistant

Stop hiring new administrative support staff. And learn how to retain your existing administrative staff.Are you a manager, director or other senior-level personnel who wants to work... Read More

Group Meeting Disrupters

MEETING DISRUPTERS: If two participants are carrying on a personal discussion that interferes with a meeting, direct a clear and simple question to one of them. In... Read More

Creativity and Innovation Management: Generating Better Ideas

Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation. There are other useful definitions for... Read More

Successful Business Decision Making

Some people make decisions without any difficulty, while others struggle. Are you having trouble making a decision? Do you feel overwhelmed by all the choices you have,... Read More

25 Great Ways to Find the Right People and Not Break the Bank

Are you trying to hire dozens of hourly workers or a senior executive? Where do you look and how do you get the word out? There are... Read More

The High, High Price of Distrust

A paper manufacturer with over 300 employees once announced that it was planning to move to more spacious and attractive premises thirty miles down the road. When... Read More

Creativity Management - The Value of Being Prolific

When asked his secret to success, the author Graham Green said that it was down to his always writing 500 words a day. There are real reasons... Read More

The Seven Cs: Partnership Danger Signs - Conflict Becoming the Norm ? Part 2

A series of articles exploring the seven critical areas that can indicate a partnership is in trouble.Conflict Becoming the Norm ? Part 2In a previous article, I... Read More

10 Ways To Work Through A Business Slowdown

In running any kind of business, it's inevitable that sometimes business will slow down. This might occur due to an upcoming holiday, seasonal variations, or uncontrollable circumstances.... Read More

Communication in Business

Effective communication in business is not about creating the perfect PowerPoint presentation. It's not about writing the perfectly-pitched report. It's not even about assiduously alliterating {smile}.Sometimes effectively... Read More

Ten Problem Solving Techniques

Do you ever need to find some good ideas, or come up with a solution for a persistent problem? Learn some simple problem solving techniques, and start... Read More

Re-Discovery Procedures for Building Effective Management Systems: Phase V

Now we turn the corner to our final phase: Re-Discovery.Last year marked the 200th anniversary of the expedition of Lewis & Clark, and much has been written... Read More

Business Intelligence & Data Warehousing in a Business Perspective

Business IntelligenceBusiness Intelligence has become a very important activity in the business arena irrespective of the domain due to the fact that managers need to analyze comprehensively... Read More

Delegation - The Basic Steps To Reducing Your Workload And Creating A Successful Team

If you have a task greater than you can handle on your own, then you need to delegate. Not a choice many of us choose to make,... Read More

Project Management - The Traveling Product Manager

Various studies ? and common sense ? indicate that involving customers increases the likelihood that your product will meet customer requirements (I hope these studies weren't funded... Read More

Hows Your HUB?

Marketing gurus are always coming up with new lingo but oftentimes they are restating the old tried and true concepts in new terms. Marketing students from the... Read More

Islam in the Workplace

Suggested practice for HR personnelMuslims now form one of the largest religious groups in the UK. At a time when great misunderstandings and stereotypes circulate the media... Read More

Do You Hear That?

I read a report in the Toronto Star stated that 70% of workplace errors happen because of communication breakdown and that many of them directly relate to... Read More

Basic Management Skills

Recent studies have shown that industrial supervisors are working at less than 60 % of their potential. Basic management skills training is guaranteed to change all this... Read More

Creativity and Innovation Management: The Value Of Due Diligence

Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation. There are other useful definitions, for... Read More

Management Team Section of Business Plans

Writing an award winning business plan is a great skill, but rather than winning any awards you need to get funded. In order to be funded the... Read More

Delegate or Die!

You Can't Do It All - Learning To DelegateThere is not a single management skill more critical to your personal and professional success as an entrepreneur than... Read More

Does Your Management Style Remind People Of Something They Read In Dilbert?

With thanks to Jeff Foxworthy, the comedian who does the "You might be a redneck series of jokes.If you really believe people in your group are lucky... Read More