Enterprise AI Administration
Governance & Lineage — Net adds
How this KPI is sourced, calculated, governed, predicted and acted on — one traceable chain.
Current value
+68k
No stored target
Mission area
Subscriber Growth
Decision journey
Subscriber Growth
Source systems
1
CRM
Lineage path
From source system to value realization — counts of governed records linked to this KPI
- 1 Sources
- 3 Mappings
- 10 Variables
- 1 Formula
- 1 Rules
- 3 Models
- 4 Scenarios
- 3 Actions
- 1 Value records
Formula
Governed calculation for this KPI
Net Adds APPROVED
Change in the active base during the period
gross adds − disconnects
Version 1.0 · Grain Account-month · Owner Head of Commercial Planning · Sources: CRM
Source-to-target lineage
Source system, object and field feeding this KPI, and how each is transformed
| Role | Source | Transformation | Target | Grain / refresh |
|---|---|---|---|---|
| Gross adds | CRMcrm_subscribers.activation_date | Gross add when activation_date falls in period and first usage within 30 days | subscriber_dimension.activation_date | Subscriber-month · Daily |
| Disconnections | CRMcrm_subscribers.termination_date | Churn event when termination_date falls in period; voluntary/involuntary from reason code | subscriber_dimension.termination_date | Subscriber-month · Daily |
| Status changes | CRMsubscription.status_change | Classify activations and disconnects | subscriber_movements.gross_adds / disconnects | Subscriber-day · Daily |
Business rules
Thresholds that escalate this KPI and the alert each raises
| Rule | Severity | Alert raised |
|---|---|---|
| Net Adds Shortfall ≤ 80% of plan | MEDIUM | Retail activations down in North |
Models
Predictive and simulation models used for this KPI
| AI model | Validation | Simulation model |
|---|---|---|
| Net Adds Forecast Model SARIMAX (benchmark: ARIMA) · v1.2 | VALIDATION REQUIRED | Subscriber Growth Scenario Model |
| Subscriber Behavioral Segmentation Model K-Means · v0.1 | VALIDATION REQUIRED | — |
| Usage Pattern Segmentation Model K-Means · v0.1 | VALIDATION REQUIRED | Subscriber Growth Scenario Model |
Governed variables
Model features derived from the source fields above
Scenarios
Stored scenarios for the Subscriber Growth journey
- Status quono action
- Digital-first acquisitionalternative
- Base casebase case
- Distributor incentivesRECOMMENDED
Actions & value
Governed actions and value records for the same journey
- Agree new commission structure with distributorsHead of Sales · Not started
- Release stock financingFinance · Not started
- Launch dormant reactivation SMSCRM · Not started
- Dormant base reactivationUSD 0.8M expected · USD 0.12M recorded actual — unverified · AT RISK