contain the following information:
1. Transactions – a complete history of the
purchases made by the customer,
including purchase date, the SKUs
purchased, the price paid, the amount of
profit, and whether the merchandise was
purchased in response to a special
promotion or marketing activity.
3. Customer Preferences – what the
customer likes, such as favorite colors,
brands, fabrics, and flavors as well as
apparel sizes.
4. Descriptive Information – Demographic
and psychographic data describing the
customer that can be used in developing
market segments.
5. Responses to marketing activities –
analysis of the transaction and contact
data provide information about the
customer’s responsiveness to marketing
activities.
To demonstrate how a customer database could
have very simple beginnings, ask students the
types of information contained in a typical invoice.
Note that each transaction invoice would contain
details on the customer’s name and address,
products and quantities purchased, price paid, etc.
If a whole year’s invoices were collected, what
types of information could be obtained?