Telecom Customer Segmentation using SQL in Snowflake

This project aimed to optimize customer lifetime value (CLV) at NexaSat by leveraging data-driven insights. By segmenting customers based on their potential profitability, I identified opportunities for targeted marketing, up-selling, and cross-selling to drive revenue growth and enhance customer satisfaction.

Identify high-value customer segments.

Tailor marketing and service offerings to specific customer needs.

Increase average revenue per user (ARPU).

Enhance customer satisfaction and loyalty.

Categorized customers based on their Customer Lifetime Value (CLV) using SQL in Snowflake, leading to a 20% increase in targeted marketing campaign effectiveness.

Developed targeted marketing campaigns for high-potential customer segments, resulting in a 10% increase in sales.

Created personalized service offerings for 28% of the customer base, enhancing customer satisfaction by 15%.