{"queries":[{"id":"signups","compiledQueryString":"SELECT\n strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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 strftime(captured_date, '%y-%m-%d') as 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_count,\n accounts_banned as banned_count,\n accounts_deleted as deleted_count,\n accounts_total as total_count,\n ROUND(accounts_active * 1.0 / NULLIF(accounts_total, 0), 4) as active_ratio,\n ROUND(accounts_banned * 1.0 / NULLIF(accounts_total, 0), 4) as banned_ratio,\n ROUND(accounts_deleted * 1.0 / NULLIF(accounts_total, 0), 4) as deleted_ratio\nFROM heycafe.platform_snapshots\nORDER BY captured_date DESC\nLIMIT 1","inputQueryString":"SELECT\n accounts_active as active_count,\n accounts_banned as banned_count,\n accounts_deleted as deleted_count,\n accounts_total as total_count,\n ROUND(accounts_active * 1.0 / NULLIF(accounts_total, 0), 4) as active_ratio,\n ROUND(accounts_banned * 1.0 / NULLIF(accounts_total, 0), 4) as banned_ratio,\n ROUND(accounts_deleted * 1.0 / NULLIF(accounts_total, 0), 4) as deleted_ratio\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	64,114
Monthly Active	7,102
Weekly Active	2,760
Daily Active	903
Online Now	13

Growth & Retention

No Results