Admin Dashboard

Investment Analytics Database Management (Phase 1: Solidgate)

Database Status

Connection
Checking...
Last Sync
Data Freshness

Cron Jobs

Loading cron jobs...

Database Tables

Loading tables...

Data Quality Checks

Running checks...

Profit Estimation

Calculate Total D70 predicted revenue minus spend for all apps. Uses LTV estimates with mobile uplift.

Auto-Fill LTV from D70 Data

Select cohort date range (users who made first purchase in this range). Countries with cohort < min size use product average.

Product LTV Estimates

Loading LTV estimates...

Realized Segmented LTV

Computes D10/D40/D70 LTV broken down by product, country, gender, age range, device OS, and image uploaded simultaneously. Segments with fewer than 20 cohort customers are filtered out.