The Financial Planning Marketing Dashboard That Works

14 August 2026·8 min read

Quick answer: A financial planning practice needs a marketing dashboard that tracks four things and four things only: enquiries by source, booked first meetings, show-up rate, and conversion to client. Build it in a spreadsheet with one row per enquiry, refreshed monthly — no BI software required. The goal isn't more data, it's being able to answer "which of our marketing actually turns into clients" in under thirty seconds. Get that right before you get anything else fancy. 📈

Most financial planning practices we meet have two kinds of marketing reporting: none at all, or a Google Analytics screenshot nobody in the practice actually understands. Neither tells you what you need to know, which is whether the money and time you're spending on marketing is turning into paying clients. The good news is that a genuinely useful dashboard for a financial planning practice is almost always simpler than principals expect — this isn't a Power BI project, it's a well-built spreadsheet with a handful of columns tracked consistently 💖. The practices that look switched-on to their board, their licensee, or just to themselves at EOFY aren't the ones with the fanciest software. They're the ones who can say "37% of our enquiries came from referrals this quarter, and referrals convert to clients at nearly double the rate of our website" — off the top of their head, because someone's been tracking it properly.

What most financial planning practices get wrong

The single biggest mistake financial planning practices make with marketing reporting is tracking activity instead of outcomes. Website visitors, social media followers, email open rates — these feel like progress, but none of them tell you whether marketing is bringing in clients. A practice can have rising website traffic and a flat client book at the same time, and the traffic number will keep making everyone feel fine about it.

The second mistake is treating every enquiry as equal. An enquiry from a Google search, an enquiry from an existing client's referral, and an enquiry from a LinkedIn post are wildly different in quality and cost — but if you're not tagging source at the point of enquiry, you can't see that. By the time someone's booked a first meeting, the source information is usually gone, guessed at, or reconstructed from memory.

The third: measuring enquiries, not clients. A flood of enquiries that never convert isn't a marketing win, it's a filtering problem — usually because the wrong people are enquiring, or the first meeting isn't closing well. A dashboard that stops at "enquiries" is only telling you half the story.

The one-tab marketing dashboard

Build this as a single spreadsheet tab. One row per enquiry. Update it as enquiries come in — don't try to reconstruct it from memory at month-end.

Columns (one row per enquiry):

Date enquired
Enquiry name
Source (see standard list below — pick ONE per enquiry, the primary driver)
Adviser assigned (if multi-adviser practice)
First meeting booked? (Y/N)
First meeting date
Showed up? (Y/N)
Became a client? (Y/N)
Date became client
Approx. client value (initial fee, or ongoing fee tier)

Standard source list (keep this short and consistent): Referral – existing client / Referral – accountant or other professional / Referral – other / Website / organic search / Google Ads / Social media / Seminar or event / Other.

Summary tab (built with simple COUNTIF/SUMIF formulas): total enquiries this month by source; enquiry → booked meeting rate by source; booked → showed up rate; showed up → became client rate (your true conversion number); enquiry → client rate by source (the one that matters most); cost per enquiry and cost per client by source (paid channels only).

Ten columns, six summary numbers. Resist the urge to add more — the value is in looking at it every month, not in how many tabs it has.

How this looks in real practices

Solo adviser relying on referrals: A one-adviser practice was certain "most of our clients come from referrals" but had never actually measured it. After three months of tagging source on every enquiry, the picture was more specific than the gut feeling: existing-client referrals were converting well, but accountant referrals — which the adviser had assumed were the strongest source — were converting at less than half that rate, largely because those enquiries were arriving pre-qualified for a service the practice didn't actually offer. That's not a marketing problem, it's a fifteen-minute conversation with the referring accountant to fix — but you only find it by tracking source and outcome separately.

Multi-adviser practice comparing performance: A four-adviser practice added the "adviser assigned" column and found their newest adviser had the highest enquiry-to-booked-meeting rate in the practice, but the lowest booked-to-client rate. That's a first-meeting skills gap, not a marketing gap — and it would have been invisible in a dashboard that only tracked enquiries at the practice level. It reframed a "we need more leads" conversation into "we need to sit in on this adviser's first meetings."

Practice running paid ads and needing to justify the spend: A practice spending a solid monthly budget on Google Ads to a principal who was quietly sceptical it was worth it added cost-per-enquiry and cost-per-client columns to the summary tab. Paid search was producing enquiries at a higher cost than referrals — no surprise there — but because those enquiries were still converting to clients at a healthy rate, the real cost-per-client for paid search was actually lower than the practice's cost of running a seminar. That number, not a screenshot of impressions, is what kept the ad budget approved at the next planning meeting.

The mechanics

The mechanics here matter more than the template — a spreadsheet is only as good as the discipline behind it. Capture source at the moment of enquiry, not later, and ask directly: "how did you hear about us?" rather than guessing from context. Whoever answers the phone or the contact form needs to be the one logging the row, ideally within the same day, because retrospective tagging is where accuracy quietly falls apart. If you're running UTM-tagged campaigns, match those UTM sources to your standard source list so the two systems agree with each other.

Review the summary tab monthly, not weekly. Financial planning enquiry volumes are genuinely too low for weekly numbers to mean anything — a practice getting 15–25 enquiries a month will see swings that look like trends but are just noise. Monthly, and ideally rolling quarterly, is where the real signal shows up.

💡 Reality check: A spreadsheet dashboard has real limits. It won't auto-capture source, it relies on someone being disciplined enough to log every row honestly, and referral tracking specifically depends on clients giving you an accurate answer — some just say "I found you online" because they can't quite remember. It's still worth doing, because an 85%-accurate dashboard beats a 0%-accurate gut feeling every time.

Mistakes to avoid

Waiting until month-end to fill in the source column from memory — you'll misattribute a third of your enquiries without realising it
Tracking enquiries but not tracking what happens after the first meeting — enquiry volume alone tells you almost nothing about marketing quality
Using a different source list every month ("Google," "SEO," "organic," "search" all logged as separate categories) instead of one fixed, short list
Building the dashboard around vanity metrics (website visits, social followers) instead of client conversion
Adding so many columns and tabs that nobody actually opens it after month two
Treating three months of data as a trend when practice volumes are genuinely too small to be statistically meaningful yet — give it at least two to three quarters

Please note: general information, not financial or legal advice — check current official guidance before relying on it. Practices should check their current AFSL, ASIC, and privacy obligations for client data handling and record-keeping before implementing any tracking system.

Frequently asked questions

What's the minimum I need to start tracking this month?

Just the raw data tab — date, name, source, booked meeting Y/N, became client Y/N. You can add the summary formulas and extra columns later once the habit of logging every enquiry is established. Starting simple is genuinely better than waiting to build the "complete" version.

How is this different from what my CRM already shows me?

Most CRMs used by financial planning practices are built for client management, not marketing attribution — they'll tell you a client's contact history but rarely make it easy to see "which source converts best" at a glance across the whole book. This dashboard sits alongside your CRM as a lightweight, purpose-built view specifically for that question.

Is a spreadsheet actually good enough, or do we need proper software?

For most single- and multi-adviser practices, a spreadsheet is genuinely enough — and honestly often better than software, because it forces someone to understand the numbers rather than trusting a dashboard they don't fully interrogate. The trade-off is that it doesn't scale well past a certain size, and it won't auto-capture anything — every row is manual. If that manual step doesn't happen reliably, the dashboard is worse than useless because it creates false confidence. Software makes sense once manual entry is clearly breaking down, not before.

How many enquiries a month do we need before this data means anything?

There's no hard cutoff, but treat anything under roughly 20-30 enquiries a month with caution when comparing sources against each other — a single unusually good or bad referral month can swing a percentage wildly. Look at rolling quarterly totals rather than single months until your volume is consistently higher.