Value Packs / Telecom / Revenue & Usage Analytics / Brief 01

Revenue & Usage Analytics · Brief 01

ARPU decline · New York Postpaid Gold

30-day rolling ARPU, scored each day and decomposed by stream

DataGenie Brief · autonomous · daily
Billing & revenue summary + network usage · by city × segment × plan · 0 rows moved

The one line you configure

Where does ARPU sit against its expected range today, across every city × segment × plan — and where is revenue per subscriber drifting while usage holds?

In a nutshell

This is not a usage problem. Across the last 14 daily reads, 30-day rolling ARPU has fallen 8% ($142 → $131) while data usage per subscriber rose 15% and the active base held. The whole gap is one stream: roaming revenue down 23%, concentrated in Business subscribers, after international roaming sessions fell 31% following the 1 April corporate travel-policy change. Plan-fee and VAS revenue are flat.

At a glance

ARPU · Gold New York$131−8%
Roaming revenue−23%the whole gap
Data per subscriber+15%usage is up
Active baseflatnot churn

Today's ARPU against its expected range, by plan · New York

belowwatchin bandabove
5G Ultra · Premium187
Postpaid Gold · Businessdrifting131
Postpaid Silver · Standard98
Prepaid Flex · Youth54

What moved

Roaming revenue · Businessthe entire gap sits here−23%
International roaming sessionssince the 1 April policy change−31%
Data usage per subscriberrising — not a usage problem+15%
Active subscribers · Goldbase is stable, so not churnflat
Plan-fee revenueunchanged — not a pricing moveflat

WHAT MOVED · 30-day rolling ARPU against its expected floor

ARPU · New York Gold Business−8%
$126$131.5$137$142.5$148crossed the floor · D-10D-13D-11D-9D-7D-5D-3D-1
Days below floor10
Fall11.3$
Active baseflat

Ten consecutive daily reads below the expected floor, and no recovery — the definition of drift rather than noise.

WHERE IT IS · ARPU change by segment × plan · New York

5G UltraPostpaid GoldPostpaid SilverPrepaid Flex
Business−1%−14%−2%
Premium+1%−4%0%
Standard0%−2%−1%+1%
Youth+2%+3%

One cell carries it: Business × Postpaid Gold at −14%. Every other segment on the same plan is within a point or two of flat, which is why a plan-level or city-level read never surfaced it.

WHY IT MOVED · Where the $11 of ARPU went, stream by stream

$0$35.5$71$106.5$142$142ARPU·14-9.4Roaming-2.1Overage+0.3VAS0Planfee-0.1Deviceinstalment$130.7ARPU·today

Roaming accounts for $9.4 of the $11.3 fall. Plan fee — the stream a pricing action would touch — did not move at all.

What the connected view adds

Billing alone shows ARPU falling and reads as price or churn. Usage alone shows consumption rising and reads as healthy. Only the two on the same segment slice show a revenue-mix shift with a specific, external cause — and that it is not fixable by pricing.

So what

Do not price against this. ARPU recovers only if roaming volume returns or the Business bundle is restructured to carry the travel change — a product decision, not a discount. Hand the New York Gold · Business cohort to product and pricing with the roaming decomposition attached, and keep the daily read running so the recovery (or the next leg down) is visible in days rather than at quarter close.

The points that matter

Usage rose while revenue fell

Data per subscriber up 15% with a flat base — the decline cannot be explained by consumption or churn.

+15%data/sub

One stream, one segment

Roaming revenue down 23% in Business subscribers accounts for $9.4 of the $11.3 ARPU fall.

−23%roaming

An external cause, not a market one

International roaming sessions fell 31% from 1 April, matching a corporate travel-policy change rather than competitive pressure.

−31%sessions

Pricing is the wrong lever

Plan-fee revenue is unchanged, so a discount or a tariff move would cost margin without touching the cause.

flatplan fee

Questions it already answers

Is this New York, or is it every metro with a Business base?

Runs the same decomposition across cities and segments, so the answer is the list of affected cohorts rather than one city's story.

What can this not tell us?

Not whether the travel policy is permanent — that sits with the corporate account teams. It sizes the exposure and names the cohort so they can be asked the right question.