internal · private analytics

AppMetrica Majordom Analytics

ETL pipeline that pulls the Majordom mobile app's analytics out of Yandex AppMetrica, lands them in a self-hosted ClickHouse warehouse, and exposes them as queryable raw-event tables — every day, automatically.

Auto-pull

05:00 & 15:00 UTC

Bounded contexts

Tests

vitest + msw

Hosting

Self-hosted

Live status

The pipeline runs in production; health is read from a ClickHouse query that measures the lag between now and the most recent ingested event.

checking…

Also: /api/health/freshness · /api/health/runs

Iteration 1 scope

This deploy implements ingestion only — events, session-starts and installations from AppMetrica Logs API into ClickHouse, daily, idempotently. A re-pull of the same day collapses on ReplacingMergeTree(_loaded_at) + OPTIMIZE FINAL DEDUPLICATE.

Iteration 2 plans funnels, retention, cohorts and dashboards on top of the same warehouse. The DDL was shaped with those queries in mind from day one.