Building a Simple Lead Tracking Dashboard in a Spreadsheet
Set up a free spreadsheet dashboard to track leads, consultations, and cases so you know which marketing is working.
Topic
Intake scripts, call reviews, lead follow-up, scheduling and conversion tracking.
The problem
Missed calls, slow follow-up and unscripted consults quietly cost small firms more than any ad campaign.
The promise
Answer faster, follow up longer and convert more consultations into signed clients.
Set up a free spreadsheet dashboard to track leads, consultations, and cases so you know which marketing is working.
How solo and small-firm lawyers can respond to new inquiries quickly and follow up consistently with or without a front-desk team.
A simple five-step intake call script for solo and small-firm lawyers that builds trust, gathers key facts, and moves callers toward a booked consultation.
A plain spreadsheet layout for tracking leads, conversions, revenue, and referrals in fifteen minutes a month.
A simple worksheet to calculate your real hourly rate and set flat fees that cover costs, taxes, and the profit you want.
A friendly, structured script for the first call with a prospective client, designed to build trust and book the consultation.
A fictional solo criminal defense attorney shares the intake habits that turn more first calls into signed engagements.
A review of Calendly for solo and small-firm lawyers who want clients to book consultations without back-and-forth emails.
A practical look at Clio Grow as an intake and client relationship tool for solo and small law firms.
Next topic
๐ค AI & Automation
Hire software before you hire staff.
The Modern Lawyer newsletter
One practical idea on personal branding, video, podcasting, LinkedIn, Reddit or AI visibility, plus what's working for lawyers right now.