For every profitable organization, it is very much essential to have robust Customer Relationship Management System with all accurate information in it. Generally every organization intends to keep product and customer master data in a single place to keep single version of truth. For Retail organizations, order, sales data captured through point of sale systems like retail brick and mortar, web, direct Inbound and Outbound. Different OLTP database may capture different source of information starting from order placed in basket, cancelled, not went through due to some check and error, cannot be fulfilled, completed, returned, and closed along with customer notes. During the order placement journey, system also captures customer contact details, contact preference and all associated attribute to identify the order and sale process. It also defines the finite period of journey and status for each to realise the potential bottleneck to convert the sales from the time the customer started the order placement journey.
For retail stores (known as Brick and Mortar), retail Sales Agents interact with the customer and try to log as much as information possible. For some business, it is not essential to track customer details as they intend to do mass marketing and promotion based on sales trend and like-for-like sales reporting. For those, tracking of RFID, QP code Scan or tracking of device or item is more important. Retail has added benefit of upselling and cross-selling during the sale. Customer interaction with the agent and less waiting queue at the till makes customer life easier and that plays major role in repeat business. For stores or manufacturing industry, tracking of order, sales tracking through device or pallet RFID, inventory tracking through various means and reduction of loss and theft of items/packages is key essential criteria.
For web touch point, user interactive screen helps customer to navigate and fulfil the order. Web captures more customer information and also about the order, sales information, customer interest.Direct touch point helps in converting sales through direct inbound and outbound mode; here customer interaction history can also be tracked along with customer interest and dissatisfaction for any product or service. Apart from traditional source of data, unstructured web log of clickstream data- showing customer interest, social networking site data having customer liking or comments on organization product or service offering can provide valuable insight into customer 360° view. Customer review data can also be logged and tracked by the organization.
All these source of information can be loaded in Enterprise data warehouse to keep single view of customer and also to have information about prospects and faceless customers.
Continue reading "Enterprise Analytical Dataset- DWH viewpoint" »