Livoa LogoLivoa
Scaled data infra, enabling data-driven decisions & actions | Schema
Data-sources/
Primary source of truth


Production App

Back-end: Transactional & gameplay data

Front-end events tracking


Mobile measurement partner

User marketing attribution data

ETL/ELT layer


Change data capture [CDC]

Data-streaming & Queue mgmt

Develop data pipelines

Run jobs/data-pipelines

Schedule & monitor data pipelines

Data-lake
[Medallion architecture]


Tools and Technology

AWS S3 [Data storage]

Glue catalog [Data catalog]

Trino [Query engine]


Medallion structure

Bronze Layer
Raw structured and unstructured data is dumped from source

Silver Layer
Transformation of unstructured data into consumable format

Gold Layer
Processed data joining multiple sources & tables to empower decision making. Eg, Marketing gold layer, Unified customer view [UCV]...

Consumption layer
[Internal users]


Business Intelligence [BI]

Business reporting & dashboards

Ops/Adhoc analytics & reports


Back-office [BO]

Tactical & Operational analytics, game & platform configs and A/B test experiments


Machine learning engine

ML-models to identify, tag and quantify user-behaviour. Output is stored in UCV gold layer

Retention/CRM layer
[Customer facing]


Customer-retention [CRM]

Communication campaigns, missions, nudges powered by DL Gold layer

A/B experiments powered by Back-office tesseract to engage & retain users


CRM analytics

Reports to assess campaign ops performance – delivery rates, CTR etc.

Funneling back campaign + A/B test analytics into Gold layer & tesseract

BI architecture

by Manan

0
0 uses