Building a simple monthly dashboard

Most membership owners know they should look at their numbers regularly. Most also know the feeling of opening several reports, getting lost in charts, and closing them again without having decided anything. The problem is rarely a lack of data. It is the lack of a single place where the numbers that matter sit together, in the same format, every month.

A monthly dashboard is that place. It does not need special software. A one-page spreadsheet, filled in on the same day each month, is enough to show you whether your business is healthy and where to look when it is not.

What a monthly dashboard is for

A dashboard has one job: to let you see, in a few minutes, whether anything important has changed. It is not a report to impress anyone, and it is not the place for deep analysis. When something on the dashboard moves, you dig into the details elsewhere.

That purpose shapes every choice. If a number would not prompt you to act when it changed, it does not belong on the page.

Choose no more than ten numbers

Ten is a limit, not a target. Group your numbers into five areas, with one to three in each:

• Growth: paying members at month end, new members, cancelled members.
• Revenue: monthly recurring revenue, plus one-time revenue if you sell extras.
• Retention: monthly churn rate, plus renewal rate if you have annual members.
• Engagement: the share of members who did your core action during the month.
• Acquisition: website visitors and visitor-to-member conversion rate.

If you are unsure which figures to include, the membership metrics that matter most gives a starting shortlist. A dashboard is only as good as the definitions behind it, so settle how you count monthly recurring revenue and cancellations before your first entry.

Laying out the page

Give every figure three columns: this month, last month, and the same month a year earlier. That way you see both short-term movement and seasonal patterns. Add a notes section at the bottom. Here is how a hypothetical dog training membership charging $20 a month might fill it in, with invented figures:

Growth: Members 412 (last month 398, a year earlier 330). New 34 (29, 31). Cancelled 20 (22, 18).

Revenue: MRR $8,240 ($7,960, $6,600). One-time sales $450 ($0, $300).

Retention: Churn 5.0% (5.6%, 5.7%).

Engagement: Members who watched a training video 71% (68%, 64%).

Acquisition: Visitors 5,100 (4,800, 3,900). Conversion 0.67% (0.60%, 0.79%).

Notes: Puppy course promoted in the newsletter. Churn down, possibly thanks to the new check-in email. Conversion still below a year ago; look at the pricing page next.

In a few seconds the owner can see steady growth, improving retention and rising engagement, alongside one clear weak spot. That is exactly what a dashboard should do.

Where the numbers come from

A dashboard only survives if filling it in is quick. List each figure with its source and the exact steps to get it:

• Members, new and cancelled: your membership platform's member report, filtered to the month.
• MRR: an export of active subscriptions, converted to monthly amounts.
• Engagement: your platform's activity report, or a count of members with at least one completed lesson, video or post.
• Visitors: your website analytics.

Write these steps down in a tab of the same spreadsheet. The first month may take an hour. After that it should take fifteen to twenty minutes. If a number takes much longer every time, either find a faster source or drop it.

Fill in the dashboard on a fixed day, such as the first working day of the month, so each month covers the same period and comparisons stay fair.

The monthly review

Filling in numbers is half the work. The other half is a short review, ideally straight afterward. Ask four questions:

1. What moved noticeably, up or down, compared with last month and a year earlier?
2. Do I know why? If not, what would I need to look at to find out?
3. Is anything moving steadily in the wrong direction over three or more months, even slowly?
4. What one thing will I do this month because of what I see?

Write the answers in the notes section. Over time those notes become a record of what you tried and what happened, which is often more valuable than the numbers themselves.

Keeping the dashboard useful

• Keep definitions stable. If you change how you count something, note it and, if possible, recalculate past months.
• Resist adding numbers. When you are tempted, ask what you would remove to make room.
• Read the trend, not the month. On a small site, one month's figures bounce around. Three months in the same direction is a signal.
• Share it if you have a team. A monthly dashboard makes a natural agenda for a short team check-in.

Building yours

1. Create a spreadsheet with one tab for the dashboard, one for data sources and one for a running history of every month.
2. Choose up to ten numbers across growth, revenue, retention, engagement and acquisition.
3. Write the definition and source for each.
4. Back-fill as many previous months as you can, so the comparisons work from the start.
5. Set a recurring reminder for the first working day of each month, and block thirty minutes for the review.