Database Reference
In-Depth Information
web site does not distinguish single types of people, those who are divorced or widowed
are included with those who have never been married (indicated in the data set as 'S').
Website_Activity
: This attribute is an indication of how active each customer is on the
company's web site. Working with Richard, we used the web site database's information
which records the duration of each customers visits to the web site to calculate how
frequently, and for how long each time, the customers use the web site. This is then
translated into one of three categories: Seldom, Regular, or Frequent.
Browsed_Electronics_12Mo
: This is simply a Yes/No column indicating whether or not
the person browsed for electronic products on the company's web site in the past year.
Bought_Electronics_12Mo
: Another Yes/No column indicating whether or not they
purchased an electronic item through Richard's company's web site in the past year.
Bought_Digital_Media_18Mo
: This attribute is a Yes/No field indicating whether or
not the person has purchased some form of digital media (such as MP3 music) in the past
year and a half. This attribute
does not
include digital book purchases.
Bought_Digital_Books
: Richard believes that as an indicator of buying behavior relative
to the company's new eReader, this attribute will likely be the best indicator. Thus, this
attribute has been set apart from the purchase of other types of digital media. Further, this
attribute indicates whether or not the customer has
ever
bought a digital book, not just in
the past year or so.
Payment_Method
: This attribute indicates how the person pays for their purchases. In
cases where the person has paid in more than one way, the mode, or most frequent
method of payment is used. There are four options:
Bank Transfer—payment via e-check or other form of wire transfer directly from the
bank to the company.
Website Account—the customer has set up a credit card or permanent electronic
funds transfer on their account so that purchases are directly charged through their
account at the time of purchase.
Credit Card—the person enters a credit card number and authorization each time
they purchase something through the site.
Monthly Billing—the person makes purchases periodically and receives a paper or
electronic bill which they pay later either by mailing a check or through the
company web site's payment system.
