Total users
75
Live analytics
Overview
High-signal metrics across users, revenue, conversations, triggers, community, and every raw SQLite table.
Executive summary
Fast, top-level numbers for the whole product.
Paying subscriptions
3
Total messages
174
Total groups
24
Growth pulse
Recent acquisition, engagement, messaging, and live content.
New users (7d)
66
Active chat users (7d)
3
Messages (24h)
8
Statuses live now
0
User signups (14d)
04-050
04-062
04-070
04-080
04-090
04-101
04-112
04-124
04-138
04-141
04-150
04-163
04-170
04-1850
Messages (14d)
04-050
04-060
04-072
04-081
04-0910
04-109
04-119
04-1222
04-136
04-1412
04-158
04-168
04-1715
04-188
Revenue (14d)
04-05₹0
04-06₹0
04-07₹0
04-08₹0
04-09₹0
04-10₹0
04-11₹0
04-12₹0
04-13₹0
04-14₹0
04-15₹0
04-16₹0
04-17₹0
04-18₹0
Revenue pulse
Billing and purchase health from subscriptions and one-time purchase audit tables.
One-time GMV
₹0
Packs sold
2
Day passes sold
4
Expired subscriptions
2
Community pulse
Groups, moderation load, and notification queue health.
Group messages
12
Pending requests
0
Reports
0
Queued notifications
0
Raw table coverage
Direct access to every table in app.db so nothing is hidden from the admin view.
CoreUsersAccounts, auth provider, trial/subscription tier, onboarding, admin and profile fields.75 rowsChatConversationsUser-persona chat threads with timestamps and uniqueness per persona.51 rowsChatMessagesAll user and assistant messages with content and timestamps.174 rowsRevenueSubscriptionsRecurring subscription lifecycle, tiers, Razorpay IDs and renewal dates.5 rowsRevenueUsage TrackingPer-user daily message usage counters.14 rowsCoreUser ContextRolling summaries, key facts, mood patterns and summary freshness.4 rowsRevenueMessage PacksTop-up purchases and remaining message balances.2 rowsRevenueDay PassesPurchased, active and expired day passes.4 rowsRevenueOne-Time PaymentsPayment audit table for packs, day passes and other products.0 rowsOpsPush TokensDevice token registry across Android and iOS, with timezone coverage.39 rowsOpsPending MessagesQueued trigger-driven assistant messages and their processing status.91 rowsOpsTrigger LogSent trigger history by user and persona.90 rowsCommunityGroupsCompanion groups, ownership, counts and archival state.24 rowsCommunityGroup MembersMembership state, reads and notification preferences.298 rowsCommunityGroup MessagesRealtime group messages, deletes and hidden state.12 rowsCommunityGroup MentionsMention events for user notifications and analytics.0 rowsCommunityGroup InvitesInvite tokens with expiry and remaining uses.0 rowsModerationGroup RequestsUser-submitted group requests and review workflow.0 rowsModerationGroup ReportsReports filed against messages and members.0 rowsModerationAdmin AuditAdministrative actions with target and serialized context.0 rowsCommunityCircle EdgesSocial graph overlap and reveal state between user pairs.3 rowsContentStatusesStories/status posts with expiry, edits, deletion and hidden state.6 rowsContentStatus ReactionsEmoji reactions to statuses.0 rowsContentStatus ViewsViewer history for statuses.0 rowsContentStatus AnalyticsPer-status viewer counts and pre-aggregated reaction payloads.6 rowsModerationStatus ReportsReports filed against statuses.0 rows