Enterprise AI Administration
Governance & Lineage — Blended ARPU
How this KPI is sourced, calculated, governed, predicted and acted on — one traceable chain.
Current value
USD 4.32
No stored target
Mission area
Revenue & ARPU
Decision journey
Revenue & Profitability
Source systems
2
CRM · Billing
Lineage path
From source system to value realization — counts of governed records linked to this KPI
- 2 Sources
- 3 Mappings
- 10 Variables
- 1 Formula
- 1 Rules
- 3 Models
- 4 Scenarios
- 3 Actions
- 1 Value records
Formula
Governed calculation for this KPI
Blended ARPU APPROVED
Average service revenue per active subscriber
service revenue / average active subscribers
Version 1.0 · Grain Subscriber-month · Owner Head of Pricing & Revenue · Sources: Billing, Finance ERP
Source-to-target lineage
Source system, object and field feeding this KPI, and how each is transformed
| Role | Source | Transformation | Target | Grain / refresh |
|---|---|---|---|---|
| Average active base (denominator) | CRMsubscription.status_change | Classify activations and disconnects | subscriber_movements.gross_adds / disconnects | Subscriber-day · Daily |
| Tariff group | Billingbilling_subscriptions.plan_code | Map plan_code to governed tariff group | subscriber_monthly_features.plan_type | Subscriber-month · Daily |
| Service revenue (numerator) | Billingbilling_service_revenue.amount | Sum by revenue_type and billing_period; excludes equipment and VAT | revenue_kpi_mart.service_revenue | Account-month · Daily |
Business rules
Thresholds that escalate this KPI and the alert each raises
| Rule | Severity | Alert raised |
|---|---|---|
| ARPU Erosion Alert −2% blended / −5% voice over 3 months | HIGH | Voice ARPU erosion |
Models
Predictive and simulation models used for this KPI
| AI model | Validation | Simulation model |
|---|---|---|
| High-Value Subscriber Segmentation Model Gaussian Mixture Model · v0.1 | VALIDATION REQUIRED | — |
| ARPU Uplift Model XGBoost · v2.4 | VALIDATION REQUIRED | ARPU Elasticity Model |
| Subscriber Behavioral Segmentation Model K-Means · v0.1 | VALIDATION REQUIRED | ARPU Elasticity Model |
Governed variables
Model features derived from the source fields above
Scenarios
Stored scenarios for the Revenue & Profitability journey
- +10% all bundlesupside
- +6% mid-tier repricingRECOMMENDED
- Hold pricesno action
- Base casebase case
Actions & value
Governed actions and value records for the same journey
- Configure new tariffs in billingHead of Pricing · In progress
- Brief channels and update price listsHead of Sales · Not started
- Monitor take-up and churn daily for 2 weeksRevenue Analytics · Not started
- Prepaid ARPU uplift (bundle repricing)USD 3.2M expected · USD 1.45M recorded actual — unverified · ON TRACK