From: Daniel Otieno, Head of Customer Value Management

Finance wants the Usiku numbers in a workbook they can audit before the commercial review. The extract is Kilele_Bundle_Extract.xlsx.

Usage is the complete usage_monthly for the two comparison periods (before: Jun to Aug 2025, after: Dec 2025 to Feb 2026) with an adopter flag (has the subscriber ever bought a night bundle). Bundle_Monthly is every bundle purchase from Mar 2025 to Jun 2026 aggregated by month, bundle and adopter flag. Daily_1GB_Adopters is every Daily 1GB (D-1GB-24H) purchase by adopters from Mar 2025 to Feb 2026 with a before/after launch flag.

Build: 1. A PivotTable of average total data, average night data, average day data and average revenue per subscriber-month, by adopter flag and period, active months only. 2…