Reporting Automation for Estate Planning and Probate Firms

Why One Cost-Per-Client Number Is Misleading in This Vertical

Reporting automation for an estate and probate firm has to separate cost-per-retained-client by matter type, because averaging a flat-fee planning engagement together with an hourly or percentage-based probate matter produces a number that describes neither one accurately. A simple will-based plan retained for $1,500-$3,000 in marketing cost of $200 looks very different from a probate matter retained through a $600 marketing spend that eventually bills $20,000-$25,000 on a $500,000 estate at the typical 4-5% probate cost — both are good outcomes, but a blended average obscures which channel and which campaign actually produced each one. A firm running Google Ads for both "estate planning attorney" and "probate attorney" searches without splitting the reporting will see one aggregate cost-per-lead number that tells them almost nothing useful about which campaign to scale and which to cut. A single cost-per-client number is misleading, which is why estate planning firm reporting breaks results out by matter type.

Building Separate Dashboards for Three Matter Types

The reporting structure that actually works splits every dashboard into three lanes matching the firm's three real client types: flat-fee planning, hourly-or-percentage probate administration, and elder law/Medicaid planning. Each lane tracks its own cost-per-lead, cost-per-consultation-booked, and cost-per-retained-client, because these numbers move independently — a probate campaign might show a higher cost-per-lead but a dramatically higher average matter value once a percentage-of-estate fee is applied, while a planning campaign might show a lower cost-per-lead but a tighter margin given the flat fee involved. Reporting automation pulls this data automatically from the CRM, tagging each lead's source and eventual matter type at intake so the numbers populate without a staff member manually sorting spreadsheets at the end of each month. Separate dashboards make probate cost-per-client tracking honest, rather than blending it into planning economics.

Tracking Average Matter Value Alongside Acquisition Cost

Cost-per-retained-client only tells half the story without average matter value tracked alongside it, and average matter value varies enormously by type in this vertical. A complex planning engagement involving business interests or multi-state property can run $7,500-$15,000, several times a simple will-based plan, so a dashboard that reports "planning matters" as one undifferentiated category still blends meaningfully different outcomes. Probate matter value depends heavily on whether the estate is contested and whether any planning was in place beforehand — an uncontested estate with a valid trust might resolve for a flat $3,000-$10,000, while a fully contested estate with no prior planning can run $10,000-$80,000 or more. Reporting that captures matter value at this level of detail lets a firm see not just how many clients a campaign produced, but what those clients were actually worth, which is the number that should ultimately drive marketing budget decisions. Probate cost-per-client tracking has to account for a matter that may take a year to close before any revenue lands.

Reporting on Referral Sources Separately From Paid Channels

Estate and probate work draws heavily on referral relationships — financial planners and CPAs who notice a client has no estate plan, elder care organizations fielding Medicaid questions they can't answer, other attorneys sending over a matter outside their practice area — and these sources deserve their own reporting lane rather than being folded into a generic "referral" bucket. Tracking which specific referral partners produce planning clients versus probate clients versus elder law inquiries lets a firm invest relationship-building time where it actually pays off, rather than treating all referral sources as interchangeable. This is especially useful because referred clients across all three matter types often convert at a meaningfully higher rate than paid search leads, a pattern that only becomes visible when referral data is broken out and tracked with the same rigor as paid channels.

Reporting on Elder Law and Medicaid Planning as Its Own Line Item

Elder law and Medicaid planning has economics that resemble neither flat-fee planning nor hourly probate cleanly, since these matters often combine a flat or hourly fee for the planning work itself with a separately billed application-filing process that can stretch over several months while a state Medicaid agency processes paperwork. Reporting automation should track this lane on its own timeline expectations rather than judging it against the faster close rate of a simple will or the more predictable billing rhythm of an uncontested probate. Because the searcher is frequently an adult child researching for a parent rather than for themselves, this lane also benefits from tracking a distinct conversion path — how many initial inquiries about a parent's situation actually convert to a signed engagement, since this audience often takes longer to move from research to retention than either of the other two client types, gathering information across multiple sessions before committing.

Turning Reporting Into Marketing Spend Decisions

The entire point of separating these three lanes is to make a concrete budget decision easier, not just to produce a more detailed report. When a firm can see that its probate campaigns cost more per lead but deliver a dramatically higher average matter value, or that its elder law inquiries convert slowly but at a strong rate once a genuine relationship is built, it can allocate next quarter's marketing budget based on real unit economics rather than a gut feeling about which service line "seems busy." Reporting automation that surfaces this comparison automatically, rather than requiring someone to reconstruct it manually every quarter, is what turns a dashboard from a passive record into an active input on where the firm actually spends its next marketing dollar. Good estate planning firm reporting turns those numbers directly into marketing-spend decisions.

Frequently Asked Questions

How often should these dashboards be reviewed?

Monthly review works for most firms, though probate matter value often isn't fully known until the estate closes, so a quarterly look-back that reconciles projected versus actual matter value is worth adding alongside the monthly acquisition-cost review.

Can percentage-of-estate probate fees be estimated before the matter closes?

Reasonably, yes — once an estate's approximate gross value is known from the initial inventory, a rough fee estimate can be logged early and refined as the matter progresses, giving reporting a usable number well before final distribution rather than waiting many months for a precise figure.

Does this reporting distinguish between new clients and periodic plan reviews?

It should — a periodic estate plan review for an existing client is a different economic event than a new client's first engagement, and blending the two into one "planning matters closed" number understates how much of a firm's planning revenue comes from returning clients versus new acquisition.

Related Reading

Accurate reporting depends on how matters are tracked from the start — see our CRM and case pipeline automation for how planning and probate matters are staged and tagged by type. For how leads are engaged before they ever reach the pipeline, see lead follow-up automation. Reporting is what makes the rest of our estate and probate automation service overview accountable.