Monthly Revenue
--
Latest month, all plans
Blended ARPU
--
Loading…
Churn Rate
--
Share of subscriber base churned
5G Handset Share
--
Active subscribers on a 5G handset
3-Month Revenue Forecast
Forecast model live · history illustrative
Loading…
Shaded band: the range the model expects revenue to land in 95% of the time.
Postpaid Revenue at Risk by State
Illustrative dataset
Loading…
Share of Search: U Mobile vs Market Leader
Illustrative dataset
Loading…
Number Porting by Competitor
Illustrative dataset
Loading…
What Customers Talk About
Source: Google Maps reviews
Loading…
Sentiment
Read by Gemini
Positive
--
Neutral
--
Negative
--
Switching signals
--
How This Forecast Works
1
Underlying trend
Calculating…
2
Model vs straight line
Calculating…
3
Uncertainty range
Calculating…
4
What changes with real data
Today the model runs on 6 months of illustrative history. In a pilot it runs on U Mobile's billing history, and the range narrows as more months of actuals come in. Planners can then ask the data agent for the forecast by plan, state or channel.
Cost per Sign-up
--
Ad spend ÷ attributed sign-ups
Marketing Return
--
Estimated 90-day revenue ÷ ad spend
App Revenue at Risk
--
Monthly, from app checkout drop-off
Walk-ins from App Drop-off
--
Customers who finish in a branch instead
Where to Spend: Search Demand by State
Branch locations: Google Maps
Search & app data: illustrative
Loading…
App leakage: demand captured, lost at app checkout
Under-spent: demand rising, ads capped
Outbid: rival dominates search
On track
Bubble size = search volume · label = growth this week
Click a state on the map
Most search per branch
Highest app checkout drop-off
Search Demand vs Our Visibility
Illustrative dataset
| State | Category | Search growth (WoW) | U Mobile share | Leader | Impression share | App drop-off | Suggested action |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
App Checkout Drop-off by Journey
Illustrative dataset
| App journey | Checkouts started | Drop-off | Where they drop | Walk-ins caused | Revenue at risk / month (MYR) | Suggested fix |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Customers Likely to Leave in the Next 30 Days
Illustrative dataset · 1,000-customer sample
--
customers at high risk
--
monthly revenue at risk
--
a year if none are kept
--
reachable in the app today
Warning signs before leaving
Loading…
Warning signs to act on
| Warning sign | Customers | MYR / month | Reach by | |
|---|---|---|---|---|
| Loading… | ||||
Highest-value customers to call first
| Customer | Segment | Plan | State | Tenure | ARPU (MYR) | Risk | Warning signs | Next step |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Attributed 90-Day ROAS by Marketing Channel
Illustrative dataset
Loading…
Channel Acquisition Performance
Illustrative dataset
| Channel | Spend (MYR) | Conversions | CAC (MYR) | ROAS |
|---|
5G Handset Uplift by Plan
Illustrative dataset
| Plan | Subscribers | ARPU, 5G handset (MYR) | ARPU, 4G handset (MYR) | Uplift (%) |
|---|
6-Month Net Revenue Trajectory
Illustrative dataset
Amounts in Million MYR
Loading…
5G ARPU Uplift by Plan Tier
Illustrative dataset
| Plan Name | 5G ARPU | 4G ARPU | Uplift |
|---|
How the Data Fits Together
Architecture
This deployment meshes 1P transactional telco data (subscribers, invoices, CDRs, cell tower QoS), Google platform feeds (Google Ads campaign telemetry, Google Maps retail outlets, GBP review sentiment), and 3P environmental data (DOSM state demographics, MetMalaysia rainfall, gazetted public holidays, and border transit flows).
BigQuery Serverless Mart
BigQuery ML ARIMA_PLUS
Vertex AI BQCA Agent
Top Retail Experience Centers (Google Reviews)
Source: Google Maps
| Store Name | Rating | Reviews | Sentiment |
|---|
Campaign Funnel: Online Ad to In-Store Activation
Illustrative dataset
Full 12-Month Telemetry across 4 National Campaign Flights
| Campaign Flight | Target Product | Ad Spend (MYR) | Google Ads Clicks | GA4 Locator Views | Physical Footfall | In-Store Activations | Digital Activations | Omnichannel CAC | ROAS Ratio |
|---|
Top Retail Experience Centres: Campaign Footfall Lift (%)
Illustrative dataset
Loading…
Store Queue Sensitivity & Counter Wait Times
Illustrative dataset
| Store Name | State | Type | Base Daily Footfall | Flight Daily Footfall | Footfall Lift | Base Wait | Flight Wait |
|---|
Analyse Any Review
Live Gemini analysis
Type or paste a review first.
Customer Reviews & Suggested Actions
Reviews: Google Maps · actions: Gemini
| Store | Stars | Sentiment | Topic | Review | Root cause | Suggested action |
|---|---|---|---|---|---|---|
| Loading reviews… | ||||||
U Mobile Retail Network: 322 Stores
Stores: Google Maps
Towers, gateways & competitor distances: illustrative
■ Cell Towers
● U Mobile Stores
▲ Transit Gateways
Loading 322 stores…
Branch Deep-Dive
Profile & reviews: Google Maps
Sales, shifts & queues: illustrative
Loading photo…
--
--
★ --
Loading branch…
--
Hours: --
Counters: --
Nearest competitors: --
12-Month POS Revenue
--
--
Avg Queue Wait & Walk-Outs
--
--
Staff Utilisation
--
Average across all six weekly shift slots
Shift Recommendation
--
1 km Surroundings & Customer Affluence Profile
Places Insights Malaysia (1 km aggregated view)
Loading 1 km catchment profile…
Revenue & Walk-Ins: 12 Months + Forecast
Illustrative dataset
Loading…
Shift Load: Walk-Ins vs Staff
Illustrative dataset
Loading…
3-Month Branch Outlook
Forecast model live · history illustrative
This branch's revenue and walk-ins for the next three months, with a 95% range, forecast from the 12 months in the chart above.
Shift Roster
Illustrative dataset
| Day Segment | Shift Window | Total Staff | Open Counters | 5G Specialists | MNP / eSIM Reps | Care & Billing | Hourly Walk-Ins | Avg Queue Wait | Abandonment | Utilisation | Revenue / Labour Hr | Status |
|---|
Sample POS Receipts & MNP Balance
Illustrative dataset
| Product Category | Transactions | Gross Revenue (MYR) | Dealer Commission |
|---|
Branch MNP Port-In vs Port-Out Competitor Balance
Customer Reviews & Suggested Actions
Source: Google Maps
High Churn-Risk Subscribers (national sample)
Illustrative dataset
| Subscriber ID | Plan Name | State | Serving Cell Tower | Dropped Calls | Complaints | Store Sentiment | Churn Risk | Primary Root Cause |
|---|
International Gateway Roaming & Travel eSIM Telemetry
Illustrative dataset
| Gateway Code | Transit Hub Name | Facility Type | Outbound Travelers | eSIM Activations | Roaming Passes | Conversion Rate / 10k | Gross Revenue (MYR) |
|---|
Malaysian Public Holiday Travel Surge Multipliers
Illustrative dataset
| Date | Holiday Name | Holiday Category | Travel Multiplier |
|---|
Enterprise BigQuery Telemetry Tables & Curated Marts
Dataset: `umobile_commercial_mart`
| Entity Group | Table / View Name | Partitioning / Clustering | Description |
|---|---|---|---|
| 1P Telco Core | subscriber_dim |
Cluster by plan_type, registered_state | Subscriber profile master with 5G device status, tenure, and sim format. |
| 1P Telco Core | billing_invoices |
Partition by invoice_date, Cluster by subscriber_id | Monthly recurring plan fee, data add-on upsell, roaming, and net revenue. |
| 1P Telco Core | cell_towers |
Cluster by state, site_classification | 4G/5G cell towers with WGS84 geographic coordinates across Malaysia. |
| Google Platform | google_ads_campaigns |
Partition by campaign_date | Campaign spend, impressions, clicks, CPC, CAC, and attributed conversions. |
| Google Platform | google_maps_stores |
Cluster by state, store_type | 322 retail store locations with exact Place IDs, competitor distance (CelcomDigi, Yes 5G, Unifi), and ratings. |
| Google Platform | store_reviews_enriched |
Partition by review_date | Google Maps reviews enriched with Vertex AI Gemini sentiment scoring, root cause analysis, and operational remedies. |
| Google Platform | ga4_web_traffic |
Partition by calendar_date | GA4 store locator pageviews, directions clicks, and digital eSIM conversions. |
| Google Platform | store_daily_traffic_sales |
Partition by traffic_date | Physical store footfall, counter consultations, queue wait times, and POS activations. |
| 3P External Context | cross_border_transit |
Partition by transit_date | Gateway passenger movements and instant travel eSIM activation volume. |
| 3P External Context | dosm_demographics |
Standard table | Department of Statistics Malaysia state population and household income. |
| Curated Mart | v_executive_kpi_daily |
Analytical SQL View | Daily executive commercial scorecard combining billing, ads, and network base. |
| Curated Mart | v_campaign_o2o_attribution |
Analytical SQL View | Full-funnel attribution bridging Google Ads to GA4 locator, store footfall, and POS activations. |
| Curated Mart | v_store_campaign_footfall_lift |
Analytical SQL View | Pre-campaign 30d baseline vs in-flight daily footfall lift and queue sensitivity. |
| Curated Mart | v_gemini_feedback_diagnostics |
Analytical SQL View | Review topics, sentiment distribution, and operational branch remedies from Gemini. |
| Curated Mart | v_churn_propensity_scored |
Analytical SQL View | Multi-factor churn risk scoring joining QoS packet loss and store reviews. |