Discoveries from Exploring: Customer Churn Prediction
Industry: Telecommunications services
Dataset: Telecom - Churn Predict.csv
Explored on: 2024-03-15
Selected Goal Column: Churn
Overview
There is a Strong Signal to predict Churn - the best model on this data had +34.72 compared to guessing.
Most Likely Yes:
Contract is 'Month-to-Month' and
Number of Referrals<=2.0 and
Online Security is 'No' and
Premium Tech Support is 'No'
Most Likely No:
Contract is one of: ['One Year', 'Two Year']
Explored 37 factors over 6043 records, in which 26.77% had Churn is Yes (1618 of 6043).

Of these factors:
  • 1 was strongly correlated with Churn, so was excluded.
  • 10 were relevant for predicting Churn.
  • 26 were found to be irrelevant or redundant, so were ignored.

  • Also generated predictions for the 1000 rows where the Churn column was empty.
    Key Factors

    We analyzed each factor (column) in the data, looking for which factors matter and which are irrelevant in determining Churn.

    Strongly Correlated Factors - In this dataset, we found some factors to be so strongly correlated with other factors that we could essentially swap them out and keep only one of them.

    The Churn column was Strongly Correlated With: Customer Status, so this factor was excluded.

    Key Factors - The most important factors and their values more likely to result in 'Yes' for Churn are:
    Factor Group Breakdown
    1
    Contract
    Contract is 'Month-to-Month'

    2
    Number of Referrals
    Number of Referrals<=0.0

    3
    Online Security
    Online Security is 'No'

    4
    Internet Type
    Internet Type is 'Fiber Optic'

    5
    Premium Tech Support
    Premium Tech Support is 'No'

    6
    Number of Dependents
    Number of Dependents<=0.0

    7
    Married
    Married is 'No'

    8
    Age
    Age>=46.0

    9
    Payment Method
    Payment Method is not 'Credit Card'

    10
    Tenure in Months

    Strongly Correlated With:
    - Total Charges
    - Total Long Distance Charges
    - Total Revenue
    Tenure in Months<=29.0
    Irrelevant Factors - The following factors in your data were not very important in determining Churn:
    Factor
    11 Latitude

    Strongly Correlated With:
    - Longitude
    - Zip Code
    12 Streaming Music

    Strongly Correlated With: Streaming Movies
    13 Online Backup
    14 Total Refunds
    15 Streaming TV
    16 Population
    17 Paperless Billing
    18 Avg Monthly GB Download
    19 Multiple Lines
    20 Gender
    21 Device Protection Plan
    22 City
    23 Avg Monthly Long Distance Charges
    24 Offer
    25 Unlimited Data
    26 Total Extra Data Charges
    27 Internet Service
    28 Monthly Charge
    29 Customer ID
    30 Phone Service
    Expand to learn more about Factors

    Certain factors (or columns) are more important when determining 'Yes' or 'No' for your Goal than others. You can optimize your time and resources by prioritizing key factors across data gathering, data management, and decision-making.


    For example, if data gathering is time-consuming or expensive, you might consider de-prioritizing irrelevant factors. Just be mindful that they may be important for other problems.


    If you need help, set up a call with our Berrijam AI Coaches to brainstorm how you can adopt these insights from factors.

    Key Segments

    A combination of factors can be used to define a segment, giving deeper insights and making them easier to act upon.

    We have automatically identified top segments for 'Yes' and 'No', by determining their importance based on the size of the segment and % Yes or % No within the segment. Alternatively, you can explore the segments below.

    More Likely Yes
    Segment Segment Breakdown
    Contract is 'Month-to-Month' and
    Number of Referrals<=2.0 and
    Online Security is 'No' and
    Premium Tech Support is 'No'

    Contract is 'Month-to-Month' and
    Number of Referrals<=2.0 and
    Online Security is 'Yes' and
    Age<=64.0

    Contract is 'Month-to-Month' and
    Number of Referrals<=2.0 and
    Online Security is 'No' and
    Premium Tech Support is 'Yes'

    Contract is 'Month-to-Month' and
    Number of Referrals<=2.0 and
    Online Security is 'Yes' and
    Age>64.0
    More Likely No
    Segment Segment Breakdown
    Contract is one of: ['One Year', 'Two Year']

    Contract is 'Month-to-Month' and
    Number of Referrals<=2.0 and
    Online Security is 'Blank'

    Contract is 'Month-to-Month' and
    Number of Referrals>2.0 and
    Married is 'Yes' and
    Number of Dependents<=0.0

    Contract is 'Month-to-Month' and
    Number of Referrals>2.0 and
    Married is 'Yes' and
    Number of Dependents>0.0
    Explore More Segments
    Click on the rings to drill down into sub-segments and click the center circle to navigate back up.

    As you hover over a segment, you’ll see the factors that define the segment, the segment size as a percentage of all records, and the percentage of 'Yes' within that segment.
    Expand to learn more about Segments

    Segments help identify important groups or populations where to invest time and effort. For example, a teacher could use segments to focus on students who are least likely to pass the course. They also identify which combination of the factors and values to focus on if you want to increase or decrease the percentage of ‘Yes’.


    For example, a maintenance team might identify that machines operating above a certain temperature and load are more likely to break down. So they might set up temperature alerts and reduce the load at certain temperatures to keep the machine working.


    If you need help, set up a call with our Berrijam AI Coaches to brainstorm some ideas on how to adopt the insights from segments to design strategies or policies that are relevant to you.

    Model Results

    We explored 626 different models to find which produced the best results.

    For the rows without a value for Churn, we generated predictions using the best models.
    We will auto-delete these on 2024-03-22 so please download them before then, otherwise you will need to re-run the exploration.

    The Best Explainable Model performed very well on this dataset:

    +30.04
    compared to guessing

    The Best Non-Explainable Model performed very well on this dataset:

    +34.72
    compared to guessing
    Download Predictions
    Recommended
    The top Non-Explainable model performed well, but none of the Explainable models achieved a similar performance. If you only care about the Predictions, we recommend using the Non-Explainable predictions. However, if you want to understand how the models arrived at the predictions, we recommend revisiting your data or setting up a consultation with one of our data scientists for better Explainable Model results.
    All Model Results
    Credit

    Explored by avishkar@gmail.com using Telecom - Churn Predict.csv on 2024-03-15 with Berrijam. Try it yourself at Berrijam.com