Revenue Dashboard Setup: A Step-by-Step Guide for Wellness Brands

A good revenue dashboard setup starts with decisions, not charts. Name the decisions you need to make each week, define the few numbers that drive them, connect the systems that hold those numbers, and agree who owns each figure. The tool comes last. At Plexo we build this as part of a 90-minute business audit ($499 AUD, one-off), which finds the operational constraints first and then turns them into a live view you can act on.

This guide gives you the full routine. It is written for founders, marketing managers and executives at wellness brands who want one trusted view of revenue and customer acquisition cost (CAC), the cost of winning one new customer.

TL;DR

• Start with three to five decisions the dashboard must support, such as where to spend on ads or which offer to push. Pick metrics after that.
• Write one definition for every metric before you build anything. Most arguments about dashboards are arguments about definitions.
• Connect payments, CRM, website analytics and ad platforms, and name one system as the source of truth for each figure.
• Build a simple first version in a spreadsheet or a free reporting tool, then check it daily against your payment data.
• A dashboard only earns its place when someone owns each number and acts on it in a weekly meeting.

Table of Contents

• What a revenue dashboard is for
• Step 1: Write down the decisions
• Step 2: Choose and define your metrics
• Step 3: Map your data sources
• Step 4: Name a source of truth for each figure
• Step 5: Pick a tool that fits your stage
• Step 6: Build the first version
• Step 7: Validate before anyone relies on it
• Step 8: Make it part of a weekly routine
• Common mistakes
• Perspective: why we build the system, not the slide
• Get the dashboard built on the right foundations
• FAQ
• Sources

What a revenue dashboard is for

A revenue dashboard is a visual page that brings revenue streams, expenses and profitability together so you can see which products earn money, where effort is wasted and what is likely to happen next month. That is the textbook version.

The useful version is narrower. It answers questions you already ask in your head every Monday:

• Did we make more or less than last week, and why?
• Which channel brought in the customers who actually stayed?
• What does a new customer cost us, and what are they worth?
• Are we on track for the month, and if not, what changes now?

If a chart does not help answer one of those, it is decoration. Guidance on dashboard design makes the same point: define the outcome and two or three decisions first, then choose the tool. A dashboard built from “whatever data we have” tends to fill up with numbers nobody uses.

For a wellness brand the questions are specific. You may sell memberships, packages, products online, retreats or clinic sessions. Each has a different rhythm, and a single total hides which one is growing.

Step 1: Write down the decisions

Take a page and write three to five decisions you make repeatedly. For a wellness brand they often look like this:

1. Which ad channel gets next month’s budget?
2. Which offer do we feature in email and on the homepage?
3. Do we hire, or hold, based on forecast revenue?
4. Which clients are about to lapse, and who contacts them?
5. Which location or practitioner calendar is underused?

Next to each, write who makes the call. That person is the dashboard’s real user. If you cannot name them, the metric is not ready to go on the page.

Where it goes wrong: founders skip this step and open a template. They end up with 30 tiles and no decision. Our audit starts here for that reason: in 90 minutes we map the operational constraints that stand between you and the number you want, and that tells us which five tiles matter.

Step 2: Choose and define your metrics

Keep the first version to eight to twelve metrics. Every one needs a written definition, a formula, a source system and an owner. Guidance on building sales dashboards also says to document metric definitions before customising anything.

A sensible starting set for a wellness brand:

Two cautions.

First, pick the window for repeat purchase and lifespan, and keep it fixed. A 60-day repeat window and a 90-day one give different answers, and the dashboard will look as if retention changed when only the definition did.

Second, be careful with benchmarks. Healthy growth varies a great deal by sector: month-on-month figures that look strong for an early-stage software business are unrealistic for an established hospitality brand. Compare yourself with your own past periods and your own targets first.

Step 3: Map your data sources

Revenue lives in several places. A usable dashboard pulls from each and joins them. The usual sources are:

• Payments and billing: charges, subscriptions and invoices.
• CRM: contacts, deals, pipeline stages and activities.
• Website analytics: sessions, sources and conversions.
• Ad platforms: spend, clicks and campaign names.
• Booking or e-commerce system: orders, appointments and products.
• Accounting: the final, reconciled figures.

A typical start-up data setup connects payments, a CRM, a product database and the relevant marketing tools. Attribution guidance adds that these sources need a persistent identifier such as an email or user ID to join them, so a lead in the CRM can be matched to the payment that followed.

That last point is where most wellness brands stall. If the booking system records an email, the CRM records a phone number and the ad platform records neither, you cannot see which campaign produced which paying client. Decide the joining field now and make sure every system captures it.

If your CRM and accounting software do not talk to each other, mapping the CRM and accounting integration first makes the later reconciliation far easier, because you know which field in one system corresponds to which in the other.

Step 4: Name a source of truth for each figure

Your payment processor, CRM and accounting software will not agree to the cent. That is normal. Billing records show charges, the CRM shows deals and contracts, and the database shows activity. The remedy is an explicit source-of-truth model with documented tolerances, not quietly overwriting one number with another.

A simple rule set:

• Revenue received: the payment system.
• Pipeline and expected revenue: the CRM.
• Spend: the ad platform, then the accounting software at month end.
• Final monthly revenue: accounting.

Write these rules on the dashboard’s first page. When the CRM and the payment system disagree, people should know which one wins before the meeting starts, not during it.

If your CRM data is untidy, fix that before you chart it. Duplicate contacts and blank lead sources will corrupt CAC and channel ROI. Our guide to a five step CRM data hygiene plan covers the clean-up, and the notes on CRM optimisation for wellness show what a tidy setup looks like.

Step 5: Pick a tool that fits your stage

You do not need expensive software on day one. The usual options, from simplest to most capable:

1. A spreadsheet. Fine for one or two sources and a weekly update. Spreadsheets, free reporting tools, Excel with Power BI and specialised BI software are the common choices, judged on how well they connect to your data, how clearly they display it and how easy they are to use.
2. A free reporting tool connected to your sheets and analytics. Good for marketing-led views. Our eight-step Looker Studio checklist walks through this route.
3. The reporting inside your CRM. If your CRM has built-in connectors, pre-built reports for revenue trends, lead source, product and forecasting are often a faster route than building from scratch.
4. Business intelligence software with a data warehouse. Worth it when you have many sources, several locations or a finance team that needs audit trails.

The right choice follows from step 3. Count your sources and the number of people who will use the page. One owner and three sources fit a spreadsheet. Five sources and a leadership team need something that refreshes on its own.

A native platform report, such as the one inside your booking system, is useful but only shows that system. It cannot tell you what a lead cost, because the ad spend is elsewhere. That gap is why a joined-up view matters.

Step 6: Build the first version

Build small. A first version that is trusted beats a large one that is not.

Page one: the headline view. Revenue against target for the month, new vs repeat revenue, CAC and the forecast. Four to six tiles at the top, a trend line underneath.

Page two: channels. Spend, leads, customers, CAC and ROI by channel. Sort by ROI so the best and worst are obvious.

Page three: retention. Repeat rate, lapsed clients and the revenue at risk from them.

Design choices that help people read it:

• Put the most important figure top left. Readers scan from there.
• Show a 12-month trend so seasonal patterns are visible. Wellness demand moves with the calendar: January goals, spring events and winter slumps are all real.
• Add one date filter that applies to the whole page, and show the comparison period beside each figure.
• Use the same colour for the same thing everywhere. One colour for revenue, one for spend.
• Label each tile with its definition on hover or in a footnote.

A useful test: someone who has never seen the page should understand the main message in a few seconds. If they cannot, remove tiles.

For the difference between a live view and a periodic report, and when each is the right tool, see our note on dashboards versus reports. For what a continuously updated view should contain, see the real-time business dashboard guide.

Step 7: Validate before anyone relies on it

Before you share the dashboard, check it against known totals.

1. Pick last month. Compare the dashboard’s revenue with your accounting software, ex GST. Note the gap.
2. Compare new customer counts with the CRM.
3. Compare ad spend with the platform’s own billing.
4. Spot-check ten individual customers from lead to payment.
5. Record each remaining gap and the reason for it.

After launch, keep checking. Reconciliation guidance suggests daily revenue checks, automated comparisons and alerts when a figure moves outside the tolerance you set. Even a simple version helps: a daily row that compares dashboard revenue with payment revenue and turns red when the gap passes your threshold.

Set the refresh schedule to match the decision. Spend and bookings may need daily updates. Retention and lifetime value can update weekly.

Step 8: Make it part of a weekly routine

A dashboard nobody discusses is wallpaper. Hold a 30-minute weekly review with the same layout each time:

1. Revenue against target and forecast.
2. The one metric that moved most, and why.
3. One action per owner, with a date.
4. Review last week’s actions.

Each metric needs a named owner. That person explains movements and proposes the next action. This is what separates reporting from accountability.

Once the dashboard is reliable, it also feeds forecasting. Our note on revenue forecasting for wellness brands shows how recurring revenue, pipeline and seasonality combine into a forecast you can plan hiring and spend around. If you want a wider leadership view, an executive scorecard with eight to twelve KPIs sits on top of the same data.

Common mistakes

• Too many metrics. More tiles mean less attention per tile.
• No shared definitions. Two people calculate CAC differently and the meeting turns into a debate.
• Mixing gross and net, or GST-inclusive and exclusive, figures. Pick one basis and label it.
• Dirty CRM fields. Blank sources and duplicates break channel reporting.
• No owner. Without a named person per metric, nobody acts.
• Building the full version first. Start with the headline page, prove it, then add.

Perspective: why we build the system, not the slide

Most revenue dashboards fail for the same reason. Someone builds them once, hands them over, and nobody owns what they show.

We start from the other end. A 90-minute audit finds the operational constraints behind the number: where content, operations and revenue stop connecting. The tailored 90-day plan then sets out what to fix, in what order.

We manage the executable plan directly with you. That means the dashboard is not a deck of recommendations. It is a live operating view of your systems, with real-time insight, actionable tasks and a clearer basis for forecasting.

The results come from that joining-up. With P3 Recovery, a wellness brand, monthly revenue moved from $65k to $110k by optimising operational strategy and marketing integration. The dashboard made the progress visible. The system work produced it.

If you are a wellness founder deciding where to start, start with the constraint, then build the view that tracks it.

Jordan

Get the dashboard built on the right foundations

The Plexo Business Audit is a 90-minute session for $499 AUD, one-off. It identifies the operational constraints holding back your revenue and produces a tailored 90-day plan. From there, we can take on hands-on implementation, including live dashboards for revenue tracking, CRM optimisation and process documentation.

You can see the full range of content, operations and revenue services or book an audit or growth call.

FAQ

What is the easiest way to create a revenue dashboard?

Start with a spreadsheet or a free reporting tool connected to one or two sources, such as payments and your CRM. Build the headline page only: revenue against target, new vs repeat revenue, CAC and forecast. Once you trust those numbers, add channels and retention.

How many metrics should a revenue dashboard have?

Eight to twelve is enough for a first version. Each should link to a decision and have a written definition and an owner. If a metric does not change what anyone does, leave it off.

How often should the data refresh?

Match the refresh to the decision. Spend, bookings and daily revenue suit a daily refresh. Retention, lifetime value and forecasts can update weekly. Check dashboard revenue against your payment data daily so errors surface early.

Why do my dashboard figures not match my accounting software?

The systems record different things: payments, contracts and final ledger entries. Timing, refunds and GST treatment also differ. Name a source of truth for each figure, set a tolerance and record the reasons for any remaining gap.

Can a dashboard help with customer acquisition cost?

Yes, if ad spend, leads and paying customers are joined by a shared identifier such as email. Then you can divide spend by new customers for each channel and see which channels pay back.

Sources

• Revenue dashboard overview and benefits
• Revenue dashboard guide on defining outcomes and decisions
• Sales dashboard guide on documenting metric definitions
• Customer acquisition guide with metric formulas
• Business growth metrics for Australian owners
• Start-up data setup guide
• Attribution data warehouse guide
• Revenue tracking and analytics guide
• Data reconciliation across systems
• CRM and accounting integration mapping

Recommended

• Revenue Forecasting Wellness
• CRM Optimization Wellness
• Customer Segmentation for Wellness Brands
• Why Your Wellness Brand Isn’t Growing