Good morning, Marcus
Two-title live status for Helsinki studio · Monday, 14 October 2024 · Fresh 2 min ago
+0.21pp since build 2.18.0 · 18 minutes active
Published 3h 42m ago · 12% revenue lift target
Role-Tailored Live-Ops Landing Dashboard · /
- Components: consolidated status, ARPDAU/crash pair, freshness badges, alert owner, event summary.
- Actions: open KPI console, triage alert, manage schedule.
- Outcomes: drill to offending title, analytics, or event command center.
Unified live-ops mart
BigQuery-native coverage across both live titles. No duplicated ETL logic or static service keys.
| Panel | Title scope | Source tables | Latest partition | Latency | Trust |
|---|---|---|---|---|---|
| Revenue & ARPDAU | Consolidated | iap_*, events_* | 14 Oct · 09:18:04 | 1.2s | Trusted |
| Retention cohorts | Frostbound | events_* | 14 Oct · 09:17:42 | 1.8s | Trusted |
| Sinks & faucets | Starfall Raiders | economy_* | 14 Oct · 09:19:11 | 1.6s | Trusted |
| SKU performance | Both titles | iap_* | 14 Oct · 09:18:33 | 1.7s | Trusted |
Title partitions
Data contract review
Unified mart contract signed off by Live-Ops Lead and hands-on operator.
View contract evidence →
Unified Live-Ops Mart and Data Freshness · /data-mart
- Components: source coverage, freshness registry, title partitions, trust state.
- Actions: run freshness check, inspect contract.
- Outcome: validates BigQuery-native foundation without exposing credentials.
KPI & cohort performance
Consolidated performance across Frostbound and Starfall Raiders.
| Install week | Players | D1 | D7 | D30 |
|---|---|---|---|---|
| Oct 7–13 | 184.2K | 42.1% | 18.8% | 8.4% |
| Sep 30–Oct 6 | 201.7K | 41.4% | 18.2% | 8.1% |
| Sep 23–29 | 196.3K | 40.7% | 17.6% | 7.9% |
| Sep 16–22 | 188.9K | 40.2% | 17.4% | 7.7% |
KPI and Cohort Performance Console · /analytics/kpis
- Components: KPI cards, synchronized filters, trend chart, D1/D7/D30 table, conversion funnel.
- Actions: switch title, choose cohort, export, share, drill down.
- Outcome: opens fresh slicer or stage-level analysis.
Fresh cohort slicer
Diagnose the soft-currency sale without waiting for the morning Notion pull.
Slice definition
Filters are allow-listed and parameterised. Estimated scan: 2.1 GB.
Query guardrails
Within 10 GB cost ceiling and 15-minute freshness SLA.
EU cohorts enforce k-anonymity k≥10.
Fresh Cohort Slicer and Pricing Diagnosis · /analytics/cohorts/new
- Components: allow-listed filters, cost preview, freshness SLA, highlighted SKU and revenue delta.
- Actions: run, duplicate, save, share.
- Outcome: result pins affected cohort and opens saved library.
Saved cohort views
Reusable, reproducible diagnosis definitions owned by analysts and economy designers.
| View name | Owner | Scope | Last run | Freshness | Version | Actions |
|---|---|---|---|---|---|---|
| Soft sale ARPPU check soft_currency_sale_500 | Designer | Frostbound · EU | Today 09:20 | 2 min | v4 | |
| Whale LTV · Nordics €100+ / 30 days | Analyst | Both titles | Yesterday 16:42 | 18 min | v8 | |
| D7 retention by title | Analyst | Both titles | Oct 11 11:08 | 3h | v3 | |
| Starter bundle conversion | Designer | Starfall Raiders | Oct 10 14:26 | 12 min | v2 |
Saved Cohort Views · /analytics/cohorts
- Components: owned view library, version, reproducibility and freshness metadata.
- Actions: open, duplicate, share by URL.
- Outcome: returns to reusable slicer definitions.
Economy anomaly monitor
Live bounds monitoring for sinks, faucets and low-volume IAP SKUs.
| Signal | Title | Baseline | Current | Delta | Duration | Threshold | Owner |
|---|---|---|---|---|---|---|---|
| soft_currency_faucet | Frostbound | 1.05M/day | 1.24M/day | +18.4% | 42 min | ±15% | Designer |
| iap:starter_bundle_v3 | Starfall Raiders | €12.80 ARPPU | €11.94 | −6.7% | 18 min | €0.50 abs | Designer |
| premium_currency_sink | Frostbound | 820K/day | 806K/day | −1.7% | — | ±10% | System |
| battle_pass_faucet | Starfall Raiders | 410K/day | 416K/day | +1.5% | — | ±10% | System |
Economy Sinks and Faucets Anomaly Monitor · /economy/anomalies
- Components: signal cards, baseline/current/delta table, breach duration and freshness.
- Actions: filter title/signal, configure, share, duplicate view.
- Outcome: governed threshold screen or diagnosis workflow.
Anomaly thresholds
Governed configuration for per-title, per-SKU and sink/faucet detection.
Raising a threshold by more than 50% triggers Slack notification and append-only audit logging. Current proposed change: +0%.
| Rule | Change | Requested by | Requested | Second approver | Status | |
|---|---|---|---|---|---|---|
| SR · starter_bundle_v3 | ±5% → ±7% | Designer | Today 08:52 | Live-Ops Lead | Pending | |
| FB · premium_currency_sink | ±10% unchanged | System | Oct 08 | Live-Ops Lead | Approved v12 |
Anomaly Threshold Configuration and Approval · /economy/anomalies/thresholds
- Components: threshold form, relative/absolute rules, approval queue, version pins.
- Actions: save draft, approve, inspect audit.
- Outcome: approved changes activate without blocking event scheduling.
LiveOps event schedule
Sales, battle passes and limited-time offers from draft through rollback.
| Event | Title | Type | Window | Status | Owner | Audit | |
|---|---|---|---|---|---|---|---|
| Soft Currency Weekend Sale | Frostbound | Sale · A/B | Oct 14–16 | Live | Designer | Complete | |
| Battle Pass Season 4 | Starfall Raiders | Battle pass | Oct 21–Dec 02 | Scheduled | Producer | Complete | |
| Harvest Moon LTO | Frostbound | Limited offer | Oct 18–20 | Approval | Producer | 1 pending | |
| Starter Bundle Refresh | Starfall Raiders | Sale | Oct 11–12 | Rolled back | Designer | Complete |
LiveOps Event Schedule · /liveops/events
- Components: event list, statuses, ownership, audit completeness and SLA.
- Actions: configure, review, open command center.
- Outcome: event creation or detail/publishing workflow.
Configure LiveOps event
Create a sale, battle pass or limited-time offer with required A/B controls visible.
Event basics
A/B test allocation
Control and variant controls are available by default.
Effect size, confidence interval and control/variant retention will be calculated automatically.
LiveOps Event Configuration and A/B Test · /liveops/events/new
- Components: event basics, title, dates, config, cohort, split, success metric.
- Actions: autosave, validate, commit schedule.
- Outcome: opens event command center with audit and publishing controls.
Soft Currency Weekend Sale
Frostbound · Oct 14 09:00 – Oct 16 23:59 · Owner: Designer
Soft currency faucet anomaly is linked to this event. Review economy monitor for baseline comparison.
| Metric | Control | Variant | Effect size | 95% CI |
|---|---|---|---|---|
| ARPDAU | €0.38 | €0.43 | +13.2% | [+8.1%, +18.3%] |
| Conversion | 8.4% | 9.7% | +1.3pp | [+0.7pp, +1.9pp] |
| D7 retention | 18.1% | 18.6% | +0.5pp | [−0.2pp, +1.2pp] |
Immutable audit history
Oct 14 · 13:18 · hands-on operator · hash 8a91…
Oct 14 · 10:12 · Live-Ops Lead · hash 30bf…
Oct 14 · 09:04 · Designer · hash 144e…
LiveOps Event Detail, Experiment Results and Publishing · /liveops/events/:eventId
- Components: publishing status, experiment table, confidence intervals, immutable audit.
- Actions: inspect anomaly, rollback, review history.
- Outcome: rollback request is audited and approval gated.
IAP SKU & whale LTV analysis
Synchronized title comparison for revenue, conversion, ARPPU and definable whale LTV.
| SKU | Frostbound revenue | Frostbound ARPPU | Starfall revenue | Starfall ARPPU | Consolidated conversion |
|---|---|---|---|---|---|
| soft_currency_sale_500 | €82.4K | €18.95 | €61.2K | €17.88 | 9.7% |
| starter_bundle_v3 | €44.7K | €12.44 | €55.8K | €12.80 | 8.4% |
| battle_pass_s4 | €39.1K | €24.12 | €48.9K | €26.07 | 6.8% |
| premium_currency_1200 | €31.8K | €16.20 | €28.3K | €15.92 | 5.9% |
Whale LTV by cohort
Definition
Whale = players with €100+ IAP revenue in rolling 30-day window. Definition v8 · Analyst.
IAP SKU and Whale LTV Analysis · /analytics/iap-skus
- Components: synchronized filters, SKU table, whale threshold, LTV chart.
- Actions: adjust threshold, compare titles, export, share.
- Outcome: creates a shareable stand-up review view.
KPI annotation timeline
Attribute ARPDAU, IAP revenue, ARPPU and retention movement to releases and balance patches.
Attribution ledger
| Annotation | Title / version | Pre/post window | ARPDAU delta | IAP revenue delta | Author | |
|---|---|---|---|---|---|---|
| Balance patch | Starfall Raiders · 2.18.0 | 7d / 7d | −€0.03 | −4.2% | Producer | |
| Build release | Frostbound · 2.17.4 | 3d / 7d | +€0.02 | +6.8% | Analyst |
Release and Balance Patch Annotation Timeline · /timeline/annotations
- Components: KPI chart overlays, attribution ledger, version history.
- Actions: add, edit, choose pre/post window, filter title.
- Outcome: produces auditable stand-up attribution.
Segment builder & CRM export
Define reusable audiences for CRM targeting with GDPR guardrails applied by default.
Segment definition
Export review
12,842 eligible rows · canonical pseudonymised player_id mapping · no direct EU identifiers.
Submission records requester, timestamp, segment hash, payload hash and retention status.
Segment Builder and CRM Export Review · /segments/export
- Components: reusable segment DSL, consent/minor exclusions, k-anonymity, export review.
- Actions: validate, provide reason, export pseudonymised.
- Outcome: creates immutable receipt and opens receipt history.
Export receipts
Restricted analyst and administrator view of CRM delivery evidence.
| Receipt | Requester | Segment definition hash | Rows | Destination | Pseudonymisation | Retention |
|---|---|---|---|---|---|---|
| EXP-7841 14 Oct · 09:24 | Analyst | seg_91b2… | 12,842 | Studio CRM | Applied | Until 2030-10-14 |
| EXP-7838 11 Oct · 15:42 | Analyst | seg_3ac8… | 8,104 | Studio CRM | Applied | Until 2030-10-11 |
| EXP-7802 04 Oct · 10:11 | Designer | seg_7d20… | 18,991 | Studio CRM | Applied | Until 2030-10-04 |
Compliance control
EU rows expose pseudonymised player_id only. Direct identifiers never enter Cloud SQL, alerts, exports or derived marts.
Contract verified · 100%Selected receipt
Payload hash: sha256:ab77c1…
Requester e-signature and consent validation retained in immutable storage.
Export Receipts and GDPR Audit History · /segments/exports
- Components: restricted receipt ledger, hashes, rows, destination, retention.
- Actions: inspect evidence, export receipt list.
- Outcome: supports GDPR Article 30 accountability.
Revenue & crash regression alerts
In-console source of truth with safe deep links and Slack delivery status.
| Alert | Title / cohort | KPI delta | Annotation context | Duration | Owner | Slack | |
|---|---|---|---|---|---|---|---|
| CRASH Crash-rate regression | Starfall Raiders · all players | +0.21pp | Balance patch 2.18.0 | 18 min | Producer | Delivered | |
| REVENUE ARPPU regression | Frostbound · Oct 7 cohort | −11.6% | Soft Currency Weekend Sale | 42 min | Designer | Delivered | |
| DIGEST Economy anomaly storm | Both titles · SKU cluster | 4 signals | Nearest: build 2.18.0 | 1h 12m | Designer | Delivered |
Revenue and Crash Regression Alerts · /alerts
- Components: alert inbox, cohort/KPI delta, nearest annotation, owner, Slack status.
- Actions: open safe deep link, diagnose, tune, review.
- Outcome: opens exact title/time tile or fresh slicer.
Alert thresholds & notifications
Prominent, auditable controls for revenue, crash-rate and anomaly coverage.
Regression thresholds
Slack routing
Current coverage
Alert Thresholds and Notification Settings · /alerts/settings
- Components: relative/absolute thresholds, Slack route, mute, deduplication.
- Actions: save audited changes, test delivery, mute specific windows.
- Outcome: maintains coverage without alert flood.
Operational analytics & reliability
PostHog instrumentation, freshness SLA, latency and reclaimed analyst effort.
Journey instrumentation
PostHog events contain no direct identifiers.
Reliability trend
Operational Analytics and Reliability Dashboard · /admin/operations
- Components: PostHog journey counts, freshness breaches, latency, publishing reliability.
- Actions: inspect trends and SLA periods.
- Outcome: validates 25-hour reclaimed-effort and reliability goals.
Access, privacy & session controls
Verified Workspace group mapping, MFA posture and pseudonymisation evidence.
Workspace group mapping
| Workspace group | Console role | Members | Status |
|---|---|---|---|
| liveops-leads | Live-Ops Lead | 1 | Verified |
| economy-design | Economy Designer | 2 | Verified |
| liveops-analysts | Analyst | 1 | Verified |
| liveops-producers | Producer | 1 | Verified |
| liveops-operators | Hands-on Operator | 1 | Verified |
Active sessions
Elevated actions
Step-up MFA required for event publishing, rollback and CRM export. Routine actions remain session-based.
Policy activePseudonymisation contract
Canonical player_id mapping remains exclusively in BigQuery. EU direct identifiers blocked at query layer.
Verified annuallyDPO contact
Data Protection Officer: privacy@helsinki-studio.example
PDPA / GDPR enquiries · 30-day response process.
Access, Privacy and Session Controls · /admin/access-privacy
- Components: group-to-role mapping, active sessions, MFA, privacy contract, DPO contact.
- Actions: revoke sessions, inspect evidence.
- Outcome: confirms least-privilege and GDPR/PDPA controls.
Immutable audit timeline
Tamper-evident record of access, configuration, publishing, annotation and export actions.
| Timestamp | Action | Actor / role | Object | Payload hash | Previous hash | Verification |
|---|---|---|---|---|---|---|
| 14 Oct 09:24:08 | CRM export | Analyst · Analyst | EXP-7841 · 12,842 rows | ab77c1… | f290d8… | Verified |
| 14 Oct 09:18:12 | Threshold approval | Live-Ops Lead | SR starter_bundle_v3 v7 | 8c119a… | 2bc001… | Verified |
| 14 Oct 09:04:33 | A/B allocation | Designer · Designer | evt_1042 · 50/50 | 144e2b… | ae8101… | Verified |
| 14 Oct 08:57:19 | Login | Producer · Producer | Google Workspace SSO + MFA | 12aa9e… | — | Verified |
| 13 Oct 17:41:02 | Annotation edited | Analyst · Analyst | Starfall 2.18.0 · v3 | 9d1f42… | 1b09c0… | Verified |
All 18,482 audit rows validate against the write-once BigQuery audit dataset. Last verification: 14 Oct 09:25 UTC.
Immutable Audit Timeline · /admin/audit
- Components: append-only event ledger, actor/role, payload and previous hashes.
- Actions: filter, search, export evidence, verify chain.
- Outcome: supports non-repudiation and GDPR accountability.