Code Monkey home page Code Monkey logo

customer-segmentation---sas's Introduction

Customer-Segmentation---SAS


Table of contents

About

Analysis of toothbrush sales in the US Market. This exercise was the part of Predictive Analytics coursework at The University of Texas at Dallas.

The following analysis were made to come out with the recommendation for improvement in the market share

  • Segmentation of customers through Recency, Frequency and Monetory (RFM Analysis)
  • Price Elasticity
  • Preference of customer of brand based on price reduction flag, display etc

Data Description

The dataset is primarily about the toothbrush sales of different brands sold in the US. The analysis we performed is for the Colgate brand.

Data, Code and Report

The data used for the analysis, code and the complete interpretations of the output of the analysis can be found here

Recommendation

Oral-B is the market leader and the tough competitor for Colgate compared to any other brand. To be the market leader Colgate must battle with Oral-B for new market shares

  • Reducing price would not improve the sales to a greater extent but reducing the price and having right advertisement like price reduction tag and feature display would improve the sales.
  • If Oral-B along with price reduction also has a display, this could affect the sale of Colgate, this is when manager must place the right advertisement for Colgate in line with competitor Oral-B
  • From the brand choice analysis, we see that customers are less likely to choose Oral-B if there is price reduction along with display advisement by Colgate. When there is price reduction sale it’s important to have display advisement, else the price reduction is not that effective
  • From the RFM analysis we can conclude that we need to concentrate the marketing campaign on Big Spenders, Potential Loyal and Customer at Risk. ~23% are lost and non-monetary, these people should be removed from the marketing campaign and focus must be on who are likely to churn, which is ~28% customers

customer-segmentation---sas's People

Contributors

shilpapbhat avatar

Stargazers

 avatar

Watchers

 avatar

customer-segmentation---sas's Issues

Unavailable data

The is a csv file to be imported called 'panel_prod_details csv' can it be availed?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    πŸ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. πŸ“ŠπŸ“ˆπŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❀️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.