Data and business intelligence for law firms
A marketing report can show clicks and enquiries while a partner remains unable to answer a more important question: which activity is producing work the firm can sustainably deliver?
Discuss a reporting and measurement review
Webvelopment scopes reporting that connects acquisition, intake and authorised commercial outcomes. The work begins with definitions and data quality, not dashboard decoration. The aim is a management view that explains what is known, what is uncertain and where action is needed.
Different stages answer different questions
A raw enquiry tells you someone submitted details or made contact. A consultation-stage record says the request reached an agreed point in the intake process. A booking, attendance, accepted matter and collected fee each describe another event.
When these are blended together, the report can appear to improve simply because a team changed a status label. A useful measurement contract defines the event, denominator, timestamp and responsible owner before calculating a conversion rate.
Connect the journey without exposing the case
Reporting may need to connect the source of an enquiry to a consultation or an approved matter reference. It does not follow that marketing staff need case narratives, documents, opposing-party details or consultation recordings.
Use the minimum authorised information needed for the decision. Restrict detailed operational and financial access, and give broader teams aggregate views where appropriate. Internal measurement and advertising-platform data sharing remain separate approvals.
What a reporting project can cover
Acquisition performance
Bring together spend, sources, campaign context, valid enquiries and agreed progression stages. Compare cost boundaries consistently and show the effect of exclusions and unknown sources.
Intake operations
Examine ownership, first attempts, ageing, consultation progression, rescheduling and no-shows. Use the report to identify a process problem and assign a response, not merely display a red or green number.
Matter and financial outcomes
Connect approved matter records and relevant financial information where the firm authorises access. Distinguish invoiced value, collections, credits, refunds and contribution. Trust balances should not be relabelled as earned revenue in a marketing chart.
Management decisions
Summarise which constraints are most important, which hypotheses have evidence and what the next action should be. A report should make responsibility clearer rather than create another meeting without a decision.
Cost per lead is only one part of the picture
Our illustrative model starts with R60 per enquiry and reaches R15,000 in media cost per qualifying matter under the stated conversion assumptions. That is not a complete acquisition cost or a profitability result.
Add the relevant management, intake, production and technology costs. Then evaluate consultation receipts and matter contribution without counting the same money twice. If collected outcomes are not available, state that limitation rather than substitute billed fees or a minimum account value.
Read the detailed cost analysis and the original planning model.
Use cohorts to understand delayed outcomes
An enquiry received this month may become a matter later. A matter accepted today may not have completed its collection cycle. Comparing all current-month matters with current-month leads can therefore answer a different question from tracking the eventual result of a defined enquiry cohort.
A useful report shows both activity during the period and the progress of earlier cohorts. It makes maturity visible and avoids celebrating a short-term movement that is actually caused by timing.
Reconciliation matters more than a perfect-looking chart
A person may enquire more than once. One organisation may have several matters. A consultation fee may be credited into a later invoice. These relationships can duplicate outcomes if records are joined carelessly.
The project should define entity relationships and test the transformations against the source systems. A report that cannot explain its totals is not ready to guide budget decisions. Unknown attribution should remain visible rather than being assigned to the last convenient click.
The data model behind a report you can trust
Most broken legal-marketing reports fail in the joins. We keep enquiries, contacts, consultations, matters, source touches and financial events as separate records. One organisation can produce several matters, and several enquiries can relate to one instruction, so the allocation rule is documented rather than forced into a one-to-one join that quietly double-counts revenue.
Every record carries the time it happened and the time it arrived in the reporting system, so a late update lands in the right cohort. Raw data stays in a restricted layer, validated transformations in a controlled one, and management sees aggregates. Matter narratives, opposing parties and documents never appear in a marketing dashboard.
Finance defines collected fees, credits, refunds, disbursements, trust balances and contribution. Marketing doesn’t get to rename a revenue column and call it profit.
Choose the tool after the reporting requirements
The firm’s existing environment, licences, access model and support requirements should guide the choice of BI software. The first task is to establish what must be measured and where the information comes from.
A dashboard implementation can include a data dictionary, field mapping, transformation rules, access controls, reconciliations, management views and a handover runbook. It should also identify what cannot yet be measured reliably.
Do not treat CRM outcomes as automatic advertising inputs
Data that is useful inside the firm may be unsuitable for a platform upload. Sensitive matters require particular care, and permitted measurement features can differ from internal reporting. We do not default to sending client identifiers or case outcomes into advertising systems.
Any approved feedback integration should have a documented purpose, limited payload and current policy review. A hash or a neutral event label does not remove the need to consider the underlying information.
Four reports for four audiences
- Acquisition: spend, source, valid enquiries, contactability and cost per agreed stage.
- Intake: response times, ownership, ageing, consultation progression, no-shows and exceptions.
- Commercial: accepted matters, collections, cost boundaries and cohort contribution, where the inputs support it.
- Management: the current constraint, the hypothesis being tested, the next action and how confident the data is.
Unknown attribution is shown as unknown. When a platform’s conversion count and the firm’s reconciled outcomes differ, the report explains why instead of forcing them to match.
How we prove the numbers
Before a dashboard is signed off we reconcile source totals for a chosen period, including duplicates and exclusions. We trace synthetic journeys through every transformation, confirm that no join duplicates a receipt, test consultation credits and refunds, compare cohort and calendar views, and check restricted access and small-number exposure. A chart is only as trustworthy as the tests behind it.
Reporting we’ve built
For the Suzuki secret shopper platform we built weighted scoring, branch-by-branch comparisons, category breakdowns and PDF reports. Our automotive assessment platform case shows organisational reporting with strict access boundaries. The sector is different, but the discipline is the same: agreed definitions, controlled access and numbers that can be traced back to their source.
Questions about analytics
A few useful answers before you decide.
Can you prove exactly which advert caused every matter?
Can reporting show practice-area profitability?
Can we begin without changing our CRM?
Give management a clearer basis for decisions
For an early sense of scope, try the analytics estimator.
Discuss data and reporting, explore CRM and intake or return to the full law-firm solution.
Keep the right things connected.
Digital growth and technology for law firms
Connect legal-practice marketing, websites, client intake, CRM, automation and commercial reporting around a clearer route from enquiry to accepted work.
Law-Firm Client Acquisition Cost: From Enquiry to Collected Contribution
A practical framework for comparing lead prices with the actual cost and commercial contribution of new legal work.
CRM and client intake for law firms
Give every enquiry an owner, a next step and a traceable outcome, with consultations, reminders and professional handovers that respect the firm’s procedures.
Suzuki Secret Shopper — App
Structured assessments and reporting interfaces.
Start a conversation
Tell us what you are working towards. We’ll help you find a practical next step.