Falcon Telecom & Media — Portal
Reporting Period: FY 2025 · Cross-Domain Analytics Suite
Cross-Domain Headline KPIs (FY 2025)
Telecom Billed Rev
$13.57M
↑ 5.6% vs FY 2024
Active Subscribers
88.0K
88% of 100K base
Net Adds 2025
51.4K
↑ 7.6% vs FY 2024
Ad Revenue 2025
$1.72B
↑ 4.6% vs FY 2024
Streaming Sessions
186K
↑ 5.6% vs FY 2024
Ticket Revenue
$80.0M
↑ 7.6% vs FY 2024
License Fees 2025
$49.1B
8,894 deals
ARPU 2025
$92.14
Stable across years
Multi-Year Cross-Domain Trend
Revenue by Domain — 2018–2025 ($M)
Top 5 Prospect Carriers — Lifetime Billing ($M)
Dashboard Directory
1 · Executive
Executive Overview
Cross-domain headline KPIs, multi-year trends, top movers across all six fact tables.
2 · Telecom
Subscriber Performance
Acquisitions, churn, upgrades, demographics. 8 lifecycle event types, 5 segments × 5 age bands.
3 · Telecom
Billing & Revenue
Bill components, ARPU, autopay, payment health. Carrier and plan breakdowns.
4 · Telecom
Plan & Carrier Mix
28 plans across 8 carriers. 5G adoption, unlimited share, technology mix.
5 · Media
Advertising Revenue
Top 35 advertisers, 12 formats, 6 channels. CPM, completion, viewability.
6 · Media
Streaming Viewership
12 platforms, sessions, completion, binge rate, device split, quality tiers.
7 · Media
Content Rights & Licensing
License fees, exclusivity premium, top licensors, 10 rights types × 4 windows.
8 · Media
Live Events & Tickets
12 event types, 8 tiers, dynamic markup, VIP mix, channel split, resale premium.
9 · Cross-Domain
Geographic Performance
30 DMAs, 4 regions, 50 states. Cross-domain revenue map.
10 · Cross-Domain
Subscriber 360
Single-subscriber view across billing, viewership, and tickets. Segment engagement index.
11 · Telecom
Churn Analysis Deep Dive
8 churn reasons, carrier × tenure × segment, win-back via Reactivation, LTV lost.
Insight Reports
AutoExplore output — 16 hypotheses tested across all 6 fact tables. Directed cross-domain Subscriber 360 exploration · 7 findings · 14 disproven hypotheses · 1 meta-finding · Generated 2026-04-25.
🔍 Insight
Evidence Dashboard
7 finding cards with charts. The COVID Q2 2020 substitution, the Carrier↔Platform null, the heavy-tailed spending pattern, and 4 more.
📄 Insight
Long-form Memo
Executive summary, methodology, full evidence per finding, what-we-didn't-find, and prioritized recommended actions.
📓 Insight
Hypothesis Journal
Iteration-by-iteration log: every hypothesis, query, result, and verdict. Markdown — opens in your editor.
Reference
Reference
Metrics & KPI Definitions
Searchable, categorized definitions of every metric used across the suite. Includes formula, unit, direction, and which dashboards reference each metric.
US State-Level Performance — Lifetime Billed Revenue
Billed Revenue by State (Tile Grid)
22 states with subscriber footprint · darker = higher revenue · hover any state for detail
22
States with data
$92.05M
Total US billed
NY · $21.98M
Top state
Lower Higher No data
Top 15 DMAs by Lifetime Billed Revenue
Rank DMA State Region Tier Billed Rev (Lifetime) Subscribers
Data: Falcon Telecom & Media synthetic warehouse · 4.7M fact rows · 2018-01-01 → 2026-04-17 · Filters: Active subscribers only on current-base KPIs · Prospect carriers shown by default (toggle for all 8) · Notes: Disputed bills included in revenue · 2026 shown as YTD · Calendar fiscal year · Generated: 2026-04-24