- Customers who left within the last month
- Services each customer has signed up for: phone, multiple lines, internet, online security, online backup, device protection, tech support, and streaming TV and movies
- Customer account information: how long as a customer, contract, payment method, paperless billing, monthly charges, total charges and number of tickets opened in the categories administrative and technical
- Demographic info about customers – gender, age range, and if they have partners and dependents
After organizing and cleaning up the data, the report consists of three dashboards:
- Churn Analysis:
- This part helps us understand why some customers leave. Key metrics and insights regarding the rate of churn are presented, allowing for a comprehensive overview of customer retention challenges.
- Customer Overview:
- Here, there is a quick look at our customers. We see how many we have, the genders, their age category, and what kind of internet they like. It's like a summary of our customer group.
- Detailed Customer Information:
- In this section, we go deeper into each customer. We look at specific details about how long they've been with us, how they use our services, contract, payment method, monthly charges, total charges and number of tickets opened in the categories administrative and technical.
- Total Subscribers:
- There are 7,043 customers currently subscribed to the service.
- Gender Breakdown:
- Among these customers, 3555 are identified as males and 3488 as females.
- Total Revenue:
- The subscriptions have generated $16.1 million in revenue.
- Age Groups:
- Most of the customers, around 84%, are in the Young category, which means 5901 people.
- Internet Preferences:
- The favorite internet service among the customers is the fast fiber optic option.
- Contract Types:
- Many customers prefer a month-to-month plan
- Subscription Duration:
- A considerable portion of customers has a subscription duration of less than 12 months, suggesting recent sign-ups.
| CHURN ANALYSIS |
|---|
 |
| CUSTOMER OVERVIEW |
|---|
 |
By right-clicking on individual customer IDs, you can 'drill through' to access specific details such as subscription duration, usage patterns, and unique characteristics. This drill-through feature provides a more detailed view, enabling a better understanding of each customer as shown below :
| CUSTOMER INFO |
|---|
 |
The factors that often lead to customers leaving:
- Tenure Less Than 12 Months:
- Customers who have been with the service for less than 12 months are more prone to discontinuation.
- Month-to-Month Contracts:
- Customers on month-to-month plans are more likely to stop using the service.
- Fiber Optic Subscribers:
- People using fiber optic internet service are more likely to leave.
- Young Customers:
- More young customers tend to stop using the service.