6-Month Net Revenue Trajectory
BigQuery `billing_invoices`
Amounts in Million MYR
5G ARPU Uplift by Plan Tier
Commercial Uplift
| Plan Name | 5G ARPU | 4G ARPU | Uplift |
|---|
Data Mesh Architecture Pillars
Google Cloud Verified
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)
Sentiment Analysis
| Store Name | Rating | Reviews | Sentiment |
|---|
Physical Branch Deep-Dive, Workforce Roster & POS Sales Inspector
322 Real Outlets + BigQuery `store_workforce_shifts`
Select any U Mobile Experience Centre, Flagship, or Dealer across 14 states (or click a marker on the Geospatial Map) to inspect its storefront profile, 3-shift staffing roster, 12-month POS sales trajectory, and MNP competitor ledger.
Loading Google Maps Photo...
Experience Centre
UM_MY_001
★ 4.0 (3,529 reviews)
U Mobile Experience Centre Berjaya Times Square
G17, Ground Floor, East Wing, Berjaya Times Square, Kuala Lumpur
Hours: 10:00 AM – 10:00 PM
Terminal Counters: 8 Terminals
Competitor Radius: CelcomDigi 80m | Yes 5G 110m | Unifi 140m
12-Month Branch POS Revenue
MYR 2.94M
52.4% Consult Conv.
Annual Walk-In Footfall: 168,400 visitors
Avg Counter Queue Wait & Abandonment
10.2 mins
2.4% Walk-Out
Target Experience Centre Queue SLA: < 8.5 mins
Workforce Counter Utilization
84.6%
MYR 248 / Labor Hr
Blended across Morning, Peak & Evening Shifts
AI Workforce Shift Recommendation
Loading shift optimization telemetry...
12-Month Branch POS Revenue & Footfall Trajectory
Monthly Sales vs Walk-Ins
Workforce Shift Capacity vs Hourly Walk-In Demand & Queue Wait
Morning / Peak / Evening Shifts
Branch Workforce Shift Roster, Role Allocation & Queue SLA Audit
BigQuery `store_workforce_shifts`
Compares Weekday vs. Weekend / Public Holiday shift headcount against walk-in consultation velocity
| Day Segment | Shift Window | Total Staff | Open Counters | 5G Specialists | MNP / eSIM Reps | Care & Billing | Hourly Walk-Ins | Avg Queue Wait | Abandonment | Utilization | Rev / Labor Hr | Shift SLA Status |
|---|
Branch POS Category Breakdown & MNP Competitor Scorecard
POS + MNP Ledger
| Product Category | Transactions | Gross Revenue (MYR) | Dealer Commission |
|---|
Branch MNP Port-In vs Port-Out Competitor Balance
Verified Google Maps Customer Reviews & Gemini Remedies
Branch Voice of Customer
Omnichannel Campaign Multi-Stage Funnel (O2O Attribution)
Google Ads ➔ GA4 Store Locator ➔ Store Footfall ➔ POS Activations
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 (%)
Baseline vs Flight Lift
Store Queue Sensitivity & Counter Wait Times
Pre-Flight vs In-Flight Queue
| Store Name | State | Type | Base Daily Footfall | Flight Daily Footfall | Footfall Lift | Base Wait | Flight Wait |
|---|
Customer Review Topic Diagnostics
Vertex AI Gemini 3.8 Flash
Sentiment Breakdown & Churn Threat Flags
Google Business Profile Verbatim
Positive Sentiment
--
Neutral Sentiment
--
Negative Sentiment
--
Critical Churn Threat Risk:
-- reviews indicating switching or cancellation
High Priority
Live Interactive Vertex AI Gemini Feedback Diagnostic Box
Real-Time Zero-Shot Extraction
Test with English, Bahasa Melayu, or Manglish feedback
Stratified Customer Feedback Log & Operational Remedies
Google Business Profile Verbatim
| Store Name | Stars | Sentiment | Topic | Language | Customer Verbatim | Diagnostic Root Cause | Operational Action |
|---|
BigQuery ML 90-Day Forward Revenue Forecast (`ARIMA_PLUS`)
Model: `revenue_forecast_model`
Horizon: 90 Days
Confidence Interval: 95%
Holiday Calendar: Malaysia (MY)
* Automated ARIMA_PLUS time-series decomposition incorporates historical seasonal cycles, year-end holiday travel multiplier, and 5G postpaid migration momentum.
Detailed Commercial Plan Portfolio Projections
Cohort Slicing
| Plan Name | Base Fee (MYR) | Data Bundle | 5G Capable | 5G ARPU (MYR) | 4G ARPU (MYR) | Uplift (%) |
|---|
Attributed 90-Day ROAS by Marketing Channel
Google Ads Multi-Touch
Channel Acquisition Performance
CAC Comparison
| Channel | Spend (MYR) | Conversions | CAC (MYR) | ROAS |
|---|
Malaysian Infrastructure & Churn Risk Radar
Google Maps Platform
■ Cell Towers
● U Mobile Stores
▲ Transit Gateways
High Churn Risk Subscriber Correlation (Network QoS + Store Sentiment)
BQML `churn_prediction_model`
| Subscriber ID | Plan Name | State | Serving Cell Tower | Dropped Calls | Complaints | Store Sentiment | Churn Risk | Primary Root Cause |
|---|
International Gateway Roaming & Travel eSIM Telemetry
Gateway Transit Corridor
| 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
3P Holiday Calendar
| 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. |