{"queries":[{"id":"signups","compiledQueryString":"SELECT\n captured_date,\n accounts_today as new_accounts,\n accounts_total\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","inputQueryString":"SELECT\n captured_date,\n accounts_today as new_accounts,\n accounts_total\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","compiled":false,"inline":true},{"id":"retention_funnel","compiledQueryString":"SELECT 'Total Accounts' as stage, accounts_total as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","inputQueryString":"SELECT 'Total Accounts' as stage, accounts_total as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","compiled":false,"inline":true},{"id":"retention_mau","compiledQueryString":"SELECT 'Monthly Active' as stage, accounts_online_month as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","inputQueryString":"SELECT 'Monthly Active' as stage, accounts_online_month as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","compiled":false,"inline":true},{"id":"retention_wau","compiledQueryString":"SELECT 'Weekly Active' as stage, accounts_online_week as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","inputQueryString":"SELECT 'Weekly Active' as stage, accounts_online_week as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","compiled":false,"inline":true},{"id":"retention_dau","compiledQueryString":"SELECT 'Daily Active' as stage, accounts_online_today as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","inputQueryString":"SELECT 'Daily Active' as stage, accounts_online_today as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","compiled":false,"inline":true},{"id":"retention_online","compiledQueryString":"SELECT 'Online Now' as stage, accounts_online as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","inputQueryString":"SELECT 'Online Now' as stage, accounts_online as users\nFROM heycafe.platform_snapshots ORDER BY captured_date DESC LIMIT 1","compiled":false,"inline":true},{"id":"churn_data","compiledQueryString":"SELECT\n captured_date,\n accounts_banned as banned,\n accounts_deleted as deleted\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","inputQueryString":"SELECT\n captured_date,\n accounts_banned as banned,\n accounts_deleted as deleted\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","compiled":false,"inline":true},{"id":"retention_trend","compiledQueryString":"SELECT\n captured_date,\n accounts_online_today as dau,\n accounts_online_week as wau,\n accounts_online_month as mau\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","inputQueryString":"SELECT\n captured_date,\n accounts_online_today as dau,\n accounts_online_week as wau,\n accounts_online_month as mau\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","compiled":false,"inline":true},{"id":"account_loss","compiledQueryString":"SELECT\n captured_date,\n ROUND((accounts_banned + accounts_deleted) * 100.0 / NULLIF(accounts_total, 0), 3) as loss_pct\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","inputQueryString":"SELECT\n captured_date,\n ROUND((accounts_banned + accounts_deleted) * 100.0 / NULLIF(accounts_total, 0), 3) as loss_pct\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","compiled":false,"inline":true},{"id":"growth_acceleration","compiledQueryString":"SELECT\n captured_date,\n accounts_today as daily_signups,\n ROUND(accounts_week * 1.0 / 7, 1) as avg_daily_from_week,\n ROUND(accounts_month * 1.0 / 30, 1) as avg_daily_from_month\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","inputQueryString":"SELECT\n captured_date,\n accounts_today as daily_signups,\n ROUND(accounts_week * 1.0 / 7, 1) as avg_daily_from_week,\n ROUND(accounts_month * 1.0 / 30, 1) as avg_daily_from_month\nFROM heycafe.platform_snapshots\nWHERE captured_date >= current_date - (\n SELECT CASE\n WHEN date_diff('day', MIN(captured_date), current_date) <= 14 THEN INTERVAL 7 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 45 THEN INTERVAL 30 DAY\n WHEN date_diff('day', MIN(captured_date), current_date) <= 90 THEN INTERVAL 60 DAY\n ELSE INTERVAL 90 DAY\n END FROM heycafe.platform_snapshots\n)\nORDER BY captured_date ASC","compiled":false,"inline":true},{"id":"account_health","compiledQueryString":"SELECT\n accounts_active as \"Active\",\n accounts_banned as \"Banned\",\n accounts_deleted as \"Deleted\",\n accounts_total as \"Total\",\n ROUND(accounts_active * 100.0 / NULLIF(accounts_total, 0), 1) as active_pct,\n ROUND(accounts_banned * 100.0 / NULLIF(accounts_total, 0), 2) as banned_pct,\n ROUND(accounts_deleted * 100.0 / NULLIF(accounts_total, 0), 2) as deleted_pct\nFROM heycafe.platform_snapshots\nORDER BY captured_date DESC\nLIMIT 1","inputQueryString":"SELECT\n accounts_active as \"Active\",\n accounts_banned as \"Banned\",\n accounts_deleted as \"Deleted\",\n accounts_total as \"Total\",\n ROUND(accounts_active * 100.0 / NULLIF(accounts_total, 0), 1) as active_pct,\n ROUND(accounts_banned * 100.0 / NULLIF(accounts_total, 0), 2) as banned_pct,\n ROUND(accounts_deleted * 100.0 / NULLIF(accounts_total, 0), 2) as deleted_pct\nFROM heycafe.platform_snapshots\nORDER BY captured_date DESC\nLIMIT 1","compiled":false,"inline":true},{"id":"growth_rates","compiledQueryString":"SELECT\n ROUND(accounts_today * 100.0 / NULLIF(accounts_total, 0), 2) as daily_growth_pct,\n ROUND(accounts_week * 100.0 / NULLIF(accounts_total, 0), 2) as weekly_growth_pct,\n ROUND(accounts_month * 100.0 / NULLIF(accounts_total, 0), 2) as monthly_growth_pct\nFROM heycafe.platform_snapshots\nORDER BY captured_date DESC\nLIMIT 1","inputQueryString":"SELECT\n ROUND(accounts_today * 100.0 / NULLIF(accounts_total, 0), 2) as daily_growth_pct,\n ROUND(accounts_week * 100.0 / NULLIF(accounts_total, 0), 2) as weekly_growth_pct,\n ROUND(accounts_month * 100.0 / NULLIF(accounts_total, 0), 2) as monthly_growth_pct\nFROM heycafe.platform_snapshots\nORDER BY captured_date DESC\nLIMIT 1","compiled":false,"inline":true}]}

Stage	Users
Total Accounts	24,694
Monthly Active	21,048
Weekly Active	20,611
Daily Active	9,119
Online Now	126

Growth & Retention

No Results