Your Law Firm Has Plenty of Data. It Still Doesn't Know What's Going On.

Most law firms I work with do not have a data problem.

They have plenty of data.

Their practice management system has data.

Their accounting software has data.

Their CRM has data.

Their payroll system has data.

Their marketing platforms have data.

Their phone system has data.

There are spreadsheets.

There are reports.

There may even be a beautiful dashboard someone spent months building.

Then I ask a relatively simple business question:

Which practice area is actually the most profitable?

Silence.

Or:

Do you actually need another attorney?

"Well, everyone is really busy."

Or:

Which marketing source produces your most profitable clients?

"We know how many leads Google generates."

That's not what I asked.

Or:

What percentage of the firm's revenue is being produced by non-partner attorneys?

Nobody knows.

Or:

How much revenue are you losing through write-offs?

"We track write-offs."

Great. How much?

Suddenly someone needs to pull a report.

This is why I don't automatically recommend more reporting when a law firm tells me it needs better data.

Usually, the firm already has an enormous amount of data.

What it doesn't have is business intelligence.

Those aren't the same thing.

Your Law Firm Probably Doesn't Need More Data. It Needs Better Questions.

This is where I start.

Before we talk about dashboards, reports, integrations, or KPIs, I want to know:

What are we trying to understand?

Because collecting data without a business question behind it creates noise.

Suppose the managing partner asks:

"Should we hire another attorney?"

That's a business question.

Now I know what information I need.

I may want to look at:

• attorney utilization

• workload distribution

• current matter volume

• historical and expected demand

• realization

• work being performed below or above the appropriate level

• delegation

• capacity by attorney

• practice-area economics

What I don't necessarily need is a 47-page report containing every metric your practice management software can produce.

Start with the decision.

Then determine what information would allow leadership to make that decision intelligently.

That's reporting.

A Report Is Only Useful If It Changes—or Validates—a Decision

Law firms generate a tremendous amount of reporting that nobody actually uses.

Someone exports it.

Someone formats it.

Someone emails it.

Maybe someone puts it into a PowerPoint.

Everyone looks at it.

Then everyone goes back to work.

Nothing changes.

Why are we producing it?

The purpose of law firm reporting isn't to prove that you know what happened last month.

It's to help you decide what to do next.

If utilization falls, what happens?

If A/R over 90 days increases, what happens?

If intake conversion drops, what happens?

If one practice area's margins deteriorate, what happens?

If write-offs increase significantly for one attorney, what happens?

If a marketing source generates lots of leads but almost no collected revenue, what happens?

A metric without a response mechanism is trivia.

Stop Starting With the Reports Your Software Gives You

This is one of the biggest mistakes I see.

Someone logs into the firm's practice management system, clicks "Reports," and starts deciding which reports leadership should review.

That's backwards.

Your software company doesn't know which decisions your firm needs to make.

Start with the business.

What do we need to know?

What decisions are we trying to make?

What risks are we trying to identify earlier?

What behavior are we trying to change?

What outcomes are we trying to improve?

Then figure out where the data lives.

Sometimes the answer is a report inside your existing software.

Sometimes it isn't.

The Most Important Questions Usually Cross Multiple Systems

This is where law firm reporting gets difficult.

Most software platforms are relatively good at reporting on the information contained inside their own system.

The problem is that leadership questions don't respect software boundaries.

Consider this question:

Which marketing source generates the most valuable clients?

Your advertising platform may know:

• spend

• clicks

• impressions

• conversions

Your CRM may know:

• leads

• consultations

• conversion

• source

Your practice management system may know:

• matters

• billing

• attorneys

• matter types

Your accounting system may know:

• collections

• expenses

• cash

But the managing partner doesn't really want four separate reports.

They want an answer.

We spent X dollars here, it generated Y clients, those clients produced Z dollars in collected revenue, and here's what we believe the return was.

That's a cross-functional business question.

And this is exactly where many law firms struggle.

Software Is Not the Same Thing as a Reporting Strategy

I've worked with many of the major legal technology platforms.

They're useful.

They solve real problems.

But buying good software does not automatically create good management information.

I've seen firms with sophisticated practice management systems that still can't answer basic questions about:

capacity.

profitability.

marketing ROI.

intake conversion.

leverage.

workload.

matter economics.

That's not necessarily because the data doesn't exist.

Sometimes it's because the information exists in different places.

Sometimes fields aren't being populated consistently.

Sometimes systems aren't integrated.

Sometimes the firm's definitions aren't consistent.

Sometimes nobody has determined which data actually matters.

And sometimes the report leadership wants simply isn't a report the software was designed to produce.

Technology stores information.

Leadership still has to decide what it wants to know.

Sometimes Excel Is Still the Answer

People occasionally seem disappointed when I say this.

They've invested heavily in legal technology and expect there to be one magical dashboard that answers every business question.

Sometimes there is a good built-in report.

Sometimes an integration solves it.

Sometimes a dedicated reporting tool makes sense.

And sometimes I export the data and put it into Excel.

That's okay.

The sophistication isn't in where the answer lives.

The sophistication is in knowing which question to ask, which data is reliable, and how to interpret what it tells you.

A simple spreadsheet that drives a $500,000 business decision is more valuable than an elaborate dashboard nobody uses.

Your Data Is Only as Good as the Definitions Behind It

Here's a problem that shows up quickly once you start building real reporting:

Nobody agrees on what the numbers mean.

Ask:

How many leads did we get last month?

Marketing gives you one number.

Intake gives you another.

Why?

Maybe marketing counts every form submission and phone call.

Intake excludes spam.

Someone else excludes existing clients.

Someone counts duplicate contacts.

Someone doesn't.

Which number is right?

Potentially all of them—based on different definitions.

That's the problem.

Before I trust a KPI, I want to know exactly how it's defined.

What counts as a lead?

What counts as a qualified lead?

When does someone become a client?

When is revenue attributed to a matter?

What exactly is included in utilization?

How are write-offs calculated?

How are attorney costs allocated?

What counts as an originated client?

How do we treat split origination?

You can build an extremely sophisticated dashboard on top of inconsistent definitions.

You'll just get a sophisticated-looking version of bad information.

One Source of Truth Doesn't Necessarily Mean One Software Platform

Firms love the phrase "single source of truth."

I understand the goal.

But sometimes leadership interprets that to mean:

"Everything has to live in one system."

It doesn't.

Your CRM may be the authoritative source for intake activity.

Your practice management system may be the authoritative source for time and matter information.

Your accounting system may be the authoritative source for financial results.

Your phone platform may be the authoritative source for call activity.

That's fine.

The real goal is that leadership agrees:

This is where this number comes from. This is how it's defined. And this is the number we're going to use.

Otherwise leadership meetings turn into debates over whose spreadsheet is correct.

That's not reporting.

That's reconciliation.

If You're Arguing About the Number, You Can't Manage the Number

I've sat through versions of this conversation more times than I can count.

"Revenue was $4.2 million."

"No, it was $4.4 million."

"That's what QuickBooks says."

"I'm looking at the practice management system."

"Does that include this?"

"What about that?"

Twenty minutes later, nobody is discussing why revenue changed.

They're still trying to establish what revenue was.

Leadership can't make good decisions if it doesn't trust the information in front of it.

Before you build more dashboards, establish confidence in the underlying data.

The Best KPIs Are Usually Connected to Decisions

I don't believe every law firm needs the exact same KPI dashboard.

The metrics should reflect the firm's business model, goals, and current constraints.

But there are several categories I commonly care about.

Financial Performance

Revenue matters.

But I usually want to understand what is underneath it.

Depending on the firm, I may look at:

• collected revenue

• profitability

• effective billing rate

• realization

• write-offs

• A/R aging

• compensation as a percentage of revenue

• overhead trends

• practice-area economics

Revenue tells me what came in.

These numbers help explain what the firm kept and why.

Attorney Economics

I may look at:

• billable hours

• collected value of work

• utilization

• realization

• leverage

• revenue by timekeeper

• ROI by timekeeper

• partner versus non-partner production

This helps answer questions about staffing, capacity, compensation, delegation, and profitability.

Intake and Sales

Depending on the practice, I may want:

• leads by source

• qualified leads

• speed to contact

• calls answered live

• consultations scheduled

• consultations completed

• engagement agreements sent

• engagement agreements received

• retainers requested

• retainers received

• conversion rates at each stage

"New clients" alone doesn't tell me where the pipeline is working—or leaking.

Marketing

I may want to connect:

• spend

• lead source

• qualified leads

• conversion

• client acquisition cost

• matter type

• collected revenue

• ultimately, return

That's much more useful than celebrating an increase in website traffic.

Operational Performance

Depending on the firm, this could include:

• matter cycle time

• workload

• capacity

• staffing ratios

• collections

• client satisfaction

• calls per intake specialist

• administrative workload

• task completion

Again, the point isn't to measure everything.

It's to measure what helps you manage something.

Some of the Most Valuable KPIs Are Uncomfortable

This is worth saying directly.

Law firms tend to enjoy metrics that make them feel successful.

Revenue increased.

Cases increased.

Website traffic increased.

Hours increased.

Great.

I also want to see the numbers that might make the room uncomfortable.

How much did we write off?

Which attorney has the lowest effective billing rate?

How much A/R is sitting beyond 90 days?

Which timekeepers aren't generating an appropriate return?

Which practice area produces lots of revenue but weak profit?

What percentage of attorney work is being performed at the wrong level?

Which intake specialist converts significantly below the team?

What percentage of calls aren't being answered during business hours?

Which marketing channel produces leads that never become good clients?

Those numbers create decisions.

And that's the point.

Measure the things that help you make uncomfortable decisions—not just the things that make the partner meeting feel good.

"Everyone Is Busy" Is Not Capacity Reporting

This is one of my favorite examples because I hear it constantly.

"We need another attorney."

Why?

"Everyone is slammed."

Maybe you do.

But "slammed" isn't a metric.

Before adding another six-figure salary to payroll, I want to know what's actually happening.

Are attorneys fully utilized?

Are some attorneys overloaded while others have capacity?

Are partners doing associate-level work?

Are associates doing work that should sit with paralegals?

Are attorneys doing administrative work?

Is poor delegation creating artificial capacity constraints?

Is one practice area overloaded while another has room?

Is the demand temporary or sustained?

A firm can absolutely need another attorney.

But that's a conclusion.

"Everyone feels busy" isn't enough evidence to get me there.

The Same Is True for Marketing

"We need more leads."

Maybe.

How many leads do you currently receive?

How many are qualified?

How quickly do you respond?

How many do you reach?

How many consultations are scheduled?

How many actually happen?

How many prospects sign?

How many pay?

What is the average value of the resulting matters?

How does that differ by source?

If you don't know those things, increasing marketing spend may simply increase the amount of opportunity leaking through the same broken funnel.

The question isn't:

"Can we generate more leads?"

The question is:

Where is the actual constraint on growth?

Reporting should help you answer that.

And the Same Is True for Profitability

A law firm can generate impressive revenue and still have disappointing profit.

I've seen firms focus intensely on top-line growth while giving surprisingly little attention to what happens to each dollar after it enters the business.

That's why I want reporting that helps explain:

Where is the money going?

People?

Partner compensation?

Marketing?

Write-offs?

Poor leverage?

Underutilization?

Excess overhead?

Bad pricing?

Unprofitable practice areas?

A/R?

Client mix?

A P&L tells me something important.

It doesn't necessarily tell me why it's happening.

Good management reporting helps connect the two.

Don't Build a Dashboard Graveyard

There is a predictable lifecycle I've seen at firms.

Leadership decides it needs KPIs.

Someone spends weeks gathering requirements.

A dashboard gets built.

Everyone is excited.

For three months, it's reviewed religiously.

Then meetings get busy.

Someone stops updating a field.

One integration breaks.

A metric becomes unreliable.

Nobody fixes it.

Six months later, the dashboard still exists.

Nobody really uses it.

You haven't built a management system.

You've built expensive wallpaper.

Every KPI Needs an Owner

If a number matters, someone should care when it moves.

Let's say intake conversion drops from 38% to 27%.

Who owns that?

Who investigates?

Who listens to calls?

Who looks at lead quality?

Who evaluates response times?

Who reviews individual performance?

Who recommends changes?

Who follows up next month?

If the answer is:

"We discuss it in the leadership meeting,"

that's probably not enough.

Dashboards don't create accountability.

Leaders responding to dashboards do.

Every KPI Also Needs Context

Numbers by themselves can mislead.

Suppose revenue increased 20%.

Fantastic.

Did profit increase?

Did headcount increase 35% to produce it?

Did one unusually large matter create the increase?

Did collections improve?

Did rates increase?

Did utilization improve?

Suppose intake conversion falls.

Was the team worse?

Or did marketing dramatically increase a lower-quality lead source?

Suppose utilization drops.

Is demand down?

Or did the firm hire ahead of expected growth?

The number tells you where to look.

It doesn't always tell you what happened.

This is why I don't want firms managing exclusively by dashboard.

Data informs judgment.

It doesn't replace it.

Trends Usually Matter More Than Isolated Numbers

I care about what happened this month.

I often care more about what has been happening for six months.

Is A/R slowly increasing?

Are write-offs trending upward?

Is utilization declining?

Is payroll becoming a larger percentage of revenue?

Is conversion improving?

Is one practice area steadily becoming more profitable?

Trends reveal things that a single month can hide.

And they give leadership an opportunity to act before something becomes a crisis.

Good reporting isn't only retrospective.

It should function as an early-warning system.

Don't Collect Data You Aren't Willing to Use

This is one of my strongest opinions about KPIs.

More isn't better.

If nobody reviews it, stop collecting it.

If nobody trusts it, fix it or stop reporting it.

If nobody knows what it means, define it.

If nobody does anything when it changes, ask why you're measuring it.

People spend real time entering data.

Every required field has a cost.

Every report has a cost.

Every dashboard has a cost.

Make the information earn its place.

If nobody can explain what decision a KPI influences, stop measuring it.

Reporting Should Get More Sophisticated as the Firm Grows

When a firm is small, the managing partner can often operate largely on intuition.

They know who is busy.

They know which clients haven't paid.

They know which matters are coming in.

They hear the phones.

They see the team.

They can feel when something changes.

That becomes less reliable as the organization grows.

At some point, the firm's complexity exceeds the owner's ability to hold the entire business in their head.

That's when reporting stops being a nice-to-have.

It becomes management infrastructure.

The owner shouldn't have to personally observe every part of the firm to know whether it's working.

The numbers should help tell the story.

But Don't Use Reporting to Micromanage

Good reporting should actually reduce the need for micromanagement.

If I know the expected outcome, have reliable data, and can see that someone is achieving it, I don't need to watch every step they take.

That's the beauty of good management information.

It creates visibility without requiring constant intervention.

The goal isn't:

"I need more data so I can control everything."

The goal is:

"I need enough visibility to know what's working, what's not, and where leadership attention is required."

Those are very different philosophies.

Reporting Is Really a Management System

This is the part I think firms often miss.

A dashboard isn't reporting.

A spreadsheet isn't reporting.

A monthly financial package isn't reporting.

Those are tools.

A real management reporting system looks more like this:

Business question → metric → reliable data → owner → review cadence → decision → action → follow-up

That's the system.

For example:

Question: Are we converting enough qualified leads?

Metric: Qualified-lead-to-client conversion.

Owner: Intake manager.

Review: Weekly.

Result: Conversion drops materially.

Action: Review call recordings, response times, lead mix, individual performance, and follow-up.

Follow-up: Determine whether changes improved conversion.

Now the metric is doing something.

Your Leadership Meetings Should Change Because of the Data

One of the clearest signs that reporting is working is that leadership conversations improve.

Instead of:

"I feel like intake isn't doing very well."

You get:

"Conversion fell six points over the last eight weeks. The decline is concentrated in this lead source and this stage of the funnel."

Instead of:

"I think we need another associate."

You get:

"Our associates are at X utilization, partners are still performing Y hours of associate-level work, and this practice area has exceeded capacity for four consecutive months."

Instead of:

"Marketing seems expensive."

You get:

"This source costs more per lead, but those clients generate substantially more collected revenue."

Now you can manage.

The Goal Isn't Perfect Data

You will never have perfect data.

Someone will enter something incorrectly.

A field will be missed.

A system won't integrate perfectly.

There will be judgment calls.

There will be exceptions.

Don't let the pursuit of perfect reporting become another excuse not to make decisions.

The goal is reliable enough information to make materially better decisions.

Then improve it over time.

Start With Five Questions, Not Fifty KPIs

If your law firm currently has weak reporting, don't begin by building the world's most sophisticated dashboard.

Sit down with leadership and ask:

What are the five most important questions we need to be able to answer about this business?

Maybe they're:

Are we profitable enough?

Do we have enough capacity?

Where is our best business coming from?

Are attorneys working at the right level?

Are we converting enough of the opportunities we're already generating?

Your questions may be completely different.

That's fine.

Once you know the questions, work backward.

What information answers them?

Where does that information live?

Is it reliable?

How should it be calculated?

Who owns the metric?

How often should it be reviewed?

What would cause us to act?

Build from there.

You Can Have Perfect Data and Still Run the Firm Poorly

Ultimately, reporting is not the objective.

Better management is.

I've seen firms with limited technology but excellent financial discipline.

I've seen firms with expensive technology stacks and weak operational visibility.

I've seen beautiful dashboards ignored.

I've seen ugly spreadsheets drive excellent decisions.

The tool is not the differentiator.

What matters is whether leadership understands the business well enough to know what it needs to see—and has the discipline to respond when the numbers reveal a problem.

Your law firm probably already has more data than you realize.

The question is whether that data helps you answer:

What's happening?

Why is it happening?

What are we going to do about it?

If your reporting can't help answer those questions, adding another dashboard probably isn't the solution.

Ask better questions.

Define the numbers.

Connect the systems where necessary.

Assign ownership.

Review the information consistently.

And most importantly, act on what it tells you.

Because the purpose of reporting isn't to know more about your business.

It's to run your business better.

If your law firm has multiple systems, dozens of reports, and plenty of data but leadership still struggles to answer basic questions about profitability, capacity, utilization, intake, marketing ROI, or performance, the problem may not be the amount of information you have.

It may be how that information is being used.

At ING Collaborations, I help law firms determine which numbers actually matter, build practical reporting around the decisions leadership needs to make, and turn those numbers into operational action.

Because better reporting isn't about creating more reports.

It's about making better decisions.