Who this is for
Get started
1
Add PostgreSQL
Connect your application or warehouse database. See Add connectors.
2
Index and mark key tables
Flag subscriptions, subscription events, usage, and accounts during indexing.
3
Ask your first question
Try: What is MRR by month for the last 12 months?
4
Build the dashboards below
Combine saved charts into dashboards for finance and product reviews.
See it in Vizkraft
Your data
Tables to mark during indexing
- Subscriptions — MRR, ARR, and churn
- Subscription events — lifecycle and conversion
- Usage daily — adoption and health signals
- Accounts — segment and region views
Dashboards to build
Revenue and retention
Answers: How is recurring revenue trending and which accounts are at risk? Include MRR, ARR, net retention, and churn KPIs; an MRR trend line; MRR by segment; and an at-risk accounts table.Product usage
Answers: Are customers actually using the product? Include DAU, WAU, and stickiness KPIs; daily active users over time; feature adoption bars; and a scatter of seats versus usage.Trial conversion
Answers: How effectively do trials become paying customers? Include a trial → activated → paid funnel, conversion by segment, and trial starts over time.Customer health
Answers: Which accounts need attention or expansion? Include NPS and at-risk account KPIs; NPS by segment; and a table of expansion candidates.Questions to ask by role
Example conversations
MRR trend
Ask: Show MRR by month for the last 12 months. You should see a line chart with month-over-month change and short insight notes on growth or churn months. Try next: Break down MRR by customer segment.Trial conversion
Ask: How many trials converted to paid this month by segment? A funnel plus segment breakdown helps RevOps and CS prioritize outreach.Metrics worth defining
Add these to Connector memory if your team uses custom formulas:- MRR — sum of active subscription monthly amounts
- ARR — MRR × 12
- Net revenue retention — (starting MRR + expansion − churn) ÷ starting MRR
- Churn rate — churned MRR ÷ starting MRR
- Stickiness — DAU ÷ MAU