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:


Google News
Updated : Wed, 09 Jul 2008 01:08:02 GMT

Iraq wants US withdrawal deadline - CNN


Telegraph.co.uk
Iraq wants US withdrawal deadline
CNN - 2 hours ago
BAGHDAD, Iraq (CNN) -- A deadline should be set for the withdrawal of US and allied forces from Iraq, and the pullout could be done as soon as 2011, an Iraqi government spokesman said Tuesday.
Video: Iraqi PM Calls for Withdrawal Date AssociatedPress
UPDATE 1-Pentagon chief downplays Iraqi calls for withdrawal Reuters UK
The Associated Press - BBC News - AFP - NewsHour
all 1,489 news articles

Publ.Date : Tue, 08 Jul 2008 22:32:49 GMT

Obama proposes bankruptcy changes - Atlanta Journal Constitution


Voice of America
Obama proposes bankruptcy changes
Atlanta Journal Constitution - 1 hour ago
By AARON GOULD SHEININ Barack Obama moved Tuesday to paint the 2008 presidential election in stark terms of rich vs. poor, and fat cats vs.
Ad Hawk: McCain's Generation Gap Newsweek
Obama ad attacks McCain on energy solutions The Associated Press
Washington Times - Daily Vidette - Los Angeles Times - MSNBC
all 2,097 news articles

Publ.Date : Tue, 08 Jul 2008 23:41:26 GMT

McCain, Obama pitch economic plans to Hispanics - Kansas City Star


Voice of America
McCain, Obama pitch economic plans to Hispanics
Kansas City Star - 42 minutes ago
By LIZ SIDOTI and CHARLES BABINGTON AP Writers Democratic presidential candidate Sen. Barack Obama, D-Ill., left, accompanied by Los Angeles Mayor Antonio Villaraigosa, waves, Tuesday, July 8, 2008, at the League of United Latin American Citizens in ...
McCain, Obama pitch economic plans to Hispanics The Associated Press
Obama Assails McCain on Immigration Before Latino Audience Washington Post
Monsters and Critics.com - McClatchy Washington Bureau - HispanicBusiness.com - KCRG
all 387 news articles

Publ.Date : Wed, 09 Jul 2008 00:25:20 GMT

VMware Ousts CEO Greene - BusinessWeek


Wall Street Journal
VMware Ousts CEO Greene
BusinessWeek - 1 hour ago
by Aaron Ricadela VMware ended a long-running battle over its strategic direction on July 8, ousting co-founder and Chief Executive Diane Greene and installing Microsoft veteran Paul Maritz in her place.
VMWare Drops 25% Of Market Cap; CEO Out Washington Post
Why VMware Dumped Diane Greene Forbes
Wall Street Journal - MarketWatch - The Associated Press - CRN
all 343 news articles

Publ.Date : Tue, 08 Jul 2008 23:18:50 GMT

Bad blood hampering Obama's effort to help retire Clinton's debt - Kansas City Star


Wall Street Journal
Bad blood hampering Obama's effort to help retire Clinton's debt
Kansas City Star - 44 minutes ago
By PATRICK HEALY A prominent donor to Sen. Barack Obama recently sent an e-mail plea to other supporters, asking them - for the sake of Democratic unity - to write checks to Sen. Hillary Rodham Clinton to help retire her $23 million in campaign debt.
While Markets Peer Ahead Wall Street Journal
Research firm: Obama outpacing McCain in Web-site traffic, online ... Computerworld
411mania.com - National Review Online - WHSV - United Press International
all 227 news articles

Publ.Date : Wed, 09 Jul 2008 00:23:52 GMT

Wildfires push some from homes; some allowed back - The Associated Press


Canada.com
Wildfires push some from homes; some allowed back
The Associated Press - 2 hours ago
BIG SUR, Calif. (AP) - Firefighters pushed back a blaze threatening this small coastal community just enough to allow hundreds of people to check on their homes Tuesday as a separate fire 300 miles north forced residents of another town to evacuate.
Video: Hot, Dry Weather Developing on Calif Fire Lines AssociatedPress
Much of US West Coast Under `Explosive' Fire Threat (Update2) Bloomberg
KSBY - CNN - RedOrbit - Lompoc Record
all 4,534 news articles

Publ.Date : Tue, 08 Jul 2008 22:40:34 GMT

Whistleblower: Cheney Wanted Cuts in Climate Change Testimony - ABC News


ABC News
Whistleblower: Cheney Wanted Cuts in Climate Change Testimony
ABC News - 35 minutes ago
By Z. BYRON WOLF President Bush is in Japan pledging to do his best to put the US on a long-term path to cut greenhouse gas emissions in half by 2050, but back in Washington a former Environmental Protection Agency official said staffers at the White ...
Cheney wanted cuts in climate testimony USA Today
Cheney's Office Pushed Purge Of Climate Change Testimony Wall Street Journal
Washington Post - Reuters - The Associated Press - Bloomberg
all 513 news articles

Publ.Date : Wed, 09 Jul 2008 00:32:45 GMT

RSS2Blog
Add RSS Feeds To My Web Pages


PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

Top 10 Things Every Business Should Provide for Every Worker - Including the Boss!

Doing business and meeting the needs of workers is increasingly... Read More

Gift Giving for Business a Major Headache

Corporate gifting is a big headache for most business owners;... Read More

Thoughts on Empowerment

People are empowered when they are given the authority and... Read More

The Top 10 Requirements for Your Business to Become and Remain Profitable

We live in a relentlessly competitive world. The daily pressure... Read More

Outsourcing NOT Just for Big Business

Outsourcing has become a controversial issue and a hot topic... Read More

Performance Expectations - 5 Tips and 5 Questions

People want to understand their role - they want to... Read More

Keeping Team Meetings Vibrant

Meetings can be the life-blood of an organisation or the... Read More

Ten Relationship Traits And Skills For Good Leadership

An important aspect of good leadership is the ability to... Read More

Online Business Peace of Mind

Is your online business disaster-proof? Online businesses face a unique... Read More

One Simple Idea to Grow Your Business

Perhaps the most common theme I've heard in working with... Read More

3 Keys to Being a Fearless Executive

In my work with business executives, I have come to... Read More

To Thine Own Self Be True--Its Better for Business: What Arthur Andersen Would Say to His Company

As a child, you probably heard, "to thine own self... Read More

Argue Your Way To Business Success

"Jack" (not his real name) is a vice president of... Read More

Hire Winners: Avoid These 10 Interview No-No?s

Have you ever hired someone who did not live up... Read More

Internal Control - The Why and How

Many retailers do not have good internal controls in place... Read More

What is Knowledge Management Anyway?

When you think of all the things companies have, you... Read More

Delegate Tasks to the Right Person

SELECTING THE RIGHT PERSON: To whom should tasks be delegated?... Read More

Meaningful Diversity: Creating Cultures of Inclusion

In the fitness room the other day, I caught a... Read More

Implementation the Catalyst of Change for Management to Reach that Next Level of Success

From the personal and professional experiences of other colleagues and... Read More

Leadership Skills

Recent studies have shown that industrial supervisors are working at... Read More

Holding Effective Meetings Can Be Easier than You Think!

I'm sure you've experienced those typical "headache" meetings! You know... Read More

Managing Dickheads

"We are so different and individualistic that we can't work... 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

Manage or Lead ? Why the Difference Matters and What to Do About That Difference

Many books have been written about managing people, and an... Read More

Time Management Tip: Stop Micro-Managing Employees

If I was a fly on the wall what would... Read More