Analytics Engineering · Data & Insights

One semantic layer. Two lenses.

A governed semantic metrics layer — metric definitions and data standards defined once — viewed through two stakeholder lenses: Content Finance (planning, forecasting & executive reporting) and Games (retention, completion, stickiness). Every number traces to the star-schema model and the SQL beneath it.

Content spend (plan)
$1.20B
32 titles · FY2025
Budget variance
+4.8%
$57M over · 27 titles over
Active users
600
13,130 streams
Avg completion
23%
2,510 game sessions

Cumulative content spend — plan vs. actual

Content Finance · FY2025 running totals ($M)
$0M$341M$681M$1022M$1362M25-0125-0325-0525-0725-0925-11
Planned
Actual

Retention — first-stream cohorts

Engagement · % of each cohort active by month offset
M0M1M2M3M4M52025-01 (116)100%66.4%42.2%31.9%22.4%14.7%2025-02 (112)100%76.8%59.8%45.5%33.9%25.9%2025-03 (83)100%69.9%47%27.7%21.7%10.8%2025-04 (94)100%63.8%50%37.2%29.8%19.1%2025-05 (97)100%77.3%54.6%38.1%24.7%16.5%2025-06 (98)100%66.3%53.1%40.8%29.6%18.4%

Both lenses are computed by the same governed metric definitions — see the (semantic layer + data model).