Data based analytics and intelligence practices typically continue to grow complex over time. This is because we get more data over time, computational power is becoming cheaper by the day and businesses are facing situations where they can either innovate or perish.
Same applies to our case study. There are various levels of complex analysis which can be applied to this business once we start getting more and more customer information / data. In this concluding part of the case study, we will talk about framing targeted marketing strategies through propensity modelling or simple segmentation.
[stextbox id=”section”]A quick Recap : [/stextbox]
You have recently started a Video CD rent shop. After 2 months you realize that there is tough competition in the market and you need to make a more customer-centric strategy to stand out in the market. You have already built all the datasets and collected data for first 2 months (Read part 1 here). After 2 months, you used insights from portfolio data to define your mass market strategy and acquisition target localities (Read Part 2 here).
Now, you are in 5th month and business has grown to 750 customers. You have 4 months of data now and are wondering how to make your strategies even more customer-centric?
[stextbox id=”section”] Month 5 : [/stextbox]
Here are some high level metrics for your business :
Till this point, all your analysis has been on portfolio level. You, want to create a more granular optimized marketing strategy. Here, we will use one the best industry approach to classify our customer portfolio into meaningful segments and then define targeted strategies for each of them.
Predictive modelling is still out of reach because of relatively small size of portfolio and data points.
Targeted engagement Strategy :
Step 1 : Form group using RFM approach :
This is one of the best and most commonly used technique. It is very quick to implement and its flexibility makes it easy to apply it across industries. This technique can be used in multiple ways. Following is a demonstrative example:
THE R : R stands for measuring Recency. In this case, we will take into account the number of days since the customer took the last CD. We will score each customer based on the band he qualifies.
THE F : F stands for frequency. In this case, we will want to know the total number of CDs a customer has rented in his entire lifetime with us. Again we will band the frequency and score accordingly
The M : M stands for Monetary. Because, in our case each product costs the same, monetary parameter will behave very similar to frequency, there is no use of this metric.
Let us consider a case, customer X has bought 8 CDs in total and bought his last CD 6 days before. His total score becomes 8/10. Similarly, we score each of the customers. First thing you need to check is the distribution and the stability of the score. Following is the distribution of scores as on month 4 and month 5:
Both the curves are approximately normally distributed and have similar proportion of population in each score band.
Step 2 : Find the profile of each customer using scores of 2 months :
For example, a customer with high score in both the months fall into loyal bucket (1st quadrant).
Step 3 : Find the right strategy for each of the groups
Loyal customers : These are the customer who were highly valuable and are still highly valuable. This segment is our loyal base and it is important to delight these customers because they give us a constant stream of revenue. All our customer delight / engagement strategies need to focus on these customers. Let’s list down a few of these possible engagement for “Up-selling” :
1. Based on the preferred genre, send updates of new releases or newly acquired CDs.
2. Send weekly updates of star rating on new movies of preferred genre.
3. Send festive promotional offers to up-sell.
4. Give free delivery services.
Grow customers : These customers are showing a growing pattern and are becoming more and more engaged with us. The right strategy with these customer is to delight them and grow their engagement further. We again add these customer to the up-sell group. A similar strategy as of Loyal customer might be helpful in making them more engaged.
Win back customers : These customers are showing a declining pattern in terms of engagement/revenue. Here we need some different set of strategies to arrest their likely attrition and bring them back. If we think about it, there are possibly 2 reasons for their possible attrition:
a) They are now shopping from other shops
b) They have declined their overall requirement
Let’s try to list down some strategies to increase their wallet share or transfer their demand from other vendors to our store :
1. Win back offers : Give promotional offers to get them back on books. Offers like ” Buy 2 CDs a month and get third 50% off” will differentiate us from other vendors.
2. Customer specific engagements : Customer all wants to be treated deferentially. A simple promo offer like ” Get 25% off on next CD” might not work as good as ” We know you like watching Romantic movies. Here is “If Only” one of the best in genre 15% off only for you”.
Other strategies :
There can be many other data driven strategies, which can be implemented at this point in time. Some of these strategies are as follows :
1. Inventory optimization model based on past demand trends
2. X-sell of other rental services to loyal customers like renting home theatre.
3. Mutually share data with Home theater store and bring off-us customers with profile similar to loyal customer on board.
[stextbox id=”section”] End Notes : [/stextbox]
Strategies discussed in this article are meant to be food for thought for the viewers. These are by no means comprehensive. If you have examples of techniques, which you implemented in your industry and can be useful for this case study, please share them for benefit of wider community.
At some point in future, I will also cover how can this business use predictive modelling once it starts operating on a larger scale.
Tavish Srivastava, co-founder and Chief Strategy Officer of Analytics Vidhya, is an IIT Madras graduate and a passionate data-science professional with 8+ years of diverse experience in markets including the US, India and Singapore, domains including Digital Acquisitions, Customer Servicing and Customer Management, and industry including Retail Banking, Credit Cards and Insurance. He is fascinated by the idea of artificial intelligence inspired by human intelligence and enjoys every discussion, theory or even movie related to this idea.
Behind the Screen: How Netflix Uses Data Science?
Top 10 Machine Learning Algorithms You Must Know
Learn Analytics using a business case study : P...
Learn Analytics using a business case study : P...
How analytics help organizations becoming custo...
How do banks identify the next best product nee...
Guide to Build Better Predictive Models using S...
Customer Profiling and Segmentation – An Anal...
Top Customer Analytics Interview Questions
A Definitive Guide for predicting Customer Life...
We use cookies essential for this site to function well. Please click to help us improve its usefulness with additional cookies. Learn about our use of cookies in our Privacy Policy & Cookies Policy.
Show details
This site uses cookies to ensure that you get the best experience possible. To learn more about how we use cookies, please refer to our Privacy Policy & Cookies Policy.
It is needed for personalizing the website.
Expiry: Session
Type: HTTP
This cookie is used to prevent Cross-site request forgery (often abbreviated as CSRF) attacks of the website
Expiry: Session
Type: HTTPS
Preserves the login/logout state of users across the whole site.
Expiry: Session
Type: HTTPS
Preserves users' states across page requests.
Expiry: Session
Type: HTTPS
Google One-Tap login adds this g_state cookie to set the user status on how they interact with the One-Tap modal.
Expiry: 365 days
Type: HTTP
Used by Microsoft Clarity, to store and track visits across websites.
Expiry: 1 Year
Type: HTTP
Used by Microsoft Clarity, Persists the Clarity User ID and preferences, unique to that site, on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
Expiry: 1 Year
Type: HTTP
Used by Microsoft Clarity, Connects multiple page views by a user into a single Clarity session recording.
Expiry: 1 Day
Type: HTTP
Collects user data is specifically adapted to the user or device. The user can also be followed outside of the loaded website, creating a picture of the visitor's behavior.
Expiry: 2 Years
Type: HTTP
Use to measure the use of the website for internal analytics
Expiry: 1 Years
Type: HTTP
The cookie is set by embedded Microsoft Clarity scripts. The purpose of this cookie is for heatmap and session recording.
Expiry: 1 Year
Type: HTTP
Collected user data is specifically adapted to the user or device. The user can also be followed outside of the loaded website, creating a picture of the visitor's behavior.
Expiry: 2 Months
Type: HTTP
This cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected includes the number of visitors, the source where they have come from, and the pages visited in an anonymous form.
Expiry: 399 Days
Type: HTTP
Used by Google Analytics, to store and count pageviews.
Expiry: 399 Days
Type: HTTP
Used by Google Analytics to collect data on the number of times a user has visited the website as well as dates for the first and most recent visit.
Expiry: 1 Day
Type: HTTP
Used to send data to Google Analytics about the visitor's device and behavior. Tracks the visitor across devices and marketing channels.
Expiry: Session
Type: PIXEL
cookies ensure that requests within a browsing session are made by the user, and not by other sites.
Expiry: 6 Months
Type: HTTP
use the cookie when customers want to make a referral from their gmail contacts; it helps auth the gmail account.
Expiry: 2 Years
Type: HTTP
This cookie is set by DoubleClick (which is owned by Google) to determine if the website visitor's browser supports cookies.
Expiry: 1 Year
Type: HTTP
this is used to send push notification using webengage.
Expiry: 1 Year
Type: HTTP
used by webenage to track auth of webenagage.
Expiry: Session
Type: HTTP
Linkedin sets this cookie to registers statistical data on users' behavior on the website for internal analytics.
Expiry: 1 Day
Type: HTTP
Use to maintain an anonymous user session by the server.
Expiry: 1 Year
Type: HTTP
Used as part of the LinkedIn Remember Me feature and is set when a user clicks Remember Me on the device to make it easier for him or her to sign in to that device.
Expiry: 1 Year
Type: HTTP
Used to store information about the time a sync with the lms_analytics cookie took place for users in the Designated Countries.
Expiry: 6 Months
Type: HTTP
Used to store information about the time a sync with the AnalyticsSyncHistory cookie took place for users in the Designated Countries.
Expiry: 6 Months
Type: HTTP
Cookie used for Sign-in with Linkedin and/or to allow for the Linkedin follow feature.
Expiry: 6 Months
Type: HTTP
allow for the Linkedin follow feature.
Expiry: 1 Year
Type: HTTP
often used to identify you, including your name, interests, and previous activity.
Expiry: 2 Months
Type: HTTP
Tracks the time that the previous page took to load
Expiry: Session
Type: HTTP
Used to remember a user's language setting to ensure LinkedIn.com displays in the language selected by the user in their settings
Expiry: Session
Type: HTTP
Tracks percent of page viewed
Expiry: Session
Type: HTTP
Indicates the start of a session for Adobe Experience Cloud
Expiry: Session
Type: HTTP
Provides page name value (URL) for use by Adobe Analytics
Expiry: Session
Type: HTTP
Used to retain and fetch time since last visit in Adobe Analytics
Expiry: 6 Months
Type: HTTP
Remembers a user's display preference/theme setting
Expiry: 6 Months
Type: HTTP
Remembers which users have updated their display / theme preferences
Expiry: 6 Months
Type: HTTP
Used by Google Adsense, to store and track conversions.
Expiry: 3 Months
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
Save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.
Expiry: 2 Years
Type: HTTP
These cookies are used for the purpose of targeted advertising.
Expiry: 6 Hours
Type: HTTP
These cookies are used for the purpose of targeted advertising.
Expiry: 1 Month
Type: HTTP
These cookies are used to gather website statistics, and track conversion rates.
Expiry: 1 Month
Type: HTTP
Aggregate analysis of website visitors
Expiry: 6 Months
Type: HTTP
This cookie is set by Facebook to deliver advertisements when they are on Facebook or a digital platform powered by Facebook advertising after visiting this website.
Expiry: 4 Months
Type: HTTP
Contains a unique browser and user ID, used for targeted advertising.
Expiry: 2 Months
Type: HTTP
Used by LinkedIn to track the use of embedded services.
Expiry: 1 Year
Type: HTTP
Used by LinkedIn for tracking the use of embedded services.
Expiry: 1 Day
Type: HTTP
Used by LinkedIn to track the use of embedded services.
Expiry: 6 Months
Type: HTTP
Use these cookies to assign a unique ID when users visit a website.
Expiry: 6 Months
Type: HTTP
These cookies are set by LinkedIn for advertising purposes, including: tracking visitors so that more relevant ads can be presented, allowing users to use the 'Apply with LinkedIn' or the 'Sign-in with LinkedIn' functions, collecting information about how visitors use the site, etc.
Expiry: 6 Months
Type: HTTP
Used to make a probabilistic match of a user's identity outside the Designated Countries
Expiry: 90 Days
Type: HTTP
Used to collect information for analytics purposes.
Expiry: 1 year
Type: HTTP
Used to store session ID for a users session to ensure that clicks from adverts on the Bing search engine are verified for reporting purposes and for personalisation
Expiry: 1 Day
Type: HTTP
Cookie declaration last updated on 24/03/2023 by Analytics Vidhya.
Cookies are small text files that can be used by websites to make a user's experience more efficient. The law states that we can store cookies on your device if they are strictly necessary for the operation of this site. For all other types of cookies, we need your permission. This site uses different types of cookies. Some cookies are placed by third-party services that appear on our pages. Learn more about who we are, how you can contact us, and how we process personal data in our Privacy Policy.
Edit
Resend OTP
Resend OTP in 45s
Hi, Nice case studies to begin with. As i am working for a telecom sector and very much interested in knowing some case studies related to that, like in south India the vodafone basket their profit to 100 crore in 2013 financial year for Q3-Q4. Now he wants to increase his profit from 100 crore to 110 crore in Q2-Q3 for financial year 2014. So for this case studies it will be helpfull if you can focus on what are the KPI's that we should look for, how to go for customer centric approach. Thanks & Regards, kumar
Avinash, Thanks for reading . To make a customer centric strategy, you should give higher weigtage to customer preference metrics. Say, even if you find the expected profit of pushing product X to a customer higher than product Y, but the customer actually prefers product Y. Customer centric apporach will bring you to the solution of offering product Y to the customer even at a cost of not selling a higher profitable product. But in general customer centric approach will converge to the same solution as that of maximizing the profit. We have recently published an article on customer centricity, which include some relevant case studies. Click here (http://www.analyticsvidhya.com/blog/2014/03/analytics-helps-organization-customer-centric/) to view this article. Hope this helps. Tavish
Very nice case study and well explained with details..
Thanks Swapneel
Hi Tarun, Very Interesting case study!