Title: Bank Marketing Objectives:
1Data Fusion, Data Mining, and Decision Support
System Bank Marketing in the 21st
Century Prof. Chan Chi Fai, Department of
Marketing Prof. Lai Siu King, Department of
Decision Science and Economics Prof. Lau Kin Nam,
Department of Marketing Prof. Leung Kwong Sak,
Department of Computer Science and
Engineering Prof. Leung Pui Lam, Department of
Statistics Prof. Leung Yee, Department of
Geography The Chinese University of Hong
Kong 11 June 2001
2The Introduction
by Prof. Chan Chi Fai
The Chinese University of Hong Kong
3Introduction
- CUHK research project supported by
- 0.7M Strategic Research Fund, CUHK
- 3.5M Innovation and Technology Fund
- from Industry Department of SAR
- Hong Kongs first prominent academic/business
cooperation on design and implementation of
Customer Relationship Management system for
financial institutions - A major Bank in Hong Kong participated as
industry partner to provide data for pilot system
implementation since Jan 99
The Chinese University of Hong Kong
Page I1
4The Study
by Prof. Lau Kin Nam
The Chinese University of Hong Kong
5Contents
- Bank Marketing Objectives
- Marketing Technology in the Information Era
- CRM fundamentals
- Major types of Selling
- CRM Roadmaps
- Phase 1 Data Capturing
- Phase 2 Data Cleansing
- Phase 3 Data Mining Applications
- CRM System
- Future CRM Directions
The Chinese University of Hong Kong
Page S1
6Bank Marketing Objectives
- New customer acquisition
- Cross-selling / up-selling
- Increase utilization
- Customer retention
- Win-back
The Chinese University of Hong Kong
Page S2
7Marketing Technology in Information Era
The Chinese University of Hong Kong
Page S3
8CRM Fundamentals
- Customer Focus
- Speed
- Technology
- Selling by Information
- Selling by Relationship
- Selling by Automation
The Chinese University of Hong Kong
Page S4
9Major Types of Selling
- Active Selling
- Event Triggered Selling
- Mortgage, Personal Loan
- Product Based Selling
- Campaign Management
- Passive Selling
- Customer Based Selling
- By Branch
- By Phone
- By Internet
The Chinese University of Hong Kong
Page S5
10Phase 1 Internal Data Capturing Process
CRM Roadmap
Employers
Autopay
Salary
Purchases
Purchases
Banks Internet Mall
Merchants
Retail Customers
Demographics, banking transaction
Browsing data
Card data
Banks Raw Database
Banks Raw Database
Phase 2
Phase 2
The Chinese University of Hong Kong
Page S6
11In-house data
BACK
- Types
- Product Usage Data
- Demographics
- Socio-economics
- Transactional Data
- Credit Card
- EPS
- PPS
- Autopay/payroll
- MPF
- Channel Data
- Problems
- Outdated
- Incomplete
- Isolated
The Chinese University of Hong Kong
Page S7
12Phase 2 Data Cleansing
Standardization of data and format
Identification of household relationship
Various classification schemes to convert data
to useful information
Enriched Database
External databases
fusion
update
Customer Survey
Solving missing value problems
Analytical and statistical models
Validation
Phase 3
Page S8
13Example
- Address standardization
- Unformatted 4/F., K.K. Leung Bldg., ShaTin, N.T.
- Formatted Room no.
- Floor
- Building
- Street
- District
The Chinese University of Hong Kong
Page S9
14Example
BACK
- Name standardization
- Unformatted Andrew C.F. Chan
- Formatted
- Last Name First Name Christian
Name
The Chinese University of Hong Kong
Page S10
15Example
BACK
- Mr. Chan Tai Man
- Sex M
- Age 32
- Tel. 26096000
- Address 25, 5/F., CRM building, Sha Tin,
- NT.
- Miss Lee Mei Lai
- Sex F
- Age 28
- Tel. 26096000
- Address 25, 5/F., CRM building, Sha Tin,
- NT.
The Chinese University of Hong Kong
Page S11
16Example
BACK
- Job Classification
- Address Classification
- Life-stage Classification
- Credit Card Merchant Classification
- SME Classification
The Chinese University of Hong Kong
Page S12
17Example
BACK
- Census
- Property transaction database
- CRE (Central Registration Establishment)
- TDC (Trade Development Council)
The Chinese University of Hong Kong
Page S13
18Survey
BACK
- Contact information
- Phone, Business address, Email, Website
- Updated demographics
- Marital Status, Number of dependants, Spouses
information - Socio-economics
- Job, Income, Property ownership, Car ownership
- Product Interests
- UT
- Insurance
- Deposit
The Chinese University of Hong Kong
Page S14
19 Enrichment Examples
BACK
The Chinese University of Hong Kong
Page S15
20Example
Page S16
21 Integrated Database
BACK
Category
Variables
Contact Information
e.g. Address, phone (Business/home), E-mail,
website
Demographics
e.g. Age, sex, marital status, Life stage
Socio-economics
e.g. Income, job, education, property ownership,
car ownership, social class
Household Information
e.g. Household Income, Numbers/Age of
dependants, Spouse information
Relationship Variables
e.g. Overall tenure, product tenure, past
profitability, No. of product
Product Ownership/ Usage
e.g. RFM (card), Deposit, Loan, UT, Insurance
Channel
e.g. Branch, ATM, Phone, Internet
Behavioral variables
e.g. Gambling, Travel, Degree of Luxury,
Life-style, Risk attitude
Page S17
22Next part
Phase 3 Data Mining
OLAP (query)
Customer and product segmentation
New customers analysis
Attrition Analysis
Integrated Database ready for mining
Marketing campaigns
Prediction model
Customer based selling 1. Cross selling
opportunity 2. Channel 3. CLV and ROI
SWOT on each customer segment and product
1.Acquisition criterion 2.Increase
utilization
Attrition pattern and signals
Cross selling by branch, phone, internet
Customer retention
Extract internal and external signals
Targeting, positions, pricing, bundling
Event driven selling
Strategic Marketing Plan
Cross Selling Plan
Page S18
232. Prizm scheme Lifestage ? Address class
Segmentations
1. By occupation
The Chinese University of Hong Kong
Page S19
243. by shareholders variables
Segmentations
BACK
Profitability
Tenure
The Chinese University of Hong Kong
Page S20
25Name Liu Wai ChuenAge 24Sex MaleEdu
College
Current Basket
Future Basket
Mortgage UT
Current and Past Value
Future Value
Page S21
26BACK
The Chinese University of Hong Kong
Page S22
27Campaign Management
BACK
Potential Customers in the Database
Selected
Selected
Past Campaign Results
Adopters
Non-Adopters
Page S23
28CRM System
Data Capturing
Data Retrieval
Data Analysis
Data Application
Sales Execution and Automation
The Chinese University of Hong Kong
Page S24
29 A Comparison
- Before CRM
- Selling a good product by
- Advertising
- Personal Selling
- Product Based Selling
- After CRM
- Selling a good product by
- Information
- Relationship
- Automation
- Customer Based Selling
The Chinese University of Hong Kong
Page S25
30Future CRM Direction 1. Customer Driven
Organization
Customer
Segment 1
Segment 2
Segment 3
Customer manager
Retention Officer (Loyalty Program, Building
Relationship)
Brand Equity Officer (Brand Awareness)
Value Equity Officer (Price, Convenience, Quality)
Modified from Driving Customer Equity, (Rust
Zeithaml Lemon), 2001
Page S26
31Future CRM Direction 2. Product and Service
Diversification
Information Service Middleman
Non-Banking Products
Banking Products
The Chinese University of Hong Kong
Page S27
32End of Presentation
There would be a Q A session after the coffee
break.
The Chinese University of Hong Kong
Page S28
33Coffee Break
Venue 1/F Foyer Time 1045 a.m. 1115 a.m.
The Chinese University of Hong Kong