Building a Simple Lead Tracking Dashboard in a Spreadsheet

You do not need expensive software to understand your marketing. A simple spreadsheet can show where your clients come from, how many inquiries become consultations, and how many consultations become paying clients. Most solo and small-firm lawyers never track this, so even a basic dashboard puts you ahead.

Start with one tab for raw data

Create a sheet called “Leads” with one row per inquiry and these columns:

• Date received
• Name or initials (avoid sensitive details)
• Source (Google, referral, website, social, other)
• Matter type
• Date of first response
• Consultation booked (yes or no)
• Client retained (yes or no)
• Fee collected or estimated value

Keep confidentiality in mind. Store the sheet in a secured account with two-factor authentication, and use initials or ID numbers rather than full details if the sheet is shared.

Add a summary tab

On a second tab, use basic formulas to count and compare:

1. Total leads this month
2. Leads by source
3. Percentage that booked a consultation
4. Percentage that became clients
5. Average time to first response

Counting formulas such as COUNTIF and simple division are enough. Add a small chart for leads by source, if you like.

Add one useful calculation

Estimate your cost per client by source. Add the money you spend on each channel, such as advertising or directories, and divide by the clients it produced. Referrals and organic search often cost less than you expect, while some paid channels turn out to be expensive.

Set a weekly review habit

Spend fifteen minutes every Friday updating the sheet and looking at the summary. Ask three questions:

• Where did our best clients come from?
• Where are we losing people between inquiry and consultation?
• What should we do more or less of next week?

Keep it simple

Resist the urge to add dozens of columns. If a field does not help you decide something, remove it. You can always add detail later once the habit is solid.

Be honest about the limits

Small numbers can be misleading. A single big client can distort a month. Look at trends over a quarter before changing your strategy. Also note that “source” can be fuzzy, since many clients find you through several touchpoints. Ask them on the intake call how they heard about you.

Your next step

Create the Leads tab today with the columns above and enter your last ten inquiries from memory or email. Add the summary tab next week once you have a month of data.