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.
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.
Trusted by 500+ organizations — including law firms and legal technology companies building their case, billing and reporting operations on Salesforce with Twopir Consulting.








Reporting Capability
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.
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.
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.
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.
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.
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.
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.
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.
Every number defined in a sentence, with its source field, date basis and accountable owner.
The custom report types that make the right object combinations reportable in the first place.
Source to signed matter, with marketing attribution that survives the referral handoff.
Cycle time, stage duration and stalled work, measured on a date basis everyone agreed.
WIP, billed, collected, written down — and where in the process the value leaked.
Capacity and distribution by role, on an agreed unit of work rather than a matter count.
For defense firms: write-down and rejection patterns by carrier, over time.
The validation, picklists and monitoring that keep the inputs trustworthy after launch.
Most firms think they need the middle column and actually need the first. We will tell you which, and the first is usually cheaper.
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.
Output A dictionary and a backlog. Often the cheapest engagement on this page, and the one that makes the others work.
The standard build. Report types, dashboards by audience, data quality rules and the walkthrough sessions that get them actually used.
Output Working dashboards, plus the quality rules that keep them true. Assumes the definitions exist — if they do not, start left.
Report sprawl. An inventory, a cull, a single authoritative set, and the naming and ownership conventions that stop it happening again.
Output A smaller set people trust, and a convention that holds. Retirement is staged — nothing is deleted before we know who runs it.
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.
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.
Source through to signed matter, with attribution that survives a referral handoff. The reporting that tells you which spend actually produces retained cases.
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.
WIP, billed, collected and written down, with the leak points visible. For defense firms this extends into carrier scorecards.
Distribution by role on an agreed unit of work. Matter counts are misleading when one matter is a week and another is two years.
The part that keeps reporting true six months later. Without it every dashboard decays back to being untrusted.
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.
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.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.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.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.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.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.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.
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.
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.
Picklists, validation, backfill where it is worth it, and monitoring. Sometimes this is the whole engagement, and sometimes that is the right answer.
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.
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.
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.
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.
Daily. Stalled matters, deadline exposure in the next thirty days, task backlog and workload distribution. Operational, actionable and drillable straight to the record.
Weekly and at month-end. WIP, unbilled time, invoice aging, collections and write-down patterns — including carrier scorecards where the firm does defense work.
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.
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.
Streamlining case-to-cash operations with Salesforce, AWS and QuickBooks.
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.
A 50% efficiency gain from Accounting Seed and Salesforce integration.
The test of reporting is not whether it renders. It is whether the person quoting it can explain it when someone pushes back.
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.
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.
Partners, operations, finance and fee earners need different numbers at different frequencies. One dashboard for everyone is why most firms have dashboards nobody opens.
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 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.
This page covers one service. Each one below goes into the detail a specific team needs — pick the one closest to the question you arrived with.
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.
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