A weekly dashboard should answer one question in under a minute: is the business healthier than last week, and if not, where did it slip? Most dashboards fail that test by showing thirty charts. Eight numbers are enough, and they are the same eight whether you sell goods, run a staking fund, bill hours or book appointments. To show real values rather than placeholders, we calculated each one on a public example dataset of an online retailer (Dec 2010 – Nov 2011).
The eight numbers
| KPI | Formula | Dec 2010 – Nov 2011 | In other businesses |
|---|---|---|---|
| 1. Revenue | sum of completed transactions | $9,633,406 | fund: turnover; firm: billings; clinic: visit revenue |
| 2. Transactions | count of distinct orders, sessions or visits | 18,957 | fund: sessions played; clinic: visits |
| 3. Average transaction value | revenue ÷ transactions | $508 | fund: turnover per session; firm: average invoice |
| 4. Active clients | clients with at least one transaction in the period | 4,293 | fund: active players; clinic: patients seen |
| 5. New-client share | first-time clients ÷ active clients, per month | 19.5% in Nov 11 | fund: newly backed players; clinic: new patients |
| 6. Repeat rate | clients with 2+ transactions ÷ active clients | 63.9% | firm: clients with repeat engagements; clinic: return visits |
| 7. Cancellation rate | cancelled or refunded value ÷ revenue | 3.2% | firm: write-offs; clinic: no-show and cancellation rate |
| 8. Top-10% client share | revenue of top 10% clients ÷ revenue from identified clients | 60.5% | fund: share of the largest players; firm: key-account share |
The first four describe volume. The last four describe quality: where growth comes from, whether clients return, what is lost to cancellations and how much depends on a few large clients. The definitions change name from one business to the next; the arithmetic does not.
Revenue: watch the week, judge the trend
Source: UCI Online Retail II (Chen, 2019), sheet Year 2010-2011, CC BY 4.0; our calculation
Weekly revenue is noisy. One bad week is not a signal; three in a row is. The zero week around New Year is the holiday break, not a collapse: label such gaps on the dashboard, or someone will spend Monday investigating a week when the business was simply closed.
The seasonal shape matters more. Monthly revenue grew from $670,439 in Jan 11 to $1,452,116 in Nov 11, so any autumn week-on-week comparison looks good. Every business has a calendar like this: tax deadlines for an accounting firm, holiday dips for a clinic, a tournament schedule for a fund. Compare with the same week last year once you have it.
Transactions, average value and who is coming back
Average transaction value stayed between $417 and $620 by month, while transactions grew from 1,081 in Jan 11 to 2,751 in Nov 11. Growth came from more transactions, not bigger ones. More transactions point to acquisition and reach; bigger ones point to pricing, packaging and minimum engagement size.
The transactions came mostly from clients who had been there before:
Source: UCI Online Retail II (Chen, 2019), sheet Year 2010-2011, CC BY 4.0; our calculation
The share of first-time clients fell from 56.3% in Jan 11 to 19.5% in Nov 11. The base is maturing: 63.9% of clients came back for more than one transaction during the year. A falling new-client share is fine while the repeat rate holds; if both fall together, acquisition has stalled and nobody has noticed yet.
Revenue is concentrated too. The top 10% of identified clients brought 60.5% of their revenue. Losing a handful of large accounts would hurt more than losing hundreds of small ones, and that holds just as much for a fund with a few high-volume players or a firm with two anchor clients. Our RFM segmentation article shows how to find who those clients are.
What the weekly view looks like
One row of eight tiles, each with the current week, the change against a four-week average and a small trend line. Below it, weekly revenue and the new-versus-returning split. Everything else goes one click deeper.
- Tiles first, charts second. If all eight tiles are in their normal range, the meeting is over.
- Compare with a baseline, not with last week alone. A four-week average absorbs the noise.
- Definitions on the dashboard. Revenue with or without cancellations, clients with or without one-off walk-ins: write it under the number.
Limits
- One year of data, so no year-over-year comparison here; your dashboard should have one.
- Revenue is gross of cancellations, and client KPIs use only transactions with a client ID.
- The example comes from one online retailer; the formulas carry over, the normal ranges do not. Set them on your own history.
Download the template
Weekly KPI dashboard template (Excel, .xlsx): no sign-up, no form. Paste one row per order, session or visit (date, ID, client ID, value, completed or cancelled), list each client once, and the formulas build one row per week: revenue, transactions, average value, active clients, new-client share, cancellation rate and revenue against the four weeks before. A period sheet adds repeat rate and the top-10% client share, so all eight numbers from the table above are covered with the same formulas.
It opens in Excel, LibreOffice and Google Sheets, has no macros and ships with a sample from the same public dataset. The tiles and trend lines are yours to add on top; the template gives you the numbers they need.
Data: UCI Online Retail II (Chen, 2019), licensed CC BY 4.0. All numbers on this page are calculated by our script on that dataset and loaded into the page from its output.