SaaS Dashboard Example: Signups, Activation, Active Users and Feature Adoption

Signups and activations per week

Signups alone flatter a product. Plotting activations — people who reached the first useful moment — on the same weeks shows how many of them were worth having.

SELECT date_trunc('week', day) AS week,
       round(100.0 * sum(activated) / sum(signups), 1) AS activation_rate
FROM signups_daily
GROUP BY 1
ORDER BY 1

Signup funnel, last 30 days

The funnel starts at signup, not at the site visit: beside every visitor, each later step would be a sliver. From signup on, the biggest drop between two steps is the one to work on.

Feature adoption last week

Adoption as a share of weekly active users, not a raw count, so a feature’s number doesn’t rise just because the product grew.

Workspaces: seats and weekly actives

For a product sold by the seat, the gap between seats bought and seats used is next year’s churn. Workspaces far below the diagonal are the accounts to call.

What metrics should a SaaS dashboard include?

Weekly or monthly active users, new signups, activation rate, retention after the first month, feature adoption as a share of active users, and — for products sold by the seat — seats in use. Revenue metrics such as MRR and churn usually come from billing data on a separate tab.

How do you calculate activation rate?

Divide the users who reached your activation moment by the users who signed up in the same period. Pick the moment that predicts staying, such as a first completed task or a first invite, and keep the definition fixed.

How do I measure feature adoption?

Count the distinct users who used the feature in a week and divide by that week’s active users. Tracking it from the launch week shows whether adoption keeps climbing or stalls.

Can I build this from my product database?

Yes. Connect the database that holds your events and accounts, paste the prompt above into Fastero, and adjust the definitions of active and activated to match your product.