# Find leads without an owner or next step Canonical page: https://agents.paretoid.com/workflows/find-leads-without-an-owner-or-next-step/ Category: CRM & Follow-up Practice relevance: cross-practice. A general operational method. Review the stated tool and jurisdiction limits before use. Jurisdiction/provider scope: Flag unassigned leads and overdue tasks using the firm’s written response rules. Status: Proposed / not tested. The public discussion supports the problem; the method source supports only the documented features. No outcome from this adapted recipe has been verified. Verification: The linked sources support the complaint and documented method components. We have not run this recipe or verified its results. The example below is synthetic, not a customer result. ## The problem Flag unassigned leads and overdue tasks using the firm’s written response rules. Why it matters: An open lead can be overlooked when nobody owns its next step. An exception list makes missing ownership and overdue administrative tasks visible without deciding whether the firm should accept the matter. ## Sources and evidence - pain: [Pain evidence: Public discussion](https://www.reddit.com/r/LawFirmMarketing/comments/1wub11m/comment/pd1q2lg/) ; author post/comment 2026-09-30, updated explanation 2026-10-05 (within 30 days). The firm wants an owner, next action and escalation for missed tasks; it currently relies on spreadsheets. - method: [Method: Lawmatics task assignment and history](https://help.lawmatics.com/en/articles/10699821-creating-tasks-for-users) Lawmatics documents assigned user tasks, automation task actions, and completion history. A native reassignment SLA engine is not established. - method: [Method: Lawmatics task assignment and history · supporting guide 2](https://help.lawmatics.com/en/articles/10738648-completing-and-editing-tasks) Additional official capability reference. It does not validate the complete proposed recipe. Source checked: October 15, 2026. Pain reports are self-reported and identities are unverified. Method documentation supports components, not a tested end-to-end workflow. This CRM recipe shares its firm discussion with other CRM tasks; it is not another independent firm report. ## Suggested approach Start when: Each workday or new intake 1. check owner, next-task date, completion and firm-defined response interval 2. Keep row or page references and mark missing or ambiguous evidence. Do not apply the suggested changes. 3. The responsible staff member checks the draft against the source records and approves any separate action. ## What you need - Existing authorized access to the correct source account and records; no new login, credentials, installation or permission grant is included. - Responsible lawyer/operations reviewer approves scope, definitions and any later action. - AI optional; use only approved minimized data and retain originals separately. - Use synthetic inputs first. Keep real data in firm-approved accounts and processing, with appropriate access, confidentiality and retention controls. Aliases alone do not anonymize records. Never paste credentials, API keys or unnecessary client details. ## How to use Documentation-checked component path; proposed workflow, not tested - The next-action field is firm-maintained, not a guaranteed native field. No bulk task export was verified. Access and setup: - The live account, entitlement, exact headers, records and field coverage have not been observed. ### 1. Ask the in-app assistant for the source report Tool: Lawmatics Merlin Copilot, optional Location: Left navigation > Merlin > Copilot With an already approved seat and firm-wide reporting access, paste the prompt. Open the returned report/export or inspect its preview; if unavailable or incomplete, use the native report route below. Do not accept mutation previews, routines or feature-request sending. Prompt: ```text For the approved intake scope [SCOPE] as of [AS OF/TIMEZONE], return a read-only matter report with Status, Stage, Owned by, Created At and our exact maintained next-action field [FIELD NAME]. Show blank owners and blank next-action values separately. Include source record references if available. If that field or a complete task list is unavailable, say so; do not infer next steps from narrative. Do not update records, assign work, build automation, schedule a routine or send anything. ``` Expected output: A report/one-time export or explicit unsupported/missing-field result; exact custom query coverage is not promised. Next step: Check actual fields and records, then use the native CSV path where a report is returned. Prose alone does not certify completeness. Check before continuing: Existing firm-approved AI entitlement and data handling approval are prerequisites. Lawmatics Merlin reporting can operate at firm scope; do not use it across ethical walls or assume matter-level permissions protect aggregate/search output. The detailed Copilot article and September 2026 release notes describe availability; the suite overview still contains a stale Coming Soon heading. Verify actual account access, with no purchase or permission changes. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://help.lawmatics.com/en/articles/16139872-merlin-copilot https://help.lawmatics.com/en/articles/15890617-merlin-ai-suite-overview https://help.lawmatics.com/en/articles/15788585-recent-updates-q3-2026 ### 2. Get the actual Lawmatics rows Tool: Lawmatics Location: Reports > Custom Reports > existing matter report > eye/view icon > Export Use an existing authorized report, or have its owner prepare a targeted report with Status, Stage, Owned by, Created At and the exact firm-maintained next-action field if it exists. Record the agreed review period and matter scope, including which date field sets the range. Export the viewed report to CSV; large exports may arrive by email. Preserve headers and file unchanged. A report creation/save is a separate account write, not performed here. If no suitable report exists, use the documented Settings > Export > Export Matters route only in restricted storage, then minimize locally. Expected output: Native matter/contact-field rows; no promise of task history, audit history, destination IDs or custom fields that the firm never recorded. Next step: Open in restricted Excel; compare rows to matter records before preparing aliases. Check before continuing: A matter report may contain contact and matter fields. A contacts-only export omits matter fields. Date-created and date-converted scopes differ; exported grouping is not preserved. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://help.lawmatics.com/en/articles/10699961-exporting-custom-reports https://help.lawmatics.com/en/articles/10699766-exporting-data https://help.lawmatics.com/en/articles/10699953-custom-reporting-using-filters https://help.lawmatics.com/en/articles/10699957-custom-reporting-columns-grouping ### 3. Check tasks without inventing a task export Tool: Lawmatics Location: Matters > selected matter > Tasks; or main Tasks dashboard For each nominated row, inspect actual tasks and status/due-date/assignee filters. Open a task for its activity history if needed. Manually record the next open task and due date with a record pointer; no native bulk task CSV is claimed. Expected output: A bounded staff-checked task capture with coverage per matter. Next step: Pass only task existence, assigned-role alias and due date to the analysis workbook. Check before continuing: A blank next-action field does not prove there is no task; incomplete access or omitted tasks means unknown. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://help.lawmatics.com/en/articles/10699825-matter-profile-overview https://help.lawmatics.com/en/articles/10738648-completing-and-editing-tasks ### 4. Make the checked, minimized handoff Tool: Excel / source-record reviewer Location: Restricted original workbook > separate analysis workbook > Scope worksheet Create Leads from the export and TasksChecked from explicit per-matter task inspection. Staff assign lead_alias and source_row_ref. Define active statuses and overdue rules in Scope. Keep untouched original exports/screenshots and the identifying source map in restricted firm storage. Build a separate minimized analysis file; do not hide raw client data on another tab. Include the complete Scope/coverage note in the AI-visible workbook or prompt. Use aliases and administrative metadata only. Unknown is not zero, false, completed or absent. Expected output: Leads(lead_alias,status,stage,owner_present,next_action_present,source_row_ref); TasksChecked(lead_alias,open_task_present,due_at,coverage,source_ref) Next step: Format each approved range as a named table. Carry source-row references and coverage into the analysis workbook. Check before continuing: Every field has an observed source or an explicit missing reason; staff assignments are marked editorial, not native. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://support.microsoft.com/en-us/excel/merge-queries-power-query https://help.lawmatics.com/en/articles/10699825-matter-profile-overview ### 5. Ask AI to inspect the checked inputs Tool: Excel Copilot, optional Location: Analysis workbook > Copilot icon at lower right > Chat only Open the minimized workbook containing the named tables and Scope. Paste the exact prompt; if unavailable, perform the same rule checks manually. Prompt: ```text Use Leads, TasksChecked and Scope only. List active lead_alias values with owner_present=false, then those lacking both an evidenced next action and an open task. Distinguish blank field, no task after complete inspection, and unknown coverage. Return lead_alias,exception,evidence_rows,coverage,proposed_internal_check,reviewer_status=pending. Never infer urgency from case facts, legal merit, owner identity or silence; do not create tasks or messages. ``` Expected output: Source-linked owner/next-step exceptions. Next step: Copy checked results into a new Review sheet, retaining source references and unresolved blockers. Check before continuing: Inspect each flagged matter; report excluded/unknown rows and the denominator. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel ### 6. Human review and final action Tool: Responsible firm reviewer Location: Internal Review worksheet / review document Intake manager verifies each exception in the matter and decides owner/next action. Save the reviewed queue; any task creation is a separately authorized human action. Expected output: Approved internal follow-up queue or unresolved coverage list. Next step: Human returns to the cited matter/Tasks record if corrections are approved. Check before continuing: No autonomous lead ranking, client communication or legal judgment. Execution status: Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed. Step documentation: https://help.lawmatics.com/en/articles/10738648-completing-and-editing-tasks ## What you will get lead-exceptions.csv: lead_alias, rule_id, exception, observed_timestamps, current_owner, proposed_next_step, reviewer ## Human review and limits Human resolves emergency/deadline indicators and prioritization. An elapsed interval never authorizes closing a potential matter or sending a non-engagement letter. The assistant drafts or reports only. Check source records and review the output before a human performs any separately approved send or change. No automatic legal decision, money movement, account connection or publication is included. What to measure: During the pilot, count findings confirmed by the reviewer, false alarms, and missing-input cases. Do not infer time or money saved. ## Original prepared-input schema leads.csv: lead_alias, owner_alias, status, opted_out, next_action_id, next_action_due, last_activity_at tasks.csv: task_id, lead_alias, owner_alias, status, due_datetime, completed_at response-rules.csv: rule_id, stage, allowed_working_hours, response_interval, escalation_owner; include timezone and staff roster Synthetic example input: ```text L1: open, no owner, no next action L2: open, assigned, task overdue during working hours L3: completed, old task still present ``` Expected synthetic output: ```text L1: missing owner and next action L2: overdue task for manager review L3: excluded from the open-lead queue ``` Failure check: Add an opted-out lead and a weekend interval. Do not draft contact for the opted-out lead or count non-working hours as overdue unless policy says so. ## Starter files Native blank scaffolds and original synthetic examples may use different schemas. Follow NATIVE-INPUT-MAPPING where supplied. These files do not connect accounts or install automation. - [Download starter kit](https://agents.paretoid.com/assets/starter-kits/g06-starter-kit.zip) — All inputs, synthetic examples and review notes in one ZIP. No automation is installed. - [Start here: get the sources and prepare the review](https://agents.paretoid.com/assets/starter-kits/g06/START-HERE.txt) — Documentation-checked acquisition, explicit manual mapping, exact prompts and human review limits - [Setup and review checklist](https://agents.paretoid.com/assets/starter-kits/g06/README.txt) — Required inputs, file use, review steps and limits - [Leads blank CSV](https://agents.paretoid.com/assets/starter-kits/g06/leads-template.csv) — Blank input headers for leads.csv - [Leads synthetic example](https://agents.paretoid.com/assets/starter-kits/g06/leads-example.csv) — Synthetic test records for leads.csv - [Tasks blank CSV](https://agents.paretoid.com/assets/starter-kits/g06/tasks-template.csv) — Blank input headers for tasks.csv - [Tasks synthetic example](https://agents.paretoid.com/assets/starter-kits/g06/tasks-example.csv) — Synthetic test records for tasks.csv - [Response rules blank CSV](https://agents.paretoid.com/assets/starter-kits/g06/response-rules-template.csv) — Blank input headers for response-rules.csv - [Response rules synthetic example](https://agents.paretoid.com/assets/starter-kits/g06/response-rules-example.csv) — Synthetic test records for response-rules.csv - [Synthetic example expected results](https://agents.paretoid.com/assets/starter-kits/g06/expected-results.txt) — Compare a pilot result with the planted exceptions - [Native input scaffold: Leads](https://agents.paretoid.com/assets/starter-kits/g06/native-leads-template.csv) — Empty editorial table for Leads; populate from verified source evidence after reviewed mapping; not a native export - [Native input scaffold: TasksChecked](https://agents.paretoid.com/assets/starter-kits/g06/native-taskschecked-template.csv) — Empty editorial table for TasksChecked; populate from verified source evidence after reviewed mapping; not a native export - [Native input scaffold: Scope](https://agents.paretoid.com/assets/starter-kits/g06/native-scope-template.txt) — Approved text input for Scope; complete from verified evidence and include in the AI-visible packet - [Native input mapping and scope guide](https://agents.paretoid.com/assets/starter-kits/g06/NATIVE-INPUT-MAPPING.txt) — Old-file-to-native-input compatibility map, acquisition requirements, privacy and blocking gates ## Optional original prepared-input prompt Destination: Your firm-approved AI assistant · prepared files This original prompt uses its own prepared-input schema. Do not mix it with native-step tables without the supplied mapping. ```text Audit these anonymized open leads against our written ownership and response rules. Return only unowned records, missing next actions and overdue tasks, with record ID, observed timestamps, owner and proposed administrative next step. Exclude completed and opted-out records. Do not rank legal merit, infer urgency from protected traits, reassign cases or contact anyone. INPUTS leads.csv: lead_alias, owner_alias, status, opted_out, next_action_id, next_action_due, last_activity_at tasks.csv: task_id, lead_alias, owner_alias, status, due_datetime, completed_at response-rules.csv: rule_id, stage, allowed_working_hours, response_interval, escalation_owner; include timezone and staff roster OUTPUT lead-exceptions.csv: lead_alias, rule_id, exception, observed_timestamps, current_owner, proposed_next_step, reviewer Use only the supplied synthetic or firm-approved inputs. Cite source row or page IDs for each finding. Keep unknowns unresolved. Return a draft for the responsible staff reviewer. Do not send messages, connect accounts, change records, move money, or make legal decisions. Keep source files unchanged. If an input or permission is missing, list what is needed and stop that check. ``` Proposed / not tested · editorial prompt Published by Law Firm Agents. Proposed adaptation; not tested. Not legal advice.