Weekly Metrics Dashboard

What is a Weekly Metrics Dashboard?

A weekly metrics dashboard is one page with 5 to 7 numbers that tell you, every Monday, whether your startup moved forward last week. Each column is a week, each row is a metric, and one row at the top holds your north star metric: the single number that best captures the value customers get from your product. For a booking app that could be “bookings completed per week”; for a newsletter, “subscribers who opened at least one issue this week”.

The dashboard matters less than the habit around it. A sheet that one person updates and the team reads every week beats a beautiful live dashboard nobody opens. Over a few months it becomes your company’s memory: when sign-ups jumped, what you changed that week, and whether the jump lasted.

When should you use it?

Start the week you have any users, customers or traffic at all, even if the numbers are tiny. Early weeks give you a baseline.

• Fits: every kind of startup. SaaS, shops, services, marketplaces, content businesses, B2B and B2C.
• Solo founders: still worth it. Five minutes of writing down numbers on Monday is a commitment device against wishful thinking.
• Skip or postpone: only while you are still in the idea stage with no product, page or audience. Use a simple log of problem interviews instead.

How do you do it, step by step?

1. Pick your north star metric. Ask: which number goes up only when customers get real value? Avoid sign-ups and page views; they rise from hype. Good north stars count a completed action that delivers the promise: “invoices paid through the app”, “meals cooked from a plan”, “items sold”. Write it on top of the sheet in bold.

2. Add 4 to 6 supporting numbers, one per stage. A practical set: one for attention (new visitors), one for sign-up (new accounts), one for activation (share of new users who complete the main action within 7 days), one for money (revenue this week), one for retention (share of last month’s active users still active) and one for survival (cash in bank or months of runway). Stop at 7.

3. Build the sheet. Rows are metrics, columns are weeks (Monday dates). Add three extra rows at the bottom: “What we changed this week”, “What we think caused the biggest move” and “Decision”. Those three rows turn numbers into learning.

4. Name ONE owner. One person collects the numbers from PostHog or GA4, Stripe and the bank, every Friday afternoon or Monday morning before the meeting. With two owners, it slips the first busy week.

5. Add simple colour rules. Compare each number with its average of the previous 4 weeks. Green if it is 10% or more above, red if 10% or more below, no colour otherwise. In Google Sheets, use Format > Conditional formatting with a custom formula.

6. Run a 30-minute Monday review. Ten minutes: everyone reads the numbers in silence. Ten minutes: discuss the biggest move, up or down, and why. Ten minutes: agree on one action and write it in the “Decision” row. No new metrics get added in the meeting; that discussion waits a month.

7. Automate only after 6 weeks. Once the metrics stop changing, connect the sheet to Data Studio, Google’s free reporting tool (called Looker Studio until Google’s April 2026 rename). On its overview page Google states the tool is free. Use scorecards with a previous-period comparison and one line chart for the north star.

What does a worked example look like?

Say Bea and Kemi run a marketplace where parents resell outgrown school uniforms. Their north star: uniform items sold per week, because a sale means value for both the seller and the buyer. Kemi owns the dashboard.

Their sheet for four weeks of August, when school shopping peaks:

The “What we changed” row says that on 15 August they added a feature where sellers can list an item by snapping one photo of the label. Listing activation jumped from 24% to 31% that week and held at 33%. Their decision on 25 August: put the photo listing on the homepage and pitch it to two parent Facebook groups before school starts.

The cash row keeps them honest. Even in their best month, they burn more than they earn, and the sheet shows it every Monday.

Which free tools help?

What mistakes should you avoid?

• Tracking 25 numbers. Nobody reads them all, so nobody reads any. Cap it at 7, and remove one before you add one.
• A north star that measures your effort. “Blog posts published” tells you what you did. Pick a number that measures what customers got.
• No owner. “We’ll all update it” means nobody does. One name, one deadline.
• Automating too early. A Data Studio report wired to metrics you change in week 3 is wasted work. Stay manual until the list is stable.
• Skipping the decision row. Numbers without a decision are a ritual with no outcome. Every review ends with one action written down.

How do you know it worked?

Your dashboard works when it has been updated every week for 8 weeks in a row, the Monday review takes 30 minutes or less, and the “Decision” row has an entry for each week.

Our rule of thumb for go / no-go: after 2 months, you should be able to point at one decision that the dashboard caused and that moved the north star. If the review keeps ending with “let’s keep going”, your metrics are too far from customer value; swap one of them for an activation or retention number.

What should you do next?

Use conversion funnel tracking to dig into whichever stage turns red, and unit economics to add CAC and payback once you spend on growth. If you share progress publicly, your dashboard makes building in public easy, since the numbers are already collected. Founders who want a weekly rhythm with feedback can practise it in the startup game for women by Fe/male Switch, alongside an AI co-founder.

FAQ

What is a north star metric?

It is the single number that best reflects the value customers get from your product, and that grows when your business grows in a healthy way. Examples: bookings completed, invoices paid, items sold. If it measures your own activity, like posts published, pick again.

What metrics should an early-stage startup track weekly?

A north star plus one number each for attention, sign-ups, activation, revenue, retention and cash. That gives you 5 to 7 rows. Swap individual metrics as your questions change, but keep the north star stable.

Is Data Studio the same as Looker Studio?

Yes. Google renamed Looker Studio back to Data Studio in April 2026, and the old Looker Studio address now forwards to the Data Studio site. The standard version is free, and there is a paid Pro tier on top.

Updated 26 October 2026 · Written by the Fe/male Switch team

Mark this method as done