Skip to main content
This cookbook is for B2B SaaS companies with accounts, subscriptions, product usage, billing, and satisfaction data. The examples use CloudFlow, a fictional workflow SaaS product.

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