Database: The Secret of Success

BENEFITS OF A DATABASE

By maintaining your list as a database, you can segment in many ways for targeting. Targeting improves the productivity of your offers. You can use a database to isolate the segment of your list most likely to respond to a particular offer. With a good database, you're not "mass-mailing" your offer to parts of your list that may have no interest in it (based on their characteristics). Because the number you're mailing is smaller, your response rate (number responding/number mailed) - one measure of productivity - should be higher. (And, of course, you'll save on printing and postage costs.)

Here are two simple examples of targeting using database information:

1. You're the owner of a neighborhood beauty salon. For each customer, you keep a record (with dates) of all the services you've provided to that customer. You're planning a special pre-summer promotion on permanent waves for the month of May.

Instead of mailing an announcement of the sale to your entire customer list (many of whom don't have their hair permed), you select only those customers who had a permanent at least three months ago. In this way, you're targeting those customers who are most likely to take advantage of your upcoming sale.

2. You're the dinner chairperson of a local fund-raising organization. Your mailing list is made up of a wide range of contributors, from those who've donated only a few dollars to those who give annual gifts of thousands of dollars. For each contributor, you maintain a record of all past donations and functions he/she has attended, in addition to basic mailing information.

This year, you're asking for donations of $100 a plate for the annual dinner dance. To get the best response to your invitation, you first target those contributors who were at last year's dinner dance. Then you target those who weren't at the dance, but who donated more than $100 in the past year. Depending on the response you expect from these first two groups, you may next want to target those names on your list that didn't attend the last dance, but contributed $50 in the last year. You may even want to have a phone follow-up to the first two groups but use the mailing only for the third group.

A properly set up database can provide many benefits for your business or organization. But the usefulness of a database depends entirely on what elements you include in it.

WHAT TO INCLUDE IN THE DATABASE

Depending on your type of business or organization, you will want to include different fields in your database. Later in this report you will see some examples of the fields that are appropriate in specific instances. For all businesses or organizations, though, certain basic information is always necessary.

By including basic information in your database, you ensure that the people or companies on your list are deliverable. That is, the mailings you produce using your list will get where you want them to go - into the hands of the individual who is most likely to respond to your offer.

1. Basic information for Business Audiences If your audience is made up of businesses, you will need to include the following fields for each name on your list:

a. A unique account number.

This number should not be tied into any other information about the customer, for example, phone number or address, since this sort of information may change over time. The account number should never change throughout the life of the customer. A sequential numbering system is simple and effective.

b. Company name.

c. Street Address.

d. Suite number, is necessary

e. P.O. Box, if necessary.

f. City

g. State

h. Zip Code, five or nine digit.

i. Phone number (with area code).

j. Job title or name of contact.

Some business mailers maintain the name of the individual within the customer's business or organization. Others simply use the appropriate job title. The alternative you choose will depend on the nature of your business and the amount of turnover associated with the position that is your contact.

2. Basic Information for Individual (Non-Business) Audiences If your audience is made up of individuals, you will need to include the following data for each name on the list:

a. A unique account number.

b. Individual's name.

c. Street address or P.O. Box.

d. Apartment number, is necessary.

e. City.

f. State.

g. Zip Code, five or nine digit.

h. Phone number (with area code).

The basic information listed above is necessary to make sure that the names on your mailing list are mailable. But how do you decide which names are more productive?

3. Data Elements to Evaluate - Recency, Frequency and Monetary Value

Regardless of whether you're mailing to businesses or individuals, there are three factors - recency, frequency and monetary value - that are commonly used to measure the value of a name.

a. Recency: Recency refers to the last time that the customer ordered or responded to an offer.

b. Frequency: Frequency is the number of orders or responses that the customer has made since becoming a customer (or during the last year or other specified time period).

c. Monetary Value: The monetary value is the amount of money the customer has spent since becoming a customer (or during the last year or other specified time period).

How do these three factors determine the value of a customer (the likelihood he/she will order again)?

* The more recently a customer has ordered from you, the more likely he/she will be to respond to your next offer.

* The more often a customer orders from you, the more likely he/she will be to respond to your next offer.

* The more money a customer spends with you, the more likely he/she will be to respond to your next offer.

All three factors - recency, frequency, and monetary value - are considered to be good indicators of whether or not a customer is likely to respond to a future offer.

But they are not equal. Recency is thought to be the best indicator, followed by frequency and then monetary value.

In order to use these valuable pieces of information, here are the specific fields you need to maintain on your database:

* For recency: The date of the last transaction with the customer - the date of the customer's last order, purchase or donation. * For frequency: The dates of all previous transactions with the customer over a certain period of time.

* For monetary value: The size (in dollars) of all of the customer's previous purchases or other transactions. (It is also common to maintain the dollar amount of the customer's most recent order as the monetary value indicator.)

In addition to evaluating the recency, frequency, and monetary worth of your audience, you will probably find that there are many other important ways to analyze the names on your database.

4. Additional Information for Business Audiences

If your audience is made up of businesses, there is additional descriptive information, some specific to your product or offer, that could be valuable to have.

You might want to consider storing some of the following data elements for each of the names on your database:

a. Number of employees in the business/organization.

b. Type of business/organization.

c. Annual sales volume.

d. Credit status code

The credit status code could be developed by you, based on the customer's payment history or perhaps obtained from a commercial credit report.

e. Items ordered from you.

With data in this field, you can select customer for programs designed to get them to reorder an item, or to order complimentary or supply items.

f. Location.

Is it a headquarters, subsidiary, branch, division, etc.? If you are making an offer that requires a decision by someone at the headquarters of a company, you may not want to send it to the branch office (unless there are employees involved in the decision too).

g. Source of the name.

This field is usually a code representing where you got the name. Assign a unique code for each referral program, publication advertisement, list, etc., you use to get a new name. Assigning a source code to each new customer allows you to evaluate the effectiveness of each technique you use to get customers or to collect prospect names.

5. Additional Information for Individual Audiences

If your audience is made up of individuals, you may want to collect information on the household unit, often the most relevant purchasing unit. Here are some suggestions for demographic information that could be useful to you in analyzing the names on your mailing list.

a. Household income.

b. Occupations of household members.

c. Number of people in the household.

d. Ages of the members of the household. e. Genders of members of the household.

f. Marital status of members of the household.

g. Information on property belonging to the household:

* Type of living quarters.

* Owned or rented living quarters.

* Number, make, model, etc. of each automobile.

* Number, make, model, etc. of each major appliance.h. Political affiliation.

i. Hobbies and leisure time activities.

Now you know the secrets of how a database can turn your mailing list into a valuable asset for your business or organization. You understand what basic fields to include. And you have had an overview of what additional fields might be added to the basic ones that make a list mailable. Be sure to carefully analyze your own needs and to include information that would be of help to you in mailing.

Syed Akram, Certified E-Business Consultant. We offer you e-business tools including hosting, interactive site design, webcast video conferencing, listservers, mailing list options, video recording, advertising, site traffic, and database development. http://www.onlineprofitsite.com

---

Ten Reasons Why Online Surveys Are The Future of Marketing

Customers are tough cookies. They're extremely media aware and increasingly cynical ? it's a clever marketeer who can get under their skin. Online surveys reinvent the traditional format and offer a unique way... Read More

Online Merchant Account - Costs and Alternatives

Merchant Account BasicsA Merchant Account is a commercial bank account established by a merchant to receive payment via credit cards. Three parts are required to accept credit cards. Besides a merchant account, you... Read More

The Internet and Customer Care: Aid or Anarchy?

It was reported in 'Marketing' magazine this month, that Britain is becoming a "disaffected nation", with each adult apparently making an average of 12 complaints to service providers each year, based on a... Read More

Old Habits Die Hard in the Third Age Years

I spent a lifetime in retailing and I'm still at it in retirement; albeit virtually.You know how it goes.You put up a web page and throw in some stock.Your page begets another and... Read More

Managing Project Risks and Issues

Inherent (or Business) RiskInherent Risk is the risk that exists in the environment around your portal project. It will tend to be unique to your organisation; it's culture and politics. For example, if... Read More

Tell Them Whats in The Can!

What does 'the can' mean? Well, its literal meaning relates to canned goods on supermarket shelves. If your can is up there among thousands of others, the label had better state pretty clearly... Read More

How E-commerce Web Site Design Differs From Normal Web Design

When it comes to e-commerce everything is a little bit different, even the web site design for an e-commerce site as compared to a normal web design. If you are interested in developing... Read More

Why Suppliers Should Use B2B Exchanges

Business to business e-commerce is on the rise! Worldwide B2B e-commerce revenues are estimated to reach around US$ 2 trillion in 2004. This is a significant leap from last year's US$ 1.4 trillion.... Read More

Start doing online business using B2B Portals in Six Steps

I registered with a B2B site but what's next?This is a question many first time users of B2B marketplaces ask themselves. A few expect that the registration itself will bring them a number... Read More

Starting An E-Commerce Business

The development and expansion of the Internet has made business opportunities, once only available to the wealthy, available to nearly everyone. In the past, opening a business was a huge commitment in terms... Read More

Intranet Project ? RAD or Waterfall?

Building BridgesI have often used the analogy of building a bridge to explain to business colleagues the difference between Rapid Application Development (RAD) and Waterfall.Let's say that we are in the middle ages... Read More

How To Accept Credit Cards Online

Anyone with an online business, whether for auctions, services, or virtually any type of product, has asked the same question at some time during their quest to create the ultimate online business -... Read More

Rules for Achieving Online Success

The Internet brought a great deal of benefits to our life. Access to a lot of free and useful information is, probably, one of the most important out of them. However, this abandon... Read More

Ecommerce - Boost Your Business ROI

Did you know that over 90% of all online orders are processed by credit cards and that web sites that offer customers the ability to pay with credit cards can achieve up to... Read More

Intranet Portals ? Search and Taxonomies

Knowledge Management for beginnersKnowledge Management (KM) can be defined simply as the process through which organizations generate value from their intellectual and knowledge-based assets. Knowledge assets are often grouped into two categories:(1) Explicit... Read More

Products for a Successful Web Business

There are F words in business. We have seen many small businesses on the internet flourish and fulfil their dream, but sadly we have seen some flounder and fail because they had the... Read More

Grow Your Business Using B2B Emarketplace ? Part II

Selecting the right emarketplaceAlthough, IT spending has been staying flat for the last several years, corporate spending in e-business is gaining significant ground and at present surpasses 20 percent of overall IT budget.This... Read More

Selecting The Right Shopping Cart For Your Website

Shopping Cart Installation And SetupShopping cart technology has evolved to be a must-have feature for the internet seller. Most e-merchants are aware that shopping carts function to facilitate the purchasing process. They provide... Read More

Two Pillars of a Successful Web Site

For a web site to get close to fulfilling its potential, you need absolute clarity on two points. First, achieve clarity on what your site's core purpose is Is to provide information? Is... Read More

How to Gain Your Visitors Trust

If you are serious about selling on the world wide web and being successful, your number one priority must be gaining your visitor's trust. Without trust you won't sale much and that's really... Read More

Direct Marketing isn?t all Brute Force

There are so many metrics surrounding direct marketing. So many facts, figures, test results and other sundry measurements.It's tempting to think the only thing that matters with direct marketing copy is to get... Read More

6 Steps to Attracting Black Customers Online

by Jamila White, "The E-Commerce Diva"In the rush to keep up with technology, many African-American business owners are so busy trying to add the latest bells and whistles to their Web sites, get... Read More

Your Affiliate Web Site Is Built ? Now What?

When I first got my web site built, I thought I finally had a presence on-line. Wrong! I soon found out that I needed someone to host my site, and I needed a... Read More

Shopping Carts and the E-Aisles

Have you ever gone to the store and thought you only needed a few things so you didn't grab a cart? The next thing you know your hands are full and groceries are... Read More

How To Prevent Your 3rd Party Merchant Account From Suspension

What would you do if you were sent an email from your online credit card processor telling you that your account has been suspended or frozen? How are you going to pay the... Read More

Credit Card Processing - 7 Things You Need to Know Before Opening an Online Merchant Account

When considering opening an online merchant account to accept credit card orders, there are a lot of things you need to keep in mind. The best thing to do is learn all about... Read More

Credit Card Merchant Account Basics

Knowing which credit card merchant account to get can be very confusing. There are thousands and thousands of banks, merchant account providers and third party sales teams that can offer you all kinds... Read More

The Internet Challenge

In spite of the increasing attention on how the Internet is changing the business landscape, many small business owners are still struggling to understand its influence. But unlike the ceaseless blinking of the... Read More

Distinguishing Features of E-Commerce

E-commerce offers customers the chance to eliminate many stages in the sales/distribution chain. The mark-ups that occur between manufacturers, wholesalers, distributors, retailers and consumers can add the cost of goods purchased by consumers.... Read More