Gaming Analytics Platform
Medallion architecture processing 380M+ records with 99.4% financial accuracy
The Problem
Fragmented data across 11 sources, manual reporting, no unified view. A mobile gaming company with 7 active titles had revenue and user acquisition data scattered across 11 different sources — ad networks (Facebook, Google, Unity, ironSource), app stores (Apple, Google Play), payment processors, attribution platforms, and internal telemetry. Reporting was manual, time-consuming, and frequently inaccurate. Finance could not reconcile revenue numbers. Executives lacked a unified view of business performance.
Our Approach
We designed and built a medallion architecture (Bronze / Silver / Gold) on Google Cloud Platform. Raw data from all 11 sources lands in the Bronze layer unmodified. The Silver layer handles cleaning, deduplication, currency normalization, and schema enforcement. The Gold layer produces business-ready aggregations optimized for dashboard performance.
30 automated pipelines run on Cloud Run, orchestrated with scheduling and dependency management. 13 executive dashboards in Metabase give the leadership team real-time visibility into revenue, user acquisition, retention, and cohort performance across all titles. Financial reconciliation accuracy reached 99.4% — replacing manual spreadsheet work that previously took days.
Architecture
Medallion architecture from raw ingestion to executive dashboards
Bronze Layer
Raw data ingestion from 11 fragmented sources — ad networks, app stores, payment processors, attribution platforms, and internal game telemetry. All data lands unmodified for auditability.
Silver Layer
Cleaned, validated, and standardized data. Deduplication, schema enforcement, currency normalization, and time zone alignment across all sources.
Gold Layer
Business-ready aggregations: revenue by title, UA spend vs. LTV, cohort retention, daily/weekly/monthly KPIs. Optimized for dashboard query performance.
Analytics Layer
13 executive dashboards in Metabase covering revenue, user acquisition, retention, cohort analysis, and financial reconciliation across all 7 active titles.
Tech Stack
Data Warehouse
Google BigQuery
Compute
GCP Cloud Run
Visualization
Metabase (13 dashboards)
Language
Python
Architecture
Medallion (Bronze / Silver / Gold)
Data Sources
11 integrated sources
Results
Records processed
Automated pipelines
Executive dashboards
Financial reconciliation accuracy
Data sources unified
Active game titles covered