-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathcrm_data_integration.htm
216 lines (176 loc) · 10.8 KB
/
crm_data_integration.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
<HTML><HEAD><TITLE>CRM and Data Integration</TITLE></HEAD>
<BODY TEXT="#202020">
<TABLE BGCOLOR=blue WIDTH=90%>
<TR>
<TD ALIGN=left VALIGN=top>
<IMG ALT="Database Answers Header" HEIGHT=67 WIDTH=417 SRC="images/ivans_dba_logo_alt.jpg" SouRCe="images/dba_banner_and_btn_400.jpg">
</TD>
<TD ALIGN=right ROWSPAN=2 VALIGN=top>
<A HREF="images/north_wales/conwy_castle.jpg"><IMG ALT="Conwy Castle, North Wales" BORDER=1 HEIiGHT=106 WIiDTH=180 SRC="images/north_wales/conwy_castle_sml.jpg"></A>
</TD>
</TR>
</TABLE>
<FONT COLOR=blue FACE=Verdana SIZE=2>
<!-- end Standard Header - Version 3-->
<TABLE BGCOLOR="#0000FF" WIDTH=90%>
<TR>
<TD ALIGN=left COLSPAN=1 VALIGN=TOP WIDTH=40>
<A HREF="index.htm"><IMG ALT="Home" BORDER=0 SRC="images/buttons/button_studio/home.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=100><A HREF="ask_a_question_rbw.php3">
<IMG ALT="Ask a Question" BORDER=0 SRC="images/buttons/button_studio/ask_a_question.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=85><A HREF="data_models/index.htm">
<IMG ALT="Data Models" BORDER=0 SRC="images/buttons/button_studio/data_models.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="faqs.htm"><IMG ALT="FAQs" BORDER=0 SRC="images/buttons/button_studio/faqs.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="search.htm"><IMG ALT="Search" BORDER=0 SRC="images/buttons/button_studio/search.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=62>
<A HREF="site_map.htm"><IMG ALT="Site Map" BORDER=0 SRC="images/buttons/button_studio/site_map.gif"></A></TD>
<TD ALIGN=right VALIGN=top><FONT COLOR=white face="Verdana" size="1"> </TD>
</TR>
</TABLE>
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<!-- end Standard Header - Version 3-->
<!-- begin body Text -->
<TABLE BGCOLOR="#98CEFD" BORDER=0 WIDTH=90%>
<TR>
<TD ALIGN=left VALIGN=top>
<IMG ALT="Beach at St.John in the Caribbean" BORDER=0 HEIGHT=120 WIDTH=100 SRC="images/beach_at_stjohn.jpg"></A>
</TD>
<TD><PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Current CRM Systems such as Siebel and BroadVision provide a
significant step forward in the ability of an organisation to manage customer data in order to understand,
evaluate and respond to customers more effectively.
Call Centres and Web Sites are creating a range of new "touch points" from which to gather customer data.
This data can then be analysed to identify patterns of buying and usage.
A marketing strategy must be geared toward achieving a One-to-One relationship with the Customer, and an
"individual feedback loop" where customers feel that they are known, remembered, listened to, and offered
the appropriate product or service.
Building such an intimate relationship with customers not only makes them loyal, but it increases
their lifetime value and profitability.
<B>CRM Data</B>
This creates a need to handle Customer data consistently across the organisation and
provide faciltiies for integration within the organisation.
The integration of this data from a range of source with exsting Customer data is of
vital importance in achieving a unified view of the customer.
If the ultimate goal of an enterprise is to develop synergy with customers through
interactive relationships, then it is necessary to build an enterprise view of that customer.
Inherently, this requires creating an "infostructure" that integrates data from all
Business Units and operational systems, enriches it with external data, and provides
analysis facilities for CRM Planning and Delivery.
A comprehensive marketing database will contain consolidated historical records of
billing, usage and service data across all lines of business with current transaction
This consolidated Customer Data is a strategic asset for deployment of multi-phase
marketing and customer relationship programs.
<B>Data Integration</B>
The goal of data integration is to identify, validate and consolidate strategic data about
your customers into a central repository to be accessed for decision support.
The successful integration of marketing and operational data depends on two key factors:
1. Data integration (See Chart) of disparate data sources
2. Creation of application specific data marts
<IMG ALT="CRM and Data Integration" SRC="images/crm_acxiom.gif">
Elements of the data integration process include:
<B>Data Knowledge and Awareness</B>
To gain a thorough understanding of source data, your analysis must include:
<I>Domain/Range Investigation:</I> What is the definition of accurate data?
<I>Data Transformation Rules:</I> Determine rules and conditions for converting business data to
meet end-user needs.
<I>Frequency Analysis :</I> How accurate is the data? What is the frequency of update?
<I>Quality Assurance :</I> Is the data reliable, are there inconsistencies that can be identified
and corrected ?
<I>Conversion :</I> Multi-sourced data files need to be edited and reformatted in a uniform manner.
Sophisticated algorithms are used to standardize data by identifying the location, length
and accuracy of each data field. The end result is a set of uniform data records with
identifiable lines of customer address and associated names. Professional titles, gender
codes or unique ID numbers can be added to each record for personalized responses at
customer touch points.
<I>Standardization :</I> All customer address information is verified and corrected to meet U.S.
Postal Service deliverability standards. In addition to gathering precise delivery point
data on home, business and SOHO accounts, Address Standardization results in better service
at the customer touch point.
As a common thread of information that links records across legacy systems, accurate
address data is a vital cross-reference for the delivery of interactive customer reference,
verification, sales and follow-up direct marketing programs.
<I>Consolidation And Enhancement</I>
Sophisticated merge/purge software is a powerful tool for consolidating household and
business data from various legacy systems and lines of business.
By linking customer records with common data elements, typically name and address, information
about a firm or individual from across the organization is combined to achieve a unified view
of the customer’s product and service history. External demographic and lifestyle data can
be appended to enhance customer knowledge even further by supplying intelligence on a
customer’s age, finances, household, autos and numerous other profile characteristics.
<B>Application Specific Data Marts</B>
As a net result of the data integration process, a storehouse of information is formed to
allow customized communications at every customer touch point. Yet the very size of
integrated marketing databases, perhaps into the terabyte range, can limit the real-time
delivery of data so critical in a call center environment.
To resolve this issue, and to support the multitudinous needs of other touch points using
customer and marketing data, Application Specific Data Marts are created.
Perhaps best viewed as a specialized extract of information derived from the marketing
database, Application Specific Data Marts offer the benefit of delivering data that is
precisely tailored to meet the unique requirements and objectives of that touch point.
Obviously, data content and detail will vary with the business application.
For example, a 1-800 order fulfillment center may only need access to customer name and
address information, whereas a customer service center would require an expanded data set
on transactions, contact history, credit status, etc. Other touch points, such as help
desk, sales, e-mail or the Internet, can design a mix of customer data that meets their
particular needs to ensure speedy response time and lower database overhead. And since
data marts are interactive and dynamic, information gleaned from new customer contacts
can be processed to update account records in the marketing database.
<B>Put It To Use</B>
The power and flexibility gained from this approach in leveraging data resources have
already led to exciting innovations in the call center marketplace.
Some of these include:
Profile Routing: incoming callers are identified by Automatic Number Identification (ANI)
codes, scored by potential value or service history, and automatically routed to an agent
with the appropriate skills sets and product knowledge.
Event Driven Offers: multiple customer contacts within a certain time frame trigger
product offers based on RFM (recency, frequency, monetary value) codes stored in the
database.
Value Based Offers: demographic and historical billing records are utilized to classify
customers for up-sell and cross-sell opportunities. Sales scripts can be customized
according to a customer’s product set and propensity to buy.
Automated On-Line Fulfillment: reverse appending of ANI phone codes with customer name and
address to allow Interactive Voice Response (IVR) verification of delivery points for
catalogs and promotional responses.
Fraud Detection: requires callers to verify phone number, address or other data stored in
customer records to initiate activation of offer or service (e.g., credit card, cellular
phone)
Telemarketing Campaigns: point- and-click segmentation analysis of demographically enhanced
customer databases to produce sophisticated profiles, name counts, contact histories and
extract files for communication programs.
<B>Conclusion</B>
The interactive nature of call center operations presents a great challenge and opportunity
for achieving one-to-one customer relationships. Transactional data from sales and service
touch points across an organization create an abundance of information about the customer.
However, too often, this data resides in discrete and possibly redundant systems segregated
by line of business or product area. The data integration process is a means of linking
data on an enterprise level to forge a single view of the customer.
Once achieved, a company is positioned to identify, differentiate and respond to customers
based on an understanding of individual needs and behavior.
The essence of 1:1 Marketing relies on the use of information technology to create customer
knowledge as a means of building loyalty and lifetime value.
The proper integration and deployment of database resources, therefore, is a fundamental
step in achieving this goal
</PRE>
</TD></TR>
<TR><TD COLSPAN=2>
<!-- Start of Standard Footer -->
<HR>
<CENTER><FONT COLOR=blue FACE="Verdana" SIZE=1>
[ <A HREF="index.htm">Home Page</A>
| <A HREF="ask_a_question.htm">Ask Us a Question</A>
| <A HREF="mailto:info@databaseanswers.com">Email Us</A>
| <A HREF="faqs.htm">FAQs</A>
| <A HREF="search.htm">Search</A>
| <A HREF="site_map.htm">Site Map</A> ]
</CENTER>
<P>
<!-- End of Standard Footer -->
<CENTER><I> © IceBreaker WebDesigns 2002</I></FONT></CENTER>
</TD></TR>
</TABLE>
</HTML>