Customers hierarchy

The Customers hierarchy contains customer demographic and purchase information, such as Customer Age, Income Bracket, Payment Method, and Ship Date.

The Customers hierarchy contains the following attributes.

Attribute

Description

Example

Age Range

The segregation of customers between a certain age group.

24 and under, 28 and above.

Customer

The name of the individual customer.

Selene Allen, Chad Laurie.

Customer Address

The postal address of the customer.

1717 Mcknight Ln, 1734 Benson St.

Customer Age

The age of a particular customer at a current point in time.

26, 38, 59.

Customer Birth Date

The date on which the Customer was born.

8/4/50, 4/30/72.

Customer City

The city where the customer resides.

Albany, Chicago, Memphis.

Customer Country

The country where the customer resides.

USA, Spain, France.

Customer Email

The email address of the customer.

hhull17@hotmail.demo, mbadour92@hotmail.demo.

Customer Gender

The gender of the customer.

Male, Female.

Customer Region

The region where the customer resides.

Northeast, South, France.

Customer State

The state where the customer resides.

Maine, North Dakota.

Days to Ship

The number of days remaining for the order to be shipped from the Distribution Center.

1, 5, 6.

Education Level

The highest level of education of the customer.

High School, Undergraduate, Graduate.

First Order Date

The date of the first order placed by the customer.

2/14/2007.

Household Count

The number of houses owned by the customer.

2, 4, over 6.

Housing Type

The type of housing owned by the customer.

Renter, Owner, Dependent.

Income Bracket

The salary range reported by the customer.

$31,000 - 40,000, $61,000 - 70,000.

Last Order Date

The date of the last order placed by the customer.

2/28/2009.

Marital Status

The marital status of the customer.

Married, Single.

Order

The tracking number associated with a particular group of items purchased.

167, 2635.

Payment Method

The way a customer pays for an order.

Amex, Check.

Phone Plan

The type of phone plan purchased by the customer.

Student, Single, Double, Family Small.

Phone Usage

The current phone usage of the customer that includes the time, date, and billing details of the call.

Active Months: 24, Average Minutes Off-peak: 412.60294, Average Minutes On-peak: 91.54584, Expire Date: 12/14/2009 12:00:00 am.

Promotion

Date range for a particular discount period under which an item is purchased (Sales Date).

9/1/06 - 9/4/06, 2/16/07 - 2/19/07.

Promotion Type

Type of discount period offered (Sale type).

Holiday Sale, Back-to-School Sale.

Rush Order

Indicates whether a customer chose to expedite delivery of an order.

1 (rush order), 0 (not a rush order).

Ship Date

The date on which an order is shipped from the distribution center.

9/15/06, 3/26/07.

Shipper

The vendor used to send products to the customer.

Pronto Packages, MailFast.

Status

The current account status of the customer.

New, Active.

Store

A retail store with location information that supports identification through the use of mobile devices.

New Design Export, General Associates Enterprise, Good’s Good Goods

Store City

The city that a store resides in.

Council Bluffs, Elk River, Liverpool

Store Country

The country that a store resides in.

Canada, Germany, USA

Store State

The state that a store resides in.

AB, PA, TX

Store Zipcode

The postal zip code for a store.

00682, 22043

Zip Code

The zip code of the area where the customer resides.

07026, 36303.

The attributes listed in the table above are some of the most commonly used attributes that are included in the logical definition of the Customers hierarchy. Refer to the following image for a complete understanding of the logical relationships of all attributes for the Customers hierarchy.