dashund

Template ยท Monthly customer usage report

One usage report for every account, refreshed monthly

This is the report a CS team looks at before deciding who needs attention. It takes the monthly per-account export, the one with active users, seats and sessions for each customer, and shows total adoption, which accounts are growing, which are shrinking, and how much revenue sits in each group. Point it at the sheet the export lands in and it stays current on its own.

Customer success teams reviewing adoption across their whole book of business.

Download the sample CSV

Starts an editable copy with the sample data. No account needed until you save.

What it looks like

Built from the sample CSV below. Every chart is stored as code, so it recomputes when the data changes.

The data it expects

One row per period or account with these columns. Names can differ; you map them once and the mapping is reused on every refresh.

monthaccountplanseatsactive_userssessionsmrr_usd
2026-03Northwind LabsEnterprise120887926400
2026-04Northwind LabsEnterprise120918266400
2026-05Northwind LabsEnterprise120958696400
2026-06Northwind LabsEnterprise120989036400
2026-07Northwind LabsEnterprise1201029466400

Showing 5 of 48 rows in the sample.

Questions

Where does this data usually come from?
A monthly export from your product analytics or admin database: one row per account per month with active users, seats and sessions. Most teams already drop it into a sheet, which is exactly what this template reads.
Can I filter to one CSM's accounts?
Add a CSM column to the export and describe the view you want in plain English, for example 'only accounts where csm is Dana'. The template builds a filtered version.
How often does it refresh?
Daily on the free plan, hourly on Professional. Connect the sheet once and it rebuilds whenever the export updates.