Be Customer Wise or Otherwise - Project Overview
About the Project
Our sponsor, GLC, is an international postal and logistics company that has a global network spanning more than 220 countries and territories. Its product offerings include global freight forwarding, international express deliveries, warehousing solutions, and other customised logistic services.
International freight and logistics services have been expanding rapidly as a result of rising incomes across the globe especially in emerging economies like China and Vietnam, driving increased consumption levels. Coupled with the ubiquity of the Internet, changes in consumption habits such as the rise of e-commerce have also further pushed up the demand for freight services. Furthermore, with increasingly integrated global networks, supply chains have gone international with goods often needing to be shipped across continents from manufacturers to distribution centres to customers. Therefore, being able to do this efficiently is one main key to success in this industry.
Motivation
Having identified the potential of Asia-Pacific, GLC has been expanding its operations in the region. However, it has faced fierce competition from other players in the industry. In addition, GLC also has to contend with the 'new, globalised customer' (Cister, Ebecken, 2002) who is extremely demanding and has become accustomed to quick satisfaction with quality.
Objectives
In order to stay competitive in this market, the company believes that besides producing cutting-edge products, it also needs to understand the needs of its customers. GLC is thus seeking to profile their customer base so as to give them an edge in better tailoring their service offerings to meet market demands to boost revenue and increase market share.
With the motivation to maximise sales revenue and market share through devising appropriate product strategies and distribution channel policies, the team will try to uncover any information in the available data that may be useful in meeting the business objectives. The team will also assess the relevance of the data provided and suggest how GLC can make better use of the historical sales data to shape this aspect of its business strategy and operations, before proposing the recommendations to the management that follow from this.
Moving Forward
The purpose of this project is to apply descriptive analytics techniques to the sales and marketing data made available by GLC to yield knowledge discovery. From the data, we aim to create clusters of customers that can be profiled uniquely across different metrics, including a customised Recency, Frequency, and Monetary (RFM) measure.
The RFM index has three components, mainly:
- Recency - refers to date of the customer’s last purchase
- Frequency - refers to the number of purchases made within a given time period
- Monetary - refers to the total dollar amount spent by the customer within a certain time frame
Using these three measures, RFM analysis then teases out the most valuable customers. In doing so, we aim to address the following questions:
- Who are the high-value customers?
- Which customers have a high potential for growth?
- What common behavioural patterns do customers of different profiles exhibit?
- What are the needs of different types of customers?
- How can current data collection be improved to aid analysis?
Tackling these issues above will pave the way for the management to devise actionable marketing strategies to improve revenues and gain market share which is the initial intent.
Limitations
The final question mentioned above touches on a secondary objective that is to provide insights on improving data collection and utilisation. GLC, like many companies, has been collecting and has stored a copious amount of data about customers, suppliers, business partners, etc. However, the inability to draw out valuable findings from the data prevents this information to be used in any meaningful way. Thus, through this project, we aim to assess the relevance of the current data collected and suggest how GLC can better utilise this to shape its business strategies.
