Salesforce · Litify Reporting

Every field in Litify is reportable. That is not the same as being reported well.

Two dashboards answering the same question differently is not a charting problem. It is two different date fields, two readings of the same stage, or free text where a picklist belonged. We fix the definitions first, then build the reporting on top — which is the only order that produces numbers a partner will act on. Definitions first. Dashboards second. In that order, always.

Reporting Architecture
WHERE NUMBERS COME FROM Intake & Matter Records Case Type · Stage · Roles Time, Expense & Invoice Entries · Bills · Payments Stage History Date Fields Integration Data THE DEFINITION LAYER Metric Dictionary What each number actually means Date Basis Which date drives which measure Quality Rules What keeps the inputs trustworthy ONE DEFINITION · ONE DATE · ONE OWNER 2πr WHAT LEADERSHIP SEES Intake & Pipeline Source to signed matter, with real attribution Matter Health Aging, cycle time and stalled work Realization WIP, write-downs, collections
1
Definition per metric, agreed before it is built
4
Dashboard audiences, each with its own view
12+
Years of Salesforce delivery
500+
Organizations served

Trusted by 500+ organizations — including law firms and legal technology companies building their case, billing and reporting operations on Salesforce with Twopir Consulting.

Social Justice Collaborative
Bernstein Liebhard LLP
LegalZoom
Sterling Law Offices, S.C.

Reporting Capability

  • Salesforce Partner
  • Metric Definitions
  • Report Types
  • Role-Based Dashboards
  • Marketing ROI
  • Realization Reporting
  • Data Quality
  • Carrier Scorecards
Why The Numbers Are Wrong

Six reasons leadership went back to the spreadsheet

Not one of these is fixed by building a better dashboard. Every one of them is fixed upstream, in the definitions or the data — which is why reporting projects that start with charts fail.

Two reports, one question, different answers

The classic symptom. Almost always two different date fields, or two people interpreting the same stage differently. Until the definition is settled, both reports are correct and the firm trusts neither.

Nobody agreed what "open matter" means

Sign-up, first substantive work, or first filing? Three answers means three cycle-time numbers. This is a definition problem masquerading as a reporting problem, and no amount of dashboard work resolves it.

Free text where a picklist belonged

You cannot group by a field people type into. Fourteen spellings of the same referral source means marketing attribution is guesswork, and the report that would prove it is the one you cannot build.

Reports built for whoever asked loudest

Two hundred saved reports, no owner, no naming convention, and nobody able to say which one is authoritative. New starters pick one at random and quote it in a partner meeting.

Dashboards designed for everyone, used by nobody

A single dashboard trying to serve partners, operations and fee earners serves none of them. Different audiences need different numbers at different frequencies, and one screen cannot do that.

Numbers nobody is accountable for

A metric with no owner is a metric nobody defends when it looks wrong. It gets questioned once, cannot be explained, and quietly stops being used — and the dashboard slowly becomes decoration.

How We Approach It

Reporting is a definitions problem wearing a charting costume

Litify reporting is built on Salesforce's own reporting engine, which means every field in the platform is reportable and the constraint is never the tool. Reports, report types, dashboards, dynamic dashboards and the whole Salesforce analytics surface are available to a Litify org. The reason firms still cannot get numbers they trust is that the reporting was built before anyone agreed what the numbers meant.

So we work in a fixed order. Agree the metric definitions — the wording, the source field, the date that drives it, the person who will be asked about it. Fix whatever in the data model or the data quality makes those definitions unreportable. Then build the report types and dashboards. Then socialise them, because a dashboard nobody has been walked through is a dashboard nobody uses.

Skipping to step three is the single most common reason reporting projects get redone. It is also why we will sometimes tell a firm that the fix is a picklist and a validation rule rather than a reporting engagement at all.

Metric Dictionary

Every number defined in a sentence, with its source field, date basis and accountable owner.

Report Types

The custom report types that make the right object combinations reportable in the first place.

Intake Reporting

Source to signed matter, with marketing attribution that survives the referral handoff.

Matter Aging

Cycle time, stage duration and stalled work, measured on a date basis everyone agreed.

Realization

WIP, billed, collected, written down — and where in the process the value leaked.

Workload

Capacity and distribution by role, on an agreed unit of work rather than a matter count.

Carrier Scorecards

For defense firms: write-down and rejection patterns by carrier, over time.

Data Quality

The validation, picklists and monitoring that keep the inputs trustworthy after launch.

Three Engagements

Define it, build it, or rescue what exists

Most firms think they need the middle column and actually need the first. We will tell you which, and the first is usually cheaper.

Engagement 01 · Define

Nobody agrees what the numbers mean

The definitions engagement. No dashboards built — the output is an agreed dictionary and a list of what has to change in the data model before the reporting is even possible.

  • Metric definitions agreed in facilitated sessions
  • Date basis named for every measure
  • Accountable owner per number
  • Gaps between wanted and reportable identified
  • Data model changes required, listed
  • A build backlog in priority order

Output A dictionary and a backlog. Often the cheapest engagement on this page, and the one that makes the others work.

Engagement 02 · Build

Definitions are settled, reporting is not built

The standard build. Report types, dashboards by audience, data quality rules and the walkthrough sessions that get them actually used.

  • Custom report types for the right object joins
  • Role-based dashboards per audience
  • Drill-down paths from summary to record
  • Data quality rules protecting the inputs
  • Subscriptions and delivery cadence
  • Walkthrough sessions per audience

Output Working dashboards, plus the quality rules that keep them true. Assumes the definitions exist — if they do not, start left.

Engagement 03 · Rescue

Hundreds of reports, none of them trusted

Report sprawl. An inventory, a cull, a single authoritative set, and the naming and ownership conventions that stop it happening again.

  • Full report and dashboard inventory
  • Usage data — what is actually run
  • Duplicates and contradictions identified
  • One authoritative version per question
  • Naming, folder and ownership conventions
  • Safe retirement of the rest

Output A smaller set people trust, and a convention that holds. Retirement is staged — nothing is deleted before we know who runs it.

What We Build

Six reporting layers, each for a different audience

Different people need different numbers at different frequencies. One dashboard trying to serve all of them serves none — so we build per audience and accept the overlap.

Metric Definitions & Dictionary

The foundation. Every number leadership wants, defined before anyone builds it — including the caveats, because a metric with hidden caveats gets discredited the first time someone finds one.

  • A one-sentence definition per metric
  • Source field and date basis named
  • Accountable owner per number
  • Targets or benchmarks where they exist
  • Known caveats stated up front
  • A review cadence for the definitions

Intake & Marketing ROI

Source through to signed matter, with attribution that survives a referral handoff. The reporting that tells you which spend actually produces retained cases.

  • Intake volume and conversion by source
  • Cost per signed matter by channel
  • Speed-to-contact and speed-to-sign
  • Referral partner performance
  • Case type mix by acquisition source
  • Where qualified intakes are lost

Matter Health & Aging

Where matters actually sit and how long they have been there. The operational dashboard that turns "we are busy" into something you can staff against.

  • Matter aging by stage and case type
  • Cycle time on an agreed date basis
  • Stalled matters and the reason codes
  • Deadline exposure in the next 30 days
  • Stage duration against benchmark
  • Drill-down from summary to the record

Financial & Realization

WIP, billed, collected and written down, with the leak points visible. For defense firms this extends into carrier scorecards.

  • WIP and unbilled time by matter and owner
  • Realization and write-down analysis
  • Invoice aging and collections
  • Carrier scorecards by write-down pattern
  • Expense recovery against disbursement
  • Profitability by case type where measurable

Workload & Capacity

Distribution by role on an agreed unit of work. Matter counts are misleading when one matter is a week and another is two years.

  • Active matter load by role and person
  • Weighted by case type, not raw counts
  • Task backlog and overdue distribution
  • Utilisation where the firm tracks it
  • Coverage gaps and absence impact
  • Trend over time, not just a snapshot

Data Quality & Monitoring

The part that keeps reporting true six months later. Without it every dashboard decays back to being untrusted.

  • Picklists replacing free text where it matters
  • Validation at the point of entry
  • Completeness monitoring on key fields
  • Exception reports for missing data
  • Duplicate detection on intake and accounts
  • An owner for data quality, named
The Questions We Settle First

Six definitions that decide every number downstream

These are the arguments worth having before anyone opens the report builder. Each one has several defensible answers and only one that your firm can live with.

When is a matter "open"?

At sign-up, at first substantive work, or at first filing? Every cycle-time, aging and capacity number depends on this answer, and firms routinely discover they have been using all three at once.

Decides Cycle time, matter aging, capacity, the open-matter count and every trend built on any of them.

What counts as a "signed" intake?

Agreement executed, first payment received, or matter created? Marketing attribution and conversion rates both hang off this, and the gap between the candidate answers is often weeks.

Decides Conversion rate, cost per acquisition, speed-to-sign and every marketing ROI comparison.

Which date starts the clock?

Incident date, intake date, sign-up date or matter-open date. Different questions genuinely need different bases — the failure is not choosing one, it is not saying which one a given report uses.

Decides Whether two reports answering the same question can ever agree with each other.

What is one unit of work?

A matter count treats a two-year mass tort and a three-week settlement as equal. Weighting by case type makes workload reporting mean something, and it needs agreeing before it is built.

Decides Workload distribution, capacity planning and any conversation about whether the firm needs to hire.

When is a matter "stalled"?

Days since last activity, days in current stage, or a missed task threshold? Whichever you pick becomes the exception report that operations runs every morning, so it has to be one people trust.

Decides The stalled-matter report, escalation triggers and how the firm spots trouble early.

What is the source of a matter?

First touch, last touch, or the referring party? Attribution that changes when a case is referred on will quietly undercount your best channels, and it is hard to unpick afterwards.

Decides Marketing ROI, referral partner value and where the firm spends its acquisition budget.
How We Deliver

Five phases, and charts come fourth

The order is the method. Firms that start at phase four get dashboards that look right and nobody uses, and then pay again to do it properly.

Phase 01

Define

Facilitated sessions to agree the metric definitions — wording, source field, date basis and accountable owner for each. Done with the people who will be asked about the numbers.

Phase 02

Assess Inputs

Whether your data can actually support those definitions. Free text where a picklist is needed, missing dates, fields nobody populates. This is where the honest bad news lives.

Phase 03

Fix Inputs

Picklists, validation, backfill where it is worth it, and monitoring. Sometimes this is the whole engagement, and sometimes that is the right answer.

Phase 04

Build

Custom report types first, because the right object joins have to exist before a useful report can. Then dashboards per audience, with drill-down to the record.

Phase 05

Socialise

Walkthrough sessions per audience, subscriptions set up, and an owner named for each dashboard. A dashboard nobody has been walked through is decoration.

The part firms skip Phase two often produces unwelcome news: the number leadership most wants cannot be reported because the data to support it was never captured. We would rather say that in week two than build a dashboard that quietly approximates it. Sometimes the answer is a small data model change and a month of collection before the metric becomes real — and knowing that is far more useful than a chart that looks authoritative and is not.

Who Reads What

Four audiences, four different dashboards

Frequency, altitude and detail all differ by audience. Building one dashboard for all of them is the most common reason none of them get used.

Managing Partners

Monthly and quarterly. Firm health, realization, acquisition cost and practice area mix — few numbers, high altitude, and every one of them defensible in a partners' meeting.

Operations

Daily. Stalled matters, deadline exposure in the next thirty days, task backlog and workload distribution. Operational, actionable and drillable straight to the record.

Finance

Weekly and at month-end. WIP, unbilled time, invoice aging, collections and write-down patterns — including carrier scorecards where the firm does defense work.

Fee Earners

Their own work, not the firm's. Their matters, their deadlines, their unbilled time. The narrowest dashboard on this page and usually the most used.

Client Outcomes

Legal platforms we have actually built

Two engagements from our legal practice. In both, reporting was designed as an input to the architecture rather than bolted on at the end — which is what made the numbers below knowable.

★★★★★
Twopir provided Salesforce customisation and integration services to help us build a robust, compliant, and scalable legal operations platform — connecting case management, document processing, and financial systems into one unified workflow. The result was transformative for how we run case-to-cash operations.
Operations Lead Fast-growing personal injury law firm Personal Injury
Case Study

Personal Injury Firm — Multi-State

Streamlining case-to-cash operations with Salesforce, AWS and QuickBooks.

40%+ Faster case-to-settlement processing
45% Reduction in reconciliation effort
35% Improvement in data accuracy
Read Full Case Study
★★★★★
Twopir's specialized Salesforce customization enabled efficient integration of third-party systems and streamlined administration and billing, leading to seamless financial operations and enhanced productivity. Automated mass billing and matter management minimized errors across our entire legal workflow.
Practice Manager Mid-size US family law firm · 150 employees Family Law
Case Study

Family Law Firm — 150 Employees, US

A 50% efficiency gain from Accounting Seed and Salesforce integration.

50% Increase in operational efficiency
45% Productivity gains from automation
35% Faster lead qualification & conversion
Read Integration Story
Why Twopir

Numbers a partner will defend in a meeting

The test of reporting is not whether it renders. It is whether the person quoting it can explain it when someone pushes back.

We agree definitions before we build anything

Wording, source field, date basis and accountable owner for every metric. It is the least glamorous phase and the one that decides whether the dashboards survive their first challenge.

We tell you when the data cannot support the metric

Sometimes the number leadership most wants was never captured. Saying so in week two is more useful than a dashboard that quietly approximates it and gets discredited in month six.

We build per audience, not per request

Partners, operations, finance and fee earners need different numbers at different frequencies. One dashboard for everyone is why most firms have dashboards nobody opens.

Every number has an owner

A metric with no owner is one nobody defends when it looks wrong. It gets questioned once, cannot be explained, and quietly stops being used along with the dashboard around it.

We work with growing and mid-market companies

We help growing and mid-market companies solve complex CRM, integration and business system challenges, and we serve enterprise organizations with the same architecture discipline. Firms at that stage need a system that survives the next three years of growth — not one built for the org chart they had last year.

Common Questions

Answers before the first call

Nearly always one of three causes, and none of them are charting problems. The two reports use different date fields — incident date versus intake date versus matter-open date. Or they interpret the same stage differently because the stage was never defined in writing. Or one of them filters on a free-text field where people have typed fourteen variations of the same value. The fix is upstream: agree the definition, name the date basis, replace the free text with a picklist. Then the reports agree because they are actually asking the same question.

Litify runs on Salesforce, so every field is reportable through Salesforce reports and dashboards, with custom report types for the object combinations you need. For the overwhelming majority of law firm reporting — intake conversion, matter aging, realization, workload, carrier scorecards — that is more than sufficient, and it has the advantage of drilling straight through to the record. A separate BI tool earns its place when you need to blend Litify data with sources outside Salesforce, or when you want history the platform does not retain. We will say which situation you are in rather than defaulting to the bigger answer.

A definitions engagement runs two to three weeks and is mostly facilitated sessions. A build on settled definitions is typically three to five weeks depending on how many audiences and how much data quality work is needed first. The variable that moves the timeline most is phase two: if the data cannot support the definitions, fixing the inputs can take longer than everything else combined, and occasionally it is the entire engagement.

With an inventory and usage data — which reports are actually run, by whom, and how often. Most report sprawl is 80 percent dead. We identify the duplicates and contradictions, establish one authoritative version per question, and put naming, folder and ownership conventions in place so it does not happen again. Retirement is staged rather than immediate: nothing gets deleted before we know who runs it and what they use it for.

Yes, and the hard part is attribution rather than charting. Every inbound source should create an intake with its campaign attached, which means the integrations creating intakes need to pass real Case Type record IDs and source data reliably. The definition that causes most trouble is what counts as the source when a case is referred on — first touch, last touch or referring party. Settle that before building and the ROI numbers hold; leave it and your best channels get quietly undercounted.

Yes. Salesforce dynamic dashboards run in the viewing user's context, so a single dashboard shows each person their own matters, deadlines and unbilled time without any cross-visibility. It respects the sharing model, so the reporting inherits whatever ethical walls and matter visibility rules the org already enforces. In practice the fee-earner dashboard is the narrowest one we build and frequently the most used.

Data quality rules and a named owner. Picklists replacing free text where grouping matters, validation at the point of entry, completeness monitoring on the fields the metrics depend on, and exception reports that surface missing data before it reaches a dashboard. Plus an accountable owner per metric and a review cadence for the definitions themselves — because practice changes, and a definition nobody revisits slowly stops describing what the firm actually does.

Next Step

If two reports disagree, the problem is upstream of the chart

A first conversation covers which numbers leadership actually wants, which ones currently disagree, and whether you need definitions work, a build, or a cull of what already exists.

Definitions · input quality · report types · dashboards by audience · owners named