Before moving money toward the campaign with the lowest reported cost per client, check how the report counted those clients and costs. Duplicate records, inconsistent definitions, missing costs, and incomplete transfers can make a campaign appear stronger or weaker than the underlying business result.
The failures below concern measurement and administration. They are different from a weak ad or a poor intake conversation, although they can make those problems harder to diagnose. Use each as a specific check on how the firm produces its numbers.
1. Counting a click as a completed inquiry
A click on a phone number shows that someone activated the link. It does not establish that a call connected, that a conversation occurred, or that the caller was a new prospect.
Inspect the event behind every reported “lead” or “conversion.” Check what triggers it and compare it with the receiving system where possible. A form event should be distinguished from a successfully received submission; a chat opening is different from a substantive inquiry.
Keep useful activity metrics, but label them accurately. The fix is not to discard early-stage behavior. It is to prevent that behavior from being reported as an outcome it does not prove.
2. Creating several opportunities from one inquiry
A prospect submits a form, calls, and follows up by email. If each contact creates a new opportunity, inquiry volume rises while the apparent engagement rate falls.
Preserve the contact events and connect them to the appropriate inquiry. Review duplicate rules carefully: shared contact details do not always mean the records describe the same person or matter.
Track merges and retain enough history to explain them. Quietly deleting records to make a report look cleaner removes evidence that may be needed to understand the journey.
3. Fragmenting one campaign across several names
“Fall-Webinar,” “fall_webinar,” and “Fall Webinar” may all refer to the same initiative. If reports treat them separately, the team can miss its full activity or assign costs inconsistently.
Use a campaign register with stable identifiers and documented naming rules. Google confirms that UTM parameter values are case-sensitive; consistency matters when manually tagging links. Its campaign URL documentation explains the relevant fields.
Preserve original values during cleanup and create a documented mapping to the standardized view. Historical records should remain traceable after names are consolidated.
4. Overwriting the original source
A staff member records a referral, but a later website visit replaces it with a tracked channel. Or the system keeps only the first source and discards useful later contact context.
Separate original tracked source, later observed interactions, and self-reported influence. Decide which field each report uses and why. A channel-credit rule is a reporting choice, not a complete explanation of what caused the engagement.
Test what happens when a record is edited or synchronized. The firm should know whether the new value corrects an error, adds context, or destroys information it intended to retain.
5. Comparing records from different time windows
Media costs may reflect a calendar month while engagements come from inquiries received over several earlier months. Another report may use a different time zone or include only weekdays.
State the time basis for each input. Use an inquiry cohort when asking how a group progressed, and an activity-period report when asking what work happened during that period. Do not label them as the same conversion measure.
The law firm marketing analytics guide provides context for connecting stages. That connection depends on compatible dates and an honest account of pending outcomes.
6. Letting staff use the same status for different outcomes
“Qualified” may mean preliminary practice fit to one employee and attorney-approved acceptance to another. “Consultation” may include bookings in one report and completed meetings in another.
Write definitions with examples and review a sample across users. Separate stages that serve different decisions. When the definition changes, record the effective date and assess whether historical comparisons remain meaningful.
A rising rate can result from a looser label. Before attributing improvement to marketing or intake, confirm that the underlying definition stayed consistent.
7. Treating missing data as a favorable answer
Blank disposition fields are excluded from a report, leaving only resolved records with known results. Missing costs are treated as zero. Unattributed engagements are assigned to the channel with the most activity.
Keep unknowns visible. Show how many records lack a required value and how that limits the conclusion. Resolve them through evidence where possible; do not fill them merely to complete a chart.
The missing records may differ systematically from the completed ones. A report based only on well-documented inquiries cannot automatically represent the whole population.
8. Reporting an incomplete acquisition cost
Media spend divided by engagements is a useful media-only measure. It becomes misleading when labeled total acquisition cost while excluding agency fees, intake labor, or other costs the firm intends to include.
Define the cost boundary and apply it consistently. Separate direct campaign costs from shared costs, and document any allocation method. Avoid counting the same expense in multiple places.
Our profitability metrics resource helps place acquisition measures in their wider financial context. A lower cost per engagement does not establish greater profit without considering the work and economics of the resulting matters.
9. Allowing failed transfers to disappear silently
A connection between two systems can work for most records while failing on a particular status, missing field, or temporary interruption. If no one monitors exceptions, the report may look complete simply because the missing records never arrived.
Compare the sending and receiving systems using appropriate identifiers and time windows. Investigate unmatched records and document the reason. Establish a visible failure queue and an owner for recovery.
When retrying a transfer, verify that the process does not create a second record or repeat a communication. Our technology-stack guide explains why information flow deserves as much attention as individual software features.
10. Changing filters without preserving comparability
Excluding staff activity, tests, or other irrelevant events can improve a report. It can also create an apparent performance change if the before-and-after periods use different rules.
Record what was excluded, when the rule changed, and whether the effect applies to collection or only to a report view. Google Analytics offers a testing state for data filters and warns that active exclusion permanently prevents the excluded data from being processed. Check the official internal-traffic guidance before activating a rule.
Do not interpret a cleaner post-change report as evidence that the campaign improved. First explain the measurement change and assess which comparisons remain valid.
Work the failures through one disputed report
A fictional regional family-law firm receives a quarterly report showing 86 “leads,” nine “clients,” $42,000 in media spend, and a reported cost per client of $4,666.67. The number looks efficient enough to justify shifting more budget into the campaign.
The operations review rebuilds the cohort from source records:
Scroll sideways to review every column.Each row is shown as a labeled card.
| Reconciliation | Records remaining | What changed |
|---|---|---|
| Reported conversion events | 86 | Mixed phone-link clicks, calls, forms, and tests |
| Remove 12 phone-link clicks with no corresponding call record | 74 | Activity is no longer labeled inquiry |
| Remove nine mutually exclusive tests or spam records | 65 | Invalid records remain documented outside the cohort |
| Merge eight form/call pairs belonging to eight people | 57 | Both interactions remain in each inquiry history |
The 57 distinct inquiries then receive mutually exclusive dispositions: 24 wrong-practice, ten outside the served market, eight unreachable after the firm’s defined attempt sequence, nine qualified, and six unresolved. The sum is 24 + 10 + 8 + 9 + 6 = 57.
The nine qualified inquiries are not nine clients. Six complete consultations; two do not schedule and one remains scheduled pending consultation. Of the six completed consultations, four sign and two do not. Three matters open during the review period, and one signed agreement remains pending opening.
The cost numerator is also incomplete. The $42,000 media figure excludes $8,000 in management and $4,000 in campaign-specific landing-page and tracking work. Under the firm’s stated acquisition-cost definition, the included total is $54,000.
That produces several accurate but different descriptions:
- media spend per distinct inquiry: $42,000 / 57 = $736.84;
- included acquisition cost per qualified inquiry: $54,000 / 9 = $6,000;
- included acquisition cost per signed agreement: $54,000 / 4 = $13,500; and
- included acquisition cost per opened matter: $54,000 / 3 = $18,000.
None is automatically profit or causal return. The matters are not mature, shared costs may remain outside the chosen numerator, and six inquiries are unresolved. The useful decision is to pause budget reallocation, correct the event and stage definitions, resolve or preserve the six unknowns, repair the duplicate rule, and issue a restated report alongside the original. The campaign may ultimately deserve more investment, but the first report cannot support that decision.
Trace one disputed number back to the records
Choose one material discrepancy and trace it through collection, transfer, classification, calculation, and presentation. Save the original report, document the correction, and show the revised result with its remaining limits.
Then address the process that allowed the error. A one-time spreadsheet adjustment may repair this month's number while leaving next month's problem untouched. A definition, validation rule, monitored exception, or accountable owner can prevent recurrence.
JurisOS is the current Juris Digital page associated with marketing operations. Its public page supports a contextual JurisOS discussion, not an assumed data-cleanup package, platform, response time, or result. Bring the disputed report, source exports, definitions, cost boundary, and one reconciled example. Ask whether the operating failure and repair can be addressed in a written scope.
