<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Saad Shahbaz on Medium]]></title>
        <description><![CDATA[Stories by Saad Shahbaz on Medium]]></description>
        <link>https://medium.com/@saadjassal88?source=rss-a08030ec88b1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*YMmIYnLfTlJVGQawYZ6ERw.png</url>
            <title>Stories by Saad Shahbaz on Medium</title>
            <link>https://medium.com/@saadjassal88?source=rss-a08030ec88b1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 21:29:23 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@saadjassal88/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Navigating Customer Retention: Key Insights from IBM’s Telco Data Analysis”]]></title>
            <link>https://medium.com/@saadjassal88/navigating-customer-retention-key-insights-from-ibms-telco-data-analysis-f8a471722da8?source=rss-a08030ec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/f8a471722da8</guid>
            <dc:creator><![CDATA[Saad Shahbaz]]></dc:creator>
            <pubDate>Fri, 27 Sep 2024 12:40:58 GMT</pubDate>
            <atom:updated>2024-09-27T12:42:22.696Z</atom:updated>
            <content:encoded><![CDATA[<p>In the fast changing telecommunications industry, customer churn continues to be a major challenge for companies aiming to retain their competitive edge. This analysis explores the key factors driving churn among IBM’s telco customers, providing valuable insights to inform retention strategies.</p><h4><strong>Understanding Churn: A Critical Threat to Customer Loyalty</strong></h4><p><strong>C</strong>ustomer churn, the phenomenon of customers discontinuing a service, poses a significant threat to businesses, particularly in subscription-based industries like telecommunications. It not only results in the immediate loss of recurring revenue but also reflects underlying issues such as dissatisfaction with service quality, pricing, or customer support. High churn rates can signal a breakdown in customer loyalty, forcing companies to invest heavily in acquiring new customers — a process often more expensive than retaining existing ones. Understanding the root causes of churn is essential for businesses to address these concerns proactively, ensuring customer satisfaction, loyalty, and long-term growth.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/307/1*NMC7DagnLdSrN08F3m7hEA.png" /></figure><p>This article highlights the SQL queries I used to analyze churn patterns and provides actionable insights to improve customer retention. The goal was to identify factors driving churn and suggest data-driven recommendations. The dataset, consisting of five tables with details on demographics, services, churn status, and feedback, allowed for an in-depth exploration of key churn drivers, from payment methods to customer satisfaction, helping shape targeted retention strategies.</p><h4><strong>Defining Project Aims</strong></h4><p>The project centered around three key questions, which serve as the foundation for my SQL analysis:</p><ol><li>Considering the top five groups with the highest average monthly charges among churned customers, how can personalized offers be tailored based on age, gender, and contract type to potentially improve customer retention rates?</li><li>What are the feedback or complaints from those churned customers?</li><li>How does the payment method influence churn behavior?</li></ol><h4><strong>Addressing the Loss of High-value Customers</strong></h4><p>The first task was to identify the top 5 customer groups based on average monthly charges among churned customers, broken down by age group, gender, and contract type. Here are the valuable insights i have gathered from this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/319/1*iMNDC6PyW6-_TU3BC60otw.jpeg" /></figure><p><strong>1. High Churn with High Charges:</strong><br> Female customers aged <strong>36–45</strong> with<strong> two-year contracts</strong> have the highest average monthly charges at <strong>$100.93</strong>. This suggests that despite being on a long-term contract, this group may be experiencing dissatisfaction, possibly related to the value for the high cost or service expectations not being met.</p><p><strong>2. Male Customers in Two-Year Contracts:</strong><br> Male customers aged <strong>26–35</strong> with <strong>two-year contracts</strong> have an average charge of<strong> $98.28</strong>, which is close to the top group. This indicates that even among long-term contract holders, churn can still occur if customer needs or satisfaction are not met.</p><p><strong>3. Younger Customers and Short-Term Contracts:</strong><br> Males aged <strong>18–25</strong> and <strong>26–35</strong> on <strong>one-year contracts</strong> have relatively lower average charges <strong>$92.65 </strong>and<strong> $89.80</strong>, respectively, but they still feature prominently in the top churned groups. Short-term contracts might not be offering sufficient incentives for them to stay.</p><p><strong>4. Older Customers and Short-Term Contracts:</strong><br> Customers aged <strong>46+</strong> on<strong> one-year contracts</strong> have an average charge of <strong>$89.54</strong>, indicating that older customers may also be vulnerable to churn if long-term benefits or value are not clear.</p><h4><strong>Recommendations</strong></h4><p><strong>1. Tailored Offers for High-Charge Customers:</strong><br> For the female 36–45 and male 26–35 age groups on two-year contracts, consider offering loyalty rewards or service upgrades that emphasize value for their high monthly charges. Personalized discounts or service enhancements can address any dissatisfaction.</p><p><strong>2. Increase Benefits for Younger Customers:</strong><br> Younger customers (especially 18–25) on one-year contracts may benefit from offers that encourage them to switch to longer-term contracts with added perks, such as discounted rates or bundled services, making it more appealing for them to stay.</p><p><strong>3. Engage Older Customers:</strong><br> For the 46+ age group on one-year contracts, providing more personalized customer service, targeted retention campaigns, or flexible long-term contracts with added support could reduce churn.</p><p><strong>4. Focus on Service Satisfaction:</strong><br> Since high-churn customers across all groups are likely dissatisfied with service quality or pricing, consider gathering direct feedback from these segments to understand their pain points better and address any ongoing issues with customer service, billing, or network quality.</p><p><strong>Tailoring strategies to meet the unique needs of each customer group allows the telco company to effectively reduce churn and enhance customer loyalty.</strong></p><h4><strong>Customer Feedback: The Key to Improvement</strong></h4><p>The second task aims to analyze the feedback provided by churned customers, highlighting the reasons they decided to leave the service.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/280/1*GlMULmOzLyOUB_o4B5r9fQ.jpeg" /></figure><h4>Key Findings from the Result</h4><p><strong>Competitor Advantage:</strong></p><p>The most frequent churn reasons revolve around competitors offering better devices or making better offers. Customers paying high monthly charges are still leaving, which indicates they may not perceive the value in what they’re receiving compared to competitors.</p><p>Competitor-related dissatisfaction is higher in middle-aged customers (~50 years old), suggesting that this group is more discerning and likely to switch for better deals.</p><p><strong>Customer Support Issues</strong>:</p><p>Dissatisfaction with customer support (specifically, the attitude of support personnel) is another prominent reason for churn. This suggests a need for improving customer service interactions to reduce frustration and enhance satisfaction.</p><p><strong>Lack of Clarity from Some Customers</strong>:</p><p>A significant group of customers provided ambiguous feedback <strong>“Don’t know”</strong>, which may indicate a disconnect between their service expectations and the company’s offerings. This could reflect general dissatisfaction without a clear trigger, or poor communication about the value of the service.</p><h4>Recommendations</h4><ol><li><strong>Upgrade Device Offerings:</strong> Provide better device options or discounts to compete with rivals, particularly targeting high-paying customers over 50.</li><li><strong>Offer Competitive Pricing:</strong> Create attractive pricing plans and promotions to counter competitor offers and retain customers.</li><li><strong>Improve Customer Support:</strong> Enhance support teams’ communication and empathy to reduce churn due to poor service interactions.</li><li><strong>Clarify Service Value: </strong>Educate customers on the value of their plans, especially for those unsure why they left.</li><li><strong>Revise Data Packages:</strong> Offer more flexible and appealing data plans to compete with competitors offering more data.</li></ol><p>These strategies will help reduce churn and better meet customer expectations.</p><h4><strong>How Payment Methods influence Customer Churn: A Revealing Insight</strong></h4><p>The third task examines how different payment methods influence customer churn rates. The goal is to understand which payment methods are associated with higher or lower churn percentages and draw insights to improve customer retention. My findings indicated that customers using mailed checks experienced a churn rate of 36.88%, while those utilizing bank withdrawals had a churn rate of 34%. In contrast, credit card users had a significantly lower churn rate of 14.48%.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/299/1*W37i4VZ_bxEJULFixqjQZg.jpeg" /></figure><p><strong>Insights Derived from the Results</strong></p><ol><li><strong>Higher Churn with Traditional Payment Methods:</strong> The significantly higher churn rates among customers using mailed checks and bank withdrawals indicate that these methods might be inconvenient, leading to customer dissatisfaction. Manual or less automated payment processes might make it easier for customers to delay or abandon payments, increasing the risk of churn.</li><li><strong>Credit Card as a Churn-Reducing Factor</strong>: Credit card payments, which are typically automated, are associated with much lower churn rates. This suggests that convenience in payment methods correlates with customer loyalty and retention. Customers who have to do less work to manage their payments are more likely to stay.</li></ol><h4>Recommendations:</h4><ol><li><strong>Promote Automated Payments:</strong> Offer discounts or rewards for switching to credit card payments.</li><li><strong>Enhance Traditional Payment Experience: </strong>Make bank withdrawals and mailed checks more convenient with reminders or smoother processes.</li><li><strong>Target High-Churn Groups: </strong>Personalize retention strategies for customers using high-churn payment methods.</li></ol><p>By improving payment options, the company can significantly reduce churn and improve retention.</p><h4>Conclusion: Leveraging Insights for Future Success</h4><p>In summary, the analysis of IBM’s telco customer churn underscores the importance of a strategic and targeted approach to retention. By focusing on customer demographics, addressing feedback, optimizing payment methods, and implementing personalized strategies, IBM can greatly enhance its customer retention rates.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/353/1*23n9dbP4pEaXDM8WOjXDlg.png" /></figure><p>These insights provide a solid foundation for future efforts to reduce churn. By prioritizing these key areas, IBM can boost customer satisfaction, build long-term loyalty, and strengthen its position in a competitive market.</p><p><strong>You can explore detailed SQL queries and their explanation on my GitHub: </strong><a href="https://github.com/Saadjassal/IBM-s-Telco-Data-Analysis-SQL">IBM’s Telco Data Analysis</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f8a471722da8" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>