Slide 1Slide 2The Value of Database InformationCRM and the Database ProcessWhat is a Database?The Purpose of a Customer DatabaseMarketing Research & Data EnhancementThe Dimensions of a Typical DatabaseThe Dynamics of Database DevelopmentDeveloping a Database: A ProcessRules of Thumb in Database DevelopmentDatabase SystemsData WarehousingData MiningDatabase ModelingSummary of Learning Objectives1995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved.1995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. CCHHAAPPTTEERR1234 0001 897251 0000066Marketing Research and Marketing Research and Database DevelopmentDatabase Development6-26-21995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. The Value of Database InformationCategorizing customer data in a systematic, timely manner has become a critical function of marketing research.Marketers can develop the ability to identify customers on an individual basis. Marketers can rank a customer’s transactions over time. Marketers can begin to access a “portal” where they can know what customers might or will purchase!6-36-31995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. CRM and the Database Process The foundation of a sound CRM process is an ability to provide shared information across an organization. Marketing Research and Information Technology must “blend” together to build profiles of individual customers and react to their desires in a proactive way. Databases, data warehouses, and data mining work in tandem using real-time data captured from customers to nurture and retain happy customers! 6-46-41995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. What is a Database? A database is a collection of information indicating what customers are buying, how often they buy, and the amount they’ve bought.6-56-51995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. The Purpose of a Customer Database Develop meaningful communication with customers. Improve the efficiency of constructing market segments. Increase the probability of repeat purchase behavior.6-66-61995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Marketing Research & Data Enhancement Data enhancement allows a business enterprise to: Obtain more knowledge of customers. Increase the effectiveness of marketing programs. Predict responsiveness to changing marketing programs.6-76-71995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. The Dimensions of a Typical Database6-86-8Source Data• Geographic Market• Residential AreaGeodemographic• Attitudinal• MotivationalAttribute• Demographics• Volume UsageTarget Market1995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. The Dynamics of Database DevelopmentThe information generated for a database should possess the following four characteristics:1) Affinity2) Frequency3) Recency4) Amount6-96-91995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Developing a Database: A Process6-106-10Determine Value of InformationIdentify Research NeedsExternal Data onBehavior andMotivationsCurrent CustomerStatusDatabase Processing SystemGeneral Predictive ModelImplement Marketing ActionNew CustomerStatusTarget MarketCharacteristicsInternal Data onCurrent CustomerProfile1995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Rules of Thumb in Database Development Database development is a protracted process which requires commitment to a long-term vision for data acquisition. Collect the data which will have the greatest impact for the future at the outset of the process. View the database in terms of “depth” – the overall number of data fields and variables. View the database in terms of “width” – the overall number of records.6-116-111995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Database SystemsTwo types of database systems exist: Sequential Systems Relational Systems6-126-121995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Data WarehousingStoring information in a data warehouse is an ongoing and iterative process, comprised of the following kinds of data: Subject-Oriented Information Integrated Information Time-Variant Information Nonvolatile Information6-136-131995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Data Mining6-146-14The MarketingResearch QuestionThe Data MiningApproachThe Data MiningTechniqueThe MiningImplementation ProcessThe VisualMining Product1995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Database ModelingScoring Models rank customer segments based on the profit potential they have for the business enterprise.Lifetime Value Models use actual purchase behavior to predict future buying patterns.6-156-151995 7888 4320 000 000001 00023Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved. Summary of Learning ObjectivesIllustrate and define a marketing research database.Explain the interactive nature of marketing research and data enhancement.Describe the dynamics of database development.List the general rules of thumb in database development.Demonstrate understanding of technology in a database context.Illustrate the development and purpose of the data warehouse.Explain the process of data mining as it relates to the data warehouse.Understand the role of modeling in database