Telecom · Campaign analytics

4G migration: converting 2.1M subscribers

Finding the subscribers most likely to upgrade, then reaching them by call, by SMS, or the moment they walked into 4G coverage.

RoleData & Business Analyst, Huawei Technologies
ToolsSQL · Python · Power BI
TimeframeOct 2024 to present
Impact2.1M customers converted
campaign rules
IFDevice is 4G-capable
ANDInside 4G coverage zone
SEND VIA
OBDSMSLocation trigger
CONVERTED2.1M

Challenge

MTN Ghana needed to move millions of 3G subscribers to 4G. A blanket “please upgrade” message wastes budget on people who won’t convert and misses the ones who would. The question was who to target, where, with what offer and through which channel.

Approach

I segmented the base by device, usage, location and lifecycle stage, then designed a campaign for each segment across outbound calls, SMS and real-time location triggers. A subscriber with a 4G phone who walked into 4G coverage got the offer at that moment.

I worked with Sales, Marketing and Channels teams to keep targeting tied to commercial priorities, and refined segments and offers as results came in.

Outcome

2.1 million customers moved to 4G. Refined offers lowered churn risk in the weeks after activation, and the segmentation framework is now reused for later campaigns.

By the numbers

2.1Mcustomers moved to 4G
3channels: calls, SMS and location triggers
Contact

Have a problem like this one? I’m open to data roles and project work, and I’d be glad to talk it through.