Call us: +1 (855) 514-8470Available 24/7 · [email protected]

← All articles

KPI · Dashboards · Customer analytics

Weekly KPI dashboard: the 8 numbers worth a look

Eight KPIs for any business with repeat clients: revenue, average value, active and new clients, repeat rate, cancellations. Formulas and a sample dashboard.

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

KPIFormulaDec 2010 – Nov 2011In other businesses
1. Revenuesum of completed transactions$9,633,406fund: turnover; firm: billings; clinic: visit revenue
2. Transactionscount of distinct orders, sessions or visits18,957fund: sessions played; clinic: visits
3. Average transaction valuerevenue ÷ transactions$508fund: turnover per session; firm: average invoice
4. Active clientsclients with at least one transaction in the period4,293fund: active players; clinic: patients seen
5. New-client sharefirst-time clients ÷ active clients, per month19.5% in Nov 11fund: newly backed players; clinic: new patients
6. Repeat rateclients with 2+ transactions ÷ active clients63.9%firm: clients with repeat engagements; clinic: return visits
7. Cancellation ratecancelled or refunded value ÷ revenue3.2%firm: write-offs; clinic: no-show and cancellation rate
8. Top-10% client sharerevenue of top 10% clients ÷ revenue from identified clients60.5%fund: share of the largest players; firm: key-account share
Source: UCI Online Retail II (Chen, 2019), sheet Year 2010-2011, CC BY 4.0; our calculation

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

Weekly revenue, $KWeeks ending on Sunday. Revenue roughly doubles from late summer into November.
$0K
$100K
$200K
$300K
$400K
$302K
Dec 12$301K
Dec 19$209K
Dec 26$85K
Jan 02$0K
Jan 09$130K
Jan 16$187K
Jan 23$209K
Jan 30$121K
Feb 06$121K
Feb 13$104K
Feb 20$140K
Feb 27$145K
Mar 06$128K
Mar 13$129K
Mar 20$153K
Mar 27$145K
Apr 03$187K
Apr 10$123K
Apr 17$146K
Apr 24$138K
May 01$83K
May 08$137K
May 15$205K
May 22$210K
May 29$160K
Jun 05$115K
Jun 12$215K
Jun 19$187K
Jun 26$127K
Jul 03$135K
Jul 10$170K
Jul 17$133K
Jul 24$188K
Jul 31$179K
Aug 07$168K
Aug 14$169K
Aug 21$173K
Aug 28$161K
Sep 04$147K
Sep 11$187K
Sep 18$224K
Sep 25$329K
Oct 02$207K
Oct 09$311K
Oct 16$221K
Oct 23$264K
Oct 30$243K
Nov 06$293K
Nov 13$358K
Nov 20$373K
Nov 27$302K
Dec 12Feb 06Apr 03May 29Jul 24Sep 18Nov 27

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:

First-time clients, % of active clients by monthDecember 2010 is left out: it is the first month of the data, so every client looks new.
56%
Jan 11
Mar 11
May 11
Jul 11
Sep 11
Nov 11

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.