Skip to content
Free Courses
Programs
Career Transformation
Digital Marketing with AI

7 Months · Indonesia's #1 Rated Digital Marketing Program

Try Free Course
Data Analytics with AI

7 Months · Indonesia's #1 Rated Data Analytics Program

Try Free Course
Software Engineering with AI

8 Months · Learn to code smarter with AI and AWS

Try Free Course
University Certified
Institut Teknologi Bandung Institut Teknologi Bandung Data-Driven Decision Making

3 Months · Hybrid

Try Free Course
Binus University Binus University Applied Cybersecurity with AI

3 Months · Hybrid

Try Free Course
Back to Portfolio
A Customer Segmentation Framework for Telkom Indonesia (OCA) project preview

A customer-segmentation framework for Telkom's OCA platform, turning 120,000+ transactions into clear retention, upsell, and activation strategies.

About Telkom Indonesia (OCA)

Telkom Indonesia is the country’s largest telecommunications company. OCA, its omnichannel communication platform, serves enterprise clients across WhatsApp, SMS, Email, and Voice Call. For this Virtual Internship project, the dataset and figures were modified for educational purposes and do not represent Telkom Indonesia’s actual business performance.

The Objective

OCA needed a client-segmentation framework to strengthen retention, expansion, personalization, and revenue growth. The core question: which enterprise accounts should be protected, expanded, or activated to drive sustainable growth?

The Result

Mely Horman analyzed 122,749 cross-channel transactions across four channels over a three-month period and built a segmentation model that combined rule-based logic with K-Means clustering, validated at a 0.41 silhouette score.

Analytical framework and clustering slide

She defined four client segments, each with a tailored strategy:

  • Titans: the highest-revenue strategic accounts, to be protected through executive account management.

  • Guardians: stable, mature accounts, to be scaled through deeper platform adoption.

  • Challengers: high-engagement accounts with strong readiness, to be accelerated through upsell and cross-sell.

  • Explorers: the largest, lowest-engagement group, to be activated through onboarding and use-case programs.

Client segment profiles slide

She closed with a 90-day action roadmap and segment-level KPIs (revenue retention, expansion, volume growth, and activation), along with supporting insights on industry-specific communication windows and the opportunity to diversify usage beyond a WhatsApp-led concentration.

You can explore the full analysis in Mely’s project deck.