CRM adoption and implementation proposal

profilejeefojvn
Cust.RelationshipMgmt.SectionY01Fall2018CO-11272018-1102PM.zip

content/Unit4/Section 0 Unit 4.html

Unit 4: Databases

In this unit we will study the various classifications of databases and the contents of those databases. We will begin with a study of the types and use of these databases and conclude with a overview of data mining.

CRM.gif

content/Unit4/Section 1 Unit 4 old.html

1.0 Types of Databases

Categorization:

  • Based on their main business functions

    • Databases managing business operations

    • Databases supporting decision-making activities

Alternate categorization:

  • According to the information included in the databases

  • Based on the nature of the underlying marketing activities

  • Based on the database technology used

2.0 Categorization Based on Information in the Databases

Types of databases:

  • Customer database

  • Prospect database

  • Cluster database

  • Enhancement database

2.1 Customer Database

  • Data from active and inactive customers

  • Basic information: name, address, zip code, and telephone number

  • Demographic information: age, gender, marital status, education, number of people in household, income

  • Psychographic information: values, activities, interests, preference

  • Transaction history: frequency of purchase, amount of spending

  • Other relevant information: inquiries and referrals, satisfaction, loyalty

  • Data from inactive customers:

2.2 Prospect Database

  • Non-customers that have profiles that are similar to the profiles of existing customers

  • Segments prospects and positions the company’s differentiated products to the prospects’ specific needs

  • Examples of some Prospect databases used in the industry:

    • The InfoBaseR list

    • Harris Selectory Online

2.3 Cluster Database

  • Clusters defined based on geographic reference groups, affinity groups, and lifestyle reference groups

  • Depending on the membership of prospective customers to specific clusters, firms can customize their marketing communications

  • Example: The Prizm database which Segments every U.S neighborhood into 62 distinct areas

2.4 Enhancement Database

  • Used to transfer additional information on customers and prospects

  • An overlaying process is used that eliminates duplications

  • Enhancements may include demographic and psychographic data, transaction history, changes in address, changes in income levels, privacy status, new product categories bought recently

  • Example: InfoBaseR Enhanced which provides a large collection of U.S customer information like telephone & address data, mailing lists including hotline files, e-mail data

content/Unit4/Section 3 Unit 4.html

3.0 Technology Categorization Based on Database

  • Hierarchical database

  • Inverted database

  • Relational database

3.1 Hierarchical Database

  • All information pertaining to a customer will be in a master record

  • Useful when the queries are standard and routine but high speed processing is required

  • Preferred in the banking, airline and hotel industries

3.2 Inverted Database

    • Suited for direct marketing applications

    • Has speed and flexibility to respond to unanticipated questions

    • Easy to add new elements to an inverted database as and when updated information is acquired

3.3 Relational Database

  • Has the greatest flexibility, but slower speed

  • Examples are Databases like Oracle, SQL Server, and Microsoft Access

  • Users can create queries to extract information from these tables and recombine it

Table of Contents.html

 
Cust. Relationship Mgmt. Section Y01 Fall 2018 CO - Unit 4 Notes

1. Introduction - Databases

2. Types of Databases

3. Technology Categorization of Databases