Benefits of Developing & Maintaining a Database

A database is more than a simple list of names and addresses. What turns a list into a database is the additional information, coupled with your ability to select names from or report on the list using any combination of data elements.

In this report, you'll see some examples of the benefits of developing and maintaining a database. Then, the specific information that a database can contain will be detailed.

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.

The United States Government four-digit coding system, the Standard Industrial Classification (SIC) system, is commonly used to identify businesses. For example, the codes 5211 through 5999 identify "Retailers." Within that category, 5411 is the code for "Grocery Stores," 5441 the number for "Candy, Nut and Confectionery Stores." The SIC Manual is available through the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402.

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 file, 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 smarter. In report #3504, we will start explaining the details of how to go about collecting the names for your mailing list, starting with your customer list.

Copyright 2004 by DeAnna Spencer

Note to editors:
To show my appreciation to the editors that use my articles, I offer a free solo ad. Simply send an email to me by using the form on the contact me page on my website to tell me the url the article was used on or send me a copy of the ezine it was used in.

This article may be redistributed freely on the Internet as long as the resource box remains intact.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
DeAnna is the publisher of the ezine, Prospecting and Presents.
Subscribers get one free ad per week.
Subscribe today by visiting http://www.pnewsletter.com
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

In The News:

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Head-PlayStation-Marketing-Share-How/story.aspx%3Fguid%3D%257B66ECD82E-54D6-43D0-BB54-57452B34E952%257Dcid=1276623602ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNGys8Pnq20LSk548ycAXltRT6DurQHead of PlayStation bMarketing/b to Share How Sony Changed the Game b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr8 hours ago/nobr/fontbrfont size=-1Dille is a 20-year bmarketing/b veteran with over 15 years in the gaming industry, including playing a pivotal role in the launch of the original PlayStation b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Veteran-Retail-Executive-Joins-Whole/story.aspx%3Fguid%3D%257BC2C060E1-6979-445A-BBCB-FFB805274CFE%257Dcid=1276603612ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNHoKfPXIt6NMsh0Q3pBk29SMvQEZgVeteran Retail Executive Joins Whole Bakers as President, Sales b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr9 hours ago/nobr/fontbrfont size=-1McAuliff is a well known and successful retail, sports and entertainment bmarketing/b executive. For the past 20 years, McAuliff has generated millions in b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/New-Marketing-Coaching-Consulting-Firm/story.aspx%3Fguid%3D%257B37D0BC2E-0EA3-4B32-8A13-AEBEE00DA5FC%257Dcid=1276563292ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNEjCM0mGqidPs6sU8cP6hEz_1BIYQNew bMarketing/b Coaching and Consulting Firm for Physicians b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr11 hours ago/nobr/fontbrfont size=-1Concierge physician Deborah Harding, MD and bmarketing/b consultant Adam Dudley announced today the launch of their Concierge Practice Profits LLC that will b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Research-Markets-Help-Your-Company/story.aspx%3Fguid%3D%257B034F7C35-24F2-4106-92D0-1B8CAF0F116C%257Dcid=1276553954ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNFZNBmLvscP273nRBMg3Avq3zgvtwResearch and Markets: Help Your Company Distinguish Itself With b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr12 hours ago/nobr/fontbrfont size=-1You are a successful entrepreneur with a brain for business, but you#39;re indecisive about bmarketing/b and need a guide that will help your company distinguish b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/IMG-Names-Jim-Tucker-Vice/story.aspx%3Fguid%3D%257B343657B6-9A34-473C-BE62-D2975769E698%257Dcid=1276638631ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNGR_nr0SzEnq94a6GyigxWdlWDhWQIMG Names Jim Tucker Vice President, US Business Development/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr7 hours ago/nobr/fontbrfont size=-1With more than 10 years of experience in corporate sponsorship and expertise in developing, negotiating and implementing integrated bmarketing/b programs for b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://adweek.com/aw/content_display/news/client/e3if0caf66d857a98ef75c536573359246f%3Fimw%3DYcid=1276540131ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNGIYQ_qyWUq6oZ0ZiCR6k6Jcx9dUgEconomy Puts Mobile bMarketing/b on Hold/abrfont size=-1font color=#6f6f6fAdweek,nbsp;NYnbsp;-/font nobr13 hours ago/nobr/fontbrfont size=-1The service was provided free as part of a Black Friday mobile bmarketing/b push. Consumers had been invited to come to JCP.com to sign up for the call, b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Consumers-Benefit-a-Frenzy-Around/story.aspx%3Fguid%3D%257B3EA6E82C-6D99-450C-B19E-D86692E11361%257Dcid=1276720345ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNFrePXxSEBVrS5WhcbcC1jTbzvTSgConsumers Benefit from a Frenzy of Around-the-Clock Online Shopping/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr3 hours ago/nobr/fontbrfont size=-1What#39;s different this year is how early the season started, and the intensity of promotional activity fueled by social bmarketing/b. b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/East-Meets-West-With-Launch/story.aspx%3Fguid%3D%257B98C6E0E4-6A2A-4A8B-8B02-1E84E8A00D25%257Dcid=1276577453ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNHAtLZxf_s70PB5f-1r0I8CCs80jQEast Meets West With the Launch of The Melrose Collection by Fila/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr11 hours ago/nobr/fontbrfont size=-1The duo will be featured in an integrated bmarketing/b program for the debut of #39;The Melrose.#39; Through the marriage of east and west coast sensibility, b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Associated-Packaging-Technologies-Makes-Three/story.aspx%3Fguid%3D%257B966D78B4-DE74-463B-A755-911D7476A874%257Dcid=1276681865ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNFZSrAPRgei66KfZ9wbBsiLSAjWBAAssociated Packaging Technologies Makes Three Key Hires/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr4 hours ago/nobr/fontbrfont size=-1Richard Schwarz is Director of Ramp;D, Jeffery Lucash is National Sales Manager - Food Service and Distribution, and Ron Skotleski is bMarketing/b Analyst for b.../b/font/div/font/td/tr/table
table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Search-Engine-Strategies-SES-Training/story.aspx%3Fguid%3D%257B523FD694-FF5B-4292-9F9B-9D4DBDFB111A%257Dcid=1276442958ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNHEO4fg4VyHVolKaTIQSkQtMhN-UgSearch Engine Strategies (SES) Training Provides Intensive SEO b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr17 hours ago/nobr/fontbrfont size=-1Aimed at consultants, site designers, website owners, in-house bmarketing/b professionals, among others, this in-depth training occurs in a small class setting b.../b/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://searchenginewatch.com/3631910cid=1276442958ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNFvWV_riAzKTtnrsBASpPvS0cYzrgA Look Back, and a New Beginning/a font size=-1 color=#6f6f6fnobrSearch Engine Watch/nobr/font/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.prweb.com/releases/2008/12/prweb1676034.htmcid=1276442958ei=pq00SYPHAqXg6gONz9SQDwusg=AFQjCNGonTxhGHSNwyU86Hv4KU5t8c3X6AEngine Ready CEO Jamie Smith to Speak at Search Engine Strategies b.../b/a font size=-1 color=#6f6f6fnobrPR Web (press release)/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1276442958hl=ennobrall 17 news articles/nobr/a/font/div/font/td/tr/table
marketing - Google News

Business Cards that Make Them CALL

How would you use business cards for gift certificates?I asked... Read More

Behold the Power of the Tip

You are an expert. You have lots of content -... Read More

Preventive Marketing Offers Small-Mid Sized Business Owners An Ideal Way To Maximize Their Results

As the owner of a creative services boutique - I... Read More

Nine Advance Networking Skills for Seasoned Networkers

A seasoned networker knows the real meaning of networking --... Read More

Grow Your Business By Getting Your Customers Buying From You More Often - 35 Ideas

35 Ideas to Spark Your Creativity:There are 3 ways to... Read More

How Much Is Your Popcorn Worth? Powerful Lessons In Marketing & The Psychology Of Selling - Part 4

Let's continue to discuss the various marketing principles that are... Read More

Forget Conventional Marketing - Embrace the Web!

Tactical marketing processes are once again undergoing fundamental shifts from... Read More

Use a Guarantee In Your Headline To Increase Trust

Sometimes you can use a guarantee effectively in your headline.... Read More

Joint Venture: 50 Power Secrets Of Joint Venture Marketing, Exposed

What is a Joint Venture?A joint venture is an agreement... Read More

How To Start A Mail Order Business

The Mail Order business is not a business of itself,... Read More

The Marketing Recipe: Money, Marketing and Me ? 3 Keys For Success

You have a great product or service? Now, how should... Read More

Custom Lanyards - The Perfect Solution for Promotion, Branding, and Marketing

Lanyards are fast becoming the new "must have" promotional item.Events... Read More

Making Your Mark With The Millennials

Generation Y--The second-largest crop of young people in America's history,... Read More

5 Steps To Help Fail-Proof Your Growing Service Business

Business startup and failure rates are scary...In The USA...- Every... Read More

Breaking The Voice Mail Barrier

Even if you never place a cold call, you still... Read More

Marketing Gurus : Do You Need One?

Its become fashionable to bash marketing "gurus" nowadays.There are some... Read More

Celebrity Product Placement: A Primer

With more and more companies wanting to integrate their products... Read More

Marketing Tips - Ten Quick Marketing Actions

It is often difficult to manage to do marketing tasks... Read More

12 Lessons I Picked Up from Attending Seminars

So you just dropped a tidy sum to attend a... Read More

Niche with Passion and Reap Your Financial Rewards

One of the keys to creating a successful business is... Read More

Niche Marketing: The Affiliate Angle

If you're just dipping your toes into the waters of... Read More

Fundraising Letters Are Easier To Write With AIDA

Learn a lesson from professional direct mail copywriters. They follow... Read More

The YOU Factor

I don't mean you, I mean the YOU that is... Read More

Whats Your Selling Sentence?

What's your Selling Sentence? If you have a business, you... Read More

Collecting Customer Data The Easy Way

Market research is a critical component of any marketing strategy.... Read More